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. Begins an element
Attributes
Opening tag
Database
Fields
2. Copies multiple records at the same time using a SELECT statement
Negation Operator
Data Elements
SUM
INSERT INTO
3. Table displayed in descending order
Data Recovery & Concurrance
Calculated Column
SUM
ESC
4. All Columns indicated and selected
Cookie
Web Service
Subqueries
*
5. Ensures functions are done efficiently
American Standard Code for Information Interchange (ASCII)
to update
UPDATE
Performance
6. Give the browser more specific information about that tag
Attributes
Interactive SQL
WHERE
Report
7. Cookies are more secure than______ - allowing travel on a website without loss of info
Object-Oriented Relational (OOR)
Stateless
Foreign Keys
hidden fields
8. Used in a SELECT clause in place of a column
Property
Aggregate Functions
IN
Word
9. File stored on a user's machine that contains infor about application
Calculated Column
MIN
Cookie
Relational
10. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
MIN
Scripting
Central Control of data
Database Management Systems (DBMS)
11. Tally of how many rows meet criteria specified
Application Programers
COUNT
Data Dictionary
Calculated Column
12. Everything between the start and end tag
Element Content
MAX
Hardware
HAVING
13. Describe information in a tree styled format
Database Management Systems (DBMS)
Integrated
End Users
Hierarchial
14. One huge database to hold all data; Access to data - and use of system to add - update & print records
ORDER BY
Database Management Systems (DBMS)
Equals Operator
Dynamic
15. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
*
sp_help
Tags
16. SELECT statment containing the nested query
Outer SELECT query
Empty Elements
Information
Self Join
17. Most valuable asset of a database system.
Views
FROM
Central control of data
Cookie
18. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
sp_help
Data Definition
Structured Query Language (SQL)
Users
19. Data in database has ability to be accessed and manipulated by several users
Service Requestor
Shared
Hardware
Self Join
20. Limits the rows that appear in the result mathcing a specified condition
Data Recovery & Concurrance
Application Programers
Comparison Operators
WHERE
21. Straight implementation of raw data formatted into rows and columns
MIN
DELETE
WHERE
Flat File
22. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
*
GROUP BY
Scripting
23. Ensures data is correct casings
Persistent
American Standard Code for Information Interchange (ASCII)
Service-Oriented Architecture (SOA)
Outer SELECT query
24. Browser requests page - code is delivered - executed and done with
UPDATE
Indexes
Dynamic
Comparison Operators
25. Data stored by DAd
Data Elements
Hierarchial
IN
Aggregate Functions
26. Uses two values as limits - selecting any values between the two of them
Outer SELECT query
BETWEEN
Service-Oriented Architecture (SOA)
Hierarchial
27. Columns containing numbers only
SUM
Performance
Inner SELECT query
Integrated
28. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Stateless
Database Administrator (DBA)
Property
Functions
29. Finds the lowest constant value in a column
Candidate Keys
Dynamic
MAX
Application Programmers
30. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Database
*
Report
Aliases
31. SQL finds and retrieves date
Indexes
LIKE
single value
ASC
32. Uses relationships between independent entities
Data Elements
Primary Keys
Word
Relational
33. Ensures data is correct casings
Attributes
American Standard Code for Information Interchange (ASCII)
Tables
Dynamic
34. = - < - > - <= - >= - <> - !
DISTINCT
hidden fields
Object-Oriented Relational (OOR)
Comparison Operators
35. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
*
Web Applications
IN
single value
36. Some form of output - usually - printed - containing information
Report
Calculated Column
Central control of data
Empty Elements
37. Used with another comparison operator - values become inverted
Negation Operator
Central control of data
Forward Slash
Structured Query Language (SQL)
38. Allow useres to retrieve data and interact with content located on web pages within website
INSERT INTO
COUNT
Web Browser
SELECT
39. Data stored by DAd
Data Elements
End Users
ALL
Equals Operator
40. Limits the output of the established groups into the derived result table
HAVING
Service Broker
FROM
Functions
41. Text markups that form an element" sort of a "box" to hold things like text and other elements
accident
Tags
SUM
Information
42. Limits the rows that appear in the result mathcing a specified condition
Web Service
WHERE
to update
Central Control of data
43. File stored on a user's machine that contains infor about application
Property
Indexes
SELECT
Cookie
44. Straight implementation of raw data formatted into rows and columns
Flat File
GROUP BY
SUM
Data Recovery & Concurrance
45. Selects from specific values in list
Session
INSERT INTO
IN
Data Recovery & Concurrance
46. Order in which WHERE clause is evaluated and combined
NOT
Precedence of Logical Operators
Database Administrator (DBA)
IN
47. Allow useres to retrieve data and interact with content located on web pages within website
FROM
Property
Data Manipulation
Web Browser
48. Looks like opening tag - but with a forward slash
Indexes
Candidate Keys
Closing tag
UPDATE
49. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Cookie
American Standard Code for Information Interchange (ASCII)
Database
50. Selects from specific values in list
IN
ALL
Data Manipulation
Persistent