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. Allows data recovery in case of corruption or loss
Bind
Relational
Data Recovery & Concurrance
Application Programers
2. Large structured set of persistent data
Service Requestor
Data Dictionary
LIKE
Database
3. Table displayed in descending order
Web Browser
SUM
GROUP BY
ESC
4. Create program files that include SQ after each command
Inner SELECT query
Tags
Performance
Embedded SQL
5. Ensures data is correct casings
Service-Oriented Architecture (SOA)
MAX
American Standard Code for Information Interchange (ASCII)
hidden fields
6. Finds the lowest constant value in a column
Persistent
hidden fields
Structured Query Language (SQL)
MAX
7. Basic Component of SQL
Central Control of data
Aggregate Functions
Data Elements
Tables
8. Averages the numeric values
AVG
Aliases
Persistent
Equals Operator
9. Join a table to a copy of itself
Self Join
SUM
Aggregate Functions
ALL
10. Interact and manipulates the data in the database
Shared
ESC
Data Manipulation
Database Administrator (DBA)
11. Everything between the start and end tag
Cookie
End Users
Closing tag
Element Content
12. Supplies value for the search condition of the SELECT statement containing it
Precedence of Logical Operators
Inner SELECT query
Scripting
ASC
13. Give the browser more specific information about that tag
Dynamic
End Users
ALL
Attributes
14. Closed in the start tag by adding a slash to the start tag
Self Join
Empty Elements
Property
NOT
15. One huge database to hold all data; Access to data - and use of system to add - update & print records
GROUP BY
Database Management Systems (DBMS)
Dynamic
Web server
16. Specifies the tables or views from which rows and columns are retrieved
UPDATE
FROM
Central Control of data
Users
17. Finds the lowest ACII value in column
UPDATE
Cookie
MIN
ASC
18. Some form of output - usually - printed - containing information
FROM
Report
Candidate Keys
Service Requestor
19. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
UPDATE
Web server
MAX
Calculated Column
20. Used with another comparison operator - values become inverted
Negation Operator
Structured Query Language (SQL)
Service Broker
Aliases
21. Used in a SELECT clause in place of a column
Database
Flat File
Data Elements
Aggregate Functions
22. Finds the lowest constant value in a column
MAX
SELECT
Relational
Hierarchial
23. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Web Applications
Functions
Tables
Attributes
24. Copies multiple records at the same time using a SELECT statement
Aggregate Functions
Web Service
INSERT INTO
Precedence of Logical Operators
25. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Dynamic
Outer SELECT query
Data Manipulation
26. Practice of writing code into a webpage that is not directly visible to the user
Inner SELECT query
Embedded SQL
Views
Scripting
27. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
ALL
SELECT
Calculated Column
28. Changes the values in one or more selected rows of a table
Precedence of Logical Operators
UPDATE
Embedded SQL
Stateless
29. Meaningful info related to database
Data
Application Programmers
UPDATE
Indexes
30. Begins an element
Hierarchial
Opening tag
NOT
Hierarchial
31. Columns containing numbers only
IN
Subquery
ESC
SUM
32. Essentially a collection of services that communicate with eachother
Cookie
SELECT
Service-Oriented Architecture (SOA)
Subquery
33. Change order of rows in result table
Data Elements
HAVING
Bind
ORDER BY
34. Data that has been processed into a format that is understandable by its audience
HAVING
Information
Performance
Application Programers
35. Used to remove duplicates from result table
DISTINCT
FROM
Web server
Data Recovery & Concurrance
36. Attribute in quotes
Property
Service Broker
Public Key Infrastructure (PKI)
to update
37. Responsible for technical implementation & maintenance of database on a design & physical level
Aggregate Functions
Database Administrator (DBA)
Hypertext Markup Language (HTML)
NOT
38. Everything in enviroment becomes an object - expands on Priniples of relational databases
Query
Object-Oriented Relational (OOR)
Service-Oriented Architecture (SOA)
Embedded SQL
39. SQL Commands: Define tables - views - _____ - delete or insert info
ESC
Object-Oriented Relational (OOR)
Aliases
to update
40. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
to update
Data Definition
ALL
Service Broker
41. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Tags
Web Applications
SUM
Information
42. Data stored by DAd
Data Elements
Fields
to update
Performance
43. Data stored by DAd
Data Elements
HAVING
Views
hidden fields
44. Allow useres to retrieve data and interact with content located on web pages within website
Calculated Column
Web Browser
Candidate Keys
Persistent
45. Attribute in quotes
Property
Indexes
Integrated
Data Definition
46. Definition of commands it can do
Hypertext Markup Language (HTML)
Outer SELECT query
Calculated Column
Data Definition
47. Selects from specific values in list
Service Broker
Word
IN
BETWEEN
48. Limits the rows that appear in the result mathcing a specified condition
WHERE
MAX
Data
Service-Oriented Architecture (SOA)
49. Grant acces and control to only specific information
Subquery
Embedded SQL
Views
SUM
50. Table displayed in ascending order
Service Requestor
Closing tag
Database
ASC