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. Changes the values in one or more selected rows of a table
Joins
UPDATE
Attributes
Attributes
2. Ensures data is correct casings
Outer SELECT query
Subqueries
American Standard Code for Information Interchange (ASCII)
Embedded SQL
3. Data in database interacts & corresponds with other data
Application Programmers
Integrated
ASC
Property
4. Used with another comparison operator - values become inverted
HAVING
Negation Operator
Central control of data
Bind
5. Columns containing numbers only
COUNT
Shared
Word
SUM
6. Meaningful info related to database
Scripting
BETWEEN
Data
SELECT
7. Compares value of the column in the specified condition with the value specified
Equals Operator
Data Definition
Report
Attributes
8. Describe information in a tree styled format
Aggregate Functions
Hierarchial
WHERE
Outer SELECT query
9. Concatenated in SQL Server Database software using the addition symbol
Word
Fields
Dynamic
LIKE
10. Command based way to ask the database a question
Performance
Element Content
Query
Subqueries
11. Closed in the start tag by adding a slash to the start tag
Users
Users
Relational
Empty Elements
12. Writes programs that use or allow acces to databse with specific purpose
to update
Application Programers
Word
Relational
13. Has the highest precedence - followed by the AND - OR
NOT
Database Management Systems (DBMS)
Aliases
Word
14. Most valuable asset of a database system.
Central control of data
Flat File
Data Definition
Data Elements
15. The Web is ___________
Negation Operator
Integrated
Bind
Stateless
16. Everything in enviroment becomes an object - expands on Priniples of relational databases
Data Recovery & Concurrance
DELETE
Object-Oriented Relational (OOR)
FROM
17. Uses relationships between independent entities
Data Definition
Data Administrator (DAd)
Comparison Operators
Relational
18. Grant acces and control to only specific information
Shared
to update
accident
Views
19. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Negation Operator
Hypertext Markup Language (HTML)
Aliases
Subqueries
20. Concatenated in SQL Server Database software using the addition symbol
Candidate Keys
Data Definition
Data Recovery & Concurrance
Fields
21. Command based way to ask the database a question
Indexes
ESC
Query
Web Browser
22. Join a table to a copy of itself
Self Join
INSERT INTO
IN
Object-Oriented Relational (OOR)
23. Describe information in a tree styled format
Hierarchial
Performance
MAX
Service Provider
24. Decides what data is stored in the databse and the manner it is stored
Report
Equals Operator
Data Recovery & Concurrance
Data Administrator (DAd)
25. Large structured set of persistent data
COUNT
Data Definition
NOT
Database
26. SQL finds and retrieves date
*
Indexes
Query
Web Browser
27. Join a table to a copy of itself
Self Join
Integrated
Property
Data Dictionary
28. Everything between the start and end tag
Report
Closing tag
Element Content
Data Recovery & Concurrance
29. Ongoing record of data reflecting the info defining the database
Dynamic
Data Dictionary
ESC
Word
30. Give the browser more specific information about that tag
SELECT
Attributes
Data Dictionary
Precedence of Logical Operators
31. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Database
Opening tag
Web server
Comparison Operators
32. 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.
Self Join
Attributes
Central control of data
Primary Keys
33. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Relational
ALL
Tags
accident
34. Attribute in quotes
Session
Property
Database
SUM
35. Limits the rows that appear in the result mathcing a specified condition
Data Manipulation
Bind
Views
WHERE
36. = - < - > - <= - >= - <> - !
Data Administrator (DAd)
Web server
Application Programmers
Comparison Operators
37. Ensures functions are done efficiently
Shared
Performance
Data Dictionary
Outer SELECT query
38. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Hardware
Opening tag
Element Content
39. Ensures functions are done efficiently
Empty Elements
Service-Oriented Architecture (SOA)
Subqueries
Performance
40. Begins an element
Data Definition
Fields
Performance
Opening tag
41. Changes the values in one or more selected rows of a table
WHERE
ORDER BY
Self Join
UPDATE
42. Data stored by DAd
Attributes
Property
Subquery
Data Elements
43. Essentially a collection of services that communicate with eachother
DELETE
Scripting
Central Control of data
Service-Oriented Architecture (SOA)
44. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Property
HAVING
Negation Operator
45. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Data Definition
Structured Query Language (SQL)
Bind
ALL
46. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Requestor
Interactive SQL
Service Provider
Aliases
47. Software system designed to support interface for a software asset that manages a specific set of tasks
Opening tag
Data
Data Manipulation
Service Provider
48. Individuals that use - manipulate or maintain aspects of database
to update
Users
Central control of data
Application Programmers
49. Combines rows from a SELECT statements result table into a group
Flat File
Web Browser
LIKE
GROUP BY
50. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Closing tag
Aliases
AVG
Structured Query Language (SQL)