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. Characterizes operation of a relational database
Indexes
Joins
Application Programers
Scripting
2. Command based way to ask the database a question
Query
SUM
Data
Inner SELECT query
3. Data in database has ability to be accessed and manipulated by several users
Report
Candidate Keys
Shared
Database
4. Most valuable asset of a database system.
Object-Oriented Relational (OOR)
Central control of data
Fields
Database Administrator (DBA)
5. Characterizes operation of a relational database
ASC
Joins
Data
Calculated Column
6. Meaningful info related to database
Data
Service Provider
Integrated
Web Browser
7. Begins an element
Empty Elements
Precedence of Logical Operators
Database Management Systems (DBMS)
Opening tag
8. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
End Users
AVG
Word
9. Identifies columns to appear in the result
Structured Query Language (SQL)
ESC
Subquery
SELECT
10. Used to close a tag properly
Element Content
MAX
Service Requestor
Forward Slash
11. Cookies are more secure than______ - allowing travel on a website without loss of info
Aliases
hidden fields
Embedded SQL
Interactive SQL
12. Data that has been processed into a format that is understandable by its audience
Opening tag
Relational
INSERT INTO
Information
13. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Dynamic
single value
Interactive SQL
BETWEEN
14. Data remains unchanged in database
IN
ASC
Persistent
Interactive SQL
15. Used to remove duplicates from result table
Word
Data Dictionary
DISTINCT
IN
16. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Service Requestor
Service Provider
Structured Query Language (SQL)
SUM
17. Cookies are more secure than______ - allowing travel on a website without loss of info
Indexes
hidden fields
Attributes
Integrated
18. Tally of how many rows meet criteria specified
COUNT
Service Provider
Application Programmers
BETWEEN
19. Straight implementation of raw data formatted into rows and columns
Web Browser
ESC
*
Flat File
20. Specifies the tables or views from which rows and columns are retrieved
single value
FROM
Web server
Interactive SQL
21. Has the highest precedence - followed by the AND - OR
NOT
Fields
Views
Users
22. Using product as intended for its audience
Relational
Data Definition
End Users
Calculated Column
23. Everything between the start and end tag
Embedded SQL
Service Broker
Self Join
Element Content
24. Used with another comparison operator - values become inverted
Tags
IN
Data Dictionary
Negation Operator
25. Everything between the start and end tag
Shared
Performance
Element Content
Object-Oriented Relational (OOR)
26. Data that has been processed into a format that is understandable by its audience
Information
Service Broker
Hierarchial
Web Browser
27. Some form of output - usually - printed - containing information
Embedded SQL
GROUP BY
Report
Empty Elements
28. One huge database to hold all data; Access to data - and use of system to add - update & print records
Aliases
Indexes
Data
Database Management Systems (DBMS)
29. Table displayed in ascending order
ALL
Precedence of Logical Operators
ASC
Public Key Infrastructure (PKI)
30. Selects from specific values in list
Interactive SQL
DISTINCT
IN
Indexes
31. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Self Join
BETWEEN
Hypertext Markup Language (HTML)
Service Provider
32. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Structured Query Language (SQL)
Application Programers
Tags
33. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Word
UPDATE
Data Definition
34. Individuals that use - manipulate or maintain aspects of database
Users
Database Administrator (DBA)
Aggregate Functions
INSERT INTO
35. Table displayed in descending order
Tags
ESC
Comparison Operators
hidden fields
36. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Dynamic
to update
SUM
ALL
37. 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.
Data Definition
Fields
Performance
Candidate Keys
38. One of the tools that SQL uses to find and retrieve data.
Precedence of Logical Operators
Data Administrator (DAd)
Indexes
WHERE
39. Used to combine one query to another
Subqueries
Embedded SQL
Web server
Primary Keys
40. SQL Commands - Two Things Specify data interested in - Indicate the ________
Empty Elements
accident
ASC
Application Programers
41. Begins an element
Data Administrator (DAd)
Opening tag
MAX
American Standard Code for Information Interchange (ASCII)
42. Finds the lowest ACII value in column
Data Dictionary
Central control of data
Web server
MIN
43. Closed in the start tag by adding a slash to the start tag
Performance
Empty Elements
Central Control of data
Session
44. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Data Definition
ORDER BY
Tags
45. Data in database interacts & corresponds with other data
Integrated
AVG
Tags
ORDER BY
46. Command based way to ask the database a question
Negation Operator
Hardware
Aggregate Functions
Query
47. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Comparison Operators
Hardware
Central Control of data
Closing tag
48. Software system designed to support interface for a software asset that manages a specific set of tasks
Information
Service Provider
ASC
Scripting
49. Combines rows from a SELECT statements result table into a group
Shared
Views
GROUP BY
Opening tag
50. Supplies value for the search condition of the SELECT statement containing it
MIN
Aggregate Functions
Inner SELECT query
Element Content