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. Data that has been processed into a format that is understandable by its audience
Relational
Information
FROM
Attributes
2. Change order of rows in result table
Data Recovery & Concurrance
ORDER BY
Service Provider
Web server
3. Deletes selected rows
Information
Web Browser
Dynamic
DELETE
4. Text markups that form an element" sort of a "box" to hold things like text and other elements
Candidate Keys
Tags
Data Administrator (DAd)
MAX
5. Definition of commands it can do
Performance
Data Administrator (DAd)
Data Definition
Indexes
6. Data remains unchanged in database
ALL
to update
Persistent
Relational
7. Changes the values in one or more selected rows of a table
UPDATE
NOT
Shared
Integrated
8. Data in database has ability to be accessed and manipulated by several users
Shared
Precedence of Logical Operators
FROM
Service Provider
9. Responsible for technical implementation & maintenance of database on a design & physical level
Data Administrator (DAd)
Database Administrator (DBA)
Candidate Keys
*
10. Order in which WHERE clause is evaluated and combined
Flat File
Precedence of Logical Operators
Persistent
GROUP BY
11. Changes the values in one or more selected rows of a table
Data Definition
Database
UPDATE
GROUP BY
12. Practice of writing code into a webpage that is not directly visible to the user
Scripting
Word
Data Elements
Web Service
13. Describe information in a tree styled format
Hierarchial
Data Manipulation
Web Service
ALL
14. Executes commands one at a time - results being displayed immediately
Aggregate Functions
Embedded SQL
Interactive SQL
Views
15. Ensures functions are done efficiently
Cookie
SELECT
Performance
Stateless
16. Compares value of the column in the specified condition with the value specified
Service Requestor
Web server
Data Recovery & Concurrance
Equals Operator
17. Command based way to ask the database a question
Query
Negation Operator
SUM
Outer SELECT query
18. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Object-Oriented Relational (OOR)
Tags
Hypertext Markup Language (HTML)
Information
19. Uses two values as limits - selecting any values between the two of them
Report
Candidate Keys
BETWEEN
Comparison Operators
20. Essentially a collection of services that communicate with eachother
LIKE
Aggregate Functions
ESC
Service-Oriented Architecture (SOA)
21. Give the browser more specific information about that tag
Attributes
AVG
Equals Operator
Closing tag
22. All Columns indicated and selected
Calculated Column
Persistent
*
Cookie
23. Finds the lowest constant value in a column
Property
MAX
Hypertext Markup Language (HTML)
Database Administrator (DBA)
24. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Outer SELECT query
GROUP BY
Empty Elements
25. Has the highest precedence - followed by the AND - OR
Interactive SQL
LIKE
Session
NOT
26. Used to combine one query to another
ALL
Tags
GROUP BY
Subqueries
27. Grant acces and control to only specific information
SUM
Scripting
INSERT INTO
Views
28. Most valuable asset of a database system.
Forward Slash
Central control of data
Foreign Keys
ALL
29. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Web Service
Outer SELECT query
Outer SELECT query
Central Control of data
30. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
MAX
Attributes
Report
31. Limits the output of the established groups into the derived result table
Web server
HAVING
Application Programers
Self Join
32. Table displayed in ascending order
Negation Operator
ASC
Relational
Empty Elements
33. SQL finds and retrieves date
Object-Oriented Relational (OOR)
Indexes
Fields
End Users
34. Everything between the start and end tag
Aggregate Functions
End Users
ESC
Element Content
35. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Shared
Structured Query Language (SQL)
Forward Slash
Negation Operator
36. Grant acces and control to only specific information
Comparison Operators
Session
Tables
Views
37. Ensures functions are done efficiently
Data Elements
Service-Oriented Architecture (SOA)
Performance
Web server
38. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Application Programers
to update
Bind
Scripting
39. Limits the output of the established groups into the derived result table
Views
to update
HAVING
Cookie
40. Table displayed in ascending order
BETWEEN
ASC
Data Administrator (DAd)
End Users
41. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Query
hidden fields
Session
Web Applications
42. Software system designed to support interoperable machine - to - machine interaction over a network
Service-Oriented Architecture (SOA)
Tables
Web Service
Data
43. One of the tools that SQL uses to find and retrieve data.
Empty Elements
Empty Elements
Subqueries
Indexes
44. Data stored by DAd
accident
Data Elements
Structured Query Language (SQL)
DISTINCT
45. Allow useres to retrieve data and interact with content located on web pages within website
Dynamic
SELECT
Empty Elements
Web Browser
46. File stored on a user's machine that contains infor about application
Comparison Operators
single value
hidden fields
Cookie
47. Defines a new column
BETWEEN
Views
MIN
Calculated Column
48. Columns containing numbers only
SUM
Candidate Keys
Comparison Operators
Inner SELECT query
49. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Object-Oriented Relational (OOR)
hidden fields
single value
DISTINCT
50. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Data Administrator (DAd)
Element Content
Dynamic
Service Broker