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. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Self Join
Fields
LIKE
2. Change order of rows in result table
ORDER BY
Relational
BETWEEN
Hypertext Markup Language (HTML)
3. Limits the output of the established groups into the derived result table
HAVING
Tables
Hardware
Interactive SQL
4. Ongoing record of data reflecting the info defining the database
Flat File
accident
Data Dictionary
Bind
5. Changes the values in one or more selected rows of a table
GROUP BY
UPDATE
MIN
Empty Elements
6. SQL Commands - Two Things Specify data interested in - Indicate the ________
Data Recovery & Concurrance
accident
Persistent
End Users
7. Compares value of the column in the specified condition with the value specified
ESC
DISTINCT
Equals Operator
ALL
8. Definition of commands it can do
Data Definition
Precedence of Logical Operators
Hypertext Markup Language (HTML)
NOT
9. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Aliases
Bind
hidden fields
Hardware
10. Allows data recovery in case of corruption or loss
Bind
sp_help
Data Recovery & Concurrance
Equals Operator
11. Flat File Examples: Excel Spreadsheets - _____
Word
Attributes
Element Content
Comparison Operators
12. Grant acces and control to only specific information
Views
Tags
Calculated Column
Subquery
13. Table displayed in ascending order
Precedence of Logical Operators
ASC
IN
Service Provider
14. Used to close a tag properly
Negation Operator
Service Broker
Central Control of data
Forward Slash
15. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Aggregate Functions
Word
single value
Performance
16. Allows use of single or multiple character wildcards with the underscore or percent symbol
Opening tag
Integrated
LIKE
SUM
17. Used to remove duplicates from result table
ASC
Embedded SQL
DELETE
DISTINCT
18. Meaningful info related to database
Data
Aggregate Functions
Views
Central control of data
19. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
ASC
Structured Query Language (SQL)
Candidate Keys
Performance
20. Describe information in a tree styled format
INSERT INTO
Application Programers
Hierarchial
Data
21. Combines rows from a SELECT statements result table into a group
Shared
GROUP BY
Application Programmers
Dynamic
22. Table displayed in ascending order
ASC
Stateless
Opening tag
Hierarchial
23. Specifies the tables or views from which rows and columns are retrieved
DISTINCT
Web server
Relational
FROM
24. Deletes selected rows
HAVING
Performance
DELETE
GROUP BY
25. Concatenated in SQL Server Database software using the addition symbol
Dynamic
Database Management Systems (DBMS)
Bind
Fields
26. File stored on a user's machine that contains infor about application
BETWEEN
Cookie
MIN
Equals Operator
27. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Report
*
Element Content
28. The Web is ___________
Stateless
MAX
Central Control of data
Service-Oriented Architecture (SOA)
29. Give the browser more specific information about that tag
Fields
Dynamic
Bind
Attributes
30. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Outer SELECT query
Bind
Closing tag
Comparison Operators
31. Text markups that form an element" sort of a "box" to hold things like text and other elements
UPDATE
Report
Cookie
Tags
32. Tally of how many rows meet criteria specified
Application Programmers
NOT
Service Requestor
COUNT
33. Command based way to ask the database a question
LIKE
Database Management Systems (DBMS)
Query
accident
34. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Opening tag
Fields
NOT
35. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
DELETE
Inner SELECT query
Attributes
36. Grant acces and control to only specific information
Views
Attributes
Information
Data Recovery & Concurrance
37. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.
Primary Keys
INSERT INTO
Empty Elements
COUNT
38. Large structured set of persistent data
Users
Data Definition
Database
Flat File
39. SQL Commands: Define tables - views - _____ - delete or insert info
Negation Operator
Outer SELECT query
to update
End Users
40. SELECT statment containing the nested query
Outer SELECT query
Service Requestor
Central Control of data
DISTINCT
41. Uses two values as limits - selecting any values between the two of them
Data Definition
Opening tag
BETWEEN
Web Service
42. Selects from specific values in list
IN
hidden fields
Outer SELECT query
Cookie
43. Writes programs that use or allow acces to databse with specific purpose
Application Programers
ESC
End Users
Subqueries
44. Data that has been processed into a format that is understandable by its audience
Empty Elements
Element Content
Information
Database Management Systems (DBMS)
45. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Closing tag
Structured Query Language (SQL)
Indexes
Tables
46. Looks like opening tag - but with a forward slash
Service Broker
Closing tag
ORDER BY
Users
47. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Report
Aliases
Flat File
Foreign Keys
48. Text markups that form an element" sort of a "box" to hold things like text and other elements
Hierarchial
Tags
Dynamic
SELECT
49. Finds the lowest constant value in a column
MAX
Word
INSERT INTO
Web server
50. Has the highest precedence - followed by the AND - OR
Interactive SQL
American Standard Code for Information Interchange (ASCII)
BETWEEN
NOT