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. All Columns indicated and selected
*
AVG
Report
Persistent
2. Individuals that use - manipulate or maintain aspects of database
Users
Integrated
Subqueries
Self Join
3. Begins an element
Database Administrator (DBA)
Integrated
Users
Opening tag
4. Has the highest precedence - followed by the AND - OR
Persistent
ALL
NOT
Equals Operator
5. Identifies columns to appear in the result
Subqueries
ESC
Web server
SELECT
6. One huge database to hold all data; Access to data - and use of system to add - update & print records
Primary Keys
American Standard Code for Information Interchange (ASCII)
Database Management Systems (DBMS)
DELETE
7. Characterizes operation of a relational database
Database
Joins
ALL
Hardware
8. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
ALL
Joins
SUM
Integrated
9. Uses relationships between independent entities
Database Administrator (DBA)
Relational
Word
Session
10. Copies multiple records at the same time using a SELECT statement
Performance
INSERT INTO
Application Programmers
Central Control of data
11. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Web server
IN
HAVING
Hypertext Markup Language (HTML)
12. Everything in enviroment becomes an object - expands on Priniples of relational databases
Web Service
MAX
Object-Oriented Relational (OOR)
Inner SELECT query
13. Finds the lowest ACII value in column
Indexes
Data
Calculated Column
MIN
14. Compares value of the column in the specified condition with the value specified
Subqueries
Empty Elements
Web Browser
Equals Operator
15. Averages the numeric values
AVG
Attributes
Database
Query
16. One huge database to hold all data; Access to data - and use of system to add - update & print records
Embedded SQL
Comparison Operators
Hypertext Markup Language (HTML)
Database Management Systems (DBMS)
17. Essentially a collection of services that communicate with eachother
Primary Keys
HAVING
Service-Oriented Architecture (SOA)
Central Control of data
18. Everything between the start and end tag
Element Content
Shared
ASC
single value
19. One of the tools that SQL uses to find and retrieve data.
Indexes
HAVING
Dynamic
Empty Elements
20. Give the browser more specific information about that tag
Integrated
Web Service
Web Applications
Attributes
21. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Integrated
Self Join
NOT
22. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
DISTINCT
Central Control of data
SELECT
Application Programmers
23. Large structured set of persistent data
Service Requestor
Scripting
Database
Subquery
24. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Word
Application Programmers
Candidate Keys
Attributes
25. SELECT statment containing the nested query
End Users
hidden fields
to update
Outer SELECT query
26. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Session
hidden fields
Service Broker
Candidate Keys
27. Data remains unchanged in database
Persistent
Hierarchial
Shared
AVG
28. Command used to show the attributes that define a table.
sp_help
ASC
Data Manipulation
ALL
29. Basic Component of SQL
Tables
Calculated Column
SUM
Scripting
30. Cookies are more secure than______ - allowing travel on a website without loss of info
Performance
Information
Data Manipulation
hidden fields
31. Command based way to ask the database a question
Indexes
Query
Self Join
Cookie
32. Finds the lowest constant value in a column
Interactive SQL
MAX
LIKE
Aggregate Functions
33. Three Basic Operations of SP - SR - SB: Publish - Find - ____
DELETE
BETWEEN
Bind
NOT
34. Table displayed in descending order
ASC
Inner SELECT query
ESC
End Users
35. Ensures data is correct casings
Report
Service-Oriented Architecture (SOA)
American Standard Code for Information Interchange (ASCII)
sp_help
36. SQL Commands - Two Things Specify data interested in - Indicate the ________
Hypertext Markup Language (HTML)
Report
accident
Users
37. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Public Key Infrastructure (PKI)
Hypertext Markup Language (HTML)
Aggregate Functions
38. Finds the lowest ACII value in column
Fields
Joins
Closing tag
MIN
39. Ensures data is correct casings
ALL
Database Management Systems (DBMS)
American Standard Code for Information Interchange (ASCII)
Indexes
40. Decides what data is stored in the databse and the manner it is stored
Interactive SQL
Data Administrator (DAd)
Precedence of Logical Operators
Database Administrator (DBA)
41. Ongoing record of data reflecting the info defining the database
Data Dictionary
Performance
Database Management Systems (DBMS)
Flat File
42. Data in database interacts & corresponds with other data
Relational
Integrated
Embedded SQL
*
43. SQL Commands - Two Things Specify data interested in - Indicate the ________
Empty Elements
accident
Data
Service Requestor
44. Used to remove duplicates from result table
DISTINCT
SUM
Data Dictionary
End Users
45. Writes programs that use or allow acces to databse with specific purpose
Dynamic
Hypertext Markup Language (HTML)
BETWEEN
Application Programers
46. Looks like opening tag - but with a forward slash
Closing tag
Data Manipulation
BETWEEN
Scripting
47. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Structured Query Language (SQL)
Query
Tags
Performance
48. Table displayed in ascending order
ASC
IN
Dynamic
MIN
49. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Aggregate Functions
AVG
Embedded SQL
ALL
50. Uses relationships between independent entities
Data Recovery & Concurrance
Relational
Query
Flat File