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. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Central control of data
Users
Central Control of data
2. Order in which WHERE clause is evaluated and combined
Negation Operator
Element Content
Precedence of Logical Operators
Aliases
3. SQL finds and retrieves date
Word
Tables
Service-Oriented Architecture (SOA)
Indexes
4. Changes the values in one or more selected rows of a table
Relational
UPDATE
Web server
Foreign Keys
5. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Word
sp_help
Structured Query Language (SQL)
Web server
6. Deletes selected rows
DELETE
Hardware
BETWEEN
Web Service
7. Used to remove duplicates from result table
Users
Hierarchial
GROUP BY
DISTINCT
8. Writes programs that use or allow acces to databse with specific purpose
Application Programers
ORDER BY
UPDATE
Report
9. = - < - > - <= - >= - <> - !
Users
Comparison Operators
Stateless
UPDATE
10. Data that has been processed into a format that is understandable by its audience
Data Administrator (DAd)
Web Browser
Joins
Information
11. Flat File Examples: Excel Spreadsheets - _____
NOT
Word
Service-Oriented Architecture (SOA)
Subqueries
12. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Query
Precedence of Logical Operators
Embedded SQL
ALL
13. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
NOT
American Standard Code for Information Interchange (ASCII)
Data Recovery & Concurrance
14. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
MIN
Views
Service Requestor
15. Data in database has ability to be accessed and manipulated by several users
Scripting
Shared
Web server
Service-Oriented Architecture (SOA)
16. Has the highest precedence - followed by the AND - OR
hidden fields
NOT
Dynamic
Hardware
17. 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
ORDER BY
single value
SUM
Session
18. Individuals that use - manipulate or maintain aspects of database
Relational
Users
Shared
Comparison Operators
19. Allow useres to retrieve data and interact with content located on web pages within website
Opening tag
Database Management Systems (DBMS)
single value
Web Browser
20. Used in a SELECT clause in place of a column
Aliases
Service-Oriented Architecture (SOA)
Performance
Aggregate Functions
21. Essentially a collection of services that communicate with eachother
Database Administrator (DBA)
ASC
Service-Oriented Architecture (SOA)
NOT
22. Writes programs that use or allow acces to databse with specific purpose
BETWEEN
MIN
Application Programers
American Standard Code for Information Interchange (ASCII)
23. Characterizes operation of a relational database
Negation Operator
Application Programmers
COUNT
Joins
24. Command used to show the attributes that define a table.
sp_help
Session
Bind
single value
25. SQL Commands - Two Things Specify data interested in - Indicate the ________
NOT
Equals Operator
accident
Interactive SQL
26. One of the tools that SQL uses to find and retrieve data.
Indexes
Element Content
End Users
Structured Query Language (SQL)
27. Ensures functions are done efficiently
WHERE
Performance
sp_help
Shared
28. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Requestor
Data
Negation Operator
Service Provider
29. Uses relationships between independent entities
Negation Operator
Relational
Shared
Word
30. Used to close a tag properly
Forward Slash
Data Administrator (DAd)
Dynamic
*
31. Used to combine one query to another
Subqueries
hidden fields
IN
Forward Slash
32. Flat File Examples: Excel Spreadsheets - _____
Joins
Word
WHERE
Object-Oriented Relational (OOR)
33. Looks like opening tag - but with a forward slash
DELETE
Closing tag
Fields
Application Programmers
34. Limits the output of the established groups into the derived result table
Data Manipulation
Data Dictionary
HAVING
Closing tag
35. Interact and manipulates the data in the database
Data Dictionary
Hierarchial
Indexes
Data Manipulation
36. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Information
Self Join
Hypertext Markup Language (HTML)
ASC
37. Combines rows from a SELECT statements result table into a group
AVG
Query
Property
GROUP BY
38. Some form of output - usually - printed - containing information
Property
Report
Functions
Element Content
39. Straight implementation of raw data formatted into rows and columns
hidden fields
Flat File
Database Administrator (DBA)
Aggregate Functions
40. Decides what data is stored in the databse and the manner it is stored
Negation Operator
Dynamic
to update
Data Administrator (DAd)
41. SQL finds and retrieves date
ASC
Performance
Indexes
ESC
42. Network node that discovers and invokes other software services to provide a buisness solution
Application Programers
Service Requestor
Web server
Property
43. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Subqueries
Data
Service Broker
COUNT
44. Executes commands one at a time - results being displayed immediately
Interactive SQL
Data Manipulation
Empty Elements
Service Provider
45. Responsible for technical implementation & maintenance of database on a design & physical level
Bind
Relational
Database Administrator (DBA)
Session
46. Characterizes operation of a relational database
IN
Property
ESC
Joins
47. Decides what data is stored in the databse and the manner it is stored
Element Content
Integrated
Public Key Infrastructure (PKI)
Data Administrator (DAd)
48. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Data Manipulation
Tags
Closing tag
49. Basic Component of SQL
Dynamic
End Users
Tables
Query
50. File stored on a user's machine that contains infor about application
Cookie
hidden fields
Session
Relational