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. Table displayed in ascending order
Relational
UPDATE
ASC
Joins
2. One of the tools that SQL uses to find and retrieve data.
American Standard Code for Information Interchange (ASCII)
Functions
Indexes
Element Content
3. Give the browser more specific information about that tag
Foreign Keys
BETWEEN
Attributes
GROUP BY
4. Executes commands one at a time - results being displayed immediately
Interactive SQL
Hardware
Fields
Joins
5. Text markups that form an element" sort of a "box" to hold things like text and other elements
Equals Operator
Tags
SELECT
Aliases
6. Limits the output of the established groups into the derived result table
Performance
GROUP BY
HAVING
Equals Operator
7. All Columns indicated and selected
Calculated Column
Hardware
*
ASC
8. SQL finds and retrieves date
Precedence of Logical Operators
Aliases
Hypertext Markup Language (HTML)
Indexes
9. Ongoing record of data reflecting the info defining the database
FROM
Candidate Keys
Inner SELECT query
Data Dictionary
10. 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.
GROUP BY
Hypertext Markup Language (HTML)
Primary Keys
Embedded SQL
11. Used to remove duplicates from result table
Aliases
DISTINCT
Relational
Persistent
12. Uses two values as limits - selecting any values between the two of them
WHERE
SELECT
BETWEEN
Tags
13. Order in which WHERE clause is evaluated and combined
Data Recovery & Concurrance
hidden fields
Outer SELECT query
Precedence of Logical Operators
14. Command based way to ask the database a question
Query
American Standard Code for Information Interchange (ASCII)
Service Requestor
GROUP BY
15. Allows data recovery in case of corruption or loss
SELECT
Data Recovery & Concurrance
Dynamic
Data Definition
16. Individuals that use - manipulate or maintain aspects of database
hidden fields
UPDATE
Users
Embedded SQL
17. 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
Hardware
accident
Session
Database Management Systems (DBMS)
18. Definition of commands it can do
Equals Operator
WHERE
Data Definition
Closing tag
19. Finds the lowest ACII value in column
MIN
Embedded SQL
MAX
Performance
20. Data stored by DAd
COUNT
ALL
Data Elements
Hardware
21. Uses relationships between independent entities
Opening tag
HAVING
Subqueries
Relational
22. Tally of how many rows meet criteria specified
SELECT
COUNT
Cookie
Database Administrator (DBA)
23. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Hardware
accident
Indexes
Service Broker
24. Give the browser more specific information about that tag
Attributes
Performance
SUM
Precedence of Logical Operators
25. Data that has been processed into a format that is understandable by its audience
Web Service
Hardware
Information
Data Manipulation
26. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
Information
Web server
Data Administrator (DAd)
27. Essentially a collection of services that communicate with eachother
Data
ALL
Service-Oriented Architecture (SOA)
Joins
28. Practice of writing code into a webpage that is not directly visible to the user
Application Programmers
FROM
Scripting
Indexes
29. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Dynamic
Hypertext Markup Language (HTML)
Functions
NOT
30. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Data Manipulation
Property
Scripting
Bind
31. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
Tags
MIN
Inner SELECT query
32. Using product as intended for its audience
Query
Data
End Users
Data Definition
33. Attribute in quotes
Service Provider
*
Data Recovery & Concurrance
Property
34. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
ORDER BY
LIKE
Structured Query Language (SQL)
Web Applications
35. Supplies value for the search condition of the SELECT statement containing it
INSERT INTO
accident
BETWEEN
Inner SELECT query
36. Flat File Examples: Excel Spreadsheets - _____
Information
accident
Indexes
Word
37. SELECT statment containing the nested query
Data Manipulation
Outer SELECT query
Structured Query Language (SQL)
Database Administrator (DBA)
38. Attribute in quotes
DELETE
Inner SELECT query
Opening tag
Property
39. Copies multiple records at the same time using a SELECT statement
DELETE
Performance
INSERT INTO
Flat File
40. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Embedded SQL
Fields
Application Programers
41. Fields in a relational table that match the primary key from one column to the primary key of another table.
Foreign Keys
Indexes
DELETE
Web server
42. Data stored by DAd
Data Elements
to update
Database Management Systems (DBMS)
Joins
43. Data remains unchanged in database
Web Browser
Subqueries
Persistent
Outer SELECT query
44. SQL Commands - Two Things Specify data interested in - Indicate the ________
Inner SELECT query
hidden fields
accident
Hardware
45. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Data Manipulation
Data Definition
Fields
46. Straight implementation of raw data formatted into rows and columns
Precedence of Logical Operators
Functions
Calculated Column
Flat File
47. Grant acces and control to only specific information
HAVING
Views
*
Aliases
48. Command based way to ask the database a question
MAX
Inner SELECT query
Query
GROUP BY
49. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Web Service
Information
Fields
50. Straight implementation of raw data formatted into rows and columns
Flat File
hidden fields
Negation Operator
Data Manipulation