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. Limits the rows that appear in the result mathcing a specified condition
Aliases
Data Manipulation
INSERT INTO
WHERE
2. Concatenated in SQL Server Database software using the addition symbol
Aliases
Fields
NOT
Web Service
3. Meaningful info related to database
*
Aliases
Data
Users
4. Create program files that include SQ after each command
Embedded SQL
American Standard Code for Information Interchange (ASCII)
End Users
Closing tag
5. Network node that discovers and invokes other software services to provide a buisness solution
Shared
IN
COUNT
Service Requestor
6. Columns containing numbers only
Outer SELECT query
SUM
Report
Persistent
7. Give the browser more specific information about that tag
Attributes
IN
Tags
MAX
8. Everything in enviroment becomes an object - expands on Priniples of relational databases
BETWEEN
Hardware
SUM
Object-Oriented Relational (OOR)
9. Compares value of the column in the specified condition with the value specified
Hardware
Subquery
Equals Operator
Fields
10. Compares value of the column in the specified condition with the value specified
MAX
Equals Operator
INSERT INTO
*
11. Used with another comparison operator - values become inverted
Negation Operator
hidden fields
LIKE
HAVING
12. Essentially a collection of services that communicate with eachother
Database Management Systems (DBMS)
Shared
Indexes
Service-Oriented Architecture (SOA)
13. Limits the output of the established groups into the derived result table
AVG
HAVING
Application Programers
ORDER BY
14. Most valuable asset of a database system.
Report
Central control of data
NOT
Object-Oriented Relational (OOR)
15. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Hierarchial
Negation Operator
SUM
Aliases
16. Large structured set of persistent data
Report
Fields
Database
Data Administrator (DAd)
17. Software system designed to support interface for a software asset that manages a specific set of tasks
Persistent
Service Provider
Hypertext Markup Language (HTML)
UPDATE
18. Has the highest precedence - followed by the AND - OR
Hardware
NOT
Equals Operator
Cookie
19. Text markups that form an element" sort of a "box" to hold things like text and other elements
Fields
Empty Elements
Data Elements
Tags
20. Specifies the tables or views from which rows and columns are retrieved
Tables
Central control of data
Data Elements
FROM
21. Finds the lowest ACII value in column
Indexes
MIN
HAVING
Data Manipulation
22. Uses relationships between independent entities
Performance
DISTINCT
NOT
Relational
23. Text markups that form an element" sort of a "box" to hold things like text and other elements
Database Administrator (DBA)
Aggregate Functions
Tags
SELECT
24. Defines a new column
Cookie
Subqueries
Calculated Column
Data Manipulation
25. Used in a SELECT clause in place of a column
Web server
Web server
Functions
Aggregate Functions
26. Limits the rows that appear in the result mathcing a specified condition
WHERE
sp_help
SELECT
Data Administrator (DAd)
27. SQL finds and retrieves date
to update
American Standard Code for Information Interchange (ASCII)
SUM
Indexes
28. Data in database has ability to be accessed and manipulated by several users
Views
GROUP BY
Query
Shared
29. Flat File Examples: Excel Spreadsheets - _____
NOT
Word
MAX
to update
30. Give the browser more specific information about that tag
AVG
Attributes
Hypertext Markup Language (HTML)
Web Service
31. Command based way to ask the database a question
ORDER BY
Application Programers
Query
Application Programmers
32. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Comparison Operators
single value
Service Broker
Database Management Systems (DBMS)
33. Flat File Examples: Excel Spreadsheets - _____
FROM
Precedence of Logical Operators
Word
MIN
34. Tally of how many rows meet criteria specified
Data Elements
SUM
Subquery
COUNT
35. Finds the lowest constant value in a column
Stateless
MAX
Persistent
ALL
36. Averages the numeric values
Functions
GROUP BY
AVG
Query
37. Allows data recovery in case of corruption or loss
Joins
Views
Negation Operator
Data Recovery & Concurrance
38. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Users
Inner SELECT query
Structured Query Language (SQL)
Persistent
39. Tally of how many rows meet criteria specified
COUNT
Element Content
Element Content
Precedence of Logical Operators
40. Definition of commands it can do
UPDATE
Indexes
Data Definition
Calculated Column
41. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Closing tag
IN
Application Programers
42. All Columns indicated and selected
*
Data Definition
Service Requestor
AVG
43. Data remains unchanged in database
Persistent
Service Requestor
Integrated
Calculated Column
44. Has the highest precedence - followed by the AND - OR
to update
FROM
Web Browser
NOT
45. Data stored by DAd
SUM
Database Administrator (DBA)
UPDATE
Data Elements
46. Begins an element
*
GROUP BY
SUM
Opening tag
47. Looks like opening tag - but with a forward slash
Web Browser
Database Management Systems (DBMS)
Closing tag
Data Definition
48. 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.
Indexes
NOT
Candidate Keys
Report
49. Describe information in a tree styled format
hidden fields
ORDER BY
MIN
Hierarchial
50. SQL finds and retrieves date
Indexes
Report
Aggregate Functions
NOT