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. Columns containing numbers only
ASC
SUM
Application Programmers
Service Requestor
2. Using product as intended for its audience
Performance
Scripting
End Users
Subquery
3. Used in a SELECT clause in place of a column
Aggregate Functions
Users
Data Recovery & Concurrance
Flat File
4. Create program files that include SQ after each command
Cookie
Embedded SQL
Data Dictionary
Calculated Column
5. File stored on a user's machine that contains infor about application
Web Applications
Cookie
DELETE
COUNT
6. Interact and manipulates the data in the database
Aliases
Data Manipulation
Relational
Flat File
7. Straight implementation of raw data formatted into rows and columns
Information
Self Join
Flat File
Interactive SQL
8. Software system designed to support interoperable machine - to - machine interaction over a network
End Users
Candidate Keys
Service Requestor
Web Service
9. Finds the lowest constant value in a column
Database Administrator (DBA)
Property
MAX
GROUP BY
10. Limits the rows that appear in the result mathcing a specified condition
single value
Persistent
Service Requestor
WHERE
11. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Joins
Joins
Web Service
12. Ensures data is correct casings
MAX
American Standard Code for Information Interchange (ASCII)
Self Join
Web server
13. Specifies the tables or views from which rows and columns are retrieved
Opening tag
FROM
Hypertext Markup Language (HTML)
to update
14. Cookies are more secure than______ - allowing travel on a website without loss of info
Flat File
hidden fields
Comparison Operators
Hypertext Markup Language (HTML)
15. Most valuable asset of a database system.
BETWEEN
Central control of data
Equals Operator
Data Definition
16. Attribute in quotes
Data Recovery & Concurrance
ORDER BY
Property
WHERE
17. Attribute in quotes
Property
INSERT INTO
Object-Oriented Relational (OOR)
Data Manipulation
18. Closed in the start tag by adding a slash to the start tag
Hardware
Element Content
Empty Elements
Self Join
19. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Database Administrator (DBA)
Hypertext Markup Language (HTML)
ASC
Web Applications
20. Used in a SELECT clause in place of a column
Data Dictionary
Joins
Aggregate Functions
Fields
21. Copies multiple records at the same time using a SELECT statement
MAX
Web server
INSERT INTO
Integrated
22. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Service Provider
Application Programmers
GROUP BY
23. Large structured set of persistent data
Web server
Service Broker
Data Administrator (DAd)
Database
24. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Service Requestor
Inner SELECT query
Integrated
25. Changes the values in one or more selected rows of a table
Central control of data
MIN
Data Definition
UPDATE
26. Finds the lowest ACII value in column
Web Browser
Subqueries
Empty Elements
MIN
27. Compares value of the column in the specified condition with the value specified
Subquery
Persistent
Equals Operator
Data Definition
28. Executes commands one at a time - results being displayed immediately
single value
American Standard Code for Information Interchange (ASCII)
Interactive SQL
BETWEEN
29. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Hardware
Application Programmers
Database
Report
30. = - < - > - <= - >= - <> - !
Data Elements
Central Control of data
Comparison Operators
Embedded SQL
31. Allows use of single or multiple character wildcards with the underscore or percent symbol
*
Session
Aggregate Functions
LIKE
32. Straight implementation of raw data formatted into rows and columns
Application Programers
Embedded SQL
Data Definition
Flat File
33. Selects from specific values in list
Web server
SUM
IN
Closing tag
34. Software system designed to support interoperable machine - to - machine interaction over a network
accident
UPDATE
Candidate Keys
Web Service
35. Data remains unchanged in database
Persistent
Stateless
Negation Operator
Outer SELECT query
36. Decides what data is stored in the databse and the manner it is stored
Web server
BETWEEN
Data Administrator (DAd)
Performance
37. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
MIN
Calculated Column
Dynamic
Aliases
38. SQL Commands - Two Things Specify data interested in - Indicate the ________
Tags
SELECT
Data Manipulation
accident
39. Characterizes operation of a relational database
Service-Oriented Architecture (SOA)
Joins
to update
Report
40. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
MIN
Scripting
GROUP BY
41. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Cookie
Data Dictionary
Structured Query Language (SQL)
42. Data in database interacts & corresponds with other data
INSERT INTO
INSERT INTO
Integrated
Functions
43. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Integrated
single value
End Users
44. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Calculated Column
Tags
Report
45. Table displayed in descending order
Shared
Hardware
ESC
Information
46. Data in database has ability to be accessed and manipulated by several users
BETWEEN
Empty Elements
Shared
UPDATE
47. Order in which WHERE clause is evaluated and combined
Object-Oriented Relational (OOR)
Aggregate Functions
Comparison Operators
Precedence of Logical Operators
48. Command used to show the attributes that define a table.
IN
Web server
sp_help
Opening tag
49. Data in database has ability to be accessed and manipulated by several users
Shared
Views
Aggregate Functions
ESC
50. One of the tools that SQL uses to find and retrieve data.
Indexes
Persistent
Central Control of data
Integrated