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. Command used to show the attributes that define a table.
Public Key Infrastructure (PKI)
Web Browser
sp_help
Bind
2. Attribute in quotes
AVG
Property
American Standard Code for Information Interchange (ASCII)
Opening tag
3. File stored on a user's machine that contains infor about application
Cookie
Data Dictionary
Outer SELECT query
HAVING
4. Using product as intended for its audience
Data Elements
ASC
Cookie
End Users
5. Executes commands one at a time - results being displayed immediately
Session
Database Management Systems (DBMS)
Self Join
Interactive SQL
6. Begins an element
SUM
Opening tag
Dynamic
Web Applications
7. Interact and manipulates the data in the database
Data Manipulation
Hierarchial
Relational
Data Dictionary
8. Individuals that use - manipulate or maintain aspects of database
Indexes
Embedded SQL
Closing tag
Users
9. Everything between the start and end tag
Element Content
Aggregate Functions
LIKE
Flat File
10. Flat File Examples: Excel Spreadsheets - _____
End Users
Word
Self Join
Service-Oriented Architecture (SOA)
11. Straight implementation of raw data formatted into rows and columns
COUNT
Web Service
Flat File
SUM
12. Basic Component of SQL
Tables
LIKE
Tags
FROM
13. Used with another comparison operator - values become inverted
Relational
MIN
Structured Query Language (SQL)
Negation Operator
14. Order in which WHERE clause is evaluated and combined
Web Browser
Hypertext Markup Language (HTML)
Property
Precedence of Logical Operators
15. All Columns indicated and selected
Forward Slash
*
Aliases
Integrated
16. Closed in the start tag by adding a slash to the start tag
Indexes
accident
Application Programers
Empty Elements
17. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Indexes
Property
Indexes
18. Definition of commands it can do
Web Browser
Bind
hidden fields
Data Definition
19. Describe information in a tree styled format
Hierarchial
Interactive SQL
Embedded SQL
Indexes
20. Data in database has ability to be accessed and manipulated by several users
AVG
Shared
Subquery
Attributes
21. Cookies are more secure than______ - allowing travel on a website without loss of info
Web Service
hidden fields
single value
Attributes
22. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Service Broker
Performance
Session
23. Describe information in a tree styled format
Fields
Hierarchial
GROUP BY
Structured Query Language (SQL)
24. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
UPDATE
American Standard Code for Information Interchange (ASCII)
single value
Aggregate Functions
25. Limits the output of the established groups into the derived result table
Embedded SQL
Indexes
HAVING
Information
26. Selects from specific values in list
IN
Data Manipulation
Database Management Systems (DBMS)
Aliases
27. = - < - > - <= - >= - <> - !
Data Definition
Comparison Operators
SUM
COUNT
28. Meaningful info related to database
Views
WHERE
Data
SUM
29. Decides what data is stored in the databse and the manner it is stored
FROM
Primary Keys
Data Administrator (DAd)
Indexes
30. Essentially a collection of services that communicate with eachother
Hypertext Markup Language (HTML)
Dynamic
Service-Oriented Architecture (SOA)
Application Programmers
31. Data that has been processed into a format that is understandable by its audience
Views
MAX
ALL
Information
32. SQL Commands: Define tables - views - _____ - delete or insert info
Data Manipulation
to update
Subqueries
Word
33. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
NOT
Web Applications
AVG
*
34. Browser requests page - code is delivered - executed and done with
Dynamic
Web server
Flat File
American Standard Code for Information Interchange (ASCII)
35. Closed in the start tag by adding a slash to the start tag
Database Administrator (DBA)
LIKE
Empty Elements
Relational
36. Combines rows from a SELECT statements result table into a group
GROUP BY
Closing tag
ASC
Web Applications
37. Ensures functions are done efficiently
Closing tag
Scripting
Performance
sp_help
38. Text markups that form an element" sort of a "box" to hold things like text and other elements
Word
Tags
Empty Elements
Web Browser
39. Limits the rows that appear in the result mathcing a specified condition
Aggregate Functions
Subqueries
BETWEEN
WHERE
40. Used with another comparison operator - values become inverted
Indexes
SELECT
UPDATE
Negation Operator
41. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
Shared
Fields
Web Browser
42. Using product as intended for its audience
Central Control of data
End Users
Self Join
Dynamic
43. Uses two values as limits - selecting any values between the two of them
Inner SELECT query
Comparison Operators
BETWEEN
End Users
44. Compares value of the column in the specified condition with the value specified
Equals Operator
Property
Tables
Attributes
45. Looks like opening tag - but with a forward slash
Inner SELECT query
SUM
Cookie
Closing tag
46. Flat File Examples: Excel Spreadsheets - _____
Data Definition
Word
sp_help
Service-Oriented Architecture (SOA)
47. Interact and manipulates the data in the database
Hypertext Markup Language (HTML)
Data Manipulation
UPDATE
Structured Query Language (SQL)
48. Responsible for technical implementation & maintenance of database on a design & physical level
Flat File
Database Administrator (DBA)
Indexes
Joins
49. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
NOT
Application Programmers
HAVING
AVG
50. Command based way to ask the database a question
GROUP BY
Query
Service-Oriented Architecture (SOA)
Central Control of data