SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
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. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
to update
Shared
Empty Elements
2. Tally of how many rows meet criteria specified
COUNT
ALL
Indexes
UPDATE
3. Practice of writing code into a webpage that is not directly visible to the user
Equals Operator
Scripting
Joins
Data Elements
4. Data stored by DAd
Data Elements
Attributes
ORDER BY
Word
5. Some form of output - usually - printed - containing information
Web Browser
FROM
Stateless
Report
6. Begins an element
Opening tag
Integrated
Data Administrator (DAd)
AVG
7. One huge database to hold all data; Access to data - and use of system to add - update & print records
Bind
SUM
Fields
Database Management Systems (DBMS)
8. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Indexes
Hypertext Markup Language (HTML)
*
Cookie
9. Compares value of the column in the specified condition with the value specified
Persistent
WHERE
Query
Equals Operator
10. Writes programs that use or allow acces to databse with specific purpose
Calculated Column
Application Programers
Persistent
Data Dictionary
11. Some form of output - usually - printed - containing information
Subqueries
Web Browser
Report
DISTINCT
12. Columns containing numbers only
SUM
MAX
LIKE
Flat File
13. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Joins
Information
Central Control of data
ALL
14. Give the browser more specific information about that tag
Attributes
Service Requestor
Empty Elements
Web Service
15. Ongoing record of data reflecting the info defining the database
BETWEEN
GROUP BY
Data Dictionary
Application Programmers
16. Used in a SELECT clause in place of a column
hidden fields
Relational
Application Programmers
Aggregate Functions
17. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Query
Inner SELECT query
Service Broker
Scripting
18. Network node that discovers and invokes other software services to provide a buisness solution
BETWEEN
Relational
Service Requestor
LIKE
19. Large structured set of persistent data
Data Administrator (DAd)
Database
Hypertext Markup Language (HTML)
DISTINCT
20. Used to combine one query with another.
Subquery
SUM
ALL
Cookie
21. Averages the numeric values
Cookie
SUM
AVG
GROUP BY
22. Limits the output of the established groups into the derived result table
Database Administrator (DBA)
Dynamic
AVG
HAVING
23. Table displayed in ascending order
Users
Equals Operator
Hardware
ASC
24. Software system designed to support interoperable machine - to - machine interaction over a network
Application Programers
Web Service
UPDATE
Database Administrator (DBA)
25. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Integrated
Hypertext Markup Language (HTML)
to update
Subquery
26. Essentially a collection of services that communicate with eachother
Joins
Service-Oriented Architecture (SOA)
Hardware
hidden fields
27. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Session
Aggregate Functions
Web server
MIN
28. Copies multiple records at the same time using a SELECT statement
hidden fields
INSERT INTO
DISTINCT
Indexes
29. Straight implementation of raw data formatted into rows and columns
SELECT
Element Content
Database
Flat File
30. Grant acces and control to only specific information
Views
Data Dictionary
Candidate Keys
MIN
31. Closed in the start tag by adding a slash to the start tag
Database Management Systems (DBMS)
Empty Elements
Scripting
Shared
32. Ongoing record of data reflecting the info defining the database
accident
Hypertext Markup Language (HTML)
Integrated
Data Dictionary
33. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Attributes
NOT
Hierarchial
34. Allows use of single or multiple character wildcards with the underscore or percent symbol
BETWEEN
Central Control of data
LIKE
ASC
35. Changes the values in one or more selected rows of a table
DELETE
*
Web Service
UPDATE
36. Everything in enviroment becomes an object - expands on Priniples of relational databases
SELECT
Property
Data Elements
Object-Oriented Relational (OOR)
37. Characterizes operation of a relational database
Service Provider
Self Join
Joins
Service-Oriented Architecture (SOA)
38. Uses two values as limits - selecting any values between the two of them
BETWEEN
Data Dictionary
WHERE
WHERE
39. SQL Commands: Define tables - views - _____ - delete or insert info
Scripting
Shared
to update
End Users
40. Identifies columns to appear in the result
Data Elements
Outer SELECT query
SELECT
Opening tag
41. Supplies value for the search condition of the SELECT statement containing it
Central control of data
Inner SELECT query
Attributes
Service Broker
42. Describe information in a tree styled format
Hierarchial
Element Content
Shared
Data
43. Table displayed in descending order
Joins
MIN
Data Recovery & Concurrance
ESC
44. Order in which WHERE clause is evaluated and combined
*
Precedence of Logical Operators
Web server
to update
45. Three Basic Operations of SP - SR - SB: Publish - Find - ____
MAX
Bind
Data Administrator (DAd)
Relational
46. Order in which WHERE clause is evaluated and combined
LIKE
Precedence of Logical Operators
COUNT
Word
47. Looks like opening tag - but with a forward slash
DELETE
Closing tag
Shared
SUM
48. Using product as intended for its audience
End Users
HAVING
Session
Inner SELECT query
49. Ensures functions are done efficiently
Performance
HAVING
Primary Keys
Outer SELECT query
50. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Attributes
Application Programmers
Cookie