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. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Embedded SQL
Hardware
Object-Oriented Relational (OOR)
Service Requestor
2. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Data Manipulation
Bind
Foreign Keys
3. Copies multiple records at the same time using a SELECT statement
INSERT INTO
COUNT
Foreign Keys
Views
4. Software system designed to support interoperable machine - to - machine interaction over a network
ALL
Data Manipulation
Shared
Web Service
5. Change order of rows in result table
ORDER BY
Web Service
Central Control of data
Session
6. Allow useres to retrieve data and interact with content located on web pages within website
Equals Operator
Relational
Dynamic
Web Browser
7. Characterizes operation of a relational database
COUNT
Database Administrator (DBA)
Joins
IN
8. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
single value
GROUP BY
SUM
9. Has the highest precedence - followed by the AND - OR
Data Manipulation
FROM
NOT
*
10. Limits the output of the established groups into the derived result table
Scripting
Database
sp_help
HAVING
11. Data in database has ability to be accessed and manipulated by several users
Dynamic
Joins
Negation Operator
Shared
12. Join a table to a copy of itself
ESC
Performance
Property
Self Join
13. Changes the values in one or more selected rows of a table
Data Elements
Subqueries
UPDATE
DISTINCT
14. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Report
Data Recovery & Concurrance
Tables
15. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Primary Keys
Functions
Empty Elements
Data Dictionary
16. Finds the lowest ACII value in column
DELETE
MIN
Empty Elements
Data Elements
17. Software system designed to support interface for a software asset that manages a specific set of tasks
Information
Service Provider
Public Key Infrastructure (PKI)
Service-Oriented Architecture (SOA)
18. Software system designed to support interoperable machine - to - machine interaction over a network
Calculated Column
Inner SELECT query
Web Service
GROUP BY
19. Identifies columns to appear in the result
ASC
Shared
SELECT
Public Key Infrastructure (PKI)
20. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Element Content
Indexes
Aggregate Functions
21. = - < - > - <= - >= - <> - !
Comparison Operators
ALL
Hypertext Markup Language (HTML)
Functions
22. SELECT statment containing the nested query
AVG
Outer SELECT query
*
SUM
23. Text markups that form an element" sort of a "box" to hold things like text and other elements
Database
Central Control of data
Tags
Attributes
24. Tally of how many rows meet criteria specified
AVG
Indexes
Web Browser
COUNT
25. Data that has been processed into a format that is understandable by its audience
Data Definition
Information
Aggregate Functions
Comparison Operators
26. Specifies the tables or views from which rows and columns are retrieved
Data
Application Programmers
FROM
SELECT
27. Straight implementation of raw data formatted into rows and columns
Flat File
DISTINCT
Indexes
UPDATE
28. Some form of output - usually - printed - containing information
Report
Data Recovery & Concurrance
Joins
Outer SELECT query
29. Join a table to a copy of itself
Property
Cookie
Joins
Self Join
30. Browser requests page - code is delivered - executed and done with
sp_help
ORDER BY
DELETE
Dynamic
31. SQL finds and retrieves date
Web server
Users
ORDER BY
Indexes
32. Ensures functions are done efficiently
Web server
Performance
Views
Functions
33. Copies multiple records at the same time using a SELECT statement
Word
Closing tag
Web Service
INSERT INTO
34. Data stored by DAd
Data Administrator (DAd)
Data Elements
BETWEEN
Data Dictionary
35. Straight implementation of raw data formatted into rows and columns
Database Management Systems (DBMS)
ORDER BY
Flat File
FROM
36. Using product as intended for its audience
Indexes
Report
End Users
Views
37. Has the highest precedence - followed by the AND - OR
American Standard Code for Information Interchange (ASCII)
NOT
Persistent
SUM
38. Create program files that include SQ after each command
hidden fields
Embedded SQL
Web Browser
Empty Elements
39. Everything between the start and end tag
Service Requestor
BETWEEN
Element Content
SELECT
40. Used to combine one query to another
SELECT
*
Equals Operator
Subqueries
41. Used to combine one query with another.
UPDATE
Subquery
Report
BETWEEN
42. Table displayed in descending order
Joins
BETWEEN
ESC
Object-Oriented Relational (OOR)
43. The Web is ___________
Data Administrator (DAd)
Central control of data
Stateless
Indexes
44. Grant acces and control to only specific information
Views
Data Administrator (DAd)
IN
Database Administrator (DBA)
45. Data that has been processed into a format that is understandable by its audience
Service Requestor
UPDATE
Aggregate Functions
Information
46. Definition of commands it can do
Hierarchial
FROM
Data Definition
FROM
47. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Precedence of Logical Operators
Comparison Operators
Data Elements
48. Ongoing record of data reflecting the info defining the database
Data Dictionary
Joins
SELECT
INSERT INTO
49. Used with another comparison operator - values become inverted
Foreign Keys
Scripting
Public Key Infrastructure (PKI)
Negation Operator
50. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
IN
GROUP BY
MIN