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. Definition of commands it can do
Service-Oriented Architecture (SOA)
Hypertext Markup Language (HTML)
Bind
Data Definition
2. Deletes selected rows
Embedded SQL
DELETE
ASC
Precedence of Logical Operators
3. Responsible for technical implementation & maintenance of database on a design & physical level
Query
Database Administrator (DBA)
Structured Query Language (SQL)
Cookie
4. Using product as intended for its audience
End Users
Bind
Shared
Precedence of Logical Operators
5. Identifies columns to appear in the result
SELECT
Shared
Interactive SQL
Database Management Systems (DBMS)
6. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Data Dictionary
Bind
Closing tag
7. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
SUM
NOT
to update
8. Ensures data is correct casings
Opening tag
MAX
Dynamic
American Standard Code for Information Interchange (ASCII)
9. Using product as intended for its audience
HAVING
Equals Operator
End Users
Word
10. Software system designed to support interoperable machine - to - machine interaction over a network
Comparison Operators
Web Browser
Web Service
Database Administrator (DBA)
11. Allows data recovery in case of corruption or loss
Integrated
Users
ESC
Data Recovery & Concurrance
12. Used in a SELECT clause in place of a column
Integrated
Hierarchial
SELECT
Aggregate Functions
13. Has the highest precedence - followed by the AND - OR
NOT
End Users
Views
Data Administrator (DAd)
14. Individuals that use - manipulate or maintain aspects of database
Web server
Data Recovery & Concurrance
Users
Session
15. 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
American Standard Code for Information Interchange (ASCII)
Interactive SQL
Session
Tags
16. Network node that discovers and invokes other software services to provide a buisness solution
Structured Query Language (SQL)
ALL
Subqueries
Service Requestor
17. Practice of writing code into a webpage that is not directly visible to the user
Service-Oriented Architecture (SOA)
Application Programers
Subqueries
Scripting
18. The Web is ___________
Dynamic
Stateless
Web server
Query
19. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
DELETE
Application Programers
Bind
Hardware
20. All Columns indicated and selected
Embedded SQL
*
Shared
Object-Oriented Relational (OOR)
21. Describe information in a tree styled format
Performance
Hierarchial
Calculated Column
Service-Oriented Architecture (SOA)
22. Data in database has ability to be accessed and manipulated by several users
Shared
LIKE
Service Broker
End Users
23. Basic Component of SQL
Tables
Functions
HAVING
Data
24. Finds the lowest ACII value in column
Aliases
MIN
Application Programmers
Service Requestor
25. Large structured set of persistent data
Database
single value
Self Join
single value
26. Attribute in quotes
Subqueries
Service Provider
INSERT INTO
Property
27. Some form of output - usually - printed - containing information
Precedence of Logical Operators
ASC
Database
Report
28. Specifies the tables or views from which rows and columns are retrieved
FROM
Data Definition
COUNT
Stateless
29. Finds the lowest constant value in a column
Web Service
MAX
LIKE
SUM
30. Ensures data is correct casings
Web Service
American Standard Code for Information Interchange (ASCII)
DISTINCT
Data Elements
31. One huge database to hold all data; Access to data - and use of system to add - update & print records
Closing tag
Data Elements
Database Management Systems (DBMS)
sp_help
32. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Users
ASC
Data Administrator (DAd)
Central Control of data
33. Closed in the start tag by adding a slash to the start tag
American Standard Code for Information Interchange (ASCII)
Empty Elements
MIN
*
34. Ensures functions are done efficiently
*
IN
Performance
Hardware
35. Combines rows from a SELECT statements result table into a group
Bind
GROUP BY
NOT
Equals Operator
36. Change order of rows in result table
Aliases
ORDER BY
Precedence of Logical Operators
UPDATE
37. Columns containing numbers only
SUM
sp_help
Comparison Operators
Indexes
38. Closed in the start tag by adding a slash to the start tag
Empty Elements
DELETE
Tables
FROM
39. Table displayed in descending order
ESC
SUM
Data Definition
Public Key Infrastructure (PKI)
40. Interact and manipulates the data in the database
Application Programmers
Information
DELETE
Data Manipulation
41. Tally of how many rows meet criteria specified
COUNT
Public Key Infrastructure (PKI)
End Users
Fields
42. Selects from specific values in list
Information
Service Broker
IN
hidden fields
43. Writes programs that use or allow acces to databse with specific purpose
Tables
Data Definition
Dynamic
Application Programers
44. Writes programs that use or allow acces to databse with specific purpose
SELECT
Application Programers
Data Definition
Joins
45. Straight implementation of raw data formatted into rows and columns
SUM
Flat File
single value
Data
46. Command based way to ask the database a question
Query
WHERE
ALL
Bind
47. Begins an element
Opening tag
Application Programers
GROUP BY
Forward Slash
48. Data that has been processed into a format that is understandable by its audience
Interactive SQL
Precedence of Logical Operators
Information
ORDER BY
49. Limits the output of the established groups into the derived result table
Web Browser
HAVING
Cookie
Word
50. Table displayed in ascending order
*
Service Provider
Flat File
ASC