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. Grant acces and control to only specific information
Views
Integrated
Application Programers
Equals Operator
2. Limits the rows that appear in the result mathcing a specified condition
Subquery
WHERE
Equals Operator
Forward Slash
3. Command based way to ask the database a question
Query
Data Definition
Word
Cookie
4. Give the browser more specific information about that tag
sp_help
Attributes
Self Join
Web Browser
5. Has the highest precedence - followed by the AND - OR
Forward Slash
NOT
Application Programmers
to update
6. Selects from specific values in list
IN
Query
WHERE
Interactive SQL
7. Used to combine one query with another.
hidden fields
Joins
Functions
Subquery
8. Some form of output - usually - printed - containing information
INSERT INTO
Closing tag
Report
FROM
9. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Closing tag
to update
Equals Operator
10. Straight implementation of raw data formatted into rows and columns
Service-Oriented Architecture (SOA)
Flat File
Fields
FROM
11. Allows use of single or multiple character wildcards with the underscore or percent symbol
Subqueries
Candidate Keys
LIKE
Subqueries
12. Limits the output of the established groups into the derived result table
Service-Oriented Architecture (SOA)
Hierarchial
Integrated
HAVING
13. Uses two values as limits - selecting any values between the two of them
ESC
GROUP BY
LIKE
BETWEEN
14. Used in a SELECT clause in place of a column
Aggregate Functions
Web Browser
Data Definition
Data Dictionary
15. Columns containing numbers only
Indexes
Joins
Calculated Column
SUM
16. Describe information in a tree styled format
Outer SELECT query
Relational
Service Provider
Hierarchial
17. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
NOT
MIN
SUM
Application Programmers
18. Averages the numeric values
Hypertext Markup Language (HTML)
AVG
SUM
ASC
19. Everything between the start and end tag
Element Content
Comparison Operators
End Users
Subquery
20. Three Basic Operations of SP - SR - SB: Publish - Find - ____
SUM
MAX
Service Broker
Bind
21. Concatenated in SQL Server Database software using the addition symbol
Fields
Application Programers
Data Elements
Dynamic
22. Large structured set of persistent data
Tags
Scripting
Comparison Operators
Database
23. SELECT statment containing the nested query
DELETE
Hardware
Outer SELECT query
Dynamic
24. SQL finds and retrieves date
Data Recovery & Concurrance
Joins
Indexes
Equals Operator
25. Uses relationships between independent entities
Data Definition
Relational
Data Elements
Subquery
26. All Columns indicated and selected
*
SELECT
Negation Operator
Precedence of Logical Operators
27. Identifies columns to appear in the result
Comparison Operators
WHERE
SELECT
DISTINCT
28. SQL Commands: Define tables - views - _____ - delete or insert info
to update
DISTINCT
Data Manipulation
LIKE
29. Allow useres to retrieve data and interact with content located on web pages within website
Database Management Systems (DBMS)
ASC
Web Browser
Query
30. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Negation Operator
Hypertext Markup Language (HTML)
Integrated
NOT
31. Describe information in a tree styled format
American Standard Code for Information Interchange (ASCII)
Aliases
Hierarchial
NOT
32. Limits the rows that appear in the result mathcing a specified condition
ORDER BY
Database Administrator (DBA)
Users
WHERE
33. Defines a new column
Views
Web server
Calculated Column
LIKE
34. Software system designed to support interface for a software asset that manages a specific set of tasks
Word
Data Recovery & Concurrance
Service Provider
Element Content
35. Finds the lowest constant value in a column
Tags
MAX
Data Manipulation
Data Dictionary
36. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Integrated
ALL
Web Browser
hidden fields
37. Columns containing numbers only
Web Browser
Database Management Systems (DBMS)
SUM
Equals Operator
38. Grant acces and control to only specific information
Web Service
Information
NOT
Views
39. Writes programs that use or allow acces to databse with specific purpose
WHERE
Application Programers
AVG
Central control of data
40. Used to combine one query to another
Subqueries
Structured Query Language (SQL)
Central control of data
Tags
41. Straight implementation of raw data formatted into rows and columns
COUNT
*
Cookie
Flat File
42. Meaningful info related to database
Cookie
Data
Subqueries
Views
43. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
Bind
Session
*
INSERT INTO
44. Writes programs that use or allow acces to databse with specific purpose
HAVING
Central Control of data
Information
Application Programers
45. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Object-Oriented Relational (OOR)
Precedence of Logical Operators
Aliases
Integrated
46. Change order of rows in result table
ORDER BY
Performance
accident
Element Content
47. Allow useres to retrieve data and interact with content located on web pages within website
Functions
Web Browser
accident
*
48. Fields in a relational table that match the primary key from one column to the primary key of another table.
Service-Oriented Architecture (SOA)
Web Browser
Users
Foreign Keys
49. Data stored by DAd
ORDER BY
Data Elements
Hierarchial
Aggregate Functions
50. Uses two values as limits - selecting any values between the two of them
BETWEEN
Persistent
Scripting
IN