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. Uses relationships between independent entities
Inner SELECT query
Relational
Stateless
Hardware
2. Table displayed in descending order
Bind
Database
Data Administrator (DAd)
ESC
3. Executes commands one at a time - results being displayed immediately
Tables
Data Elements
Interactive SQL
ESC
4. Changes the values in one or more selected rows of a table
COUNT
Query
UPDATE
Bind
5. All Columns indicated and selected
Flat File
*
Data Definition
Flat File
6. Describe information in a tree styled format
Hierarchial
Tags
Data
Hardware
7. Limits the output of the established groups into the derived result table
HAVING
UPDATE
Web server
Database Administrator (DBA)
8. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Aggregate Functions
Central Control of data
MIN
Users
9. Grant acces and control to only specific information
Integrated
Views
Relational
AVG
10. Averages the numeric values
AVG
Tables
sp_help
Negation Operator
11. Begins an element
Service-Oriented Architecture (SOA)
Tags
Cookie
Opening tag
12. Change order of rows in result table
INSERT INTO
American Standard Code for Information Interchange (ASCII)
ORDER BY
accident
13. Tally of how many rows meet criteria specified
COUNT
DELETE
Aggregate Functions
Opening tag
14. Compares value of the column in the specified condition with the value specified
Scripting
Data Recovery & Concurrance
Performance
Equals Operator
15. Concatenated in SQL Server Database software using the addition symbol
UPDATE
Fields
UPDATE
Cookie
16. Identifies columns to appear in the result
Structured Query Language (SQL)
Users
hidden fields
SELECT
17. Finds the lowest constant value in a column
Hierarchial
ASC
MAX
Shared
18. Meaningful info related to database
Public Key Infrastructure (PKI)
Performance
Data
Information
19. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Calculated Column
DELETE
SUM
Web Applications
20. Allow useres to retrieve data and interact with content located on web pages within website
hidden fields
Negation Operator
Web Browser
DELETE
21. Table displayed in ascending order
ASC
DELETE
Shared
Aliases
22. Software system designed to support interface for a software asset that manages a specific set of tasks
WHERE
Service Provider
End Users
Web Service
23. Basic Component of SQL
Tables
WHERE
DELETE
SUM
24. Writes programs that use or allow acces to databse with specific purpose
Candidate Keys
WHERE
Application Programers
to update
25. Command based way to ask the database a question
ALL
Query
Views
Stateless
26. Order in which WHERE clause is evaluated and combined
Self Join
Relational
Precedence of Logical Operators
SUM
27. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
American Standard Code for Information Interchange (ASCII)
DELETE
American Standard Code for Information Interchange (ASCII)
28. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Service Requestor
Tags
Data Manipulation
29. Closed in the start tag by adding a slash to the start tag
Empty Elements
Public Key Infrastructure (PKI)
Flat File
Equals Operator
30. One huge database to hold all data; Access to data - and use of system to add - update & print records
Fields
NOT
SUM
Database Management Systems (DBMS)
31. Straight implementation of raw data formatted into rows and columns
Flat File
MIN
Report
hidden fields
32. Ongoing record of data reflecting the info defining the database
Data Dictionary
BETWEEN
IN
Subqueries
33. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
AVG
Service-Oriented Architecture (SOA)
Service Provider
34. Selects from specific values in list
Service Requestor
IN
MIN
accident
35. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
*
Persistent
SUM
ALL
36. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Empty Elements
Application Programers
Data Administrator (DAd)
37. Closed in the start tag by adding a slash to the start tag
Attributes
Application Programmers
Empty Elements
Web Service
38. Join a table to a copy of itself
Service-Oriented Architecture (SOA)
Bind
Object-Oriented Relational (OOR)
Self Join
39. SQL Commands - Two Things Specify data interested in - Indicate the ________
to update
Service Provider
ASC
accident
40. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Calculated Column
Subqueries
Web server
Service Provider
41. Begins an element
Joins
Functions
Central Control of data
Opening tag
42. Data in database has ability to be accessed and manipulated by several users
ESC
Comparison Operators
Shared
Forward Slash
43. Data stored by DAd
Database Administrator (DBA)
single value
Data Elements
Dynamic
44. Change order of rows in result table
Tags
ORDER BY
Service Broker
ASC
45. Defines a new column
single value
Database
Data Recovery & Concurrance
Calculated Column
46. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Subquery
Service Broker
NOT
Negation Operator
47. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
Precedence of Logical Operators
FROM
Dynamic
48. Network node that discovers and invokes other software services to provide a buisness solution
Opening tag
Object-Oriented Relational (OOR)
SUM
Service Requestor
49. Data stored by DAd
Data Elements
BETWEEN
Relational
Interactive SQL
50. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
Interactive SQL
SELECT
*