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. Finds the lowest constant value in a column
MAX
HAVING
Functions
Data Manipulation
2. Using product as intended for its audience
Indexes
Dynamic
End Users
Interactive SQL
3. Copies multiple records at the same time using a SELECT statement
Property
INSERT INTO
Fields
ESC
4. Limits the output of the established groups into the derived result table
SELECT
ALL
Bind
HAVING
5. = - < - > - <= - >= - <> - !
Comparison Operators
Views
NOT
Data Manipulation
6. Most valuable asset of a database system.
to update
Calculated Column
Central control of data
Database Management Systems (DBMS)
7. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
DISTINCT
INSERT INTO
Object-Oriented Relational (OOR)
Service Broker
8. Deletes selected rows
DELETE
Hardware
Central Control of data
Fields
9. Data stored by DAd
Persistent
MAX
Data Elements
UPDATE
10. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Structured Query Language (SQL)
Interactive SQL
HAVING
Cookie
11. Everything in enviroment becomes an object - expands on Priniples of relational databases
GROUP BY
Structured Query Language (SQL)
ORDER BY
Object-Oriented Relational (OOR)
12. Basic Component of SQL
Cookie
Aggregate Functions
Tables
Subqueries
13. Concatenated in SQL Server Database software using the addition symbol
Element Content
Web Browser
Flat File
Fields
14. Create program files that include SQ after each command
Candidate Keys
Embedded SQL
Opening tag
Service Provider
15. Straight implementation of raw data formatted into rows and columns
ASC
SELECT
Flat File
Data Administrator (DAd)
16. Finds the lowest ACII value in column
Embedded SQL
MIN
INSERT INTO
Web Browser
17. Interact and manipulates the data in the database
Data Manipulation
Element Content
Hypertext Markup Language (HTML)
Session
18. SQL Commands - Two Things Specify data interested in - Indicate the ________
Closing tag
accident
Indexes
AVG
19. Limits the output of the established groups into the derived result table
HAVING
to update
DISTINCT
Negation Operator
20. SELECT statment containing the nested query
Outer SELECT query
hidden fields
Subquery
Indexes
21. Averages the numeric values
Central control of data
AVG
Precedence of Logical Operators
Object-Oriented Relational (OOR)
22. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
DISTINCT
UPDATE
sp_help
23. All Columns indicated and selected
American Standard Code for Information Interchange (ASCII)
*
LIKE
accident
24. Used to remove duplicates from result table
DISTINCT
SUM
Hypertext Markup Language (HTML)
single value
25. File stored on a user's machine that contains infor about application
Cookie
Structured Query Language (SQL)
Dynamic
Aliases
26. Attribute in quotes
Precedence of Logical Operators
COUNT
Closing tag
Property
27. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
MIN
Aliases
Service Broker
LIKE
28. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Object-Oriented Relational (OOR)
American Standard Code for Information Interchange (ASCII)
Comparison Operators
Central Control of data
29. Data remains unchanged in database
Integrated
Database Management Systems (DBMS)
Persistent
WHERE
30. Finds the lowest constant value in a column
Service Provider
Integrated
Closing tag
MAX
31. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Data Elements
American Standard Code for Information Interchange (ASCII)
Structured Query Language (SQL)
32. Individuals that use - manipulate or maintain aspects of database
Data Elements
Structured Query Language (SQL)
Users
Aliases
33. Allows data recovery in case of corruption or loss
HAVING
hidden fields
Data Recovery & Concurrance
NOT
34. Data stored by DAd
AVG
American Standard Code for Information Interchange (ASCII)
Application Programers
Data Elements
35. Table displayed in ascending order
Service-Oriented Architecture (SOA)
Scripting
BETWEEN
ASC
36. = - < - > - <= - >= - <> - !
Comparison Operators
INSERT INTO
Outer SELECT query
COUNT
37. Averages the numeric values
AVG
Data Elements
SUM
SUM
38. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Shared
Application Programers
Hypertext Markup Language (HTML)
DELETE
39. Software system designed to support interoperable machine - to - machine interaction over a network
Stateless
Comparison Operators
Data Manipulation
Web Service
40. Uses relationships between independent entities
Relational
Web Browser
to update
IN
41. Text markups that form an element" sort of a "box" to hold things like text and other elements
single value
Flat File
Tags
Calculated Column
42. Tally of how many rows meet criteria specified
MAX
Data Manipulation
Opening tag
COUNT
43. Used to combine one query to another
Subqueries
Data Manipulation
Dynamic
SELECT
44. Used with another comparison operator - values become inverted
Negation Operator
Service Broker
Public Key Infrastructure (PKI)
Aliases
45. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Closing tag
SUM
Functions
DELETE
46. Command based way to ask the database a question
Query
Interactive SQL
Database Administrator (DBA)
Web Service
47. Supplies value for the search condition of the SELECT statement containing it
Users
Inner SELECT query
BETWEEN
SELECT
48. Ongoing record of data reflecting the info defining the database
Data Elements
Indexes
Data Dictionary
IN
49. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Service Provider
Data
Data
50. Text markups that form an element" sort of a "box" to hold things like text and other elements
hidden fields
Tags
Joins
Service Requestor