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. One of the tools that SQL uses to find and retrieve data.
Database Management Systems (DBMS)
Indexes
Report
NOT
2. Writes programs that use or allow acces to databse with specific purpose
Attributes
INSERT INTO
Application Programers
Negation Operator
3. Ongoing record of data reflecting the info defining the database
IN
DELETE
Outer SELECT query
Data Dictionary
4. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Data
Application Programmers
BETWEEN
Tables
5. Combines rows from a SELECT statements result table into a group
Service Broker
MIN
Service Provider
GROUP BY
6. Practice of writing code into a webpage that is not directly visible to the user
Data
Aggregate Functions
accident
Scripting
7. Used to combine one query to another
Report
Users
Subqueries
Word
8. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
to update
GROUP BY
Opening tag
9. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Attributes
Database Management Systems (DBMS)
to update
single value
10. Browser requests page - code is delivered - executed and done with
ESC
Dynamic
Stateless
DELETE
11. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Candidate Keys
Central Control of data
Bind
Information
12. Uses relationships between independent entities
Users
Fields
Relational
Web Service
13. File stored on a user's machine that contains infor about application
Dynamic
Inner SELECT query
Cookie
MAX
14. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Closing tag
Shared
Service-Oriented Architecture (SOA)
15. Most valuable asset of a database system.
Object-Oriented Relational (OOR)
Central control of data
ORDER BY
Data Definition
16. Give the browser more specific information about that tag
Property
Embedded SQL
Attributes
Empty Elements
17. File stored on a user's machine that contains infor about application
Cookie
ALL
GROUP BY
Integrated
18. Describe information in a tree styled format
Hierarchial
Web Service
Joins
LIKE
19. Finds the lowest ACII value in column
MIN
ORDER BY
Data Manipulation
Database
20. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Object-Oriented Relational (OOR)
Views
Service Provider
Central Control of data
21. Change order of rows in result table
ORDER BY
Word
Database Administrator (DBA)
Query
22. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
Hardware
Central Control of data
INSERT INTO
23. Averages the numeric values
American Standard Code for Information Interchange (ASCII)
Persistent
BETWEEN
AVG
24. Specifies the tables or views from which rows and columns are retrieved
SUM
Cookie
FROM
Data Administrator (DAd)
25. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Application Programmers
Data Manipulation
Application Programers
26. Copies multiple records at the same time using a SELECT statement
Persistent
INSERT INTO
SUM
Report
27. Data remains unchanged in database
Persistent
Object-Oriented Relational (OOR)
Data Elements
Data Administrator (DAd)
28. Data stored by DAd
Performance
Attributes
Data Elements
Central Control of data
29. Writes programs that use or allow acces to databse with specific purpose
Application Programers
Closing tag
Relational
Subquery
30. SQL Commands: Define tables - views - _____ - delete or insert info
Foreign Keys
Embedded SQL
Hypertext Markup Language (HTML)
to update
31. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Application Programmers
Data
UPDATE
32. Columns containing numbers only
Comparison Operators
Hypertext Markup Language (HTML)
AVG
SUM
33. Looks like opening tag - but with a forward slash
Closing tag
Information
BETWEEN
AVG
34. Limits the output of the established groups into the derived result table
Service-Oriented Architecture (SOA)
HAVING
Application Programmers
Service Broker
35. Finds the lowest constant value in a column
MAX
Closing tag
BETWEEN
End Users
36. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
DISTINCT
Structured Query Language (SQL)
Candidate Keys
Integrated
37. Change order of rows in result table
ORDER BY
GROUP BY
ESC
Calculated Column
38. = - < - > - <= - >= - <> - !
Comparison Operators
to update
Data Recovery & Concurrance
Inner SELECT query
39. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Attributes
Primary Keys
INSERT INTO
40. Interact and manipulates the data in the database
Bind
HAVING
Views
Data Manipulation
41. Changes the values in one or more selected rows of a table
Cookie
INSERT INTO
UPDATE
Hierarchial
42. Give the browser more specific information about that tag
Attributes
IN
Opening tag
Cookie
43. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.
Views
Primary Keys
Data Elements
NOT
44. Used to remove duplicates from result table
HAVING
Tags
DISTINCT
Integrated
45. Order in which WHERE clause is evaluated and combined
SUM
IN
Precedence of Logical Operators
Performance
46. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Application Programers
INSERT INTO
Scripting
47. Practice of writing code into a webpage that is not directly visible to the user
NOT
Hardware
INSERT INTO
Scripting
48. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Central control of data
Information
Cookie
49. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Attributes
Central control of data
Hardware
Interactive SQL
50. Large structured set of persistent data
Closing tag
MAX
Inner SELECT query
Database