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. SELECT statment containing the nested query
Primary Keys
Bind
Outer SELECT query
Aggregate Functions
2. Used to combine one query to another
Subqueries
Dynamic
GROUP BY
Data Definition
3. Flat File Examples: Excel Spreadsheets - _____
Data Definition
WHERE
Relational
Word
4. SQL Commands - Two Things Specify data interested in - Indicate the ________
Report
Data Recovery & Concurrance
accident
HAVING
5. Used to combine one query to another
SUM
Subqueries
Outer SELECT query
Persistent
6. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Central control of data
Service Broker
Joins
Bind
7. Uses two values as limits - selecting any values between the two of them
BETWEEN
Object-Oriented Relational (OOR)
Scripting
Property
8. Change order of rows in result table
Session
accident
Service Requestor
ORDER BY
9. Grant acces and control to only specific information
Views
Cookie
DELETE
ASC
10. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Primary Keys
Service Provider
Hardware
SUM
11. Text markups that form an element" sort of a "box" to hold things like text and other elements
Service Requestor
Tags
ORDER BY
Aggregate Functions
12. Create program files that include SQ after each command
hidden fields
LIKE
Closing tag
Embedded SQL
13. Averages the numeric values
Functions
AVG
SUM
Flat File
14. Ensures functions are done efficiently
Performance
Inner SELECT query
Cookie
ESC
15. Data stored by DAd
Data Elements
Relational
Database Management Systems (DBMS)
Indexes
16. Definition of commands it can do
Data Definition
ASC
Scripting
Indexes
17. Basic Component of SQL
Service Provider
Central Control of data
Tables
Data Manipulation
18. Characterizes operation of a relational database
Joins
hidden fields
Data
Service Provider
19. 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
Database Administrator (DBA)
Word
Data Definition
Session
20. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Service Requestor
Bind
Hierarchial
ALL
21. Has the highest precedence - followed by the AND - OR
Views
Integrated
NOT
Data Administrator (DAd)
22. The Web is ___________
Attributes
Performance
Stateless
Hardware
23. Decides what data is stored in the databse and the manner it is stored
Comparison Operators
Element Content
IN
Data Administrator (DAd)
24. Finds the lowest ACII value in column
MIN
Embedded SQL
WHERE
Element Content
25. Straight implementation of raw data formatted into rows and columns
Tags
Web Browser
Flat File
Aggregate Functions
26. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Dynamic
ALL
Embedded SQL
27. Using product as intended for its audience
Closing tag
ASC
End Users
Data Manipulation
28. Writes programs that use or allow acces to databse with specific purpose
Persistent
MIN
Database Administrator (DBA)
Application Programers
29. Allow useres to retrieve data and interact with content located on web pages within website
Service Requestor
Users
Database Management Systems (DBMS)
Web Browser
30. Closed in the start tag by adding a slash to the start tag
Application Programers
Empty Elements
NOT
ALL
31. Combines rows from a SELECT statements result table into a group
UPDATE
Aggregate Functions
Web server
GROUP BY
32. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Structured Query Language (SQL)
SUM
single value
GROUP BY
33. Large structured set of persistent data
End Users
Data Definition
Empty Elements
Database
34. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Shared
Negation Operator
Element Content
35. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
GROUP BY
Application Programers
Comparison Operators
36. Everything between the start and end tag
LIKE
NOT
Element Content
End Users
37. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
SELECT
Database Management Systems (DBMS)
ALL
Service Broker
38. Describe information in a tree styled format
Hierarchial
Opening tag
Database
Application Programmers
39. Text markups that form an element" sort of a "box" to hold things like text and other elements
Property
Aliases
Tags
Precedence of Logical Operators
40. 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
Closing tag
AVG
Session
Database Management Systems (DBMS)
41. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Data Administrator (DAd)
LIKE
Database Administrator (DBA)
Central Control of data
42. Uses relationships between independent entities
SUM
Relational
Embedded SQL
Hypertext Markup Language (HTML)
43. Table displayed in descending order
Functions
FROM
Public Key Infrastructure (PKI)
ESC
44. All Columns indicated and selected
*
Embedded SQL
Hierarchial
Public Key Infrastructure (PKI)
45. SQL finds and retrieves date
ASC
single value
Hardware
Indexes
46. Individuals that use - manipulate or maintain aspects of database
Users
MIN
NOT
Subqueries
47. Flat File Examples: Excel Spreadsheets - _____
Interactive SQL
Self Join
Word
MAX
48. Meaningful info related to database
SUM
HAVING
Calculated Column
Data
49. SQL Commands: Define tables - views - _____ - delete or insert info
Service Broker
Stateless
Relational
to update
50. Changes the values in one or more selected rows of a table
Hypertext Markup Language (HTML)
UPDATE
Hierarchial
DISTINCT