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. Change order of rows in result table
Foreign Keys
Persistent
ORDER BY
IN
2. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Foreign Keys
HAVING
Session
3. Create program files that include SQ after each command
SUM
Scripting
Embedded SQL
*
4. Basic Component of SQL
Tables
Bind
Fields
SUM
5. Cookies are more secure than______ - allowing travel on a website without loss of info
Flat File
Comparison Operators
hidden fields
Data Definition
6. Used to close a tag properly
Embedded SQL
Forward Slash
ALL
Hardware
7. Finds the lowest constant value in a column
Embedded SQL
Integrated
MAX
Hardware
8. Create program files that include SQ after each command
ORDER BY
Database
Embedded SQL
Foreign Keys
9. Data in database interacts & corresponds with other data
Web Browser
Tables
Integrated
Shared
10. Browser requests page - code is delivered - executed and done with
Aggregate Functions
ORDER BY
Dynamic
Integrated
11. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
Users
Element Content
Structured Query Language (SQL)
12. File stored on a user's machine that contains infor about application
INSERT INTO
Cookie
SUM
NOT
13. Some form of output - usually - printed - containing information
to update
HAVING
ASC
Report
14. Allows data recovery in case of corruption or loss
Object-Oriented Relational (OOR)
Indexes
Data Recovery & Concurrance
Flat File
15. Table displayed in descending order
Database Administrator (DBA)
ESC
DISTINCT
Query
16. SQL Commands: Define tables - views - _____ - delete or insert info
Stateless
Scripting
to update
Service Provider
17. Ongoing record of data reflecting the info defining the database
Aliases
Web server
accident
Data Dictionary
18. Columns containing numbers only
sp_help
Report
SUM
hidden fields
19. Cookies are more secure than______ - allowing travel on a website without loss of info
Service Provider
hidden fields
Hardware
Indexes
20. Network node that discovers and invokes other software services to provide a buisness solution
Shared
Property
Tables
Service Requestor
21. Essentially a collection of services that communicate with eachother
Information
Service-Oriented Architecture (SOA)
Database Administrator (DBA)
LIKE
22. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
End Users
Indexes
MIN
23. Software system designed to support interoperable machine - to - machine interaction over a network
IN
Data Recovery & Concurrance
Web Service
MAX
24. Uses two values as limits - selecting any values between the two of them
BETWEEN
to update
Empty Elements
American Standard Code for Information Interchange (ASCII)
25. Ongoing record of data reflecting the info defining the database
Public Key Infrastructure (PKI)
Data Dictionary
accident
ALL
26. Used to combine one query to another
Subqueries
Data Dictionary
*
Tables
27. SQL Commands - Two Things Specify data interested in - Indicate the ________
Service Provider
accident
ESC
UPDATE
28. Decides what data is stored in the databse and the manner it is stored
Scripting
Database
Data Administrator (DAd)
HAVING
29. Identifies columns to appear in the result
MAX
Forward Slash
Bind
SELECT
30. Supplies value for the search condition of the SELECT statement containing it
HAVING
GROUP BY
Inner SELECT query
AVG
31. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Outer SELECT query
Bind
Aggregate Functions
Service Broker
32. Writes programs that use or allow acces to databse with specific purpose
Views
Inner SELECT query
Application Programers
DISTINCT
33. Data that has been processed into a format that is understandable by its audience
MIN
Bind
Web server
Information
34. Join a table to a copy of itself
Self Join
Query
Interactive SQL
Precedence of Logical Operators
35. Copies multiple records at the same time using a SELECT statement
Web Browser
End Users
Information
INSERT INTO
36. Ensures functions are done efficiently
Performance
MAX
Negation Operator
Users
37. Flat File Examples: Excel Spreadsheets - _____
Fields
SUM
Word
Forward Slash
38. Ensures data is correct casings
Inner SELECT query
American Standard Code for Information Interchange (ASCII)
LIKE
*
39. Identifies columns to appear in the result
DISTINCT
Tags
SELECT
Tables
40. Large structured set of persistent data
Database
Web Browser
AVG
Tags
41. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
hidden fields
Indexes
ALL
Data Dictionary
42. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Object-Oriented Relational (OOR)
single value
Performance
43. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
hidden fields
Application Programmers
Self Join
Tags
44. Attribute in quotes
Hypertext Markup Language (HTML)
Property
UPDATE
Forward Slash
45. Compares value of the column in the specified condition with the value specified
Equals Operator
WHERE
Cookie
ESC
46. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.
Database Management Systems (DBMS)
Candidate Keys
Data Recovery & Concurrance
BETWEEN
47. Straight implementation of raw data formatted into rows and columns
Subqueries
hidden fields
Flat File
DISTINCT
48. Data remains unchanged in database
Report
Persistent
DISTINCT
Application Programmers
49. Table displayed in descending order
hidden fields
ESC
COUNT
Precedence of Logical Operators
50. Order in which WHERE clause is evaluated and combined
Tables
AVG
Precedence of Logical Operators
Aliases