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. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Inner SELECT query
Data Elements
Calculated Column
Bind
2. Command based way to ask the database a question
Service Broker
Data Elements
Query
Comparison Operators
3. Used to close a tag properly
Forward Slash
Dynamic
Word
MAX
4. Used in a SELECT clause in place of a column
Precedence of Logical Operators
SELECT
Aggregate Functions
Service Provider
5. Join a table to a copy of itself
Self Join
Data
Comparison Operators
DELETE
6. Supplies value for the search condition of the SELECT statement containing it
Information
Inner SELECT query
Empty Elements
Query
7. Change order of rows in result table
Data Manipulation
Persistent
ORDER BY
Views
8. Large structured set of persistent data
Database
SUM
Tables
Hardware
9. Specifies the tables or views from which rows and columns are retrieved
Data Manipulation
FROM
Database
Comparison Operators
10. Ongoing record of data reflecting the info defining the database
Opening tag
Web server
Hypertext Markup Language (HTML)
Data Dictionary
11. Used to combine one query to another
UPDATE
Structured Query Language (SQL)
Subqueries
DELETE
12. Compares value of the column in the specified condition with the value specified
AVG
DISTINCT
Equals Operator
Outer SELECT query
13. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Stateless
Web Browser
SUM
Data
14. Ensures functions are done efficiently
Scripting
Performance
Hardware
Hypertext Markup Language (HTML)
15. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Outer SELECT query
Structured Query Language (SQL)
ORDER BY
16. Cookies are more secure than______ - allowing travel on a website without loss of info
Subqueries
COUNT
hidden fields
Integrated
17. Limits the output of the established groups into the derived result table
Data Dictionary
Views
HAVING
Cookie
18. Practice of writing code into a webpage that is not directly visible to the user
Flat File
Empty Elements
Data Manipulation
Scripting
19. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
MIN
Aliases
Structured Query Language (SQL)
AVG
20. Used with another comparison operator - values become inverted
Object-Oriented Relational (OOR)
Negation Operator
Views
INSERT INTO
21. Individuals that use - manipulate or maintain aspects of database
Report
Scripting
Application Programmers
Users
22. Allows data recovery in case of corruption or loss
Performance
Data Recovery & Concurrance
Database Management Systems (DBMS)
Data Definition
23. Text markups that form an element" sort of a "box" to hold things like text and other elements
Service Provider
Tags
Users
Joins
24. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
LIKE
Indexes
Service Requestor
25. Definition of commands it can do
Self Join
ORDER BY
Data Definition
LIKE
26. Allows use of single or multiple character wildcards with the underscore or percent symbol
Relational
Flat File
Fields
LIKE
27. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
BETWEEN
ALL
Web Service
Precedence of Logical Operators
28. Give the browser more specific information about that tag
Attributes
Hierarchial
Calculated Column
Integrated
29. Create program files that include SQ after each command
to update
Data Manipulation
Embedded SQL
DISTINCT
30. Finds the lowest constant value in a column
GROUP BY
Tables
MAX
single value
31. Order in which WHERE clause is evaluated and combined
Data Administrator (DAd)
Precedence of Logical Operators
DISTINCT
Scripting
32. Begins an element
ORDER BY
Opening tag
Tables
SUM
33. Defines a new column
Attributes
Data Definition
Calculated Column
Application Programers
34. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Data Administrator (DAd)
SUM
Relational
Functions
35. Describe information in a tree styled format
Hierarchial
single value
Integrated
SUM
36. SQL finds and retrieves date
American Standard Code for Information Interchange (ASCII)
accident
Dynamic
Indexes
37. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Attributes
LIKE
Web Applications
Interactive SQL
38. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Data Recovery & Concurrance
Inner SELECT query
Relational
39. Deletes selected rows
Users
Database
Comparison Operators
DELETE
40. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Relational
WHERE
Empty Elements
41. Table displayed in descending order
ESC
Flat File
Property
Hardware
42. Supplies value for the search condition of the SELECT statement containing it
Central Control of data
Inner SELECT query
FROM
Service Requestor
43. Used to combine one query to another
Web Applications
Users
Session
Subqueries
44. 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
BETWEEN
Element Content
Report
45. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Stateless
HAVING
Application Programmers
Service Broker
46. Decides what data is stored in the databse and the manner it is stored
to update
Functions
Data Administrator (DAd)
Web server
47. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Embedded SQL
Web server
Service Requestor
48. The Web is ___________
Data Elements
Foreign Keys
accident
Stateless
49. Grant acces and control to only specific information
Views
sp_help
Web Browser
Primary Keys
50. Large structured set of persistent data
Database
HAVING
Empty Elements
FROM