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. = - < - > - <= - >= - <> - !
accident
Comparison Operators
Joins
INSERT INTO
2. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Indexes
Hardware
ALL
Query
3. Essentially a collection of services that communicate with eachother
Calculated Column
Service-Oriented Architecture (SOA)
Data Definition
Attributes
4. SQL Commands - Two Things Specify data interested in - Indicate the ________
Subquery
Data Administrator (DAd)
accident
Data Recovery & Concurrance
5. Everything between the start and end tag
SUM
Forward Slash
Element Content
Foreign Keys
6. Some form of output - usually - printed - containing information
SELECT
Report
Outer SELECT query
Persistent
7. Data stored by DAd
Data Elements
HAVING
Performance
INSERT INTO
8. Data in database has ability to be accessed and manipulated by several users
Structured Query Language (SQL)
IN
Database Administrator (DBA)
Shared
9. Finds the lowest constant value in a column
Self Join
Users
MAX
Bind
10. Basic Component of SQL
Hypertext Markup Language (HTML)
Stateless
Application Programers
Tables
11. Table displayed in descending order
Shared
Empty Elements
Self Join
ESC
12. Used to combine one query with another.
Subquery
Hypertext Markup Language (HTML)
Web Service
Database Management Systems (DBMS)
13. Uses relationships between independent entities
Property
sp_help
Hardware
Relational
14. Uses relationships between independent entities
Joins
Relational
Data Definition
LIKE
15. Attribute in quotes
Database Administrator (DBA)
Information
HAVING
Property
16. Large structured set of persistent data
Database
Flat File
Dynamic
Service Provider
17. Essentially a collection of services that communicate with eachother
Service Provider
Service-Oriented Architecture (SOA)
Data Elements
Indexes
18. SQL finds and retrieves date
Indexes
BETWEEN
Database Management Systems (DBMS)
Relational
19. Deletes selected rows
DELETE
Flat File
Embedded SQL
Hardware
20. Everything between the start and end tag
Relational
Subqueries
Element Content
DELETE
21. Individuals that use - manipulate or maintain aspects of database
INSERT INTO
Aliases
Cookie
Users
22. SQL Commands - Two Things Specify data interested in - Indicate the ________
Structured Query Language (SQL)
accident
HAVING
Indexes
23. Cookies are more secure than______ - allowing travel on a website without loss of info
Interactive SQL
BETWEEN
UPDATE
hidden fields
24. Columns containing numbers only
Central Control of data
Data Definition
SUM
Service-Oriented Architecture (SOA)
25. Finds the lowest constant value in a column
Users
MAX
ESC
Interactive SQL
26. Definition of commands it can do
Indexes
DISTINCT
SELECT
Data Definition
27. One of the tools that SQL uses to find and retrieve data.
Indexes
Database
*
ASC
28. Used to combine one query to another
Negation Operator
Subqueries
Views
*
29. SQL finds and retrieves date
Negation Operator
Public Key Infrastructure (PKI)
Indexes
Data Manipulation
30. Responsible for technical implementation & maintenance of database on a design & physical level
ORDER BY
SUM
Database Administrator (DBA)
Comparison Operators
31. Create program files that include SQ after each command
Embedded SQL
NOT
American Standard Code for Information Interchange (ASCII)
Outer SELECT query
32. Selects from specific values in list
Fields
Service Broker
Data Elements
IN
33. Most valuable asset of a database system.
Web Service
Relational
Central control of data
Embedded SQL
34. Concatenated in SQL Server Database software using the addition symbol
Dynamic
Empty Elements
Fields
Scripting
35. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
ASC
Shared
Views
36. Individuals that use - manipulate or maintain aspects of database
Equals Operator
Empty Elements
Users
Negation Operator
37. Used in a SELECT clause in place of a column
Foreign Keys
Tags
Aggregate Functions
INSERT INTO
38. File stored on a user's machine that contains infor about application
GROUP BY
Cookie
Functions
Web server
39. Allow useres to retrieve data and interact with content located on web pages within website
hidden fields
SELECT
WHERE
Web Browser
40. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Element Content
single value
Database Management Systems (DBMS)
Users
41. Create program files that include SQ after each command
ESC
Embedded SQL
Web Applications
Aggregate Functions
42. Cookies are more secure than______ - allowing travel on a website without loss of info
Structured Query Language (SQL)
hidden fields
Precedence of Logical Operators
SELECT
43. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Structured Query Language (SQL)
Database Management Systems (DBMS)
Candidate Keys
Service Broker
44. Averages the numeric values
HAVING
AVG
NOT
Central Control of data
45. Ensures functions are done efficiently
Database
Subqueries
sp_help
Performance
46. SELECT statment containing the nested query
Outer SELECT query
Web Service
Views
Persistent
47. Fields in a relational table that match the primary key from one column to the primary key of another table.
Structured Query Language (SQL)
Foreign Keys
Hardware
American Standard Code for Information Interchange (ASCII)
48. Closed in the start tag by adding a slash to the start tag
Database Administrator (DBA)
Database
Calculated Column
Empty Elements
49. Columns containing numbers only
AVG
WHERE
Views
SUM
50. Allow useres to retrieve data and interact with content located on web pages within website
MIN
Web Browser
Data
SUM