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. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Shared
single value
Candidate Keys
Interactive SQL
2. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Interactive SQL
Data
Bind
Aliases
3. Practice of writing code into a webpage that is not directly visible to the user
Data Definition
Scripting
Dynamic
ESC
4. Finds the lowest constant value in a column
NOT
Web server
MAX
Data Administrator (DAd)
5. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Forward Slash
Data Manipulation
IN
6. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SELECT
SUM
Bind
Data Definition
7. = - < - > - <= - >= - <> - !
Central control of data
*
Indexes
Comparison Operators
8. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Application Programers
Functions
Hardware
Application Programers
9. Writes programs that use or allow acces to databse with specific purpose
Attributes
Negation Operator
Application Programers
Database
10. Allows use of single or multiple character wildcards with the underscore or percent symbol
SUM
LIKE
Fields
Web Browser
11. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Self Join
Hierarchial
Indexes
Structured Query Language (SQL)
12. Some form of output - usually - printed - containing information
Hypertext Markup Language (HTML)
Integrated
Database Management Systems (DBMS)
Report
13. File stored on a user's machine that contains infor about application
Cookie
Database Management Systems (DBMS)
Element Content
Database Management Systems (DBMS)
14. Columns containing numbers only
Closing tag
SUM
GROUP BY
INSERT INTO
15. Ensures data is correct casings
Central Control of data
Primary Keys
Bind
American Standard Code for Information Interchange (ASCII)
16. Flat File Examples: Excel Spreadsheets - _____
Database Administrator (DBA)
Word
LIKE
Data Recovery & Concurrance
17. Uses two values as limits - selecting any values between the two of them
Self Join
BETWEEN
Interactive SQL
Functions
18. Changes the values in one or more selected rows of a table
UPDATE
Hierarchial
LIKE
Integrated
19. Data stored by DAd
Data Elements
Empty Elements
Query
Web Service
20. Uses two values as limits - selecting any values between the two of them
BETWEEN
Embedded SQL
Relational
Database Administrator (DBA)
21. Deletes selected rows
SELECT
Users
Structured Query Language (SQL)
DELETE
22. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Cookie
SUM
Service Broker
Dynamic
23. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Scripting
Flat File
Relational
Service Broker
24. Finds the lowest ACII value in column
GROUP BY
MIN
AVG
ESC
25. Executes commands one at a time - results being displayed immediately
Interactive SQL
End Users
Persistent
Web Service
26. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Data Elements
Query
Data Elements
27. Everything between the start and end tag
Data Definition
SUM
Central Control of data
Element Content
28. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Views
Bind
Candidate Keys
29. Ongoing record of data reflecting the info defining the database
Interactive SQL
Persistent
Database
Data Dictionary
30. 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
Relational
Session
Application Programers
Inner SELECT query
31. Decides what data is stored in the databse and the manner it is stored
DISTINCT
Data Administrator (DAd)
Bind
Tags
32. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Closing tag
MIN
Structured Query Language (SQL)
BETWEEN
33. Identifies columns to appear in the result
ALL
Data Recovery & Concurrance
AVG
SELECT
34. Using product as intended for its audience
End Users
Flat File
Web Service
Opening tag
35. Software system designed to support interface for a software asset that manages a specific set of tasks
INSERT INTO
Service Provider
Fields
BETWEEN
36. Allows use of single or multiple character wildcards with the underscore or percent symbol
UPDATE
Data Recovery & Concurrance
Session
LIKE
37. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
hidden fields
Service Broker
Indexes
Element Content
38. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
American Standard Code for Information Interchange (ASCII)
NOT
Functions
Precedence of Logical Operators
39. Columns containing numbers only
SUM
Data Administrator (DAd)
Property
Attributes
40. Ensures functions are done efficiently
Data Dictionary
Performance
American Standard Code for Information Interchange (ASCII)
Relational
41. Finds the lowest ACII value in column
Data
MIN
Service Requestor
Functions
42. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
DELETE
Closing tag
Users
43. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Aliases
Aggregate Functions
Users
44. Text markups that form an element" sort of a "box" to hold things like text and other elements
Data Dictionary
Tags
Database
Negation Operator
45. Flat File Examples: Excel Spreadsheets - _____
Equals Operator
Word
Views
Database
46. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
MAX
ESC
Joins
47. Ensures data is correct casings
Closing tag
American Standard Code for Information Interchange (ASCII)
End Users
LIKE
48. SQL Commands: Define tables - views - _____ - delete or insert info
accident
to update
Dynamic
NOT
49. Begins an element
Property
sp_help
Performance
Opening tag
50. Used with another comparison operator - values become inverted
Interactive SQL
Negation Operator
accident
Dynamic