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. Finds the lowest ACII value in column
MIN
Data
DELETE
Service Requestor
2. Order in which WHERE clause is evaluated and combined
Web Service
Precedence of Logical Operators
IN
Web server
3. Command based way to ask the database a question
Data Administrator (DAd)
Data Definition
Web server
Query
4. = - < - > - <= - >= - <> - !
Comparison Operators
Tables
Inner SELECT query
Database Administrator (DBA)
5. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Aggregate Functions
GROUP BY
Relational
6. Decides what data is stored in the databse and the manner it is stored
Negation Operator
SUM
Data Administrator (DAd)
Indexes
7. SQL Commands: Define tables - views - _____ - delete or insert info
GROUP BY
to update
Report
INSERT INTO
8. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
ORDER BY
Word
Aliases
Application Programers
9. Has the highest precedence - followed by the AND - OR
Database
FROM
NOT
IN
10. Join a table to a copy of itself
Self Join
Element Content
Hardware
Object-Oriented Relational (OOR)
11. = - < - > - <= - >= - <> - !
Comparison Operators
ESC
*
Opening tag
12. Averages the numeric values
Subqueries
Integrated
Data Administrator (DAd)
AVG
13. Used in a SELECT clause in place of a column
Closing tag
Information
MAX
Aggregate Functions
14. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
NOT
sp_help
hidden fields
15. Interact and manipulates the data in the database
Tags
Comparison Operators
DISTINCT
Data Manipulation
16. Allows data recovery in case of corruption or loss
MAX
ORDER BY
AVG
Data Recovery & Concurrance
17. The Web is ___________
Service Provider
Stateless
Data Elements
Views
18. Definition of commands it can do
hidden fields
Fields
Data Definition
Performance
19. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.
Primary Keys
Negation Operator
NOT
Outer SELECT query
20. Compares value of the column in the specified condition with the value specified
Self Join
American Standard Code for Information Interchange (ASCII)
Inner SELECT query
Equals Operator
21. Ensures data is correct casings
Application Programmers
Web Applications
accident
American Standard Code for Information Interchange (ASCII)
22. 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
Central Control of data
Empty Elements
Outer SELECT query
23. Allows data recovery in case of corruption or loss
Attributes
Central control of data
Data Recovery & Concurrance
Views
24. Tally of how many rows meet criteria specified
Subqueries
COUNT
Web Applications
ALL
25. Software system designed to support interoperable machine - to - machine interaction over a network
INSERT INTO
Query
Hardware
Web Service
26. Ongoing record of data reflecting the info defining the database
FROM
Web server
Data Dictionary
to update
27. Identifies columns to appear in the result
Users
LIKE
Report
SELECT
28. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Precedence of Logical Operators
Self Join
sp_help
29. Individuals that use - manipulate or maintain aspects of database
single value
Candidate Keys
Users
Hierarchial
30. Writes programs that use or allow acces to databse with specific purpose
ALL
Application Programers
COUNT
NOT
31. Columns containing numbers only
sp_help
SUM
Indexes
Closing tag
32. Table displayed in ascending order
COUNT
ASC
LIKE
Tags
33. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.
Data Elements
Aggregate Functions
MIN
Candidate Keys
34. Software system designed to support interface for a software asset that manages a specific set of tasks
Central Control of data
Element Content
SUM
Service Provider
35. Uses two values as limits - selecting any values between the two of them
Hypertext Markup Language (HTML)
BETWEEN
Service Provider
Application Programers
36. Flat File Examples: Excel Spreadsheets - _____
Bind
Word
DELETE
Persistent
37. Allow useres to retrieve data and interact with content located on web pages within website
Query
ORDER BY
Web Browser
Functions
38. Deletes selected rows
ASC
Web Browser
DELETE
LIKE
39. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
WHERE
Service Provider
Database Management Systems (DBMS)
Structured Query Language (SQL)
40. Looks like opening tag - but with a forward slash
UPDATE
Outer SELECT query
Closing tag
Fields
41. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
Service-Oriented Architecture (SOA)
Opening tag
Cookie
42. Supplies value for the search condition of the SELECT statement containing it
Scripting
MAX
Data Manipulation
Inner SELECT query
43. Specifies the tables or views from which rows and columns are retrieved
Web Service
FROM
Scripting
DISTINCT
44. Give the browser more specific information about that tag
Equals Operator
Attributes
Candidate Keys
Self Join
45. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Comparison Operators
AVG
Hardware
Negation Operator
46. Copies multiple records at the same time using a SELECT statement
Relational
FROM
INSERT INTO
Web Service
47. All Columns indicated and selected
Property
*
Tables
Session
48. Browser requests page - code is delivered - executed and done with
INSERT INTO
Database Administrator (DBA)
Dynamic
Service-Oriented Architecture (SOA)
49. Text markups that form an element" sort of a "box" to hold things like text and other elements
Hardware
Tags
Database Administrator (DBA)
Database
50. Individuals that use - manipulate or maintain aspects of database
Equals Operator
ORDER BY
Hardware
Users