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. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
ALL
Database Management Systems (DBMS)
Data Elements
2. Characterizes operation of a relational database
GROUP BY
Data
Joins
Object-Oriented Relational (OOR)
3. Data that has been processed into a format that is understandable by its audience
Interactive SQL
Service Requestor
Comparison Operators
Information
4. Straight implementation of raw data formatted into rows and columns
Integrated
Cookie
Flat File
accident
5. Ongoing record of data reflecting the info defining the database
Service Provider
Shared
Data Dictionary
Functions
6. Using product as intended for its audience
Joins
End Users
MIN
sp_help
7. Grant acces and control to only specific information
American Standard Code for Information Interchange (ASCII)
COUNT
Views
Web Service
8. The Web is ___________
BETWEEN
Stateless
Bind
sp_help
9. Tally of how many rows meet criteria specified
Equals Operator
Negation Operator
COUNT
Functions
10. Table displayed in descending order
Foreign Keys
Web Service
hidden fields
ESC
11. Finds the lowest constant value in a column
MAX
Flat File
Data Recovery & Concurrance
Central control of data
12. Create program files that include SQ after each command
Database
Embedded SQL
Database Management Systems (DBMS)
Equals Operator
13. Command based way to ask the database a question
Functions
Query
Opening tag
Bind
14. Copies multiple records at the same time using a SELECT statement
Dynamic
INSERT INTO
Service-Oriented Architecture (SOA)
BETWEEN
15. 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
IN
Attributes
Session
*
16. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Performance
Hypertext Markup Language (HTML)
COUNT
Service Provider
17. Order in which WHERE clause is evaluated and combined
to update
Precedence of Logical Operators
Query
Self Join
18. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Opening tag
HAVING
Outer SELECT query
19. Used to remove duplicates from result table
Embedded SQL
DISTINCT
End Users
Service Provider
20. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
American Standard Code for Information Interchange (ASCII)
COUNT
MAX
21. Limits the rows that appear in the result mathcing a specified condition
ORDER BY
Database
WHERE
Report
22. SQL finds and retrieves date
Indexes
to update
Data
Hypertext Markup Language (HTML)
23. Fields in a relational table that match the primary key from one column to the primary key of another table.
SUM
hidden fields
Foreign Keys
Service-Oriented Architecture (SOA)
24. = - < - > - <= - >= - <> - !
Comparison Operators
ALL
Scripting
Report
25. Straight implementation of raw data formatted into rows and columns
Object-Oriented Relational (OOR)
Opening tag
COUNT
Flat File
26. Has the highest precedence - followed by the AND - OR
Views
Data Definition
Information
NOT
27. Responsible for technical implementation & maintenance of database on a design & physical level
Data
Database Administrator (DBA)
Session
Web Browser
28. All Columns indicated and selected
COUNT
Data Definition
*
Flat File
29. Browser requests page - code is delivered - executed and done with
Data Elements
Structured Query Language (SQL)
Dynamic
HAVING
30. Some form of output - usually - printed - containing information
Report
MAX
Information
Subquery
31. Concatenated in SQL Server Database software using the addition symbol
Equals Operator
Joins
Fields
American Standard Code for Information Interchange (ASCII)
32. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Application Programers
Joins
Information
33. All Columns indicated and selected
Database Administrator (DBA)
UPDATE
*
Inner SELECT query
34. One of the tools that SQL uses to find and retrieve data.
Indexes
*
to update
Web Browser
35. Data stored by DAd
Interactive SQL
End Users
Data Elements
Calculated Column
36. Defines a new column
Calculated Column
Service Requestor
Data Elements
Property
37. Give the browser more specific information about that tag
Attributes
Indexes
BETWEEN
Primary Keys
38. Command based way to ask the database a question
Web server
Query
End Users
SELECT
39. Table displayed in descending order
ESC
SUM
Negation Operator
accident
40. Uses relationships between independent entities
Relational
ALL
Negation Operator
NOT
41. Limits the output of the established groups into the derived result table
HAVING
Data Manipulation
End Users
UPDATE
42. Uses relationships between independent entities
Data Administrator (DAd)
Query
SUM
Relational
43. Limits the rows that appear in the result mathcing a specified condition
Persistent
WHERE
accident
Web Browser
44. Averages the numeric values
AVG
Database Management Systems (DBMS)
Hierarchial
Integrated
45. Using product as intended for its audience
End Users
FROM
Closing tag
DISTINCT
46. Data stored by DAd
Database Management Systems (DBMS)
Data Definition
Data Elements
Element Content
47. Selects from specific values in list
SELECT
IN
COUNT
single value
48. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Web Service
Hardware
Primary Keys
Application Programmers
49. Everything between the start and end tag
Empty Elements
Data Elements
Calculated Column
Element Content
50. Table displayed in ascending order
Web Applications
Performance
Query
ASC