SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Database Management Fundamentals
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Network node that discovers and invokes other software services to provide a buisness solution
Query
Interactive SQL
Structured Query Language (SQL)
Service Requestor
2. Describe information in a tree styled format
UPDATE
Empty Elements
Property
Hierarchial
3. SQL finds and retrieves date
Indexes
Data Elements
Property
Application Programers
4. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities
Indexes
Public Key Infrastructure (PKI)
Calculated Column
Web Browser
5. Responsible for technical implementation & maintenance of database on a design & physical level
BETWEEN
GROUP BY
Service Requestor
Database Administrator (DBA)
6. SQL Commands: Define tables - views - _____ - delete or insert info
Equals Operator
Persistent
Hierarchial
to update
7. Executes commands one at a time - results being displayed immediately
Central Control of data
Interactive SQL
Equals Operator
Performance
8. Practice of writing code into a webpage that is not directly visible to the user
Data Definition
Service-Oriented Architecture (SOA)
Scripting
Database Administrator (DBA)
9. Combines rows from a SELECT statements result table into a group
Performance
Data Dictionary
GROUP BY
Tags
10. Used to remove duplicates from result table
Forward Slash
DISTINCT
LIKE
Joins
11. Create program files that include SQ after each command
Data Recovery & Concurrance
MIN
Cookie
Embedded SQL
12. Everything in enviroment becomes an object - expands on Priniples of relational databases
Web Browser
Object-Oriented Relational (OOR)
Embedded SQL
Cookie
13. Uses relationships between independent entities
Relational
Database
Web Service
Database Administrator (DBA)
14. Defines a new column
Word
Subquery
Hierarchial
Calculated Column
15. Allows use of single or multiple character wildcards with the underscore or percent symbol
ALL
Shared
Element Content
LIKE
16. Grant acces and control to only specific information
Users
Query
Views
Performance
17. Describe information in a tree styled format
Tables
Hierarchial
SUM
Subqueries
18. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Web server
Central control of data
SUM
19. Decides what data is stored in the databse and the manner it is stored
Hardware
Performance
Data Administrator (DAd)
FROM
20. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Hypertext Markup Language (HTML)
Database
American Standard Code for Information Interchange (ASCII)
21. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Fields
Web Applications
Service-Oriented Architecture (SOA)
accident
22. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Opening tag
Functions
Database Administrator (DBA)
single value
23. Deletes selected rows
DELETE
Service Requestor
GROUP BY
Closing tag
24. Limits the rows that appear in the result mathcing a specified condition
Service Broker
ORDER BY
Object-Oriented Relational (OOR)
WHERE
25. Table displayed in descending order
ESC
sp_help
IN
Performance
26. Join a table to a copy of itself
Web server
Precedence of Logical Operators
SUM
Self Join
27. Individuals that use - manipulate or maintain aspects of database
accident
Users
MAX
Scripting
28. Software system designed to support interface for a software asset that manages a specific set of tasks
Outer SELECT query
Property
Service Provider
Structured Query Language (SQL)
29. File stored on a user's machine that contains infor about application
Bind
Cookie
Aggregate Functions
Candidate Keys
30. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
GROUP BY
accident
Indexes
Web server
31. Browser requests page - code is delivered - executed and done with
Dynamic
ESC
Structured Query Language (SQL)
*
32. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Data Dictionary
ORDER BY
Structured Query Language (SQL)
33. Limits the rows that appear in the result mathcing a specified condition
Cookie
WHERE
ESC
Data Administrator (DAd)
34. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
Query
AVG
Database Management Systems (DBMS)
35. Command based way to ask the database a question
Hierarchial
Data Elements
Tables
Query
36. SELECT statment containing the nested query
COUNT
ORDER BY
Outer SELECT query
Application Programers
37. Using product as intended for its audience
WHERE
End Users
Embedded SQL
*
38. Fields in a relational table that match the primary key from one column to the primary key of another table.
Service Requestor
UPDATE
Foreign Keys
accident
39. Characterizes operation of a relational database
Hierarchial
Candidate Keys
HAVING
Joins
40. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Indexes
ALL
Data Elements
Service-Oriented Architecture (SOA)
41. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Primary Keys
ALL
Persistent
LIKE
42. Averages the numeric values
Opening tag
AVG
Closing tag
Relational
43. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Comparison Operators
DELETE
Flat File
44. Finds the lowest ACII value in column
MIN
FROM
Persistent
Dynamic
45. Data stored by DAd
Data Elements
Web Browser
Calculated Column
Subquery
46. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
AVG
Shared
to update
47. Used to remove duplicates from result table
Subquery
DISTINCT
Shared
Service Broker
48. Essentially a collection of services that communicate with eachother
IN
Database Management Systems (DBMS)
WHERE
Service-Oriented Architecture (SOA)
49. Selects from specific values in list
Calculated Column
ORDER BY
IN
Session
50. Give the browser more specific information about that tag
Attributes
Foreign Keys
Database Administrator (DBA)
Web Browser
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests