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. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Data Recovery & Concurrance
Data Definition
Report
2. Used with another comparison operator - values become inverted
Hypertext Markup Language (HTML)
Service Requestor
Negation Operator
ASC
3. Interact and manipulates the data in the database
Data Manipulation
COUNT
Web Applications
FROM
4. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
End Users
Functions
Property
Tags
5. Browser requests page - code is delivered - executed and done with
Dynamic
Calculated Column
Joins
Integrated
6. Join a table to a copy of itself
Self Join
ORDER BY
American Standard Code for Information Interchange (ASCII)
GROUP BY
7. Straight implementation of raw data formatted into rows and columns
Application Programmers
FROM
Indexes
Flat File
8. Command used to show the attributes that define a table.
LIKE
Data Elements
sp_help
Data Dictionary
9. Meaningful info related to database
Application Programmers
Data
Fields
Web Applications
10. Begins an element
Precedence of Logical Operators
Opening tag
Report
Attributes
11. Has the highest precedence - followed by the AND - OR
NOT
Application Programmers
Property
Aggregate Functions
12. Most valuable asset of a database system.
Central control of data
Hypertext Markup Language (HTML)
Web server
Functions
13. Essentially a collection of services that communicate with eachother
Hypertext Markup Language (HTML)
Service-Oriented Architecture (SOA)
Integrated
SUM
14. Basic Component of SQL
Hypertext Markup Language (HTML)
Central Control of data
Equals Operator
Tables
15. Writes programs that use or allow acces to databse with specific purpose
UPDATE
UPDATE
Application Programers
Service-Oriented Architecture (SOA)
16. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Dynamic
SUM
ESC
Embedded SQL
17. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Aliases
BETWEEN
Interactive SQL
18. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Property
Calculated Column
single value
Functions
19. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Forward Slash
Structured Query Language (SQL)
Property
Property
20. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
to update
BETWEEN
Aliases
Application Programmers
21. Specifies the tables or views from which rows and columns are retrieved
FROM
ALL
Subquery
Data Dictionary
22. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.
Property
Inner SELECT query
Primary Keys
Cookie
23. SQL Commands: Define tables - views - _____ - delete or insert info
Query
to update
UPDATE
Scripting
24. Everything between the start and end tag
Aggregate Functions
Property
Element Content
AVG
25. Data stored by DAd
Tags
SELECT
SUM
Data Elements
26. Large structured set of persistent data
ORDER BY
Self Join
Database
Indexes
27. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
hidden fields
WHERE
ORDER BY
28. Straight implementation of raw data formatted into rows and columns
Flat File
Joins
ESC
Database Management Systems (DBMS)
29. Cookies are more secure than______ - allowing travel on a website without loss of info
Service Requestor
Data Definition
hidden fields
Information
30. Uses two values as limits - selecting any values between the two of them
Web server
DELETE
SUM
BETWEEN
31. Using product as intended for its audience
End Users
Service Broker
ALL
Element Content
32. Three Basic Operations of SP - SR - SB: Publish - Find - ____
MAX
IN
Bind
Empty Elements
33. Executes commands one at a time - results being displayed immediately
SELECT
Aliases
Interactive SQL
Shared
34. Ongoing record of data reflecting the info defining the database
Empty Elements
Joins
Data Dictionary
Service Broker
35. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Hypertext Markup Language (HTML)
Outer SELECT query
Service Broker
36. SQL finds and retrieves date
ESC
Data
Indexes
to update
37. Changes the values in one or more selected rows of a table
UPDATE
Hardware
Property
Hypertext Markup Language (HTML)
38. Begins an element
Information
FROM
Opening tag
Users
39. Describe information in a tree styled format
Outer SELECT query
LIKE
Hierarchial
Structured Query Language (SQL)
40. Some form of output - usually - printed - containing information
Forward Slash
to update
Hierarchial
Report
41. Finds the lowest ACII value in column
Web Browser
MIN
NOT
Views
42. 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
Interactive SQL
LIKE
Session
Element Content
43. Copies multiple records at the same time using a SELECT statement
ALL
Embedded SQL
Tags
INSERT INTO
44. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
ESC
single value
Integrated
Views
45. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Views
Web server
MAX
MAX
46. Interact and manipulates the data in the database
Self Join
Interactive SQL
ASC
Data Manipulation
47. Limits the output of the established groups into the derived result table
Aliases
HAVING
Service-Oriented Architecture (SOA)
Query
48. Closed in the start tag by adding a slash to the start tag
Dynamic
Database
Tables
Empty Elements
49. Decides what data is stored in the databse and the manner it is stored
Users
Data Administrator (DAd)
hidden fields
Stateless
50. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Database Management Systems (DBMS)
Scripting
Aliases
INSERT INTO