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. SQL finds and retrieves date
Subqueries
Central control of data
Service Provider
Indexes
2. Grant acces and control to only specific information
HAVING
Database
AVG
Views
3. Using product as intended for its audience
Data Elements
Dynamic
Application Programers
End Users
4. All Columns indicated and selected
*
Data
Web server
single value
5. One of the tools that SQL uses to find and retrieve data.
Shared
Indexes
FROM
GROUP BY
6. File stored on a user's machine that contains infor about application
Cookie
Database Management Systems (DBMS)
Tags
hidden fields
7. Meaningful info related to database
Opening tag
Data
Database
IN
8. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
WHERE
NOT
Cookie
Structured Query Language (SQL)
9. SQL Commands: Define tables - views - _____ - delete or insert info
Object-Oriented Relational (OOR)
Application Programers
to update
COUNT
10. Closed in the start tag by adding a slash to the start tag
Data Definition
Attributes
Empty Elements
Data Definition
11. Flat File Examples: Excel Spreadsheets - _____
Word
Service Broker
Tags
Tables
12. Columns containing numbers only
Closing tag
SUM
Database Management Systems (DBMS)
Session
13. Deletes selected rows
Aliases
DELETE
AVG
Integrated
14. Responsible for technical implementation & maintenance of database on a design & physical level
SUM
Tables
Database Administrator (DBA)
Web server
15. Everything between the start and end tag
to update
Tables
AVG
Element Content
16. Begins an element
Service-Oriented Architecture (SOA)
to update
Data Manipulation
Opening tag
17. Table displayed in ascending order
SUM
ASC
Data Manipulation
DELETE
18. Browser requests page - code is delivered - executed and done with
accident
Application Programmers
Dynamic
Database Administrator (DBA)
19. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Property
Application Programmers
Database Administrator (DBA)
Structured Query Language (SQL)
20. Table displayed in descending order
MIN
Stateless
ESC
Application Programers
21. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Structured Query Language (SQL)
GROUP BY
ALL
single value
22. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Bind
Fields
Joins
23. Text markups that form an element" sort of a "box" to hold things like text and other elements
Word
Tags
Bind
Flat File
24. Everything between the start and end tag
Element Content
single value
BETWEEN
Report
25. Used with another comparison operator - values become inverted
Service Broker
Negation Operator
ORDER BY
Application Programmers
26. Straight implementation of raw data formatted into rows and columns
Property
GROUP BY
American Standard Code for Information Interchange (ASCII)
Flat File
27. Uses relationships between independent entities
Relational
Data Administrator (DAd)
Foreign Keys
Data
28. Everything in enviroment becomes an object - expands on Priniples of relational databases
Precedence of Logical Operators
Object-Oriented Relational (OOR)
single value
Persistent
29. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Query
Hierarchial
AVG
30. Data stored by DAd
Dynamic
Public Key Infrastructure (PKI)
Equals Operator
Data Elements
31. Command based way to ask the database a question
Integrated
Service-Oriented Architecture (SOA)
Query
Hierarchial
32. Straight implementation of raw data formatted into rows and columns
Performance
Fields
Flat File
Word
33. SQL Commands: Define tables - views - _____ - delete or insert info
Element Content
Aggregate Functions
to update
Database
34. Most valuable asset of a database system.
Stateless
American Standard Code for Information Interchange (ASCII)
DISTINCT
Central control of data
35. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Database Administrator (DBA)
Web server
Query
36. Used in a SELECT clause in place of a column
MAX
Calculated Column
Aggregate Functions
UPDATE
37. Used to combine one query to another
Empty Elements
Subqueries
Property
Element Content
38. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Central Control of data
Application Programmers
LIKE
Bind
39. Looks like opening tag - but with a forward slash
Data Definition
Aliases
Closing tag
Element Content
40. Defines a new column
Users
Calculated Column
Element Content
DELETE
41. Changes the values in one or more selected rows of a table
UPDATE
Closing tag
Web Browser
Users
42. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Applications
Data Elements
Indexes
Integrated
43. Finds the lowest constant value in a column
MAX
DELETE
Scripting
LIKE
44. Change order of rows in result table
Hypertext Markup Language (HTML)
Opening tag
ORDER BY
Indexes
45. Tally of how many rows meet criteria specified
COUNT
Word
Shared
Element Content
46. Averages the numeric values
Application Programers
Hypertext Markup Language (HTML)
AVG
IN
47. Meaningful info related to database
INSERT INTO
WHERE
Hardware
Data
48. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Query
Structured Query Language (SQL)
Candidate Keys
Service Broker
49. Interact and manipulates the data in the database
Hierarchial
Data Manipulation
Subqueries
Bind
50. Uses two values as limits - selecting any values between the two of them
Web Applications
accident
BETWEEN
Application Programmers