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. Data stored by DAd
Persistent
Data Recovery & Concurrance
Data Elements
Service Provider
2. Fields in a relational table that match the primary key from one column to the primary key of another table.
SUM
Relational
*
Foreign Keys
3. Basic Component of SQL
Comparison Operators
Tables
ASC
Functions
4. Uses two values as limits - selecting any values between the two of them
ESC
Service Requestor
Data Administrator (DAd)
BETWEEN
5. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
DELETE
Views
Stateless
6. Limits the rows that appear in the result mathcing a specified condition
AVG
Database Administrator (DBA)
Equals Operator
WHERE
7. Uses relationships between independent entities
Attributes
SUM
Relational
FROM
8. Ongoing record of data reflecting the info defining the database
Word
ASC
Outer SELECT query
Data Dictionary
9. Columns containing numbers only
Indexes
Service-Oriented Architecture (SOA)
Candidate Keys
SUM
10. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Indexes
Tables
Equals Operator
11. Copies multiple records at the same time using a SELECT statement
SELECT
Opening tag
INSERT INTO
Tags
12. Straight implementation of raw data formatted into rows and columns
Calculated Column
Aggregate Functions
ESC
Flat File
13. Changes the values in one or more selected rows of a table
INSERT INTO
Shared
UPDATE
Aliases
14. Data in database interacts & corresponds with other data
Integrated
COUNT
Scripting
Data Definition
15. = - < - > - <= - >= - <> - !
Data Dictionary
Fields
Comparison Operators
hidden fields
16. Large structured set of persistent data
Data Administrator (DAd)
Information
Database
Data Recovery & Concurrance
17. Change order of rows in result table
ORDER BY
Joins
GROUP BY
Negation Operator
18. Data stored by DAd
COUNT
Information
Indexes
Data Elements
19. Software system designed to support interface for a software asset that manages a specific set of tasks
Web Browser
Service Provider
Object-Oriented Relational (OOR)
SUM
20. Supplies value for the search condition of the SELECT statement containing it
Service Provider
SUM
UPDATE
Inner SELECT query
21. Grant acces and control to only specific information
Views
Data Elements
Data Manipulation
Shared
22. Columns containing numbers only
Empty Elements
Outer SELECT query
SUM
Service Provider
23. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Functions
SUM
SUM
ALL
24. Ongoing record of data reflecting the info defining the database
Data Dictionary
Structured Query Language (SQL)
Relational
hidden fields
25. Averages the numeric values
Web Browser
Data Dictionary
AVG
Data Manipulation
26. Table displayed in descending order
ESC
Aliases
Service Broker
Database Administrator (DBA)
27. Defines a new column
Service Broker
Calculated Column
Performance
Word
28. Finds the lowest ACII value in column
Public Key Infrastructure (PKI)
MIN
Self Join
Data Manipulation
29. File stored on a user's machine that contains infor about application
Data Elements
sp_help
Cookie
Tags
30. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Dynamic
GROUP BY
Word
Functions
31. Table displayed in ascending order
ASC
Tables
ORDER BY
COUNT
32. Table displayed in descending order
sp_help
NOT
ESC
SELECT
33. Closed in the start tag by adding a slash to the start tag
Integrated
Embedded SQL
Empty Elements
Integrated
34. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
Aggregate Functions
Central control of data
Comparison Operators
35. Browser requests page - code is delivered - executed and done with
Dynamic
GROUP BY
Performance
Subquery
36. Combines rows from a SELECT statements result table into a group
GROUP BY
Stateless
Outer SELECT query
hidden fields
37. SELECT statment containing the nested query
Central Control of data
Hardware
Hypertext Markup Language (HTML)
Outer SELECT query
38. Finds the lowest constant value in a column
GROUP BY
Object-Oriented Relational (OOR)
Service Broker
MAX
39. Command based way to ask the database a question
Calculated Column
Embedded SQL
Query
UPDATE
40. Give the browser more specific information about that tag
Attributes
Structured Query Language (SQL)
Interactive SQL
Relational
41. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
Outer SELECT query
Integrated
NOT
42. Has the highest precedence - followed by the AND - OR
Outer SELECT query
ASC
Central control of data
NOT
43. Everything between the start and end tag
sp_help
Element Content
Tags
Hierarchial
44. Has the highest precedence - followed by the AND - OR
Tags
Data Administrator (DAd)
Joins
NOT
45. Data remains unchanged in database
Word
accident
Equals Operator
Persistent
46. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Web server
Service Requestor
Service Broker
Comparison Operators
47. Identifies columns to appear in the result
Flat File
SELECT
to update
Service Broker
48. Combines rows from a SELECT statements result table into a group
Application Programers
Aliases
sp_help
GROUP BY
49. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
IN
Precedence of Logical Operators
Equals Operator
Functions
50. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
ASC
Data Recovery & Concurrance
Negation Operator