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. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Negation Operator
HAVING
ALL
Hypertext Markup Language (HTML)
2. File stored on a user's machine that contains infor about application
Tables
Cookie
Indexes
Database Administrator (DBA)
3. Basic Component of SQL
Web Browser
Service-Oriented Architecture (SOA)
Tables
ALL
4. Averages the numeric values
Comparison Operators
WHERE
MIN
AVG
5. Software system designed to support interface for a software asset that manages a specific set of tasks
Web Service
Service-Oriented Architecture (SOA)
Service Provider
Persistent
6. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Database
WHERE
Indexes
7. Give the browser more specific information about that tag
Persistent
Hierarchial
Structured Query Language (SQL)
Attributes
8. Allow useres to retrieve data and interact with content located on web pages within website
Functions
Web Browser
SUM
Data Administrator (DAd)
9. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
BETWEEN
Forward Slash
Relational
10. Join a table to a copy of itself
Inner SELECT query
Self Join
Database Management Systems (DBMS)
Dynamic
11. Data that has been processed into a format that is understandable by its audience
BETWEEN
Persistent
Information
Bind
12. Data in database has ability to be accessed and manipulated by several users
Bind
Shared
Outer SELECT query
IN
13. Concatenated in SQL Server Database software using the addition symbol
Attributes
Fields
BETWEEN
Joins
14. Compares value of the column in the specified condition with the value specified
Tags
Equals Operator
Negation Operator
Self Join
15. Definition of commands it can do
Object-Oriented Relational (OOR)
to update
Data Definition
Web server
16. Change order of rows in result table
ORDER BY
Primary Keys
Data Manipulation
BETWEEN
17. Data in database has ability to be accessed and manipulated by several users
DISTINCT
Scripting
Subquery
Shared
18. Compares value of the column in the specified condition with the value specified
Property
Information
Equals Operator
Calculated Column
19. Copies multiple records at the same time using a SELECT statement
INSERT INTO
MIN
Users
Data Elements
20. Create program files that include SQ after each command
Data Dictionary
Users
Embedded SQL
Opening tag
21. Large structured set of persistent data
Report
Database
Data Manipulation
Service Requestor
22. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Data Elements
single value
Data Dictionary
Embedded SQL
23. Allows data recovery in case of corruption or loss
Aliases
Calculated Column
Data Recovery & Concurrance
Closing tag
24. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
MIN
Calculated Column
SUM
ALL
25. Using product as intended for its audience
End Users
Primary Keys
Precedence of Logical Operators
INSERT INTO
26. Finds the lowest ACII value in column
Empty Elements
WHERE
MIN
Report
27. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
accident
MAX
GROUP BY
Aliases
28. Supplies value for the search condition of the SELECT statement containing it
COUNT
sp_help
UPDATE
Inner SELECT query
29. Practice of writing code into a webpage that is not directly visible to the user
FROM
MIN
Persistent
Scripting
30. Definition of commands it can do
Empty Elements
Data Definition
IN
Persistent
31. Characterizes operation of a relational database
Tags
Indexes
Joins
Tables
32. Closed in the start tag by adding a slash to the start tag
FROM
Empty Elements
Public Key Infrastructure (PKI)
Closing tag
33. Allows use of single or multiple character wildcards with the underscore or percent symbol
Data Administrator (DAd)
Integrated
LIKE
Aliases
34. Writes programs that use or allow acces to databse with specific purpose
Element Content
Aggregate Functions
Shared
Application Programers
35. All Columns indicated and selected
Query
*
Integrated
Tags
36. SQL Commands: Define tables - views - _____ - delete or insert info
to update
Tags
American Standard Code for Information Interchange (ASCII)
Data
37. Begins an element
Service Broker
Data Elements
Opening tag
LIKE
38. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Service Requestor
Outer SELECT query
Joins
39. Software system designed to support interface for a software asset that manages a specific set of tasks
Aggregate Functions
Object-Oriented Relational (OOR)
Dynamic
Service Provider
40. Basic Component of SQL
Tables
Functions
single value
INSERT INTO
41. Data in database interacts & corresponds with other data
Aggregate Functions
Integrated
Outer SELECT query
Application Programmers
42. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Interactive SQL
Hardware
Web server
43. Used to combine one query to another
NOT
Subqueries
Cookie
IN
44. Executes commands one at a time - results being displayed immediately
Property
Users
hidden fields
Interactive SQL
45. Allow useres to retrieve data and interact with content located on web pages within website
Cookie
LIKE
Web Browser
Empty Elements
46. Table displayed in ascending order
Hardware
ASC
INSERT INTO
Foreign Keys
47. Most valuable asset of a database system.
Scripting
SUM
Functions
Central control of data
48. SQL finds and retrieves date
Indexes
HAVING
Flat File
Primary Keys
49. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Data Definition
Functions
Indexes
DELETE
50. Deletes selected rows
ORDER BY
DELETE
Hardware
Views