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. Compares value of the column in the specified condition with the value specified
Equals Operator
IN
Inner SELECT query
single value
2. Software system designed to support interoperable machine - to - machine interaction over a network
Views
single value
ESC
Web Service
3. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Joins
BETWEEN
Shared
4. Columns containing numbers only
End Users
Object-Oriented Relational (OOR)
Data Dictionary
SUM
5. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
Session
Information
Property
AVG
6. Basic Component of SQL
Tables
Data Recovery & Concurrance
Data Dictionary
AVG
7. Data that has been processed into a format that is understandable by its audience
BETWEEN
HAVING
NOT
Information
8. Text markups that form an element" sort of a "box" to hold things like text and other elements
Web Service
ALL
Tags
Comparison Operators
9. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
single value
Structured Query Language (SQL)
ESC
Scripting
10. Used to combine one query to another
Subqueries
Word
Central control of data
Calculated Column
11. Software system designed to support interface for a software asset that manages a specific set of tasks
Performance
Tags
Attributes
Service Provider
12. Join a table to a copy of itself
Equals Operator
UPDATE
Persistent
Self Join
13. Basic Component of SQL
GROUP BY
DELETE
UPDATE
Tables
14. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
SELECT
Session
Database Management Systems (DBMS)
Central Control of data
15. Using product as intended for its audience
Database Administrator (DBA)
Joins
End Users
Joins
16. Everything between the start and end tag
Element Content
Fields
American Standard Code for Information Interchange (ASCII)
UPDATE
17. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
Session
Dynamic
Web Applications
Comparison Operators
18. Uses relationships between independent entities
Information
Structured Query Language (SQL)
Service Provider
Relational
19. Everything in enviroment becomes an object - expands on Priniples of relational databases
Subquery
Object-Oriented Relational (OOR)
Application Programers
Data Manipulation
20. Identifies columns to appear in the result
Users
Application Programers
SELECT
Relational
21. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Application Programers
Web server
Relational
Database Management Systems (DBMS)
22. Allow useres to retrieve data and interact with content located on web pages within website
Query
Attributes
IN
Web Browser
23. Individuals that use - manipulate or maintain aspects of database
Users
Outer SELECT query
Cookie
ORDER BY
24. Create program files that include SQ after each command
Functions
Embedded SQL
DELETE
Outer SELECT query
25. Writes programs that use or allow acces to databse with specific purpose
accident
Database Management Systems (DBMS)
Tags
Application Programers
26. Network node that discovers and invokes other software services to provide a buisness solution
Shared
hidden fields
WHERE
Service Requestor
27. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Precedence of Logical Operators
ESC
Information
28. Flat File Examples: Excel Spreadsheets - _____
Word
Empty Elements
IN
Shared
29. Ongoing record of data reflecting the info defining the database
Query
Data Dictionary
Service Requestor
Application Programmers
30. Defines a new column
Web server
Calculated Column
Database Administrator (DBA)
DELETE
31. Definition of commands it can do
Data Definition
Information
American Standard Code for Information Interchange (ASCII)
to update
32. Essentially a collection of services that communicate with eachother
Users
Data Manipulation
Service-Oriented Architecture (SOA)
Closing tag
33. Combines rows from a SELECT statements result table into a group
GROUP BY
Inner SELECT query
*
Empty Elements
34. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
ESC
Central control of data
Hardware
35. Deletes selected rows
Service Provider
DELETE
Report
Service Provider
36. Characterizes operation of a relational database
Users
Joins
Forward Slash
Word
37. Command based way to ask the database a question
Application Programmers
ASC
Service Broker
Query
38. = - < - > - <= - >= - <> - !
Calculated Column
Comparison Operators
Inner SELECT query
COUNT
39. Interact and manipulates the data in the database
Self Join
Data Manipulation
Service Provider
Comparison Operators
40. All Columns indicated and selected
Data
Outer SELECT query
MAX
*
41. Used with another comparison operator - values become inverted
Indexes
Service Provider
Application Programmers
Negation Operator
42. Definition of commands it can do
Shared
Subqueries
Public Key Infrastructure (PKI)
Data Definition
43. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Subqueries
Application Programmers
End Users
44. Uses two values as limits - selecting any values between the two of them
Bind
BETWEEN
Comparison Operators
Hierarchial
45. Used to remove duplicates from result table
DISTINCT
Data Recovery & Concurrance
Data Manipulation
Tags
46. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Empty Elements
GROUP BY
Foreign Keys
47. Identifies columns to appear in the result
SELECT
COUNT
Bind
Indexes
48. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Data Dictionary
Flat File
Hypertext Markup Language (HTML)
Object-Oriented Relational (OOR)
49. Practice of writing code into a webpage that is not directly visible to the user
Scripting
Application Programmers
AVG
Data Manipulation
50. Order in which WHERE clause is evaluated and combined
Web Service
Precedence of Logical Operators
Views
Comparison Operators