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. Writes programs that use or allow acces to databse with specific purpose
Application Programers
Data Definition
Outer SELECT query
Hypertext Markup Language (HTML)
2. Combines rows from a SELECT statements result table into a group
Inner SELECT query
Query
BETWEEN
GROUP BY
3. Decides what data is stored in the databse and the manner it is stored
WHERE
Data Administrator (DAd)
Database
Tags
4. Deletes selected rows
DELETE
Cookie
DISTINCT
HAVING
5. Executes commands one at a time - results being displayed immediately
Users
ESC
Stateless
Interactive SQL
6. SELECT statment containing the nested query
Negation Operator
Negation Operator
Outer SELECT query
Element Content
7. Allows use of single or multiple character wildcards with the underscore or percent symbol
Aggregate Functions
Interactive SQL
LIKE
Data Administrator (DAd)
8. Finds the lowest ACII value in column
MIN
End Users
Service-Oriented Architecture (SOA)
GROUP BY
9. SQL Commands - Two Things Specify data interested in - Indicate the ________
Integrated
GROUP BY
COUNT
accident
10. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
MAX
Outer SELECT query
Database
Central Control of data
11. Identifies columns to appear in the result
SELECT
INSERT INTO
Service-Oriented Architecture (SOA)
Tags
12. Begins an element
Fields
Outer SELECT query
Opening tag
COUNT
13. Command used to show the attributes that define a table.
Interactive SQL
Inner SELECT query
Central Control of data
sp_help
14. Used to combine one query to another
Data Elements
SUM
Subqueries
Property
15. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Central control of data
Precedence of Logical Operators
COUNT
16. Flat File Examples: Excel Spreadsheets - _____
End Users
Outer SELECT query
Application Programers
Word
17. Used with another comparison operator - values become inverted
Outer SELECT query
Data Recovery & Concurrance
Empty Elements
Negation Operator
18. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Data Recovery & Concurrance
Users
ALL
19. Data remains unchanged in database
Web Service
Performance
Persistent
AVG
20. Used to combine one query with another.
Joins
Persistent
Database Administrator (DBA)
Subquery
21. Data remains unchanged in database
Data Elements
Service-Oriented Architecture (SOA)
Data Administrator (DAd)
Persistent
22. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
DISTINCT
SUM
IN
BETWEEN
23. Has the highest precedence - followed by the AND - OR
Data
NOT
Bind
IN
24. Basic Component of SQL
Query
Shared
End Users
Tables
25. Describe information in a tree styled format
Functions
Hierarchial
Information
Joins
26. Using product as intended for its audience
Web server
End Users
Indexes
IN
27. Allows use of single or multiple character wildcards with the underscore or percent symbol
Service-Oriented Architecture (SOA)
LIKE
Shared
Application Programmers
28. Data in database has ability to be accessed and manipulated by several users
Shared
sp_help
Web server
Performance
29. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Structured Query Language (SQL)
Joins
AVG
30. Writes programs that use or allow acces to databse with specific purpose
Word
Indexes
Embedded SQL
Application Programers
31. Text markups that form an element" sort of a "box" to hold things like text and other elements
Central Control of data
Tags
BETWEEN
Application Programers
32. Decides what data is stored in the databse and the manner it is stored
Flat File
Data Administrator (DAd)
Opening tag
End Users
33. Limits the output of the established groups into the derived result table
HAVING
Web server
Fields
Equals Operator
34. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Central Control of data
sp_help
Application Programmers
single value
35. Has the highest precedence - followed by the AND - OR
Precedence of Logical Operators
NOT
Structured Query Language (SQL)
Opening tag
36. Create program files that include SQ after each command
Embedded SQL
COUNT
Application Programmers
SUM
37. Used to combine one query to another
Comparison Operators
Subqueries
Relational
American Standard Code for Information Interchange (ASCII)
38. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Shared
Service Broker
Cookie
Aggregate Functions
39. Attribute in quotes
Hardware
Property
Hypertext Markup Language (HTML)
WHERE
40. SQL finds and retrieves date
Indexes
Word
Aliases
Stateless
41. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Object-Oriented Relational (OOR)
Application Programmers
Object-Oriented Relational (OOR)
Indexes
42. Change order of rows in result table
American Standard Code for Information Interchange (ASCII)
Dynamic
ORDER BY
ALL
43. Used with another comparison operator - values become inverted
Shared
HAVING
Negation Operator
Object-Oriented Relational (OOR)
44. Flat File Examples: Excel Spreadsheets - _____
Word
DISTINCT
Calculated Column
Views
45. Changes the values in one or more selected rows of a table
Word
Empty Elements
Joins
UPDATE
46. Tally of how many rows meet criteria specified
COUNT
SUM
Data Manipulation
Outer SELECT query
47. Browser requests page - code is delivered - executed and done with
Data Manipulation
Equals Operator
UPDATE
Dynamic
48. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Application Programmers
Functions
Tables
Hardware
49. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Aggregate Functions
Data
Central Control of data
Persistent
50. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Data Administrator (DAd)
Web server
Opening tag
Structured Query Language (SQL)