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. Used to remove duplicates from result table
Service-Oriented Architecture (SOA)
IN
DISTINCT
Structured Query Language (SQL)
2. Data in database has ability to be accessed and manipulated by several users
WHERE
Service Requestor
Shared
Flat File
3. Begins an element
Opening tag
Self Join
Views
American Standard Code for Information Interchange (ASCII)
4. Grant acces and control to only specific information
American Standard Code for Information Interchange (ASCII)
HAVING
Views
WHERE
5. Looks like opening tag - but with a forward slash
Closing tag
Persistent
Embedded SQL
Session
6. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
to update
Flat File
accident
7. Interact and manipulates the data in the database
Tags
Data Recovery & Concurrance
Session
Data Manipulation
8. Defines a new column
Joins
INSERT INTO
Database Management Systems (DBMS)
Calculated Column
9. Ongoing record of data reflecting the info defining the database
Data Dictionary
to update
Equals Operator
Fields
10. Change order of rows in result table
ORDER BY
Query
Application Programmers
ALL
11. Using product as intended for its audience
Property
End Users
Hypertext Markup Language (HTML)
Application Programmers
12. SELECT statment containing the nested query
American Standard Code for Information Interchange (ASCII)
Data Manipulation
Outer SELECT query
Indexes
13. Has the highest precedence - followed by the AND - OR
Data
Aliases
Interactive SQL
NOT
14. Data that has been processed into a format that is understandable by its audience
Object-Oriented Relational (OOR)
Performance
Information
UPDATE
15. Text markups that form an element" sort of a "box" to hold things like text and other elements
Fields
Tags
Cookie
Session
16. Responsible for technical implementation & maintenance of database on a design & physical level
Bind
Scripting
Closing tag
Database Administrator (DBA)
17. Table displayed in ascending order
Fields
Empty Elements
SUM
ASC
18. Uses two values as limits - selecting any values between the two of them
BETWEEN
DISTINCT
Views
Flat File
19. Interact and manipulates the data in the database
accident
Data Manipulation
Foreign Keys
Precedence of Logical Operators
20. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Users
SELECT
Service Broker
21. Used to remove duplicates from result table
Self Join
Query
DISTINCT
Empty Elements
22. Order in which WHERE clause is evaluated and combined
Property
Precedence of Logical Operators
Inner SELECT query
Database Administrator (DBA)
23. Everything in enviroment becomes an object - expands on Priniples of relational databases
Central Control of data
Web Browser
Object-Oriented Relational (OOR)
Hypertext Markup Language (HTML)
24. Identifies columns to appear in the result
SELECT
COUNT
accident
Report
25. Columns containing numbers only
SUM
Embedded SQL
ALL
hidden fields
26. Everything in enviroment becomes an object - expands on Priniples of relational databases
accident
Fields
Object-Oriented Relational (OOR)
Property
27. Data in database interacts & corresponds with other data
Relational
Embedded SQL
Integrated
GROUP BY
28. Individuals that use - manipulate or maintain aspects of database
Negation Operator
Users
Data
MAX
29. Selects from specific values in list
Relational
Bind
IN
Self Join
30. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Self Join
Aliases
SELECT
American Standard Code for Information Interchange (ASCII)
31. Uses relationships between independent entities
Relational
Bind
Shared
Shared
32. Give the browser more specific information about that tag
Element Content
Attributes
UPDATE
Views
33. Table displayed in descending order
Fields
Central Control of data
Closing tag
ESC
34. One of the tools that SQL uses to find and retrieve data.
AVG
ESC
Indexes
Hierarchial
35. Deletes selected rows
Central control of data
Session
DELETE
Property
36. Flat File Examples: Excel Spreadsheets - _____
ALL
Users
Word
Database Management Systems (DBMS)
37. Copies multiple records at the same time using a SELECT statement
Calculated Column
INSERT INTO
hidden fields
Aggregate Functions
38. Finds the lowest ACII value in column
Equals Operator
Information
MIN
Tags
39. Data that has been processed into a format that is understandable by its audience
Central control of data
Information
SELECT
Property
40. Grant acces and control to only specific information
Fields
Views
INSERT INTO
Service Provider
41. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Data Dictionary
Database Management Systems (DBMS)
Tags
42. Cookies are more secure than______ - allowing travel on a website without loss of info
Element Content
LIKE
Views
hidden fields
43. = - < - > - <= - >= - <> - !
Comparison Operators
INSERT INTO
FROM
Information
44. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Query
FROM
Service Requestor
Structured Query Language (SQL)
45. Meaningful info related to database
Data
DELETE
Data Recovery & Concurrance
Indexes
46. Table displayed in descending order
ESC
Application Programers
Word
LIKE
47. Basic Component of SQL
WHERE
Tables
FROM
Property
48. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
MIN
Precedence of Logical Operators
Hardware
Functions
49. One huge database to hold all data; Access to data - and use of system to add - update & print records
Relational
AVG
Web Browser
Database Management Systems (DBMS)
50. Limits the output of the established groups into the derived result table
GROUP BY
Application Programmers
HAVING
Information