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. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
MIN
Aggregate Functions
LIKE
2. Allows data recovery in case of corruption or loss
Hardware
ALL
Data Recovery & Concurrance
Data Administrator (DAd)
3. Finds the lowest ACII value in column
Tags
MIN
Property
SUM
4. Data that has been processed into a format that is understandable by its audience
Data Elements
Web Service
Outer SELECT query
Information
5. Averages the numeric values
AVG
American Standard Code for Information Interchange (ASCII)
Comparison Operators
Opening tag
6. Data in database has ability to be accessed and manipulated by several users
Equals Operator
Shared
Opening tag
Cookie
7. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
SUM
IN
FROM
8. Ongoing record of data reflecting the info defining the database
Comparison Operators
Data Dictionary
FROM
Opening tag
9. Essentially a collection of services that communicate with eachother
Web Service
hidden fields
NOT
Service-Oriented Architecture (SOA)
10. Tally of how many rows meet criteria specified
COUNT
Interactive SQL
Web Browser
Database
11. Cookies are more secure than______ - allowing travel on a website without loss of info
DISTINCT
Report
hidden fields
ALL
12. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Negation Operator
Structured Query Language (SQL)
ALL
13. Identifies columns to appear in the result
Service Broker
Database Administrator (DBA)
IN
SELECT
14. Data in database interacts & corresponds with other data
WHERE
Integrated
Central control of data
LIKE
15. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
DELETE
Stateless
ALL
Database Administrator (DBA)
16. Data remains unchanged in database
Property
SELECT
Service Provider
Persistent
17. Browser requests page - code is delivered - executed and done with
Query
Inner SELECT query
Dynamic
Performance
18. Everything in enviroment becomes an object - expands on Priniples of relational databases
accident
Outer SELECT query
Object-Oriented Relational (OOR)
Flat File
19. Basic Component of SQL
Tables
COUNT
*
Data Administrator (DAd)
20. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
ORDER BY
Public Key Infrastructure (PKI)
Structured Query Language (SQL)
American Standard Code for Information Interchange (ASCII)
21. Combines rows from a SELECT statements result table into a group
GROUP BY
NOT
Stateless
Query
22. Used to remove duplicates from result table
Data Manipulation
DISTINCT
Database Management Systems (DBMS)
Bind
23. Compares value of the column in the specified condition with the value specified
Equals Operator
Service Broker
Comparison Operators
Scripting
24. Has the highest precedence - followed by the AND - OR
Property
NOT
Negation Operator
Closing tag
25. Definition of commands it can do
Element Content
Empty Elements
Scripting
Data Definition
26. Defines a new column
Calculated Column
Application Programmers
Dynamic
Data Definition
27. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
FROM
Joins
Fields
28. Interact and manipulates the data in the database
Data Recovery & Concurrance
Indexes
Data Manipulation
Data Elements
29. Meaningful info related to database
DELETE
Data
Views
BETWEEN
30. Has the highest precedence - followed by the AND - OR
Shared
NOT
LIKE
WHERE
31. Ensures functions are done efficiently
Performance
Data Recovery & Concurrance
Data Dictionary
Data Manipulation
32. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Object-Oriented Relational (OOR)
Calculated Column
Bind
Aggregate Functions
33. Used in a SELECT clause in place of a column
BETWEEN
Aggregate Functions
American Standard Code for Information Interchange (ASCII)
Relational
34. Practice of writing code into a webpage that is not directly visible to the user
Calculated Column
Attributes
Service-Oriented Architecture (SOA)
Scripting
35. Using product as intended for its audience
End Users
Data Manipulation
Service Provider
SUM
36. Characterizes operation of a relational database
WHERE
Element Content
SELECT
Joins
37. Flat File Examples: Excel Spreadsheets - _____
hidden fields
Central Control of data
Self Join
Word
38. Defines a new column
Tags
AVG
Relational
Calculated Column
39. Large structured set of persistent data
Closing tag
Information
Database
Service Requestor
40. Table displayed in ascending order
Data Recovery & Concurrance
Information
Comparison Operators
ASC
41. Table displayed in descending order
SELECT
Embedded SQL
UPDATE
ESC
42. Give the browser more specific information about that tag
Structured Query Language (SQL)
Integrated
Service Broker
Attributes
43. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
COUNT
Functions
Application Programers
Joins
44. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Opening tag
Data Administrator (DAd)
SUM
45. Individuals that use - manipulate or maintain aspects of database
Service Provider
Central control of data
GROUP BY
Users
46. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
Database Administrator (DBA)
SUM
AVG
47. SQL finds and retrieves date
LIKE
Indexes
Data Elements
Attributes
48. SQL Commands: Define tables - views - _____ - delete or insert info
to update
Web Service
Shared
*
49. Supplies value for the search condition of the SELECT statement containing it
Hypertext Markup Language (HTML)
Performance
Service Provider
Inner SELECT query
50. Looks like opening tag - but with a forward slash
Self Join
Bind
Precedence of Logical Operators
Closing tag