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. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Inner SELECT query
Tables
Data Elements
Web server
2. Flat File Examples: Excel Spreadsheets - _____
Aggregate Functions
Word
sp_help
Service Provider
3. Grant acces and control to only specific information
Subqueries
Views
Data Recovery & Concurrance
Persistent
4. Meaningful info related to database
Application Programers
Dynamic
Data
LIKE
5. Limits the rows that appear in the result mathcing a specified condition
WHERE
Bind
Data Recovery & Concurrance
Application Programmers
6. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Cookie
Property
sp_help
7. Ensures functions are done efficiently
Functions
Performance
Shared
Session
8. Finds the lowest ACII value in column
MAX
LIKE
Inner SELECT query
MIN
9. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Tables
Functions
COUNT
Service Broker
10. File stored on a user's machine that contains infor about application
Cookie
Data Administrator (DAd)
Indexes
Hierarchial
11. Most valuable asset of a database system.
FROM
LIKE
Equals Operator
Central control of data
12. Uses relationships between independent entities
Bind
Relational
Functions
Candidate Keys
13. Selects from specific values in list
*
IN
DELETE
Hierarchial
14. Cookies are more secure than______ - allowing travel on a website without loss of info
Functions
Service Broker
Precedence of Logical Operators
hidden fields
15. Attribute in quotes
Hardware
Hypertext Markup Language (HTML)
Property
GROUP BY
16. Attribute in quotes
DISTINCT
Hierarchial
Calculated Column
Property
17. Compares value of the column in the specified condition with the value specified
Service Requestor
Equals Operator
Aliases
Views
18. Data in database interacts & corresponds with other data
Inner SELECT query
INSERT INTO
Integrated
Candidate Keys
19. Network node that discovers and invokes other software services to provide a buisness solution
Flat File
Service Requestor
LIKE
Dynamic
20. Everything in enviroment becomes an object - expands on Priniples of relational databases
Opening tag
Data
Object-Oriented Relational (OOR)
MIN
21. Characterizes operation of a relational database
Aliases
Aggregate Functions
Joins
Shared
22. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Tags
MIN
to update
Application Programmers
23. SQL finds and retrieves date
Data Manipulation
Object-Oriented Relational (OOR)
Indexes
Service Requestor
24. Finds the lowest constant value in a column
MAX
Web server
Data Elements
Flat File
25. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Data Administrator (DAd)
Aggregate Functions
Information
Central Control of data
26. Finds the lowest ACII value in column
Data
Web Service
MIN
ASC
27. Looks like opening tag - but with a forward slash
Integrated
Equals Operator
LIKE
Closing tag
28. File stored on a user's machine that contains infor about application
Data
Application Programers
ALL
Cookie
29. Definition of commands it can do
Data
COUNT
Calculated Column
Data Definition
30. Interact and manipulates the data in the database
Data Manipulation
Service Provider
Database
Interactive SQL
31. Create program files that include SQ after each command
Integrated
MIN
Embedded SQL
MAX
32. Basic Component of SQL
Tables
AVG
Shared
American Standard Code for Information Interchange (ASCII)
33. Flat File Examples: Excel Spreadsheets - _____
Word
Web Service
ORDER BY
Web Service
34. Averages the numeric values
UPDATE
End Users
to update
AVG
35. Responsible for technical implementation & maintenance of database on a design & physical level
Dynamic
Calculated Column
Indexes
Database Administrator (DBA)
36. Changes the values in one or more selected rows of a table
Negation Operator
Data Definition
UPDATE
sp_help
37. Copies multiple records at the same time using a SELECT statement
INSERT INTO
ESC
Self Join
Query
38. Text markups that form an element" sort of a "box" to hold things like text and other elements
SUM
Functions
Tags
Structured Query Language (SQL)
39. Join a table to a copy of itself
Self Join
DELETE
Object-Oriented Relational (OOR)
Attributes
40. Averages the numeric values
MAX
ESC
AVG
Interactive SQL
41. Selects from specific values in list
Report
IN
INSERT INTO
AVG
42. Data stored by DAd
Scripting
Empty Elements
Data Elements
ASC
43. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
to update
Data Definition
American Standard Code for Information Interchange (ASCII)
44. Identifies columns to appear in the result
*
Data Administrator (DAd)
SELECT
Tags
45. Describe information in a tree styled format
COUNT
Foreign Keys
Hierarchial
Query
46. Everything in enviroment becomes an object - expands on Priniples of relational databases
Data Definition
Application Programers
DELETE
Object-Oriented Relational (OOR)
47. Data in database has ability to be accessed and manipulated by several users
Relational
Database Administrator (DBA)
Database
Shared
48. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Service-Oriented Architecture (SOA)
GROUP BY
ORDER BY
49. Some form of output - usually - printed - containing information
SELECT
Report
Word
single value
50. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Fields
Session
Database