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. Data in database interacts & corresponds with other data
MAX
BETWEEN
Persistent
Integrated
2. Looks like opening tag - but with a forward slash
to update
Closing tag
SUM
ALL
3. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Application Programmers
Scripting
Opening tag
4. Ensures data is correct casings
Database Management Systems (DBMS)
American Standard Code for Information Interchange (ASCII)
Tables
Public Key Infrastructure (PKI)
5. Data remains unchanged in database
Persistent
SELECT
Data Administrator (DAd)
*
6. Limits the output of the established groups into the derived result table
SELECT
Aliases
HAVING
Tables
7. Writes programs that use or allow acces to databse with specific purpose
Interactive SQL
Application Programers
Aliases
Object-Oriented Relational (OOR)
8. Everything in enviroment becomes an object - expands on Priniples of relational databases
Bind
WHERE
Self Join
Object-Oriented Relational (OOR)
9. Looks like opening tag - but with a forward slash
Precedence of Logical Operators
Closing tag
ORDER BY
SUM
10. Defines a new column
Calculated Column
MIN
Negation Operator
Subquery
11. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Data Elements
*
Central Control of data
12. Used to combine one query to another
Subqueries
SUM
Performance
Empty Elements
13. Data stored by DAd
Data Elements
Functions
Integrated
SUM
14. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
SUM
Information
Web Browser
15. Begins an element
Data
Opening tag
Scripting
Application Programers
16. Data stored by DAd
Web Applications
Embedded SQL
Data Elements
Interactive SQL
17. Changes the values in one or more selected rows of a table
Service-Oriented Architecture (SOA)
Hierarchial
UPDATE
Data Manipulation
18. Definition of commands it can do
Data Definition
INSERT INTO
Hierarchial
Embedded SQL
19. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Indexes
Element Content
Central Control of data
Data Recovery & Concurrance
20. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Users
Relational
Application Programmers
Data Administrator (DAd)
21. Everything between the start and end tag
Element Content
single value
Negation Operator
American Standard Code for Information Interchange (ASCII)
22. Data that has been processed into a format that is understandable by its audience
Information
IN
Database
single value
23. SELECT statment containing the nested query
Outer SELECT query
Hierarchial
Web Service
Database Administrator (DBA)
24. SQL finds and retrieves date
Indexes
Data Elements
Database Management Systems (DBMS)
Data Recovery & Concurrance
25. SQL Commands: Define tables - views - _____ - delete or insert info
to update
Comparison Operators
Web server
Comparison Operators
26. Grant acces and control to only specific information
Data Definition
Views
MAX
Negation Operator
27. 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.
Forward Slash
Primary Keys
Aliases
Views
28. Ensures functions are done efficiently
Forward Slash
Performance
hidden fields
Web server
29. Finds the lowest ACII value in column
Closing tag
WHERE
MIN
Embedded SQL
30. Used with another comparison operator - values become inverted
Negation Operator
Hardware
Joins
Web Applications
31. Allows data recovery in case of corruption or loss
Central control of data
Data Recovery & Concurrance
Self Join
Information
32. Data remains unchanged in database
Hardware
GROUP BY
Persistent
Shared
33. Flat File Examples: Excel Spreadsheets - _____
Empty Elements
Word
ALL
Data
34. Change order of rows in result table
Hardware
Cookie
ORDER BY
Subqueries
35. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.
American Standard Code for Information Interchange (ASCII)
Candidate Keys
Database Administrator (DBA)
Data Dictionary
36. Copies multiple records at the same time using a SELECT statement
Fields
Calculated Column
Web server
INSERT INTO
37. Closed in the start tag by adding a slash to the start tag
Web server
Empty Elements
SUM
ASC
38. Supplies value for the search condition of the SELECT statement containing it
Indexes
Hardware
Closing tag
Inner SELECT query
39. Finds the lowest constant value in a column
COUNT
Forward Slash
MAX
Foreign Keys
40. Network node that discovers and invokes other software services to provide a buisness solution
Foreign Keys
Service Requestor
single value
Database Administrator (DBA)
41. Attribute in quotes
Dynamic
Property
ASC
NOT
42. Interact and manipulates the data in the database
accident
SUM
Data Manipulation
DISTINCT
43. Practice of writing code into a webpage that is not directly visible to the user
Database Management Systems (DBMS)
Database Administrator (DBA)
Scripting
Session
44. Individuals that use - manipulate or maintain aspects of database
Equals Operator
Interactive SQL
Users
GROUP BY
45. Table displayed in descending order
Empty Elements
ESC
SUM
HAVING
46. Allows use of single or multiple character wildcards with the underscore or percent symbol
Application Programers
DELETE
Outer SELECT query
LIKE
47. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Data Dictionary
Central Control of data
Subquery
Opening tag
48. Create program files that include SQ after each command
Comparison Operators
MIN
Embedded SQL
Bind
49. = - < - > - <= - >= - <> - !
Data Administrator (DAd)
Hypertext Markup Language (HTML)
SUM
Comparison Operators
50. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Application Programers
Database Management Systems (DBMS)
Data Elements