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. One huge database to hold all data; Access to data - and use of system to add - update & print records
DISTINCT
Database Management Systems (DBMS)
Report
Data Dictionary
2. Compares value of the column in the specified condition with the value specified
DELETE
Session
Equals Operator
Inner SELECT query
3. Identifies columns to appear in the result
End Users
Database
DELETE
SELECT
4. Writes programs that use or allow acces to databse with specific purpose
Data Recovery & Concurrance
Report
NOT
Application Programers
5. Used to remove duplicates from result table
BETWEEN
Hierarchial
MIN
DISTINCT
6. Deletes selected rows
Views
INSERT INTO
DELETE
Negation Operator
7. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
NOT
Application Programmers
Indexes
8. Closed in the start tag by adding a slash to the start tag
Empty Elements
MAX
Application Programers
FROM
9. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Performance
Central Control of data
Web server
Tables
10. Most valuable asset of a database system.
Integrated
Central control of data
Object-Oriented Relational (OOR)
DELETE
11. Used with another comparison operator - values become inverted
Service Provider
MAX
Closing tag
Negation Operator
12. Used to combine one query with another.
sp_help
Aliases
Calculated Column
Subquery
13. Software system designed to support interoperable machine - to - machine interaction over a network
Information
Web Service
Data Definition
Data
14. Individuals that use - manipulate or maintain aspects of database
Users
Service Provider
SUM
Inner SELECT query
15. Used in a SELECT clause in place of a column
UPDATE
MIN
MAX
Aggregate Functions
16. Uses two values as limits - selecting any values between the two of them
Views
BETWEEN
Equals Operator
ALL
17. Allows use of single or multiple character wildcards with the underscore or percent symbol
Empty Elements
Service Broker
Integrated
LIKE
18. Characterizes operation of a relational database
Joins
Closing tag
American Standard Code for Information Interchange (ASCII)
Hypertext Markup Language (HTML)
19. Command based way to ask the database a question
Hardware
Property
Word
Query
20. One of the tools that SQL uses to find and retrieve data.
Data Elements
Tables
to update
Indexes
21. Individuals that use - manipulate or maintain aspects of database
Shared
End Users
Functions
Users
22. Ensures functions are done efficiently
Persistent
Performance
Indexes
NOT
23. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Empty Elements
single value
Data
hidden fields
24. Change order of rows in result table
Comparison Operators
ORDER BY
Joins
Embedded SQL
25. Uses relationships between independent entities
Relational
single value
Service-Oriented Architecture (SOA)
Empty Elements
26. Finds the lowest ACII value in column
Negation Operator
Stateless
MIN
sp_help
27. Uses relationships between independent entities
Negation Operator
Relational
SUM
Web Service
28. 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
Database Management Systems (DBMS)
INSERT INTO
Public Key Infrastructure (PKI)
Indexes
29. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
MAX
Service Broker
Application Programmers
Session
30. Limits the rows that appear in the result mathcing a specified condition
Indexes
Tables
WHERE
AVG
31. Join a table to a copy of itself
Database Management Systems (DBMS)
NOT
Session
Self Join
32. Interact and manipulates the data in the database
Comparison Operators
Data Manipulation
Application Programers
Service Requestor
33. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Equals Operator
Interactive SQL
Data Dictionary
ALL
34. Ensures functions are done efficiently
American Standard Code for Information Interchange (ASCII)
COUNT
Performance
Database
35. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Session
Functions
ALL
MIN
36. Used with another comparison operator - values become inverted
Negation Operator
Query
hidden fields
ASC
37. Decides what data is stored in the databse and the manner it is stored
Primary Keys
Data Administrator (DAd)
ASC
Query
38. SELECT statment containing the nested query
IN
Outer SELECT query
Relational
Interactive SQL
39. Essentially a collection of services that communicate with eachother
Comparison Operators
Service-Oriented Architecture (SOA)
Users
Calculated Column
40. Closed in the start tag by adding a slash to the start tag
COUNT
Structured Query Language (SQL)
Empty Elements
Word
41. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.
Database Administrator (DBA)
Query
IN
Candidate Keys
42. = - < - > - <= - >= - <> - !
Service Broker
Information
Stateless
Comparison Operators
43. Characterizes operation of a relational database
Joins
Data
Hardware
Application Programmers
44. Changes the values in one or more selected rows of a table
Hardware
Data Elements
UPDATE
Empty Elements
45. Everything between the start and end tag
Element Content
Outer SELECT query
American Standard Code for Information Interchange (ASCII)
UPDATE
46. Change order of rows in result table
HAVING
WHERE
Cookie
ORDER BY
47. = - < - > - <= - >= - <> - !
DELETE
End Users
Hardware
Comparison Operators
48. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Forward Slash
Hypertext Markup Language (HTML)
Empty Elements
Joins
49. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Closing tag
American Standard Code for Information Interchange (ASCII)
MIN
Hypertext Markup Language (HTML)
50. Columns containing numbers only
Flat File
Data Manipulation
Performance
SUM