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. Writes programs that use or allow acces to databse with specific purpose
ALL
Application Programers
hidden fields
SELECT
2. Everything between the start and end tag
Negation Operator
Empty Elements
Central Control of data
Element Content
3. Used to combine one query to another
Subqueries
Interactive SQL
LIKE
Word
4. Table displayed in ascending order
Joins
ASC
Users
DELETE
5. = - < - > - <= - >= - <> - !
Comparison Operators
SELECT
GROUP BY
Session
6. Network node that discovers and invokes other software services to provide a buisness solution
Information
DISTINCT
Negation Operator
Service Requestor
7. SELECT statment containing the nested query
Data Definition
Joins
Outer SELECT query
Tags
8. Columns containing numbers only
Hypertext Markup Language (HTML)
Interactive SQL
Data Manipulation
SUM
9. Averages the numeric values
Object-Oriented Relational (OOR)
American Standard Code for Information Interchange (ASCII)
AVG
Integrated
10. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Cookie
to update
DELETE
11. Limits the output of the established groups into the derived result table
Query
DISTINCT
HAVING
Structured Query Language (SQL)
12. Copies multiple records at the same time using a SELECT statement
MAX
SELECT
INSERT INTO
Web Service
13. Identifies columns to appear in the result
Application Programmers
SELECT
Session
Fields
14. SQL Commands: Define tables - views - _____ - delete or insert info
Fields
MIN
to update
SUM
15. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Word
UPDATE
Functions
Tables
16. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Calculated Column
Fields
Aliases
17. Data in database has ability to be accessed and manipulated by several users
Property
Tables
Web Browser
Shared
18. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Performance
sp_help
ASC
19. All Columns indicated and selected
SUM
Property
*
Property
20. Give the browser more specific information about that tag
Application Programmers
Performance
Attributes
Self Join
21. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Database
Outer SELECT query
Object-Oriented Relational (OOR)
22. Uses relationships between independent entities
Relational
Web server
DISTINCT
AVG
23. Data remains unchanged in database
Data Recovery & Concurrance
Hypertext Markup Language (HTML)
Persistent
Element Content
24. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities
Data
ORDER BY
Public Key Infrastructure (PKI)
Data Manipulation
25. Ongoing record of data reflecting the info defining the database
WHERE
Data Dictionary
INSERT INTO
to update
26. Meaningful info related to database
Data Dictionary
Data
sp_help
Word
27. Specifies the tables or views from which rows and columns are retrieved
Forward Slash
DISTINCT
FROM
Service Requestor
28. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Application Programers
Bind
SUM
Hierarchial
29. Begins an element
Fields
Opening tag
Fields
to update
30. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Service Broker
ALL
Central control of data
Service-Oriented Architecture (SOA)
31. Averages the numeric values
AVG
HAVING
SUM
Flat File
32. Basic Component of SQL
Relational
Tables
NOT
Performance
33. Changes the values in one or more selected rows of a table
Data Administrator (DAd)
Service Requestor
INSERT INTO
UPDATE
34. Used with another comparison operator - values become inverted
Negation Operator
Data
Joins
Web server
35. Software system designed to support interface for a software asset that manages a specific set of tasks
Structured Query Language (SQL)
Hardware
Service Provider
Property
36. Straight implementation of raw data formatted into rows and columns
Aggregate Functions
Data Elements
Empty Elements
Flat File
37. Data in database interacts & corresponds with other data
Candidate Keys
Integrated
Object-Oriented Relational (OOR)
Structured Query Language (SQL)
38. Executes commands one at a time - results being displayed immediately
Subqueries
Interactive SQL
Attributes
*
39. Attribute in quotes
SUM
Property
Data Dictionary
DELETE
40. Data that has been processed into a format that is understandable by its audience
Cookie
BETWEEN
Precedence of Logical Operators
Information
41. Flat File Examples: Excel Spreadsheets - _____
Word
Data Administrator (DAd)
Query
Report
42. Looks like opening tag - but with a forward slash
Functions
Closing tag
Structured Query Language (SQL)
Performance
43. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
Flat File
Closing tag
Information
44. Cookies are more secure than______ - allowing travel on a website without loss of info
Data Dictionary
hidden fields
SUM
Fields
45. Writes programs that use or allow acces to databse with specific purpose
accident
Performance
Self Join
Application Programers
46. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Query
Service-Oriented Architecture (SOA)
Cookie
Bind
47. Ongoing record of data reflecting the info defining the database
Data Dictionary
Closing tag
Dynamic
GROUP BY
48. Data that has been processed into a format that is understandable by its audience
Information
Hardware
Data Administrator (DAd)
Tables
49. Changes the values in one or more selected rows of a table
Joins
NOT
Service Requestor
UPDATE
50. Selects from specific values in list
IN
Closing tag
Data Administrator (DAd)
Attributes