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. Ensures functions are done efficiently
Tables
accident
Performance
Equals Operator
2. Limits the rows that appear in the result mathcing a specified condition
WHERE
Web Service
Service Broker
Outer SELECT query
3. All Columns indicated and selected
Data Administrator (DAd)
*
Information
Data Definition
4. Selects from specific values in list
IN
Aggregate Functions
Session
FROM
5. Used with another comparison operator - values become inverted
Stateless
Information
Negation Operator
accident
6. Finds the lowest ACII value in column
MIN
Data Definition
Joins
SELECT
7. Everything in enviroment becomes an object - expands on Priniples of relational databases
Users
Word
Query
Object-Oriented Relational (OOR)
8. Order in which WHERE clause is evaluated and combined
Aliases
Equals Operator
Precedence of Logical Operators
AVG
9. Limits the output of the established groups into the derived result table
FROM
Hierarchial
HAVING
Database Administrator (DBA)
10. Begins an element
WHERE
UPDATE
Opening tag
Report
11. Characterizes operation of a relational database
accident
Hardware
Flat File
Joins
12. Finds the lowest constant value in a column
Embedded SQL
MAX
Tags
American Standard Code for Information Interchange (ASCII)
13. SQL finds and retrieves date
WHERE
Indexes
Aliases
Views
14. Used to combine one query to another
Aggregate Functions
Subqueries
Tables
HAVING
15. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Data
Equals Operator
SUM
16. Practice of writing code into a webpage that is not directly visible to the user
Precedence of Logical Operators
Opening tag
Scripting
Public Key Infrastructure (PKI)
17. Responsible for technical implementation & maintenance of database on a design & physical level
American Standard Code for Information Interchange (ASCII)
Database Administrator (DBA)
Stateless
Embedded SQL
18. Using product as intended for its audience
Primary Keys
Outer SELECT query
End Users
Data Elements
19. Tally of how many rows meet criteria specified
Functions
IN
Element Content
COUNT
20. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Functions
hidden fields
Public Key Infrastructure (PKI)
21. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Session
Web Browser
End Users
22. Data in database has ability to be accessed and manipulated by several users
Service Provider
Database
Data Manipulation
Shared
23. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Subqueries
Session
Aliases
Service Broker
24. Flat File Examples: Excel Spreadsheets - _____
Data
Database
Data Administrator (DAd)
Word
25. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
Object-Oriented Relational (OOR)
LIKE
Embedded SQL
26. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Web server
Aggregate Functions
Persistent
27. Used to combine one query to another
Subqueries
Functions
Persistent
Inner SELECT query
28. Executes commands one at a time - results being displayed immediately
Foreign Keys
Hypertext Markup Language (HTML)
Interactive SQL
Equals Operator
29. 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
Data
Data Elements
End Users
30. Allows use of single or multiple character wildcards with the underscore or percent symbol
Database
Data
LIKE
Comparison Operators
31. Allows data recovery in case of corruption or loss
WHERE
Data Recovery & Concurrance
WHERE
LIKE
32. Table displayed in descending order
Dynamic
Subquery
NOT
ESC
33. Defines a new column
Data
Calculated Column
GROUP BY
Service-Oriented Architecture (SOA)
34. Averages the numeric values
Service Broker
AVG
SUM
Joins
35. Interact and manipulates the data in the database
Embedded SQL
Interactive SQL
Integrated
Data Manipulation
36. Ongoing record of data reflecting the info defining the database
Integrated
Embedded SQL
Data Dictionary
MAX
37. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
MAX
Web server
Aggregate Functions
Comparison Operators
38. Allows use of single or multiple character wildcards with the underscore or percent symbol
SUM
LIKE
SUM
ESC
39. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
BETWEEN
Negation Operator
Shared
ALL
40. Browser requests page - code is delivered - executed and done with
Empty Elements
Dynamic
Data Dictionary
Scripting
41. Using product as intended for its audience
hidden fields
End Users
ASC
Service Requestor
42. Limits the output of the established groups into the derived result table
HAVING
Database Administrator (DBA)
NOT
INSERT INTO
43. SELECT statment containing the nested query
Outer SELECT query
SUM
Interactive SQL
Flat File
44. Executes commands one at a time - results being displayed immediately
Interactive SQL
Negation Operator
Word
Subqueries
45. Flat File Examples: Excel Spreadsheets - _____
Foreign Keys
FROM
Word
sp_help
46. Meaningful info related to database
Functions
Data
Service Broker
Web server
47. Create program files that include SQ after each command
Embedded SQL
Web server
Data Definition
Indexes
48. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Aliases
GROUP BY
Precedence of Logical Operators
49. File stored on a user's machine that contains infor about application
Hierarchial
Cookie
Object-Oriented Relational (OOR)
Data Administrator (DAd)
50. Concatenated in SQL Server Database software using the addition symbol
Precedence of Logical Operators
Fields
Relational
to update