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. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Service Requestor
BETWEEN
Aliases
2. Averages the numeric values
DELETE
AVG
Closing tag
ALL
3. Identifies columns to appear in the result
to update
Dynamic
SELECT
Property
4. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Integrated
Web server
Equals Operator
Data Definition
5. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Persistent
Integrated
to update
Hypertext Markup Language (HTML)
6. Columns containing numbers only
IN
SUM
Embedded SQL
DELETE
7. Ensures functions are done efficiently
Data Recovery & Concurrance
Performance
Web Browser
Word
8. Limits the rows that appear in the result mathcing a specified condition
Relational
SUM
WHERE
Functions
9. Changes the values in one or more selected rows of a table
Service Provider
Public Key Infrastructure (PKI)
Element Content
UPDATE
10. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Inner SELECT query
Opening tag
Equals Operator
11. Changes the values in one or more selected rows of a table
IN
UPDATE
Web Service
Hierarchial
12. Command used to show the attributes that define a table.
sp_help
Data Definition
Comparison Operators
Hypertext Markup Language (HTML)
13. Order in which WHERE clause is evaluated and combined
GROUP BY
Precedence of Logical Operators
Opening tag
BETWEEN
14. The Web is ___________
Calculated Column
Stateless
Cookie
SELECT
15. Create program files that include SQ after each command
Users
Flat File
Embedded SQL
Hardware
16. Practice of writing code into a webpage that is not directly visible to the user
Scripting
ORDER BY
Calculated Column
Database Management Systems (DBMS)
17. 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.
Closing tag
American Standard Code for Information Interchange (ASCII)
accident
Primary Keys
18. Looks like opening tag - but with a forward slash
HAVING
Closing tag
Indexes
FROM
19. Has the highest precedence - followed by the AND - OR
Cookie
Views
Report
NOT
20. Used to combine one query with another.
Subquery
Data Manipulation
UPDATE
Tags
21. Practice of writing code into a webpage that is not directly visible to the user
Integrated
Scripting
MAX
Aggregate Functions
22. Averages the numeric values
Subqueries
Stateless
AVG
ORDER BY
23. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Web Browser
Public Key Infrastructure (PKI)
Hardware
BETWEEN
24. Grant acces and control to only specific information
Scripting
Aliases
Closing tag
Views
25. File stored on a user's machine that contains infor about application
Interactive SQL
Cookie
ASC
Element Content
26. Uses relationships between independent entities
Relational
Subqueries
Self Join
Calculated Column
27. Responsible for technical implementation & maintenance of database on a design & physical level
Views
Calculated Column
Database Administrator (DBA)
Self Join
28. Network node that discovers and invokes other software services to provide a buisness solution
sp_help
Structured Query Language (SQL)
Equals Operator
Service Requestor
29. Some form of output - usually - printed - containing information
Report
Session
Query
Data Manipulation
30. Characterizes operation of a relational database
Joins
SUM
IN
Word
31. Copies multiple records at the same time using a SELECT statement
hidden fields
INSERT INTO
ESC
Data Elements
32. Cookies are more secure than______ - allowing travel on a website without loss of info
AVG
hidden fields
Flat File
Hardware
33. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Aggregate Functions
single value
Indexes
Subqueries
34. Straight implementation of raw data formatted into rows and columns
Users
ESC
ESC
Flat File
35. Allows data recovery in case of corruption or loss
Central control of data
Data Recovery & Concurrance
Self Join
Central Control of data
36. Data in database interacts & corresponds with other data
Structured Query Language (SQL)
Integrated
Shared
NOT
37. Defines a new column
Persistent
Hierarchial
Calculated Column
Inner SELECT query
38. Defines a new column
Indexes
MAX
DELETE
Calculated Column
39. Finds the lowest constant value in a column
LIKE
MAX
Shared
Calculated Column
40. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.
Performance
GROUP BY
Data Definition
Candidate Keys
41. Basic Component of SQL
Tables
AVG
sp_help
Data Recovery & Concurrance
42. Individuals that use - manipulate or maintain aspects of database
Users
ALL
Closing tag
hidden fields
43. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Aliases
hidden fields
Data Elements
ALL
44. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
NOT
Report
MIN
45. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
Opening tag
Views
Shared
46. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
AVG
Data Manipulation
ALL
Application Programmers
47. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Tables
Data Administrator (DAd)
INSERT INTO
Aliases
48. Everything in enviroment becomes an object - expands on Priniples of relational databases
Central Control of data
Subqueries
Object-Oriented Relational (OOR)
Property
49. Uses two values as limits - selecting any values between the two of them
BETWEEN
Integrated
Application Programers
Embedded SQL
50. Grant acces and control to only specific information
Views
MIN
Stateless
NOT