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. Interact and manipulates the data in the database
Data Manipulation
NOT
ORDER BY
Precedence of Logical Operators
2. Software system designed to support interface for a software asset that manages a specific set of tasks
Performance
Aliases
to update
Service Provider
3. Table displayed in ascending order
ASC
Web Service
Equals Operator
Service Provider
4. Basic Component of SQL
Database Management Systems (DBMS)
Tables
Aggregate Functions
Data Manipulation
5. SQL Commands - Two Things Specify data interested in - Indicate the ________
NOT
accident
Data Recovery & Concurrance
COUNT
6. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Aggregate Functions
Web Service
Integrated
7. Combines rows from a SELECT statements result table into a group
BETWEEN
Cookie
GROUP BY
Data Recovery & Concurrance
8. All Columns indicated and selected
Self Join
*
LIKE
Bind
9. Attribute in quotes
DISTINCT
Property
UPDATE
UPDATE
10. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Data Recovery & Concurrance
Aliases
Hypertext Markup Language (HTML)
Joins
11. Uses two values as limits - selecting any values between the two of them
BETWEEN
Data Dictionary
Data Manipulation
GROUP BY
12. Data that has been processed into a format that is understandable by its audience
Service Broker
Persistent
Information
Bind
13. Describe information in a tree styled format
Hierarchial
Tags
*
HAVING
14. File stored on a user's machine that contains infor about application
Web Service
Interactive SQL
Users
Cookie
15. Writes programs that use or allow acces to databse with specific purpose
Database Management Systems (DBMS)
Negation Operator
Application Programers
FROM
16. Allows data recovery in case of corruption or loss
Central control of data
BETWEEN
Property
Data Recovery & Concurrance
17. Data stored by DAd
HAVING
Data Elements
Self Join
Scripting
18. Large structured set of persistent data
Calculated Column
ALL
GROUP BY
Database
19. Three Basic Operations of SP - SR - SB: Publish - Find - ____
UPDATE
Application Programers
Aliases
Bind
20. Defines a new column
Calculated Column
Report
SUM
MAX
21. Selects from specific values in list
IN
LIKE
GROUP BY
Database
22. Ongoing record of data reflecting the info defining the database
Data Dictionary
WHERE
SELECT
Aggregate Functions
23. Copies multiple records at the same time using a SELECT statement
Database
Attributes
Indexes
INSERT INTO
24. Using product as intended for its audience
End Users
Database Management Systems (DBMS)
Views
Equals Operator
25. Used with another comparison operator - values become inverted
Self Join
Negation Operator
Data Manipulation
HAVING
26. Allows use of single or multiple character wildcards with the underscore or percent symbol
*
Bind
LIKE
Bind
27. Join a table to a copy of itself
Subqueries
Element Content
Self Join
Application Programers
28. Straight implementation of raw data formatted into rows and columns
Object-Oriented Relational (OOR)
Flat File
Data
Precedence of Logical Operators
29. Identifies columns to appear in the result
Aliases
Web Browser
SELECT
HAVING
30. Closed in the start tag by adding a slash to the start tag
Hypertext Markup Language (HTML)
Candidate Keys
Subqueries
Empty Elements
31. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
End Users
Flat File
Users
32. Some form of output - usually - printed - containing information
Web server
Report
DELETE
MIN
33. Used to remove duplicates from result table
Embedded SQL
Database Management Systems (DBMS)
DISTINCT
Equals Operator
34. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
AVG
Hardware
single value
End Users
35. Allow useres to retrieve data and interact with content located on web pages within website
ESC
Primary Keys
Web Browser
Tables
36. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
GROUP BY
Application Programmers
Forward Slash
NOT
37. Allows use of single or multiple character wildcards with the underscore or percent symbol
Candidate Keys
Web Browser
LIKE
Public Key Infrastructure (PKI)
38. Limits the output of the established groups into the derived result table
Information
HAVING
Service-Oriented Architecture (SOA)
ASC
39. Looks like opening tag - but with a forward slash
Closing tag
to update
Scripting
DISTINCT
40. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
hidden fields
ALL
Comparison Operators
41. Executes commands one at a time - results being displayed immediately
Data Elements
Web Browser
Data Administrator (DAd)
Interactive SQL
42. Used to combine one query to another
Session
INSERT INTO
Subqueries
Element Content
43. Attribute in quotes
Database Management Systems (DBMS)
Property
IN
Inner SELECT query
44. Interact and manipulates the data in the database
Negation Operator
Data Manipulation
Application Programmers
SELECT
45. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Bind
Central Control of data
Functions
accident
46. Describe information in a tree styled format
Hierarchial
Interactive SQL
Data Elements
End Users
47. Changes the values in one or more selected rows of a table
UPDATE
American Standard Code for Information Interchange (ASCII)
Shared
Aliases
48. Has the highest precedence - followed by the AND - OR
Web server
single value
Hierarchial
NOT
49. Command used to show the attributes that define a table.
Indexes
sp_help
Data Manipulation
IN
50. Data stored by DAd
Attributes
Data Elements
ORDER BY
Word