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. Compares value of the column in the specified condition with the value specified
End Users
Equals Operator
MIN
single value
2. Some form of output - usually - printed - containing information
Joins
Report
Attributes
Interactive SQL
3. Begins an element
Opening tag
Functions
LIKE
hidden fields
4. SELECT statment containing the nested query
Service-Oriented Architecture (SOA)
Outer SELECT query
Element Content
Integrated
5. Limits the rows that appear in the result mathcing a specified condition
Service Provider
Outer SELECT query
WHERE
Views
6. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
MIN
COUNT
SELECT
7. Supplies value for the search condition of the SELECT statement containing it
Query
Inner SELECT query
accident
Persistent
8. Executes commands one at a time - results being displayed immediately
Interactive SQL
Empty Elements
Structured Query Language (SQL)
Cookie
9. Data in database has ability to be accessed and manipulated by several users
Self Join
Data Dictionary
Shared
Bind
10. Meaningful info related to database
SUM
Property
Data
ORDER BY
11. Large structured set of persistent data
Data Elements
MIN
to update
Database
12. Give the browser more specific information about that tag
Shared
Element Content
Attributes
IN
13. Allow useres to retrieve data and interact with content located on web pages within website
Aliases
Application Programers
Web Browser
Inner SELECT query
14. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Query
Central Control of data
Aliases
Views
15. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
IN
Aliases
Precedence of Logical Operators
MIN
16. Basic Component of SQL
Service Requestor
Tables
sp_help
Empty Elements
17. Uses relationships between independent entities
Aggregate Functions
Subqueries
Relational
Element Content
18. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
LIKE
Functions
Report
NOT
19. Used to close a tag properly
Dynamic
Forward Slash
American Standard Code for Information Interchange (ASCII)
Comparison Operators
20. Individuals that use - manipulate or maintain aspects of database
Users
MAX
Persistent
Application Programmers
21. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Empty Elements
Service-Oriented Architecture (SOA)
hidden fields
22. SQL finds and retrieves date
*
Tables
Indexes
Flat File
23. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Application Programmers
Database Management Systems (DBMS)
Service Broker
Database
24. Selects from specific values in list
Database Administrator (DBA)
IN
Embedded SQL
NOT
25. Ensures data is correct casings
Aggregate Functions
Aliases
American Standard Code for Information Interchange (ASCII)
Comparison Operators
26. Interact and manipulates the data in the database
Data Manipulation
ASC
INSERT INTO
single value
27. Identifies columns to appear in the result
BETWEEN
single value
SELECT
sp_help
28. Straight implementation of raw data formatted into rows and columns
End Users
Flat File
Application Programmers
Hierarchial
29. Writes programs that use or allow acces to databse with specific purpose
ESC
Application Programers
to update
Data Recovery & Concurrance
30. Decides what data is stored in the databse and the manner it is stored
Query
Empty Elements
Data Administrator (DAd)
Word
31. Browser requests page - code is delivered - executed and done with
Web server
Dynamic
Tables
Application Programmers
32. The Web is ___________
Data Dictionary
Information
Stateless
Word
33. Everything between the start and end tag
Element Content
SUM
NOT
*
34. Data in database interacts & corresponds with other data
Candidate Keys
Integrated
ALL
AVG
35. Finds the lowest ACII value in column
MIN
Object-Oriented Relational (OOR)
Database Administrator (DBA)
ASC
36. Order in which WHERE clause is evaluated and combined
Hierarchial
Web server
Integrated
Precedence of Logical Operators
37. Basic Component of SQL
Tables
Central Control of data
Fields
Web Service
38. Finds the lowest constant value in a column
Views
MAX
BETWEEN
Web Service
39. Responsible for technical implementation & maintenance of database on a design & physical level
BETWEEN
Database Administrator (DBA)
Service Broker
Shared
40. Large structured set of persistent data
ASC
Data Elements
Equals Operator
Database
41. Used to combine one query to another
Report
ESC
Subqueries
Element Content
42. Using product as intended for its audience
Aggregate Functions
Precedence of Logical Operators
End Users
Service-Oriented Architecture (SOA)
43. Software system designed to support interoperable machine - to - machine interaction over a network
Central Control of data
Indexes
Database
Web Service
44. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
Embedded SQL
UPDATE
Persistent
Session
45. Uses relationships between independent entities
DISTINCT
Relational
Information
LIKE
46. Concatenated in SQL Server Database software using the addition symbol
Opening tag
Fields
Closing tag
Data Administrator (DAd)
47. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Word
BETWEEN
DISTINCT
48. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
single value
Bind
SUM
Service Broker
49. Software system designed to support interoperable machine - to - machine interaction over a network
DISTINCT
Integrated
Web Service
ESC
50. Flat File Examples: Excel Spreadsheets - _____
Self Join
Empty Elements
Word
Report