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. Averages the numeric values
Database Management Systems (DBMS)
AVG
Bind
single value
2. Software system designed to support interoperable machine - to - machine interaction over a network
Database Management Systems (DBMS)
Data Definition
*
Web Service
3. Table displayed in descending order
to update
Data
Flat File
ESC
4. Ensures functions are done efficiently
WHERE
Bind
Performance
Joins
5. Compares value of the column in the specified condition with the value specified
American Standard Code for Information Interchange (ASCII)
Service Provider
Interactive SQL
Equals Operator
6. Data stored by DAd
Hypertext Markup Language (HTML)
Service Provider
Data Elements
Stateless
7. Used to combine one query with another.
INSERT INTO
NOT
Web Browser
Subquery
8. Data that has been processed into a format that is understandable by its audience
IN
Information
Inner SELECT query
Scripting
9. Join a table to a copy of itself
Self Join
Structured Query Language (SQL)
Hypertext Markup Language (HTML)
ORDER BY
10. Closed in the start tag by adding a slash to the start tag
Query
Empty Elements
Relational
MIN
11. Individuals that use - manipulate or maintain aspects of database
Users
Scripting
SUM
Integrated
12. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
DISTINCT
Self Join
Service Broker
Subqueries
13. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Service-Oriented Architecture (SOA)
Closing tag
Query
14. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
Hierarchial
INSERT INTO
FROM
15. Uses two values as limits - selecting any values between the two of them
DELETE
BETWEEN
Object-Oriented Relational (OOR)
Data Recovery & Concurrance
16. Characterizes operation of a relational database
ASC
MAX
Negation Operator
Joins
17. Definition of commands it can do
to update
Indexes
Data Definition
Performance
18. Software system designed to support interoperable machine - to - machine interaction over a network
Web Browser
Application Programmers
Relational
Web Service
19. Give the browser more specific information about that tag
accident
accident
ASC
Attributes
20. Responsible for technical implementation & maintenance of database on a design & physical level
SELECT
Closing tag
ALL
Database Administrator (DBA)
21. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Database
DISTINCT
UPDATE
22. Straight implementation of raw data formatted into rows and columns
Flat File
Service Requestor
Application Programmers
Bind
23. Limits the output of the established groups into the derived result table
HAVING
Cookie
INSERT INTO
Tables
24. Software system designed to support interface for a software asset that manages a specific set of tasks
Attributes
Functions
Indexes
Service Provider
25. Writes programs that use or allow acces to databse with specific purpose
Application Programers
Data Elements
Foreign Keys
Web server
26. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Self Join
INSERT INTO
Web server
Integrated
27. Grant acces and control to only specific information
Views
ALL
Report
Data Definition
28. Finds the lowest ACII value in column
MIN
SELECT
Bind
COUNT
29. One huge database to hold all data; Access to data - and use of system to add - update & print records
single value
Database Management Systems (DBMS)
ORDER BY
Report
30. Grant acces and control to only specific information
NOT
Calculated Column
Data Manipulation
Views
31. Begins an element
Integrated
Opening tag
WHERE
AVG
32. Finds the lowest constant value in a column
Structured Query Language (SQL)
MAX
Report
Users
33. SQL finds and retrieves date
Indexes
Session
Cookie
Empty Elements
34. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Self Join
LIKE
Precedence of Logical Operators
Hardware
35. Data remains unchanged in database
Hardware
End Users
Data Elements
Persistent
36. SELECT statment containing the nested query
Cookie
Outer SELECT query
AVG
Empty Elements
37. Most valuable asset of a database system.
Functions
Web server
Data Administrator (DAd)
Central control of data
38. Deletes selected rows
DELETE
Cookie
FROM
Web Service
39. 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.
Candidate Keys
Negation Operator
End Users
End Users
40. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
American Standard Code for Information Interchange (ASCII)
Foreign Keys
*
single value
41. Responsible for technical implementation & maintenance of database on a design & physical level
sp_help
AVG
Web server
Database Administrator (DBA)
42. Used to remove duplicates from result table
Calculated Column
Hierarchial
Service Broker
DISTINCT
43. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.
HAVING
Relational
DISTINCT
Primary Keys
44. Data remains unchanged in database
Calculated Column
Persistent
IN
ORDER BY
45. Change order of rows in result table
ORDER BY
ASC
Tags
Views
46. Has the highest precedence - followed by the AND - OR
Data Dictionary
AVG
NOT
Persistent
47. Browser requests page - code is delivered - executed and done with
Dynamic
Cookie
Embedded SQL
Service Broker
48. Limits the rows that appear in the result mathcing a specified condition
Data Dictionary
WHERE
MAX
GROUP BY
49. Some form of output - usually - printed - containing information
Self Join
Tables
Report
Relational
50. Copies multiple records at the same time using a SELECT statement
INSERT INTO
ESC
Opening tag
Hypertext Markup Language (HTML)