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. Columns containing numbers only
Relational
SUM
Precedence of Logical Operators
Fields
2. Closed in the start tag by adding a slash to the start tag
AVG
Subqueries
Empty Elements
Performance
3. Averages the numeric values
Structured Query Language (SQL)
Data Definition
Bind
AVG
4. Limits the rows that appear in the result mathcing a specified condition
accident
Service Requestor
Flat File
WHERE
5. Table displayed in ascending order
Property
MIN
ASC
ESC
6. SQL finds and retrieves date
UPDATE
Indexes
Database Administrator (DBA)
MAX
7. Software system designed to support interoperable machine - to - machine interaction over a network
Aggregate Functions
Persistent
Web Service
Structured Query Language (SQL)
8. Data stored by DAd
WHERE
Data Elements
IN
Calculated Column
9. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
COUNT
SELECT
Hardware
10. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Attributes
Users
Empty Elements
11. The Web is ___________
Stateless
Service Broker
Information
single value
12. Three Basic Operations of SP - SR - SB: Publish - Find - ____
NOT
ALL
Bind
Opening tag
13. Uses relationships between independent entities
Property
SELECT
Views
Relational
14. Looks like opening tag - but with a forward slash
single value
Closing tag
Shared
Persistent
15. Ensures data is correct casings
Data Recovery & Concurrance
Aggregate Functions
American Standard Code for Information Interchange (ASCII)
DELETE
16. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Calculated Column
Service Broker
Hardware
Fields
17. = - < - > - <= - >= - <> - !
Element Content
DELETE
Comparison Operators
Central Control of data
18. Decides what data is stored in the databse and the manner it is stored
Fields
Database Administrator (DBA)
Flat File
Data Administrator (DAd)
19. Create program files that include SQ after each command
Session
Integrated
Data
Embedded SQL
20. Data remains unchanged in database
SUM
COUNT
Persistent
UPDATE
21. Order in which WHERE clause is evaluated and combined
Candidate Keys
hidden fields
SUM
Precedence of Logical Operators
22. Text markups that form an element" sort of a "box" to hold things like text and other elements
Opening tag
DELETE
Tags
Query
23. Create program files that include SQ after each command
Data
SUM
Self Join
Embedded SQL
24. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
ASC
Persistent
Scripting
25. Interact and manipulates the data in the database
Information
Data Elements
Data Manipulation
ESC
26. Everything between the start and end tag
Element Content
BETWEEN
NOT
Inner SELECT query
27. Characterizes operation of a relational database
American Standard Code for Information Interchange (ASCII)
Joins
SUM
Integrated
28. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Integrated
Views
Data Dictionary
Hypertext Markup Language (HTML)
29. Basic Component of SQL
Service Provider
Cookie
Bind
Tables
30. Data stored by DAd
AVG
accident
Service-Oriented Architecture (SOA)
Data Elements
31. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Database Management Systems (DBMS)
End Users
Web server
Hypertext Markup Language (HTML)
32. Data in database has ability to be accessed and manipulated by several users
Forward Slash
SUM
COUNT
Shared
33. Finds the lowest constant value in a column
MAX
NOT
Closing tag
End Users
34. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Public Key Infrastructure (PKI)
Query
Precedence of Logical Operators
35. Decides what data is stored in the databse and the manner it is stored
Foreign Keys
Data Administrator (DAd)
Shared
Equals Operator
36. Essentially a collection of services that communicate with eachother
hidden fields
Bind
Service-Oriented Architecture (SOA)
Views
37. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Empty Elements
Users
LIKE
38. Identifies columns to appear in the result
Flat File
Query
HAVING
SELECT
39. Meaningful info related to database
Data
Web server
Object-Oriented Relational (OOR)
Property
40. File stored on a user's machine that contains infor about application
SUM
Comparison Operators
Equals Operator
Cookie
41. Has the highest precedence - followed by the AND - OR
DELETE
NOT
Persistent
MIN
42. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Indexes
SUM
Application Programmers
Empty Elements
43. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Data Elements
ALL
Users
DELETE
44. Some form of output - usually - printed - containing information
Report
Closing tag
Aliases
*
45. Tally of how many rows meet criteria specified
COUNT
Structured Query Language (SQL)
NOT
GROUP BY
46. Using product as intended for its audience
End Users
Data Manipulation
Database Management Systems (DBMS)
single value
47. Give the browser more specific information about that tag
Central control of data
Inner SELECT query
Attributes
Tags
48. Uses two values as limits - selecting any values between the two of them
Outer SELECT query
End Users
Embedded SQL
BETWEEN
49. Meaningful info related to database
Service Provider
Data
Opening tag
Shared
50. Describe information in a tree styled format
DELETE
Application Programmers
single value
Hierarchial