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 Classes of Users: End Users - ____________ - Database Administrator (DBA)
hidden fields
Subqueries
Report
Application Programmers
2. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Primary Keys
Shared
End Users
3. Browser requests page - code is delivered - executed and done with
Data Definition
Session
Service-Oriented Architecture (SOA)
Dynamic
4. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Tables
Calculated Column
End Users
5. Looks like opening tag - but with a forward slash
Property
Closing tag
Service Broker
Data Administrator (DAd)
6. Large structured set of persistent data
Database
Service Requestor
accident
Attributes
7. Large structured set of persistent data
Database
NOT
Users
Outer SELECT query
8. = - < - > - <= - >= - <> - !
SUM
SELECT
Aliases
Comparison Operators
9. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Equals Operator
Stateless
Views
10. Ongoing record of data reflecting the info defining the database
Web server
Data Dictionary
Application Programers
Attributes
11. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
sp_help
BETWEEN
Subqueries
Aliases
12. Everything between the start and end tag
Query
Aliases
Negation Operator
Element Content
13. Data that has been processed into a format that is understandable by its audience
Information
Data Dictionary
BETWEEN
COUNT
14. Grant acces and control to only specific information
Query
Database Management Systems (DBMS)
BETWEEN
Views
15. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Service Requestor
Fields
Structured Query Language (SQL)
accident
16. Essentially a collection of services that communicate with eachother
UPDATE
Service-Oriented Architecture (SOA)
Word
Data Definition
17. Flat File Examples: Excel Spreadsheets - _____
Performance
LIKE
Word
Hypertext Markup Language (HTML)
18. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
SUM
Relational
Data Definition
Structured Query Language (SQL)
19. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Scripting
Web server
Comparison Operators
Comparison Operators
20. Some form of output - usually - printed - containing information
Web Browser
Embedded SQL
Report
Dynamic
21. SQL Commands - Two Things Specify data interested in - Indicate the ________
Subquery
Bind
Self Join
accident
22. Give the browser more specific information about that tag
LIKE
Subquery
Service Requestor
Attributes
23. Ongoing record of data reflecting the info defining the database
ESC
Application Programmers
Data Dictionary
Web server
24. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Database Administrator (DBA)
UPDATE
Web Applications
25. Changes the values in one or more selected rows of a table
Data
End Users
Functions
UPDATE
26. Selects from specific values in list
Bind
Attributes
IN
single value
27. Practice of writing code into a webpage that is not directly visible to the user
Scripting
LIKE
Database
SUM
28. The Web is ___________
AVG
Stateless
SUM
Bind
29. SQL Commands: Define tables - views - _____ - delete or insert info
Views
Web server
Property
to update
30. Interact and manipulates the data in the database
Hypertext Markup Language (HTML)
Data Manipulation
Empty Elements
Subquery
31. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
ESC
Property
INSERT INTO
32. SQL finds and retrieves date
Candidate Keys
accident
Indexes
Data Administrator (DAd)
33. Give the browser more specific information about that tag
SELECT
Attributes
DISTINCT
Web Applications
34. Definition of commands it can do
Users
Data Definition
Service Provider
American Standard Code for Information Interchange (ASCII)
35. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Comparison Operators
ALL
Aggregate Functions
Joins
36. SQL Commands - Two Things Specify data interested in - Indicate the ________
Application Programmers
Functions
Service Provider
accident
37. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Data Recovery & Concurrance
DELETE
Hardware
Performance
38. Identifies columns to appear in the result
Relational
Indexes
Dynamic
SELECT
39. Three Basic Operations of SP - SR - SB: Publish - Find - ____
American Standard Code for Information Interchange (ASCII)
Bind
Data Administrator (DAd)
Calculated Column
40. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
SELECT
Shared
Word
41. Basic Component of SQL
MAX
Hypertext Markup Language (HTML)
Functions
Tables
42. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Data Dictionary
DELETE
Aggregate Functions
43. Interact and manipulates the data in the database
Data Manipulation
Integrated
Precedence of Logical Operators
Data Dictionary
44. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
DISTINCT
AVG
Joins
45. Create program files that include SQ after each command
HAVING
Application Programers
Users
Embedded SQL
46. Practice of writing code into a webpage that is not directly visible to the user
Data Administrator (DAd)
Scripting
WHERE
Web Service
47. Begins an element
ESC
BETWEEN
Word
Opening tag
48. Data stored by DAd
Public Key Infrastructure (PKI)
Word
Data Elements
Shared
49. Used to remove duplicates from result table
DELETE
Opening tag
DISTINCT
to update
50. Command based way to ask the database a question
Word
Query
Tags
Data Administrator (DAd)