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. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Embedded SQL
Views
*
2. The Web is ___________
Database Administrator (DBA)
Subqueries
to update
Stateless
3. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
*
Hypertext Markup Language (HTML)
Data Manipulation
Central Control of data
4. Table displayed in ascending order
Shared
Scripting
hidden fields
ASC
5. Network node that discovers and invokes other software services to provide a buisness solution
Database Administrator (DBA)
INSERT INTO
Service Requestor
single value
6. Command based way to ask the database a question
Aggregate Functions
single value
American Standard Code for Information Interchange (ASCII)
Query
7. Data in database interacts & corresponds with other data
Tables
Views
Integrated
Web server
8. Software system designed to support interoperable machine - to - machine interaction over a network
DELETE
ORDER BY
Calculated Column
Web Service
9. Writes programs that use or allow acces to databse with specific purpose
Application Programers
MAX
Relational
Report
10. Uses two values as limits - selecting any values between the two of them
GROUP BY
BETWEEN
Interactive SQL
hidden fields
11. SELECT statment containing the nested query
Outer SELECT query
Negation Operator
FROM
Application Programers
12. Software system designed to support interoperable machine - to - machine interaction over a network
Scripting
Self Join
Central Control of data
Web Service
13. Changes the values in one or more selected rows of a table
MIN
UPDATE
Data Administrator (DAd)
SUM
14. Finds the lowest ACII value in column
DELETE
Data Recovery & Concurrance
MIN
Stateless
15. Using product as intended for its audience
End Users
BETWEEN
UPDATE
Service Broker
16. File stored on a user's machine that contains infor about application
Data Administrator (DAd)
Cookie
hidden fields
Data Elements
17. Give the browser more specific information about that tag
Data Administrator (DAd)
Attributes
Comparison Operators
Session
18. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
hidden fields
Data Manipulation
Web Service
Central Control of data
19. Practice of writing code into a webpage that is not directly visible to the user
Attributes
Foreign Keys
Scripting
Interactive SQL
20. Defines a new column
Aggregate Functions
Calculated Column
Comparison Operators
Persistent
21. Command used to show the attributes that define a table.
Service-Oriented Architecture (SOA)
sp_help
Hardware
Indexes
22. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Relational
American Standard Code for Information Interchange (ASCII)
ALL
Bind
23. 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.
hidden fields
Primary Keys
Data
Bind
24. Some form of output - usually - printed - containing information
Data Manipulation
Report
Query
*
25. SQL Commands - Two Things Specify data interested in - Indicate the ________
Web Applications
Integrated
Relational
accident
26. Data in database interacts & corresponds with other data
Views
Tags
Integrated
Relational
27. Supplies value for the search condition of the SELECT statement containing it
Persistent
Integrated
Inner SELECT query
NOT
28. Grant acces and control to only specific information
Views
Negation Operator
UPDATE
Integrated
29. Change order of rows in result table
Tables
ORDER BY
Service-Oriented Architecture (SOA)
SUM
30. Finds the lowest constant value in a column
WHERE
MAX
GROUP BY
Service-Oriented Architecture (SOA)
31. Selects from specific values in list
Equals Operator
Indexes
IN
ORDER BY
32. Text markups that form an element" sort of a "box" to hold things like text and other elements
Data Administrator (DAd)
Comparison Operators
Performance
Tags
33. Used in a SELECT clause in place of a column
Query
Closing tag
Precedence of Logical Operators
Aggregate Functions
34. One huge database to hold all data; Access to data - and use of system to add - update & print records
Joins
Users
SUM
Database Management Systems (DBMS)
35. Used to remove duplicates from result table
GROUP BY
Central control of data
DISTINCT
Closing tag
36. All Columns indicated and selected
Opening tag
ALL
*
MAX
37. Has the highest precedence - followed by the AND - OR
Database Administrator (DBA)
NOT
Word
ORDER BY
38. Join a table to a copy of itself
Central control of data
Self Join
Data
Outer SELECT query
39. Table displayed in descending order
ESC
Aggregate Functions
Flat File
Inner SELECT query
40. Characterizes operation of a relational database
Web Browser
Service Provider
Joins
Calculated Column
41. SQL finds and retrieves date
Indexes
Database
Equals Operator
sp_help
42. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Indexes
Interactive SQL
Indexes
Application Programmers
43. Looks like opening tag - but with a forward slash
Central control of data
Closing tag
Dynamic
Interactive SQL
44. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Web Browser
Foreign Keys
WHERE
45. Give the browser more specific information about that tag
sp_help
Persistent
Attributes
Data Elements
46. Data in database has ability to be accessed and manipulated by several users
Aggregate Functions
Database Administrator (DBA)
Shared
sp_help
47. Grant acces and control to only specific information
LIKE
Report
Views
End Users
48. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Tags
MAX
Data Administrator (DAd)
49. Everything in enviroment becomes an object - expands on Priniples of relational databases
Report
Scripting
Object-Oriented Relational (OOR)
SUM
50. Executes commands one at a time - results being displayed immediately
Interactive SQL
Data
Outer SELECT query
Precedence of Logical Operators