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. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Outer SELECT query
Cookie
Candidate Keys
2. Averages the numeric values
Comparison Operators
AVG
accident
Equals Operator
3. Most valuable asset of a database system.
Central control of data
Service Requestor
DELETE
Relational
4. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Dynamic
Session
Aliases
Indexes
5. Has the highest precedence - followed by the AND - OR
Service-Oriented Architecture (SOA)
Data Elements
DISTINCT
NOT
6. Join a table to a copy of itself
sp_help
Data Recovery & Concurrance
Self Join
Report
7. = - < - > - <= - >= - <> - !
accident
Relational
Tags
Comparison Operators
8. Used to combine one query to another
hidden fields
Subqueries
Forward Slash
Indexes
9. SQL finds and retrieves date
Foreign Keys
sp_help
Forward Slash
Indexes
10. Deletes selected rows
DELETE
Shared
Joins
ESC
11. Grant acces and control to only specific information
Service Provider
Views
Service Provider
DELETE
12. Data in database interacts & corresponds with other data
Integrated
Web Service
Bind
Fields
13. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Web Browser
Negation Operator
IN
Bind
14. 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
Web server
Session
Persistent
Cookie
15. SQL finds and retrieves date
Functions
Hierarchial
Database Management Systems (DBMS)
Indexes
16. Straight implementation of raw data formatted into rows and columns
Data Manipulation
Application Programers
Flat File
Foreign Keys
17. Give the browser more specific information about that tag
Web Service
Performance
Joins
Attributes
18. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
sp_help
Shared
Web server
Hypertext Markup Language (HTML)
19. Writes programs that use or allow acces to databse with specific purpose
Data Manipulation
Flat File
Application Programers
American Standard Code for Information Interchange (ASCII)
20. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
LIKE
Application Programmers
Structured Query Language (SQL)
WHERE
21. Table displayed in descending order
FROM
ESC
WHERE
Hierarchial
22. Cookies are more secure than______ - allowing travel on a website without loss of info
Comparison Operators
hidden fields
Central Control of data
COUNT
23. Characterizes operation of a relational database
Indexes
Inner SELECT query
Hierarchial
Joins
24. SQL Commands: Define tables - views - _____ - delete or insert info
Flat File
INSERT INTO
Data Elements
to update
25. Combines rows from a SELECT statements result table into a group
GROUP BY
Self Join
Data Dictionary
Data Administrator (DAd)
26. All Columns indicated and selected
Web Service
MIN
COUNT
*
27. Large structured set of persistent data
Hardware
Database
Attributes
Service Provider
28. Cookies are more secure than______ - allowing travel on a website without loss of info
Data Definition
Service-Oriented Architecture (SOA)
hidden fields
Data Definition
29. Selects from specific values in list
Empty Elements
IN
Data Manipulation
Data Administrator (DAd)
30. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
ASC
ASC
hidden fields
Central Control of data
31. Meaningful info related to database
Data
IN
Application Programmers
Integrated
32. Data in database interacts & corresponds with other data
WHERE
Integrated
SUM
Subquery
33. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
ORDER BY
Dynamic
Database Management Systems (DBMS)
Service Broker
34. Begins an element
hidden fields
Opening tag
Service-Oriented Architecture (SOA)
ALL
35. Averages the numeric values
AVG
Data Manipulation
Information
ALL
36. Used in a SELECT clause in place of a column
ORDER BY
Negation Operator
DISTINCT
Aggregate Functions
37. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Self Join
Stateless
Indexes
38. Definition of commands it can do
Word
FROM
SUM
Data Definition
39. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Central Control of data
COUNT
Flat File
40. 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.
Primary Keys
GROUP BY
Data
SUM
41. Interact and manipulates the data in the database
Data Manipulation
Hardware
Primary Keys
Embedded SQL
42. Using product as intended for its audience
accident
Interactive SQL
Closing tag
End Users
43. Change order of rows in result table
INSERT INTO
Application Programmers
ORDER BY
Views
44. Command used to show the attributes that define a table.
sp_help
Interactive SQL
Word
American Standard Code for Information Interchange (ASCII)
45. Ensures data is correct casings
SUM
LIKE
Comparison Operators
American Standard Code for Information Interchange (ASCII)
46. Defines a new column
to update
Report
Calculated Column
Data
47. Executes commands one at a time - results being displayed immediately
Interactive SQL
MAX
Empty Elements
BETWEEN
48. Software system designed to support interoperable machine - to - machine interaction over a network
Interactive SQL
ASC
Embedded SQL
Web Service
49. Characterizes operation of a relational database
Session
Joins
INSERT INTO
Cookie
50. Some form of output - usually - printed - containing information
Report
SUM
Web Service
Service Broker