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. Used to combine one query to another
Web server
ASC
Subqueries
DISTINCT
2. Identifies columns to appear in the result
Hypertext Markup Language (HTML)
accident
BETWEEN
SELECT
3. Attribute in quotes
Equals Operator
Property
Hypertext Markup Language (HTML)
Hardware
4. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Calculated Column
Integrated
single value
5. Some form of output - usually - printed - containing information
Dynamic
Data Manipulation
Report
Service Broker
6. Table displayed in ascending order
accident
Word
ASC
Service-Oriented Architecture (SOA)
7. Definition of commands it can do
hidden fields
SELECT
Data Definition
Foreign Keys
8. Essentially a collection of services that communicate with eachother
SELECT
Database
Database Management Systems (DBMS)
Service-Oriented Architecture (SOA)
9. Uses relationships between independent entities
Relational
Data Dictionary
Service Broker
Functions
10. The Web is ___________
Web server
Stateless
End Users
Empty Elements
11. Change order of rows in result table
ORDER BY
Data Manipulation
Web Service
Database
12. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Information
Closing tag
Word
13. SELECT statment containing the nested query
MIN
SUM
SELECT
Outer SELECT query
14. Some form of output - usually - printed - containing information
Embedded SQL
Data Dictionary
Joins
Report
15. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
accident
Object-Oriented Relational (OOR)
Data Administrator (DAd)
16. Data in database has ability to be accessed and manipulated by several users
Hierarchial
Users
Shared
Embedded SQL
17. Selects from specific values in list
Self Join
Web Service
ESC
IN
18. Command based way to ask the database a question
Empty Elements
Query
Primary Keys
Closing tag
19. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
to update
AVG
Opening tag
Web server
20. Looks like opening tag - but with a forward slash
Query
NOT
Closing tag
Structured Query Language (SQL)
21. Executes commands one at a time - results being displayed immediately
Data Definition
DELETE
Interactive SQL
Inner SELECT query
22. Defines a new column
Database Administrator (DBA)
Data Definition
Hardware
Calculated Column
23. Ensures functions are done efficiently
Information
Performance
to update
MAX
24. Software system designed to support interface for a software asset that manages a specific set of tasks
Data Elements
Service Provider
Central Control of data
Embedded SQL
25. Writes programs that use or allow acces to databse with specific purpose
SELECT
Application Programers
Report
Indexes
26. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
ALL
Web server
Data
Element Content
27. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Embedded SQL
Self Join
Web Browser
28. Allows use of single or multiple character wildcards with the underscore or percent symbol
HAVING
Aliases
Data Recovery & Concurrance
LIKE
29. Uses two values as limits - selecting any values between the two of them
Aliases
Opening tag
BETWEEN
to update
30. One huge database to hold all data; Access to data - and use of system to add - update & print records
*
Bind
Database Management Systems (DBMS)
Precedence of Logical Operators
31. All Columns indicated and selected
*
Scripting
Service-Oriented Architecture (SOA)
Property
32. Most valuable asset of a database system.
Hardware
FROM
BETWEEN
Central control of data
33. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Object-Oriented Relational (OOR)
to update
Hardware
Database Management Systems (DBMS)
34. Data that has been processed into a format that is understandable by its audience
Stateless
Public Key Infrastructure (PKI)
Flat File
Information
35. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
NOT
Candidate Keys
Query
36. Flat File Examples: Excel Spreadsheets - _____
Word
American Standard Code for Information Interchange (ASCII)
Property
MAX
37. Has the highest precedence - followed by the AND - OR
Data Definition
SELECT
Performance
NOT
38. Ongoing record of data reflecting the info defining the database
Negation Operator
Application Programmers
Web Applications
Data Dictionary
39. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Data
Relational
Central Control of data
WHERE
40. Tally of how many rows meet criteria specified
WHERE
UPDATE
COUNT
Dynamic
41. Straight implementation of raw data formatted into rows and columns
Indexes
MIN
Flat File
GROUP BY
42. Fields in a relational table that match the primary key from one column to the primary key of another table.
Attributes
Data Definition
Foreign Keys
Service Provider
43. Allow useres to retrieve data and interact with content located on web pages within website
Subqueries
Web Browser
Persistent
Interactive SQL
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.
Attributes
Cookie
hidden fields
Primary Keys
45. Copies multiple records at the same time using a SELECT statement
INSERT INTO
AVG
Shared
ASC
46. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Comparison Operators
SELECT
Word
Application Programmers
47. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Attributes
UPDATE
Indexes
Functions
48. Has the highest precedence - followed by the AND - OR
Subqueries
ALL
NOT
WHERE
49. Ongoing record of data reflecting the info defining the database
Joins
FROM
Data Dictionary
Persistent
50. Used to combine one query to another
Subqueries
Web Applications
Indexes
Forward Slash