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. Uses relationships between independent entities
Relational
Service Broker
ESC
hidden fields
2. Selects from specific values in list
Flat File
IN
LIKE
MAX
3. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
SUM
Database Administrator (DBA)
Comparison Operators
single value
4. Finds the lowest ACII value in column
DISTINCT
Interactive SQL
MIN
AVG
5. Deletes selected rows
Session
Web Service
Indexes
DELETE
6. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Query
Service Provider
SUM
Hypertext Markup Language (HTML)
7. Flat File Examples: Excel Spreadsheets - _____
Query
Indexes
Flat File
Word
8. Limits the output of the established groups into the derived result table
Bind
HAVING
Web Browser
Element Content
9. Using product as intended for its audience
ORDER BY
Query
Service Requestor
End Users
10. Identifies columns to appear in the result
SELECT
Performance
Service Broker
Application Programers
11. Identifies columns to appear in the result
SELECT
Functions
INSERT INTO
Precedence of Logical Operators
12. Specifies the tables or views from which rows and columns are retrieved
Tags
FROM
Dynamic
Service Provider
13. Text markups that form an element" sort of a "box" to hold things like text and other elements
Performance
Integrated
Tags
Data Dictionary
14. One huge database to hold all data; Access to data - and use of system to add - update & print records
hidden fields
Inner SELECT query
Database Management Systems (DBMS)
Data Dictionary
15. Ensures data is correct casings
Relational
American Standard Code for Information Interchange (ASCII)
Query
Data Definition
16. Has the highest precedence - followed by the AND - OR
Data Elements
NOT
Structured Query Language (SQL)
ESC
17. Used to remove duplicates from result table
FROM
DISTINCT
Empty Elements
Service Requestor
18. Software system designed to support interface for a software asset that manages a specific set of tasks
LIKE
Negation Operator
Service Provider
Database Administrator (DBA)
19. Command used to show the attributes that define a table.
WHERE
ASC
Data Dictionary
sp_help
20. Data in database has ability to be accessed and manipulated by several users
Data Dictionary
Shared
UPDATE
Equals Operator
21. Allows use of single or multiple character wildcards with the underscore or percent symbol
Data Recovery & Concurrance
Views
LIKE
Web Browser
22. Large structured set of persistent data
Word
Scripting
Structured Query Language (SQL)
Database
23. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
DELETE
Comparison Operators
Central Control of data
Relational
24. Table displayed in ascending order
Tags
Property
Database Administrator (DBA)
ASC
25. Used in a SELECT clause in place of a column
Precedence of Logical Operators
Aggregate Functions
ESC
COUNT
26. = - < - > - <= - >= - <> - !
Service Provider
Data Administrator (DAd)
Users
Comparison Operators
27. Specifies the tables or views from which rows and columns are retrieved
ESC
FROM
Users
Bind
28. Tally of how many rows meet criteria specified
COUNT
AVG
Web Browser
Aggregate Functions
29. Looks like opening tag - but with a forward slash
Central Control of data
Closing tag
Data
single value
30. = - < - > - <= - >= - <> - !
SUM
Database
End Users
Comparison Operators
31. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
FROM
End Users
DISTINCT
Structured Query Language (SQL)
32. Limits the rows that appear in the result mathcing a specified condition
COUNT
single value
Comparison Operators
WHERE
33. Uses two values as limits - selecting any values between the two of them
Self Join
Hardware
BETWEEN
ALL
34. Supplies value for the search condition of the SELECT statement containing it
WHERE
DELETE
Inner SELECT query
Hypertext Markup Language (HTML)
35. Data in database interacts & corresponds with other data
ALL
Report
Integrated
ORDER BY
36. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Subqueries
Service Requestor
Web server
single value
37. Definition of commands it can do
Hypertext Markup Language (HTML)
Persistent
Database Management Systems (DBMS)
Data Definition
38. Cookies are more secure than______ - allowing travel on a website without loss of info
Cookie
hidden fields
Service Requestor
WHERE
39. Definition of commands it can do
Equals Operator
Data Definition
Empty Elements
ESC
40. Describe information in a tree styled format
American Standard Code for Information Interchange (ASCII)
Hierarchial
Database Administrator (DBA)
Users
41. Ensures data is correct casings
Web Browser
ASC
American Standard Code for Information Interchange (ASCII)
Word
42. Uses relationships between independent entities
Data Manipulation
COUNT
Element Content
Relational
43. Basic Component of SQL
Dynamic
Web Applications
Data
Tables
44. Essentially a collection of services that communicate with eachother
Web server
Service-Oriented Architecture (SOA)
Persistent
Service Broker
45. Straight implementation of raw data formatted into rows and columns
Data Dictionary
Tables
Indexes
Flat File
46. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Dynamic
Application Programmers
Session
Opening tag
47. Grant acces and control to only specific information
ORDER BY
Data Recovery & Concurrance
Service Requestor
Views
48. Responsible for technical implementation & maintenance of database on a design & physical level
Service Provider
accident
AVG
Database Administrator (DBA)
49. Browser requests page - code is delivered - executed and done with
Web Applications
Persistent
Property
Dynamic
50. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Web Service
SELECT
Property