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. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Indexes
Shared
Performance
2. Ensures functions are done efficiently
Performance
Indexes
Users
Candidate Keys
3. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
LIKE
American Standard Code for Information Interchange (ASCII)
Primary Keys
4. Limits the output of the established groups into the derived result table
DISTINCT
Service Provider
Hypertext Markup Language (HTML)
HAVING
5. Limits the rows that appear in the result mathcing a specified condition
Service-Oriented Architecture (SOA)
Application Programers
WHERE
Database
6. Meaningful info related to database
End Users
GROUP BY
Data
Users
7. Finds the lowest ACII value in column
Bind
Object-Oriented Relational (OOR)
Service Provider
MIN
8. Used with another comparison operator - values become inverted
Service Provider
to update
Calculated Column
Negation Operator
9. Allows use of single or multiple character wildcards with the underscore or percent symbol
sp_help
LIKE
Relational
American Standard Code for Information Interchange (ASCII)
10. Compares value of the column in the specified condition with the value specified
DISTINCT
Performance
Indexes
Equals Operator
11. Table displayed in descending order
Users
Aliases
Web Applications
ESC
12. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Comparison Operators
Aggregate Functions
Central Control of data
Closing tag
13. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Subqueries
Web Browser
Flat File
14. Individuals that use - manipulate or maintain aspects of database
FROM
Flat File
Database Administrator (DBA)
Users
15. Data in database has ability to be accessed and manipulated by several users
Integrated
Shared
Data Manipulation
Flat File
16. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Self Join
Subqueries
Aggregate Functions
17. SQL Commands: Define tables - views - _____ - delete or insert info
SUM
to update
Persistent
Indexes
18. One huge database to hold all data; Access to data - and use of system to add - update & print records
Session
Query
Database Management Systems (DBMS)
Outer SELECT query
19. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Data
SUM
Precedence of Logical Operators
ORDER BY
20. Allow useres to retrieve data and interact with content located on web pages within website
ESC
Web Browser
ESC
LIKE
21. Most valuable asset of a database system.
BETWEEN
Central control of data
Session
AVG
22. SQL Commands: Define tables - views - _____ - delete or insert info
Empty Elements
Outer SELECT query
to update
ORDER BY
23. Concatenated in SQL Server Database software using the addition symbol
Central control of data
Fields
Data Recovery & Concurrance
Empty Elements
24. Attribute in quotes
Performance
MIN
DISTINCT
Property
25. Fields in a relational table that match the primary key from one column to the primary key of another table.
Foreign Keys
Closing tag
DELETE
Subqueries
26. Executes commands one at a time - results being displayed immediately
Fields
Interactive SQL
Comparison Operators
Fields
27. Identifies columns to appear in the result
Embedded SQL
SELECT
Public Key Infrastructure (PKI)
Integrated
28. Concatenated in SQL Server Database software using the addition symbol
Fields
Data Recovery & Concurrance
Negation Operator
Persistent
29. Begins an element
Comparison Operators
Opening tag
Hardware
Web Applications
30. Used to combine one query to another
Subqueries
UPDATE
Data Definition
accident
31. Change order of rows in result table
Indexes
Interactive SQL
ORDER BY
MIN
32. SQL finds and retrieves date
Hardware
Hypertext Markup Language (HTML)
Indexes
Central Control of data
33. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Opening tag
Tags
Users
Web server
34. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Flat File
Fields
Database Administrator (DBA)
35. Some form of output - usually - printed - containing information
Functions
Report
Indexes
Web server
36. Some form of output - usually - printed - containing information
Report
Precedence of Logical Operators
Performance
American Standard Code for Information Interchange (ASCII)
37. Columns containing numbers only
WHERE
SUM
Object-Oriented Relational (OOR)
Database Administrator (DBA)
38. Combines rows from a SELECT statements result table into a group
Interactive SQL
GROUP BY
Structured Query Language (SQL)
Data Dictionary
39. Changes the values in one or more selected rows of a table
Primary Keys
Scripting
Negation Operator
UPDATE
40. Large structured set of persistent data
Database
Information
Property
Tables
41. Data remains unchanged in database
Attributes
Persistent
Central Control of data
IN
42. Data in database interacts & corresponds with other data
Inner SELECT query
Persistent
Joins
Integrated
43. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Data
Central Control of data
Indexes
Shared
44. Used to remove duplicates from result table
DISTINCT
Data Administrator (DAd)
Calculated Column
Stateless
45. SELECT statment containing the nested query
DELETE
Query
Tables
Outer SELECT query
46. Basic Component of SQL
Comparison Operators
AVG
Tables
Data Manipulation
47. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Aggregate Functions
Joins
IN
48. All Columns indicated and selected
Information
Data Recovery & Concurrance
*
Session
49. Specifies the tables or views from which rows and columns are retrieved
Data
FROM
MIN
Dynamic
50. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Stateless
single value
Data Administrator (DAd)
End Users