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. Basic Component of SQL
Service Broker
DELETE
Tables
IN
2. Describe information in a tree styled format
Central Control of data
Integrated
Hierarchial
LIKE
3. Data remains unchanged in database
Persistent
SELECT
Tables
Negation Operator
4. Changes the values in one or more selected rows of a table
Application Programmers
Application Programers
UPDATE
Indexes
5. = - < - > - <= - >= - <> - !
HAVING
Database
Bind
Comparison Operators
6. Columns containing numbers only
ASC
FROM
SUM
Users
7. One of the tools that SQL uses to find and retrieve data.
Shared
BETWEEN
American Standard Code for Information Interchange (ASCII)
Indexes
8. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Forward Slash
single value
Persistent
Word
9. Create program files that include SQ after each command
Hardware
*
End Users
Embedded SQL
10. Data stored by DAd
DISTINCT
Database
Data Elements
SUM
11. Table displayed in descending order
Aggregate Functions
Negation Operator
Self Join
ESC
12. Some form of output - usually - printed - containing information
Report
Data
Views
DELETE
13. Uses two values as limits - selecting any values between the two of them
Application Programmers
Database Management Systems (DBMS)
Subquery
BETWEEN
14. 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.
Session
Comparison Operators
Flat File
Candidate Keys
15. Uses relationships between independent entities
Information
Relational
Empty Elements
Web Applications
16. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
COUNT
Central control of data
Hypertext Markup Language (HTML)
single value
17. Meaningful info related to database
Data
Data Recovery & Concurrance
Tags
Integrated
18. Ongoing record of data reflecting the info defining the database
Service Broker
Data Administrator (DAd)
Data Dictionary
Information
19. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
End Users
COUNT
Indexes
20. = - < - > - <= - >= - <> - !
Comparison Operators
*
Indexes
SELECT
21. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Data
Element Content
WHERE
22. Allows data recovery in case of corruption or loss
Object-Oriented Relational (OOR)
Data Recovery & Concurrance
Word
MAX
23. Ensures functions are done efficiently
Persistent
Equals Operator
ORDER BY
Performance
24. Finds the lowest ACII value in column
BETWEEN
MIN
Central Control of data
Data Elements
25. Executes commands one at a time - results being displayed immediately
ESC
Cookie
Interactive SQL
COUNT
26. Characterizes operation of a relational database
UPDATE
Joins
NOT
End Users
27. Order in which WHERE clause is evaluated and combined
single value
IN
Precedence of Logical Operators
accident
28. Averages the numeric values
Relational
Empty Elements
AVG
MIN
29. Finds the lowest constant value in a column
Data Dictionary
Foreign Keys
MAX
Integrated
30. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Database Administrator (DBA)
SUM
Opening tag
31. Individuals that use - manipulate or maintain aspects of database
NOT
Application Programers
hidden fields
Users
32. Has the highest precedence - followed by the AND - OR
Closing tag
Database
hidden fields
NOT
33. 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)
Precedence of Logical Operators
ASC
Scripting
34. Software system designed to support interface for a software asset that manages a specific set of tasks
Web Browser
Database
Self Join
Service Provider
35. Describe information in a tree styled format
Indexes
Query
Self Join
Hierarchial
36. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Persistent
Closing tag
Flat File
37. Combines rows from a SELECT statements result table into a group
GROUP BY
Functions
Data Elements
Hypertext Markup Language (HTML)
38. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
Data Manipulation
Interactive SQL
single value
39. All Columns indicated and selected
Negation Operator
ALL
Data Recovery & Concurrance
*
40. Allow useres to retrieve data and interact with content located on web pages within website
Relational
Calculated Column
Attributes
Web Browser
41. Data in database interacts & corresponds with other data
MAX
HAVING
Integrated
Opening tag
42. Identifies columns to appear in the result
accident
SELECT
accident
American Standard Code for Information Interchange (ASCII)
43. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Opening tag
Functions
Structured Query Language (SQL)
Forward Slash
44. Begins an element
Object-Oriented Relational (OOR)
Bind
Opening tag
Equals Operator
45. Defines a new column
Data Dictionary
Calculated Column
Inner SELECT query
to update
46. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Fields
Session
Closing tag
47. Three Basic Operations of SP - SR - SB: Publish - Find - ____
SUM
End Users
single value
Bind
48. File stored on a user's machine that contains infor about application
Attributes
SELECT
Property
Cookie
49. Change order of rows in result table
Indexes
ORDER BY
DISTINCT
Bind
50. Finds the lowest constant value in a column
Opening tag
Equals Operator
Public Key Infrastructure (PKI)
MAX