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. Change order of rows in result table
Service Requestor
hidden fields
IN
ORDER BY
2. Compares value of the column in the specified condition with the value specified
FROM
Negation Operator
Forward Slash
Equals Operator
3. Large structured set of persistent data
MAX
Application Programmers
Application Programers
Database
4. Definition of commands it can do
Data Administrator (DAd)
Data Definition
single value
Report
5. 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
accident
Session
FROM
BETWEEN
6. One of the tools that SQL uses to find and retrieve data.
Data Dictionary
Indexes
MIN
Service Broker
7. Basic Component of SQL
Tables
Web Service
BETWEEN
SUM
8. Tally of how many rows meet criteria specified
ESC
COUNT
Stateless
*
9. Tally of how many rows meet criteria specified
Aliases
Precedence of Logical Operators
COUNT
LIKE
10. File stored on a user's machine that contains infor about application
Cookie
SUM
Users
NOT
11. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Data Administrator (DAd)
MIN
COUNT
12. Basic Component of SQL
LIKE
SUM
Views
Tables
13. Table displayed in ascending order
ASC
Database Management Systems (DBMS)
Information
Subquery
14. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Flat File
Integrated
Hardware
Data Manipulation
15. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Data Manipulation
Aggregate Functions
Service-Oriented Architecture (SOA)
Functions
16. Decides what data is stored in the databse and the manner it is stored
Data Definition
NOT
Data Administrator (DAd)
UPDATE
17. Straight implementation of raw data formatted into rows and columns
Flat File
*
Word
Database Administrator (DBA)
18. Cookies are more secure than______ - allowing travel on a website without loss of info
Closing tag
Joins
Empty Elements
hidden fields
19. Used to combine one query to another
American Standard Code for Information Interchange (ASCII)
Subqueries
Data Dictionary
Element Content
20. Ensures functions are done efficiently
Data Administrator (DAd)
Subquery
Performance
Central Control of data
21. Averages the numeric values
AVG
Users
Indexes
to update
22. Responsible for technical implementation & maintenance of database on a design & physical level
Data Dictionary
Web Browser
Database Administrator (DBA)
Data Definition
23. Command based way to ask the database a question
INSERT INTO
COUNT
Query
Service Provider
24. Specifies the tables or views from which rows and columns are retrieved
FROM
UPDATE
Performance
Users
25. Give the browser more specific information about that tag
Property
SUM
Views
Attributes
26. Meaningful info related to database
Bind
Data
Aggregate Functions
Web Applications
27. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Aliases
Central Control of data
AVG
28. Table displayed in descending order
Interactive SQL
Closing tag
Central control of data
ESC
29. Deletes selected rows
UPDATE
INSERT INTO
Fields
DELETE
30. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Tags
Functions
Aggregate Functions
31. Combines rows from a SELECT statements result table into a group
GROUP BY
Service Provider
Aggregate Functions
Element Content
32. SQL Commands: Define tables - views - _____ - delete or insert info
LIKE
Application Programmers
Object-Oriented Relational (OOR)
to update
33. Individuals that use - manipulate or maintain aspects of database
Users
SELECT
Data Definition
Relational
34. SELECT statment containing the nested query
Subquery
*
Outer SELECT query
Users
35. Ensures data is correct casings
ALL
American Standard Code for Information Interchange (ASCII)
sp_help
Hypertext Markup Language (HTML)
36. Meaningful info related to database
SUM
Data
IN
Data Elements
37. Supplies value for the search condition of the SELECT statement containing it
Data Manipulation
Bind
Element Content
Inner SELECT query
38. Some form of output - usually - printed - containing information
Data
Report
Closing tag
IN
39. Table displayed in descending order
ASC
Database
ESC
Object-Oriented Relational (OOR)
40. Order in which WHERE clause is evaluated and combined
GROUP BY
HAVING
Precedence of Logical Operators
Subqueries
41. Concatenated in SQL Server Database software using the addition symbol
Application Programers
Scripting
Fields
single value
42. Decides what data is stored in the databse and the manner it is stored
Web Browser
Data Administrator (DAd)
Fields
Element Content
43. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
FROM
Closing tag
Subqueries
44. Begins an element
Opening tag
Relational
*
Hardware
45. All Columns indicated and selected
Session
Web Service
*
End Users
46. Allow useres to retrieve data and interact with content located on web pages within website
Fields
Structured Query Language (SQL)
Web Browser
MIN
47. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
hidden fields
Hardware
Application Programmers
48. Used to remove duplicates from result table
DISTINCT
Service Requestor
Aliases
End Users
49. File stored on a user's machine that contains infor about application
Foreign Keys
hidden fields
Cookie
Database
50. 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
Hardware
Structured Query Language (SQL)
Equals Operator
Public Key Infrastructure (PKI)