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. Selects from specific values in list
IN
Service Requestor
Public Key Infrastructure (PKI)
AVG
2. Flat File Examples: Excel Spreadsheets - _____
Service Requestor
Views
COUNT
Word
3. Selects from specific values in list
Self Join
Web Browser
IN
Database Management Systems (DBMS)
4. Supplies value for the search condition of the SELECT statement containing it
ORDER BY
Inner SELECT query
Opening tag
ALL
5. Has the highest precedence - followed by the AND - OR
Subqueries
NOT
sp_help
GROUP BY
6. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
ESC
Indexes
Service Broker
Application Programmers
7. Everything between the start and end tag
Hypertext Markup Language (HTML)
Hardware
Element Content
Embedded SQL
8. Individuals that use - manipulate or maintain aspects of database
Data Elements
Interactive SQL
Users
Data Dictionary
9. Software system designed to support interface for a software asset that manages a specific set of tasks
Database Administrator (DBA)
Shared
Service Provider
Candidate Keys
10. Decides what data is stored in the databse and the manner it is stored
Hierarchial
to update
Forward Slash
Data Administrator (DAd)
11. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Attributes
ESC
SUM
Central Control of data
12. Grant acces and control to only specific information
Fields
Views
American Standard Code for Information Interchange (ASCII)
accident
13. Using product as intended for its audience
BETWEEN
End Users
Tags
Functions
14. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Cookie
Data Dictionary
Service Provider
15. Give the browser more specific information about that tag
Integrated
Attributes
Cookie
Data Manipulation
16. Cookies are more secure than______ - allowing travel on a website without loss of info
Aggregate Functions
hidden fields
Integrated
DELETE
17. Data that has been processed into a format that is understandable by its audience
Information
End Users
Integrated
Web Browser
18. All Columns indicated and selected
*
Word
Property
single value
19. Create program files that include SQ after each command
Embedded SQL
HAVING
Primary Keys
BETWEEN
20. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Hypertext Markup Language (HTML)
Bind
Query
21. Ongoing record of data reflecting the info defining the database
Data Dictionary
ALL
Indexes
Foreign Keys
22. File stored on a user's machine that contains infor about application
COUNT
IN
Tags
Cookie
23. Interact and manipulates the data in the database
Aliases
Data Manipulation
NOT
Hierarchial
24. Limits the rows that appear in the result mathcing a specified condition
WHERE
Application Programers
Integrated
Query
25. Limits the rows that appear in the result mathcing a specified condition
WHERE
Embedded SQL
Application Programmers
hidden fields
26. Data in database has ability to be accessed and manipulated by several users
Service Requestor
Property
Shared
Data Elements
27. Software system designed to support interoperable machine - to - machine interaction over a network
*
Aggregate Functions
Web Service
DELETE
28. Order in which WHERE clause is evaluated and combined
Views
Precedence of Logical Operators
MAX
NOT
29. Ensures functions are done efficiently
Relational
Performance
Element Content
Data Recovery & Concurrance
30. Definition of commands it can do
Data Definition
Web server
Data Administrator (DAd)
Views
31. Defines a new column
Calculated Column
GROUP BY
Joins
Bind
32. Create program files that include SQ after each command
Performance
Web Applications
Embedded SQL
Service Provider
33. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
*
Object-Oriented Relational (OOR)
Inner SELECT query
34. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
Information
BETWEEN
Session
Database Management Systems (DBMS)
35. Describe information in a tree styled format
DELETE
MIN
Hierarchial
Data Dictionary
36. Used in a SELECT clause in place of a column
Aggregate Functions
End Users
Comparison Operators
SUM
37. Uses two values as limits - selecting any values between the two of them
LIKE
BETWEEN
MIN
Session
38. Characterizes operation of a relational database
BETWEEN
Comparison Operators
Joins
INSERT INTO
39. Table displayed in descending order
HAVING
Functions
Web Browser
ESC
40. 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.
Flat File
Primary Keys
SUM
Aggregate Functions
41. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Embedded SQL
Hypertext Markup Language (HTML)
Subqueries
Joins
42. Join a table to a copy of itself
Self Join
SELECT
Word
End Users
43. Closed in the start tag by adding a slash to the start tag
Fields
Empty Elements
Public Key Infrastructure (PKI)
FROM
44. SQL finds and retrieves date
UPDATE
Integrated
Functions
Indexes
45. Everything between the start and end tag
Data
Hypertext Markup Language (HTML)
Negation Operator
Element Content
46. Interact and manipulates the data in the database
Data Administrator (DAd)
Web Service
Data Manipulation
Web server
47. Deletes selected rows
Web Browser
Public Key Infrastructure (PKI)
DELETE
Users
48. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
HAVING
Precedence of Logical Operators
Data Administrator (DAd)
Functions
49. Ensures functions are done efficiently
Service Requestor
Tables
Performance
hidden fields
50. Large structured set of persistent data
Bind
Database
Scripting
DELETE