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. Changes the values in one or more selected rows of a table
Structured Query Language (SQL)
DELETE
Service Provider
UPDATE
2. Characterizes operation of a relational database
Precedence of Logical Operators
Views
Joins
Service Broker
3. Data remains unchanged in database
Central control of data
Persistent
SUM
Service Provider
4. SQL Commands - Two Things Specify data interested in - Indicate the ________
Bind
Property
Hardware
accident
5. Table displayed in descending order
ASC
Word
ESC
Web server
6. Some form of output - usually - printed - containing information
Report
GROUP BY
End Users
*
7. Has the highest precedence - followed by the AND - OR
Central Control of data
Service Requestor
NOT
Object-Oriented Relational (OOR)
8. Large structured set of persistent data
Database
ALL
Application Programmers
Scripting
9. Specifies the tables or views from which rows and columns are retrieved
FROM
Empty Elements
Information
Session
10. Combines rows from a SELECT statements result table into a group
Subquery
ASC
GROUP BY
Session
11. Command used to show the attributes that define a table.
DELETE
ALL
sp_help
Property
12. Grant acces and control to only specific information
Hardware
DELETE
Outer SELECT query
Views
13. Interact and manipulates the data in the database
Performance
Dynamic
DELETE
Data Manipulation
14. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Bind
Functions
Database
SUM
15. Text markups that form an element" sort of a "box" to hold things like text and other elements
Precedence of Logical Operators
Tags
INSERT INTO
MIN
16. Data in database has ability to be accessed and manipulated by several users
HAVING
Shared
Data Manipulation
Performance
17. Software system designed to support interoperable machine - to - machine interaction over a network
Service-Oriented Architecture (SOA)
Service Provider
End Users
Web Service
18. Ongoing record of data reflecting the info defining the database
American Standard Code for Information Interchange (ASCII)
Service Requestor
Comparison Operators
Data Dictionary
19. Using product as intended for its audience
ASC
End Users
Comparison Operators
American Standard Code for Information Interchange (ASCII)
20. Limits the output of the established groups into the derived result table
Property
HAVING
Shared
Equals Operator
21. Looks like opening tag - but with a forward slash
Fields
Element Content
Closing tag
Data Recovery & Concurrance
22. Used to combine one query to another
IN
Users
single value
Subqueries
23. Supplies value for the search condition of the SELECT statement containing it
Data Elements
Negation Operator
Service-Oriented Architecture (SOA)
Inner SELECT query
24. Meaningful info related to database
Indexes
Data
accident
Information
25. SQL Commands: Define tables - views - _____ - delete or insert info
Closing tag
to update
DELETE
MAX
26. Table displayed in ascending order
Central Control of data
hidden fields
Report
ASC
27. Allow useres to retrieve data and interact with content located on web pages within website
Application Programers
Web Browser
Subqueries
Cookie
28. Essentially a collection of services that communicate with eachother
GROUP BY
Users
Data Definition
Service-Oriented Architecture (SOA)
29. Grant acces and control to only specific information
Performance
sp_help
Views
*
30. Allows use of single or multiple character wildcards with the underscore or percent symbol
Empty Elements
Session
IN
LIKE
31. Compares value of the column in the specified condition with the value specified
hidden fields
Equals Operator
Candidate Keys
to update
32. All Columns indicated and selected
SELECT
*
Relational
Dynamic
33. Describe information in a tree styled format
UPDATE
WHERE
Self Join
Hierarchial
34. Tally of how many rows meet criteria specified
LIKE
Query
SELECT
COUNT
35. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Database Management Systems (DBMS)
ASC
Database
36. Finds the lowest constant value in a column
MAX
Shared
DISTINCT
COUNT
37. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Property
Tables
Aliases
SUM
38. Text markups that form an element" sort of a "box" to hold things like text and other elements
DISTINCT
Database
Data Administrator (DAd)
Tags
39. Identifies columns to appear in the result
Web Browser
SELECT
Data Dictionary
Shared
40. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Dynamic
SUM
Data
Data Definition
41. Closed in the start tag by adding a slash to the start tag
Web Service
Empty Elements
Opening tag
Hypertext Markup Language (HTML)
42. Large structured set of persistent data
Database Management Systems (DBMS)
Functions
Object-Oriented Relational (OOR)
Database
43. Uses relationships between independent entities
Relational
Tables
DISTINCT
Attributes
44. Essentially a collection of services that communicate with eachother
DISTINCT
Bind
Service-Oriented Architecture (SOA)
Service Broker
45. Allows data recovery in case of corruption or loss
Performance
Data Recovery & Concurrance
Functions
Tags
46. Software system designed to support interoperable machine - to - machine interaction over a network
Data Dictionary
DISTINCT
Web Service
GROUP BY
47. Change order of rows in result table
FROM
Closing tag
ORDER BY
Database Administrator (DBA)
48. Create program files that include SQ after each command
American Standard Code for Information Interchange (ASCII)
Interactive SQL
Embedded SQL
Object-Oriented Relational (OOR)
49. Finds the lowest constant value in a column
Central Control of data
MAX
Tables
Outer SELECT query
50. Some form of output - usually - printed - containing information
Report
End Users
Application Programers
GROUP BY