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. Finds the lowest constant value in a column
MAX
Data Definition
Primary Keys
Dynamic
2. Command based way to ask the database a question
Data
Query
End Users
Data Manipulation
3. Flat File Examples: Excel Spreadsheets - _____
Service Broker
Word
single value
Inner SELECT query
4. SELECT statment containing the nested query
Outer SELECT query
HAVING
FROM
Stateless
5. Data in database interacts & corresponds with other data
NOT
Database Administrator (DBA)
Integrated
American Standard Code for Information Interchange (ASCII)
6. Definition of commands it can do
MIN
Tables
Data Definition
Dynamic
7. Used to combine one query to another
Empty Elements
Subqueries
Hierarchial
Service Requestor
8. Finds the lowest constant value in a column
MAX
Views
Views
American Standard Code for Information Interchange (ASCII)
9. File stored on a user's machine that contains infor about application
Comparison Operators
INSERT INTO
Cookie
Data Elements
10. SQL Commands: Define tables - views - _____ - delete or insert info
Flat File
Primary Keys
to update
Information
11. SQL Commands - Two Things Specify data interested in - Indicate the ________
ORDER BY
Web server
Equals Operator
accident
12. Combines rows from a SELECT statements result table into a group
Database Administrator (DBA)
GROUP BY
Subquery
Inner SELECT query
13. Has the highest precedence - followed by the AND - OR
Data Dictionary
to update
NOT
Web Browser
14. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Service Provider
Precedence of Logical Operators
Aliases
Data
15. Interact and manipulates the data in the database
Service-Oriented Architecture (SOA)
Data Manipulation
Comparison Operators
Joins
16. Order in which WHERE clause is evaluated and combined
Data Dictionary
Precedence of Logical Operators
Service Broker
Data Administrator (DAd)
17. SQL finds and retrieves date
Information
Embedded SQL
Indexes
Data Administrator (DAd)
18. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Relational
*
single value
Structured Query Language (SQL)
19. Basic Component of SQL
FROM
Structured Query Language (SQL)
Structured Query Language (SQL)
Tables
20. Ensures data is correct casings
Tables
American Standard Code for Information Interchange (ASCII)
INSERT INTO
GROUP BY
21. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Word
Bind
Data Manipulation
ALL
22. Change order of rows in result table
Scripting
SUM
single value
ORDER BY
23. Everything in enviroment becomes an object - expands on Priniples of relational databases
Word
Public Key Infrastructure (PKI)
Interactive SQL
Object-Oriented Relational (OOR)
24. Characterizes operation of a relational database
COUNT
Query
Property
Joins
25. Data remains unchanged in database
Equals Operator
Persistent
IN
Relational
26. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Calculated Column
SUM
Hypertext Markup Language (HTML)
Functions
27. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
SELECT
Functions
Closing tag
Persistent
28. Responsible for technical implementation & maintenance of database on a design & physical level
SUM
Database Administrator (DBA)
Service Provider
Persistent
29. Grant acces and control to only specific information
Views
ALL
NOT
Equals Operator
30. Using product as intended for its audience
Application Programmers
End Users
Service Provider
Property
31. Using product as intended for its audience
Tags
End Users
Hierarchial
Opening tag
32. Cookies are more secure than______ - allowing travel on a website without loss of info
Element Content
Fields
hidden fields
Structured Query Language (SQL)
33. Selects from specific values in list
Comparison Operators
IN
SUM
Scripting
34. Used with another comparison operator - values become inverted
AVG
Service Requestor
Negation Operator
Application Programers
35. Data stored by DAd
Data Elements
Element Content
ESC
HAVING
36. Straight implementation of raw data formatted into rows and columns
COUNT
UPDATE
Scripting
Flat File
37. Finds the lowest ACII value in column
Functions
Scripting
MIN
Inner SELECT query
38. One huge database to hold all data; Access to data - and use of system to add - update & print records
Users
Database Management Systems (DBMS)
Interactive SQL
to update
39. Columns containing numbers only
Interactive SQL
Embedded SQL
SUM
Equals Operator
40. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
*
Subqueries
Web Applications
Indexes
41. Changes the values in one or more selected rows of a table
INSERT INTO
*
Forward Slash
UPDATE
42. Ensures functions are done efficiently
Opening tag
Hypertext Markup Language (HTML)
Web Service
Performance
43. = - < - > - <= - >= - <> - !
Report
Scripting
single value
Comparison Operators
44. Data that has been processed into a format that is understandable by its audience
Joins
Foreign Keys
Information
Word
45. Supplies value for the search condition of the SELECT statement containing it
Session
Application Programers
HAVING
Inner SELECT query
46. Meaningful info related to database
Users
Outer SELECT query
Data
Self Join
47. File stored on a user's machine that contains infor about application
Primary Keys
Functions
Cookie
Hierarchial
48. Some form of output - usually - printed - containing information
BETWEEN
Views
Report
Object-Oriented Relational (OOR)
49. Flat File Examples: Excel Spreadsheets - _____
Views
ESC
DELETE
Word
50. Has the highest precedence - followed by the AND - OR
Hypertext Markup Language (HTML)
Interactive SQL
DELETE
NOT