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. Compares value of the column in the specified condition with the value specified
Service Requestor
ESC
Attributes
Equals Operator
2. Grant acces and control to only specific information
Query
Views
Functions
accident
3. Browser requests page - code is delivered - executed and done with
Users
Dynamic
Embedded SQL
Central control of data
4. Data that has been processed into a format that is understandable by its audience
Report
Information
ASC
Persistent
5. Executes commands one at a time - results being displayed immediately
BETWEEN
IN
Query
Interactive SQL
6. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Subqueries
Equals Operator
Closing tag
7. Table displayed in ascending order
Central control of data
Service Broker
DISTINCT
ASC
8. Columns containing numbers only
INSERT INTO
Data Dictionary
Service Broker
SUM
9. Basic Component of SQL
Views
Tables
Shared
Service-Oriented Architecture (SOA)
10. Identifies columns to appear in the result
COUNT
Interactive SQL
SELECT
MIN
11. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Information
Data
UPDATE
Application Programmers
12. Ensures data is correct casings
Service Broker
American Standard Code for Information Interchange (ASCII)
HAVING
IN
13. Join a table to a copy of itself
Session
Report
Central Control of data
Self Join
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
Flat File
Session
Calculated Column
SUM
15. Characterizes operation of a relational database
Foreign Keys
NOT
Joins
FROM
16. Uses relationships between independent entities
Relational
Subquery
Data Elements
Central Control of data
17. Using product as intended for its audience
Attributes
DISTINCT
Self Join
End Users
18. Command used to show the attributes that define a table.
Web Browser
Object-Oriented Relational (OOR)
sp_help
SUM
19. Used to combine one query to another
Indexes
Subqueries
ORDER BY
FROM
20. Selects from specific values in list
IN
Application Programmers
Persistent
Calculated Column
21. Looks like opening tag - but with a forward slash
FROM
Foreign Keys
Closing tag
Data Manipulation
22. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Tags
Forward Slash
Central Control of data
Outer SELECT query
23. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Service-Oriented Architecture (SOA)
Functions
IN
DISTINCT
24. Averages the numeric values
AVG
hidden fields
Calculated Column
Aggregate Functions
25. Defines a new column
NOT
Data Administrator (DAd)
Flat File
Calculated Column
26. SQL Commands - Two Things Specify data interested in - Indicate the ________
Word
accident
AVG
Session
27. Tally of how many rows meet criteria specified
Indexes
Hierarchial
COUNT
FROM
28. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Closing tag
SUM
Service Requestor
Application Programmers
29. Defines a new column
Property
Data Dictionary
Calculated Column
ASC
30. All Columns indicated and selected
COUNT
Subqueries
Web Browser
*
31. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Attributes
Performance
NOT
32. Data remains unchanged in database
Persistent
single value
HAVING
Information
33. Give the browser more specific information about that tag
Attributes
HAVING
INSERT INTO
Report
34. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tables
Property
Tags
*
35. Compares value of the column in the specified condition with the value specified
Equals Operator
DISTINCT
Web Applications
COUNT
36. Change order of rows in result table
SELECT
Data Recovery & Concurrance
UPDATE
ORDER BY
37. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
Foreign Keys
Subquery
Hardware
38. Writes programs that use or allow acces to databse with specific purpose
Hypertext Markup Language (HTML)
Service Requestor
Precedence of Logical Operators
Application Programers
39. Uses relationships between independent entities
Service Broker
Data Manipulation
Relational
Web Applications
40. Concatenated in SQL Server Database software using the addition symbol
Information
Query
ORDER BY
Fields
41. Some form of output - usually - printed - containing information
DELETE
Data Recovery & Concurrance
Report
COUNT
42. Data stored by DAd
Data Elements
Fields
Empty Elements
UPDATE
43. Supplies value for the search condition of the SELECT statement containing it
Service Provider
Cookie
Inner SELECT query
Hypertext Markup Language (HTML)
44. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Service Provider
Aggregate Functions
American Standard Code for Information Interchange (ASCII)
45. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
ALL
Indexes
WHERE
46. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Database
Hierarchial
American Standard Code for Information Interchange (ASCII)
47. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Data Definition
IN
Central control of data
48. Flat File Examples: Excel Spreadsheets - _____
single value
Word
Embedded SQL
Flat File
49. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Word
Interactive SQL
Database Administrator (DBA)
Structured Query Language (SQL)
50. Closed in the start tag by adding a slash to the start tag
Users
GROUP BY
Empty Elements
Dynamic