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. Straight implementation of raw data formatted into rows and columns
to update
Flat File
SUM
Subqueries
2. Defines a new column
Outer SELECT query
Data Recovery & Concurrance
Bind
Calculated Column
3. All Columns indicated and selected
Database Administrator (DBA)
Data Administrator (DAd)
*
NOT
4. Grant acces and control to only specific information
Views
ESC
Comparison Operators
Embedded SQL
5. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Word
Primary Keys
*
6. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Dynamic
American Standard Code for Information Interchange (ASCII)
Data Dictionary
Hardware
7. SQL Commands - Two Things Specify data interested in - Indicate the ________
Interactive SQL
Precedence of Logical Operators
Application Programmers
accident
8. Definition of commands it can do
Data Definition
American Standard Code for Information Interchange (ASCII)
Users
Cookie
9. Allows use of single or multiple character wildcards with the underscore or percent symbol
Report
LIKE
Comparison Operators
Data Recovery & Concurrance
10. Closed in the start tag by adding a slash to the start tag
Database
FROM
Data Definition
Empty Elements
11. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
ASC
Flat File
SUM
Application Programmers
12. SQL finds and retrieves date
Comparison Operators
INSERT INTO
Indexes
Dynamic
13. 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
Session
Inner SELECT query
*
Property
14. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
SELECT
Equals Operator
LIKE
15. SQL Commands - Two Things Specify data interested in - Indicate the ________
Attributes
accident
Query
Calculated Column
16. Some form of output - usually - printed - containing information
MIN
Tags
Report
Session
17. Basic Component of SQL
Tables
Dynamic
Scripting
Central Control of data
18. Command based way to ask the database a question
Query
Inner SELECT query
DELETE
Application Programmers
19. Uses two values as limits - selecting any values between the two of them
Views
Aggregate Functions
Tags
BETWEEN
20. 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
Tables
Service Broker
Session
Subqueries
21. Used to combine one query to another
LIKE
Subqueries
BETWEEN
Service Broker
22. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Application Programers
GROUP BY
Structured Query Language (SQL)
Cookie
23. Allows data recovery in case of corruption or loss
Element Content
Data Recovery & Concurrance
Session
Shared
24. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
ASC
Inner SELECT query
Joins
25. Used to remove duplicates from result table
Scripting
DISTINCT
Database Management Systems (DBMS)
Persistent
26. Limits the output of the established groups into the derived result table
Aliases
HAVING
Calculated Column
Database
27. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Hypertext Markup Language (HTML)
Query
Application Programmers
28. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
End Users
Data
Indexes
29. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Dynamic
Views
Scripting
30. Specifies the tables or views from which rows and columns are retrieved
Performance
FROM
Subqueries
Hierarchial
31. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Service-Oriented Architecture (SOA)
Database Administrator (DBA)
IN
32. Columns containing numbers only
Central control of data
Self Join
MAX
SUM
33. Join a table to a copy of itself
Equals Operator
Self Join
Hardware
Word
34. Command used to show the attributes that define a table.
Functions
sp_help
Data
Query
35. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities
Public Key Infrastructure (PKI)
Persistent
Property
End Users
36. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Persistent
ESC
Inner SELECT query
37. = - < - > - <= - >= - <> - !
Central Control of data
Service Provider
Comparison Operators
HAVING
38. Used to remove duplicates from result table
Scripting
Attributes
DISTINCT
single value
39. Using product as intended for its audience
Fields
Service-Oriented Architecture (SOA)
DISTINCT
End Users
40. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Information
Precedence of Logical Operators
Element Content
41. Flat File Examples: Excel Spreadsheets - _____
Embedded SQL
Word
Relational
Data Definition
42. Large structured set of persistent data
INSERT INTO
Database
Closing tag
NOT
43. Columns containing numbers only
Hypertext Markup Language (HTML)
Cookie
FROM
SUM
44. Writes programs that use or allow acces to databse with specific purpose
Fields
Flat File
Embedded SQL
Application Programers
45. Data in database has ability to be accessed and manipulated by several users
Shared
IN
Relational
Interactive SQL
46. Specifies the tables or views from which rows and columns are retrieved
Tables
Scripting
FROM
End Users
47. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
to update
Application Programmers
Relational
Public Key Infrastructure (PKI)
48. Finds the lowest ACII value in column
MIN
Closing tag
Outer SELECT query
Hierarchial
49. Changes the values in one or more selected rows of a table
Application Programmers
Service Provider
Data Definition
UPDATE
50. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Equals Operator
Closing tag
SELECT
Web server