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. Table displayed in descending order
Application Programers
Candidate Keys
BETWEEN
ESC
2. Uses two values as limits - selecting any values between the two of them
Indexes
Information
Persistent
BETWEEN
3. Used in a SELECT clause in place of a column
Web Applications
Bind
Aggregate Functions
Service Provider
4. Specifies the tables or views from which rows and columns are retrieved
Word
Inner SELECT query
Information
FROM
5. Averages the numeric values
HAVING
Data Recovery & Concurrance
AVG
Forward Slash
6. Create program files that include SQ after each command
ALL
Embedded SQL
AVG
Relational
7. Ensures functions are done efficiently
Performance
Primary Keys
Forward Slash
Functions
8. Combines rows from a SELECT statements result table into a group
Hierarchial
American Standard Code for Information Interchange (ASCII)
GROUP BY
Service-Oriented Architecture (SOA)
9. Closed in the start tag by adding a slash to the start tag
Central Control of data
Data Elements
HAVING
Empty Elements
10. Looks like opening tag - but with a forward slash
Scripting
BETWEEN
Database Management Systems (DBMS)
Closing tag
11. Individuals that use - manipulate or maintain aspects of database
IN
Calculated Column
Users
ESC
12. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
IN
Data Manipulation
Database
13. Uses relationships between independent entities
ALL
Relational
Query
WHERE
14. SQL finds and retrieves date
Indexes
Service Provider
to update
Database Management Systems (DBMS)
15. Table displayed in descending order
single value
single value
Word
ESC
16. Data stored by DAd
Data Elements
*
Data Manipulation
Views
17. Practice of writing code into a webpage that is not directly visible to the user
Integrated
Equals Operator
SUM
Scripting
18. Specifies the tables or views from which rows and columns are retrieved
Cookie
LIKE
FROM
Indexes
19. 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
Session
Aggregate Functions
Equals Operator
HAVING
20. Used to combine one query with another.
Subquery
MAX
hidden fields
IN
21. Selects from specific values in list
Element Content
Data Manipulation
single value
IN
22. Change order of rows in result table
ORDER BY
Aliases
MAX
NOT
23. Flat File Examples: Excel Spreadsheets - _____
Database
Scripting
Word
ASC
24. Selects from specific values in list
IN
Candidate Keys
Session
Shared
25. Changes the values in one or more selected rows of a table
HAVING
UPDATE
ORDER BY
Service Provider
26. 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
Session
Central Control of data
Inner SELECT query
Property
27. Uses relationships between independent entities
Closing tag
Relational
LIKE
Data Dictionary
28. Finds the lowest constant value in a column
MAX
Web Service
Aggregate Functions
Attributes
29. Limits the output of the established groups into the derived result table
Central Control of data
hidden fields
Word
HAVING
30. Data in database has ability to be accessed and manipulated by several users
Cookie
Shared
Dynamic
UPDATE
31. Data that has been processed into a format that is understandable by its audience
Information
Hierarchial
Word
Service-Oriented Architecture (SOA)
32. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Service Provider
Precedence of Logical Operators
Web server
IN
33. Allow useres to retrieve data and interact with content located on web pages within website
Negation Operator
Fields
Web Browser
Outer SELECT query
34. Has the highest precedence - followed by the AND - OR
Object-Oriented Relational (OOR)
Web Service
Shared
NOT
35. Ensures functions are done efficiently
Performance
Web Service
Query
Candidate Keys
36. Large structured set of persistent data
DELETE
Database
Flat File
Query
37. Allow useres to retrieve data and interact with content located on web pages within website
Persistent
Web Applications
Web Browser
ALL
38. Deletes selected rows
LIKE
DELETE
Views
Negation Operator
39. Browser requests page - code is delivered - executed and done with
Interactive SQL
Object-Oriented Relational (OOR)
Web Browser
Dynamic
40. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Comparison Operators
AVG
Service Requestor
41. Straight implementation of raw data formatted into rows and columns
Flat File
Data Manipulation
ALL
Indexes
42. Join a table to a copy of itself
Public Key Infrastructure (PKI)
Self Join
Inner SELECT query
Comparison Operators
43. Browser requests page - code is delivered - executed and done with
Dynamic
INSERT INTO
Central control of data
SUM
44. Writes programs that use or allow acces to databse with specific purpose
SELECT
Fields
Application Programers
Web Service
45. Data in database has ability to be accessed and manipulated by several users
ALL
Information
Shared
Data
46. Flat File Examples: Excel Spreadsheets - _____
Application Programmers
*
Word
Central Control of data
47. Data in database interacts & corresponds with other data
Service Provider
Equals Operator
Integrated
HAVING
48. Using product as intended for its audience
Interactive SQL
End Users
Database Management Systems (DBMS)
LIKE
49. The Web is ___________
Stateless
Data Dictionary
Closing tag
Data Definition
50. Table displayed in ascending order
ASC
COUNT
Aliases
ESC