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. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Data Administrator (DAd)
Dynamic
Structured Query Language (SQL)
2. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
FROM
Stateless
single value
*
3. Specifies the tables or views from which rows and columns are retrieved
FROM
Property
*
Closing tag
4. Used with another comparison operator - values become inverted
NOT
Database
hidden fields
Negation Operator
5. Software system designed to support interoperable machine - to - machine interaction over a network
ALL
Tags
Web Service
MAX
6. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Flat File
Hardware
Data Manipulation
7. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Calculated Column
Functions
Structured Query Language (SQL)
Comparison Operators
8. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Web server
MIN
Report
9. Limits the rows that appear in the result mathcing a specified condition
Web Service
WHERE
Data Recovery & Concurrance
Calculated Column
10. Text markups that form an element" sort of a "box" to hold things like text and other elements
Subqueries
single value
Public Key Infrastructure (PKI)
Tags
11. Writes programs that use or allow acces to databse with specific purpose
Application Programers
Aggregate Functions
Comparison Operators
DISTINCT
12. Ongoing record of data reflecting the info defining the database
Object-Oriented Relational (OOR)
Precedence of Logical Operators
Report
Data Dictionary
13. Compares value of the column in the specified condition with the value specified
Persistent
Web Service
Equals Operator
Information
14. Columns containing numbers only
Candidate Keys
Performance
Database
SUM
15. Text markups that form an element" sort of a "box" to hold things like text and other elements
Aliases
Application Programmers
Negation Operator
Tags
16. Used with another comparison operator - values become inverted
Word
Dynamic
Negation Operator
Self Join
17. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Hypertext Markup Language (HTML)
Central Control of data
End Users
18. Join a table to a copy of itself
MIN
Self Join
to update
MAX
19. Compares value of the column in the specified condition with the value specified
Equals Operator
Central Control of data
Web Browser
HAVING
20. Command based way to ask the database a question
*
Embedded SQL
Aliases
Query
21. Using product as intended for its audience
Empty Elements
Users
accident
End Users
22. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Users
COUNT
NOT
23. Deletes selected rows
Shared
DELETE
Inner SELECT query
Aliases
24. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Empty Elements
Central Control of data
Service Requestor
Query
25. Has the highest precedence - followed by the AND - OR
NOT
Service-Oriented Architecture (SOA)
Data Definition
Fields
26. Copies multiple records at the same time using a SELECT statement
GROUP BY
Public Key Infrastructure (PKI)
Fields
INSERT INTO
27. Tally of how many rows meet criteria specified
Candidate Keys
COUNT
Web Applications
Empty Elements
28. Data in database interacts & corresponds with other data
Integrated
Web Service
COUNT
Service Provider
29. Changes the values in one or more selected rows of a table
UPDATE
Closing tag
Hardware
Data
30. Most valuable asset of a database system.
Object-Oriented Relational (OOR)
Functions
ORDER BY
Central control of data
31. Identifies columns to appear in the result
SELECT
Hypertext Markup Language (HTML)
Interactive SQL
Hierarchial
32. Finds the lowest constant value in a column
MAX
Data Administrator (DAd)
Data Elements
ESC
33. Data that has been processed into a format that is understandable by its audience
to update
Information
Service Broker
Integrated
34. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Shared
DELETE
WHERE
SUM
35. Data stored by DAd
FROM
SUM
NOT
Data Elements
36. Combines rows from a SELECT statements result table into a group
ESC
WHERE
Negation Operator
GROUP BY
37. Finds the lowest constant value in a column
BETWEEN
Views
ORDER BY
MAX
38. Data remains unchanged in database
Persistent
Candidate Keys
Session
Information
39. Closed in the start tag by adding a slash to the start tag
HAVING
Empty Elements
Shared
Application Programers
40. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Word
Report
Tables
41. Used to remove duplicates from result table
Aggregate Functions
MAX
Subqueries
DISTINCT
42. Data in database interacts & corresponds with other data
Central Control of data
Integrated
Foreign Keys
Attributes
43. Ensures functions are done efficiently
Data Administrator (DAd)
Structured Query Language (SQL)
Aggregate Functions
Performance
44. Used in a SELECT clause in place of a column
Indexes
Database Management Systems (DBMS)
Persistent
Aggregate Functions
45. Meaningful info related to database
Data
Application Programmers
LIKE
Functions
46. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Bind
GROUP BY
Primary Keys
Web server
47. Cookies are more secure than______ - allowing travel on a website without loss of info
Joins
COUNT
hidden fields
Aliases
48. Limits the output of the established groups into the derived result table
LIKE
Inner SELECT query
Structured Query Language (SQL)
HAVING
49. 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.
Web server
Primary Keys
ALL
Fields
50. Executes commands one at a time - results being displayed immediately
Interactive SQL
WHERE
ASC
SUM