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. Individuals that use - manipulate or maintain aspects of database
Users
Service Provider
IN
Equals Operator
2. All Columns indicated and selected
Property
Comparison Operators
*
ALL
3. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Element Content
Web server
Negation Operator
Bind
4. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Structured Query Language (SQL)
SUM
Query
Tags
5. Finds the lowest constant value in a column
Session
Data Administrator (DAd)
MAX
Structured Query Language (SQL)
6. Meaningful info related to database
Data
Interactive SQL
Negation Operator
Shared
7. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Database Management Systems (DBMS)
Query
Hardware
Calculated Column
8. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Performance
Service Broker
Web Browser
Database
9. Data remains unchanged in database
Persistent
Object-Oriented Relational (OOR)
MIN
SUM
10. Attribute in quotes
Property
Application Programers
*
Central Control of data
11. 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
Session
WHERE
INSERT INTO
to update
12. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Web Service
Structured Query Language (SQL)
Application Programers
13. Some form of output - usually - printed - containing information
SUM
Data
Element Content
Report
14. Table displayed in descending order
ESC
Subqueries
Central control of data
Shared
15. Data in database has ability to be accessed and manipulated by several users
SELECT
Shared
Data
Candidate Keys
16. Describe information in a tree styled format
ESC
ESC
Hierarchial
Web server
17. Identifies columns to appear in the result
Query
Primary Keys
Web Service
SELECT
18. Join a table to a copy of itself
Self Join
NOT
Query
SUM
19. Deletes selected rows
Property
Opening tag
Hardware
DELETE
20. Allows use of single or multiple character wildcards with the underscore or percent symbol
Web server
LIKE
Database Administrator (DBA)
Persistent
21. Executes commands one at a time - results being displayed immediately
Information
DELETE
Interactive SQL
HAVING
22. Table displayed in descending order
ESC
Fields
Inner SELECT query
Data Definition
23. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Closing tag
Data Recovery & Concurrance
Central Control of data
24. Definition of commands it can do
Web Browser
Data Definition
MIN
Interactive SQL
25. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Performance
WHERE
Session
26. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Database Management Systems (DBMS)
Central Control of data
Subqueries
Data
27. Used in a SELECT clause in place of a column
Aggregate Functions
Cookie
Opening tag
Property
28. Decides what data is stored in the databse and the manner it is stored
Inner SELECT query
Precedence of Logical Operators
Data Administrator (DAd)
MIN
29. Used to remove duplicates from result table
DISTINCT
Application Programers
Data Definition
Aliases
30. Everything in enviroment becomes an object - expands on Priniples of relational databases
to update
Object-Oriented Relational (OOR)
Service Provider
Data Recovery & Concurrance
31. Give the browser more specific information about that tag
Attributes
Inner SELECT query
Relational
Empty Elements
32. Uses two values as limits - selecting any values between the two of them
Self Join
BETWEEN
Service Provider
UPDATE
33. Begins an element
Calculated Column
Opening tag
FROM
Dynamic
34. Allow useres to retrieve data and interact with content located on web pages within website
hidden fields
Relational
Web Browser
to update
35. Table displayed in ascending order
Embedded SQL
Word
DELETE
ASC
36. Flat File Examples: Excel Spreadsheets - _____
Information
Word
Element Content
ESC
37. Describe information in a tree styled format
Attributes
American Standard Code for Information Interchange (ASCII)
Aliases
Hierarchial
38. Command based way to ask the database a question
Data Dictionary
Web Browser
Query
Opening tag
39. Data in database interacts & corresponds with other data
Bind
accident
Integrated
SUM
40. Copies multiple records at the same time using a SELECT statement
Comparison Operators
INSERT INTO
hidden fields
Word
41. Averages the numeric values
Closing tag
SUM
AVG
Database Administrator (DBA)
42. Data stored by DAd
GROUP BY
Database Administrator (DBA)
Data Elements
Outer SELECT query
43. Interact and manipulates the data in the database
Data Manipulation
UPDATE
Hierarchial
single value
44. Allow useres to retrieve data and interact with content located on web pages within website
SUM
Web Browser
American Standard Code for Information Interchange (ASCII)
Precedence of Logical Operators
45. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Empty Elements
Application Programers
Tags
single value
46. SQL Commands - Two Things Specify data interested in - Indicate the ________
Database
accident
Self Join
COUNT
47. Three Basic Operations of SP - SR - SB: Publish - Find - ____
SELECT
Opening tag
Inner SELECT query
Bind
48. Used with another comparison operator - values become inverted
UPDATE
Data Recovery & Concurrance
Web Applications
Negation Operator
49. Combines rows from a SELECT statements result table into a group
Indexes
INSERT INTO
GROUP BY
Equals Operator
50. Changes the values in one or more selected rows of a table
accident
ESC
UPDATE
Tables