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. Tally of how many rows meet criteria specified
COUNT
MIN
Tags
Shared
2. Large structured set of persistent data
Database
Comparison Operators
SELECT
INSERT INTO
3. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Word
Bind
Session
GROUP BY
4. Responsible for technical implementation & maintenance of database on a design & physical level
Information
Database Administrator (DBA)
Cookie
Subquery
5. Used in a SELECT clause in place of a column
ASC
LIKE
End Users
Aggregate Functions
6. Most valuable asset of a database system.
Bind
Central control of data
Functions
WHERE
7. 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
Session
INSERT INTO
ASC
ORDER BY
8. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
to update
hidden fields
Application Programmers
Integrated
9. Data remains unchanged in database
Views
Hardware
Persistent
Fields
10. Used with another comparison operator - values become inverted
Tables
SUM
ALL
Negation Operator
11. Copies multiple records at the same time using a SELECT statement
Tables
Attributes
Aliases
INSERT INTO
12. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
AVG
NOT
Data Recovery & Concurrance
13. Ensures functions are done efficiently
Negation Operator
COUNT
Performance
Equals Operator
14. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities
Public Key Infrastructure (PKI)
FROM
Embedded SQL
Service Broker
15. SQL finds and retrieves date
sp_help
Hierarchial
Indexes
Users
16. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Session
AVG
SUM
End Users
17. Combines rows from a SELECT statements result table into a group
Application Programers
Negation Operator
GROUP BY
single value
18. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Primary Keys
Empty Elements
DISTINCT
Web Applications
19. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
ASC
Hypertext Markup Language (HTML)
Outer SELECT query
Structured Query Language (SQL)
20. Large structured set of persistent data
Service Broker
hidden fields
Database
Hardware
21. Data stored by DAd
Views
Data Elements
WHERE
Web server
22. Has the highest precedence - followed by the AND - OR
American Standard Code for Information Interchange (ASCII)
NOT
Word
Database Administrator (DBA)
23. Decides what data is stored in the databse and the manner it is stored
Property
Data Administrator (DAd)
Service-Oriented Architecture (SOA)
Interactive SQL
24. Used in a SELECT clause in place of a column
GROUP BY
Query
Precedence of Logical Operators
Aggregate Functions
25. Data in database interacts & corresponds with other data
Data Definition
Integrated
Application Programers
HAVING
26. Table displayed in descending order
ESC
DISTINCT
Stateless
Views
27. Practice of writing code into a webpage that is not directly visible to the user
Scripting
Interactive SQL
Forward Slash
Tags
28. SQL Commands: Define tables - views - _____ - delete or insert info
American Standard Code for Information Interchange (ASCII)
to update
Session
Report
29. Practice of writing code into a webpage that is not directly visible to the user
Aliases
Scripting
LIKE
HAVING
30. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Database Administrator (DBA)
Functions
Opening tag
31. Columns containing numbers only
Comparison Operators
Flat File
Hardware
SUM
32. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Data
Relational
Service Requestor
33. All Columns indicated and selected
Views
LIKE
*
HAVING
34. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Dynamic
Persistent
Closing tag
35. Straight implementation of raw data formatted into rows and columns
Inner SELECT query
Flat File
Central Control of data
Query
36. Identifies columns to appear in the result
SELECT
Database Management Systems (DBMS)
End Users
accident
37. Used to remove duplicates from result table
DISTINCT
Word
Object-Oriented Relational (OOR)
MAX
38. Copies multiple records at the same time using a SELECT statement
Attributes
Empty Elements
UPDATE
INSERT INTO
39. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Application Programmers
single value
Data Elements
Service Provider
40. Characterizes operation of a relational database
Joins
IN
Attributes
Information
41. Some form of output - usually - printed - containing information
Report
Web server
Aliases
ASC
42. Identifies columns to appear in the result
Central control of data
Hypertext Markup Language (HTML)
SELECT
Views
43. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Relational
Views
Closing tag
44. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Users
Aliases
Fields
45. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Hardware
ASC
MIN
46. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Aliases
Central Control of data
Negation Operator
47. Ongoing record of data reflecting the info defining the database
Data Dictionary
Data Recovery & Concurrance
ORDER BY
Query
48. Characterizes operation of a relational database
Session
BETWEEN
sp_help
Joins
49. Some form of output - usually - printed - containing information
Report
Query
Data Manipulation
WHERE
50. = - < - > - <= - >= - <> - !
Opening tag
Query
Comparison Operators
*