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. Uses two values as limits - selecting any values between the two of them
to update
Object-Oriented Relational (OOR)
Closing tag
BETWEEN
2. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
DELETE
INSERT INTO
Service Requestor
3. Used in a SELECT clause in place of a column
Service Requestor
Element Content
Aggregate Functions
Data Elements
4. Essentially a collection of services that communicate with eachother
FROM
Negation Operator
Equals Operator
Service-Oriented Architecture (SOA)
5. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
HAVING
COUNT
Forward Slash
6. Finds the lowest ACII value in column
DISTINCT
MIN
SUM
ORDER BY
7. Characterizes operation of a relational database
BETWEEN
DELETE
Joins
Web Browser
8. Decides what data is stored in the databse and the manner it is stored
Data
Data Administrator (DAd)
Report
Precedence of Logical Operators
9. = - < - > - <= - >= - <> - !
Data Elements
Primary Keys
Comparison Operators
single value
10. All Columns indicated and selected
Central Control of data
FROM
SELECT
*
11. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
SUM
Data Recovery & Concurrance
American Standard Code for Information Interchange (ASCII)
12. Defines a new column
Hypertext Markup Language (HTML)
ASC
Scripting
Calculated Column
13. Uses relationships between independent entities
AVG
hidden fields
Scripting
Relational
14. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Indexes
Service Broker
Tables
Web server
15. Tally of how many rows meet criteria specified
COUNT
MIN
Service Requestor
Service Provider
16. Responsible for technical implementation & maintenance of database on a design & physical level
to update
Database Administrator (DBA)
End Users
SUM
17. 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
Subqueries
Hierarchial
Negation Operator
Public Key Infrastructure (PKI)
18. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
Word
Word
ORDER BY
19. Columns containing numbers only
Central Control of data
SUM
Hardware
Service-Oriented Architecture (SOA)
20. Executes commands one at a time - results being displayed immediately
Service Requestor
Tables
DELETE
Interactive SQL
21. Begins an element
Web server
Opening tag
Data Definition
Integrated
22. Combines rows from a SELECT statements result table into a group
Cookie
GROUP BY
Stateless
Negation Operator
23. Ensures data is correct casings
Stateless
American Standard Code for Information Interchange (ASCII)
Database Administrator (DBA)
Hierarchial
24. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Negation Operator
Information
Fields
25. Some form of output - usually - printed - containing information
accident
DISTINCT
Bind
Report
26. Limits the rows that appear in the result mathcing a specified condition
Data Definition
WHERE
Equals Operator
Object-Oriented Relational (OOR)
27. Create program files that include SQ after each command
ALL
Embedded SQL
Calculated Column
Web Service
28. Closed in the start tag by adding a slash to the start tag
Candidate Keys
SELECT
Interactive SQL
Empty Elements
29. Change order of rows in result table
LIKE
Service Provider
ORDER BY
NOT
30. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
Inner SELECT query
UPDATE
Embedded SQL
31. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Data
accident
LIKE
Hardware
32. Describe information in a tree styled format
Hierarchial
sp_help
single value
Data Dictionary
33. Used to remove duplicates from result table
Web Service
DISTINCT
Aggregate Functions
LIKE
34. Columns containing numbers only
Element Content
SUM
NOT
Indexes
35. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Tags
ASC
Web Applications
UPDATE
36. All Columns indicated and selected
Persistent
Precedence of Logical Operators
*
American Standard Code for Information Interchange (ASCII)
37. Everything between the start and end tag
Element Content
Service-Oriented Architecture (SOA)
Property
Word
38. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Data Definition
Structured Query Language (SQL)
Database Administrator (DBA)
39. Concatenated in SQL Server Database software using the addition symbol
Fields
Users
ORDER BY
Web Service
40. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Dynamic
single value
ORDER BY
Data
41. Using product as intended for its audience
Interactive SQL
End Users
Fields
hidden fields
42. One huge database to hold all data; Access to data - and use of system to add - update & print records
DELETE
Database Management Systems (DBMS)
IN
Query
43. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
to update
Data
to update
44. Data that has been processed into a format that is understandable by its audience
Data Administrator (DAd)
Application Programmers
Information
Precedence of Logical Operators
45. Flat File Examples: Excel Spreadsheets - _____
Database Management Systems (DBMS)
NOT
Word
UPDATE
46. Identifies columns to appear in the result
hidden fields
MAX
Inner SELECT query
SELECT
47. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
single value
FROM
SUM
SELECT
48. Table displayed in descending order
Bind
ESC
SELECT
Stateless
49. Software system designed to support interoperable machine - to - machine interaction over a network
Application Programers
Persistent
Web Service
Service Requestor
50. Limits the rows that appear in the result mathcing a specified condition
End Users
WHERE
Data Manipulation
Web server