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. Defines a new column
SUM
Attributes
Fields
Calculated Column
2. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
FROM
Word
DISTINCT
3. Create program files that include SQ after each command
Embedded SQL
Tags
ALL
Attributes
4. Command based way to ask the database a question
Query
Outer SELECT query
DELETE
Data Dictionary
5. Finds the lowest ACII value in column
MIN
Data Definition
Views
Data Manipulation
6. Ensures data is correct casings
Subqueries
Fields
sp_help
American Standard Code for Information Interchange (ASCII)
7. Characterizes operation of a relational database
ALL
Joins
Data Elements
Persistent
8. File stored on a user's machine that contains infor about application
Cookie
Integrated
Service Broker
Service Provider
9. Data in database has ability to be accessed and manipulated by several users
Shared
MAX
Data Definition
Object-Oriented Relational (OOR)
10. SQL finds and retrieves date
Tags
Service-Oriented Architecture (SOA)
Indexes
LIKE
11. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
UPDATE
Tables
Service Requestor
12. Table displayed in descending order
Service Broker
Scripting
ESC
American Standard Code for Information Interchange (ASCII)
13. Responsible for technical implementation & maintenance of database on a design & physical level
Aliases
Database Administrator (DBA)
SUM
GROUP BY
14. Columns containing numbers only
SUM
Report
AVG
SELECT
15. SQL Commands - Two Things Specify data interested in - Indicate the ________
DISTINCT
DELETE
accident
Views
16. Used with another comparison operator - values become inverted
Negation Operator
Performance
Bind
UPDATE
17. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Dynamic
Integrated
Service Broker
Data Dictionary
18. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Hardware
Central Control of data
Data Manipulation
Service-Oriented Architecture (SOA)
19. Looks like opening tag - but with a forward slash
Public Key Infrastructure (PKI)
Closing tag
NOT
LIKE
20. Change order of rows in result table
Relational
COUNT
Flat File
ORDER BY
21. Specifies the tables or views from which rows and columns are retrieved
Closing tag
Service Broker
FROM
SELECT
22. Executes commands one at a time - results being displayed immediately
Interactive SQL
FROM
SUM
*
23. Begins an element
to update
Persistent
Opening tag
ESC
24. Fields in a relational table that match the primary key from one column to the primary key of another table.
Flat File
Foreign Keys
UPDATE
Structured Query Language (SQL)
25. Decides what data is stored in the databse and the manner it is stored
Indexes
Data Administrator (DAd)
Tables
Element Content
26. The Web is ___________
Fields
Stateless
Web Applications
GROUP BY
27. Closed in the start tag by adding a slash to the start tag
Data Recovery & Concurrance
Empty Elements
MAX
Flat File
28. SQL Commands: Define tables - views - _____ - delete or insert info
Element Content
Joins
to update
ASC
29. Meaningful info related to database
Users
Data
Service Broker
Flat File
30. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Relational
Web server
Database
31. Tally of how many rows meet criteria specified
COUNT
HAVING
Aggregate Functions
Closing tag
32. Data in database interacts & corresponds with other data
Empty Elements
SELECT
Integrated
Opening tag
33. Create program files that include SQ after each command
Embedded SQL
Outer SELECT query
Data
Users
34. Averages the numeric values
Outer SELECT query
Bind
AVG
hidden fields
35. Data stored by DAd
Bind
Data Elements
Data Administrator (DAd)
Dynamic
36. Allows data recovery in case of corruption or loss
Flat File
Public Key Infrastructure (PKI)
Data Recovery & Concurrance
Self Join
37. Command used to show the attributes that define a table.
sp_help
Views
Inner SELECT query
Equals Operator
38. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Hardware
HAVING
BETWEEN
39. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Element Content
Word
Web Browser
Central Control of data
40. Finds the lowest constant value in a column
MAX
Equals Operator
Views
Attributes
41. Identifies columns to appear in the result
Web Service
Calculated Column
Equals Operator
SELECT
42. Changes the values in one or more selected rows of a table
HAVING
UPDATE
Joins
Attributes
43. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Word
Aliases
AVG
44. Table displayed in descending order
Cookie
Self Join
ESC
Service Broker
45. Concatenated in SQL Server Database software using the addition symbol
DISTINCT
Fields
Views
Forward Slash
46. 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
sp_help
Data Administrator (DAd)
Subqueries
47. Identifies columns to appear in the result
SELECT
Scripting
Tables
Relational
48. Browser requests page - code is delivered - executed and done with
Hypertext Markup Language (HTML)
Dynamic
AVG
Joins
49. Closed in the start tag by adding a slash to the start tag
Data Dictionary
Tags
Empty Elements
AVG
50. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Interactive SQL
Hypertext Markup Language (HTML)
DISTINCT