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. Allows data recovery in case of corruption or loss
Tables
Data Recovery & Concurrance
Web Service
Word
2. Begins an element
Flat File
hidden fields
Opening tag
DELETE
3. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Dynamic
Hardware
*
4. Order in which WHERE clause is evaluated and combined
Data Manipulation
American Standard Code for Information Interchange (ASCII)
Service Requestor
Precedence of Logical Operators
5. Data in database has ability to be accessed and manipulated by several users
Calculated Column
American Standard Code for Information Interchange (ASCII)
Fields
Shared
6. Essentially a collection of services that communicate with eachother
Inner SELECT query
Service-Oriented Architecture (SOA)
Indexes
Web server
7. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
ASC
IN
Hardware
Dynamic
8. Selects from specific values in list
Subqueries
to update
Session
IN
9. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
DISTINCT
NOT
Data Elements
Hypertext Markup Language (HTML)
10. = - < - > - <= - >= - <> - !
sp_help
Relational
Comparison Operators
Aggregate Functions
11. Writes programs that use or allow acces to databse with specific purpose
Application Programers
Service-Oriented Architecture (SOA)
Data Manipulation
Query
12. Uses two values as limits - selecting any values between the two of them
Persistent
Integrated
MAX
BETWEEN
13. Closed in the start tag by adding a slash to the start tag
Outer SELECT query
Structured Query Language (SQL)
Empty Elements
Hardware
14. Individuals that use - manipulate or maintain aspects of database
Word
to update
ORDER BY
Users
15. Using product as intended for its audience
Data Dictionary
Data Elements
End Users
ASC
16. Describe information in a tree styled format
Hierarchial
Aggregate Functions
Object-Oriented Relational (OOR)
Session
17. Finds the lowest ACII value in column
Cookie
Hierarchial
Service Requestor
MIN
18. 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
Shared
Closing tag
Session
Data Elements
19. Has the highest precedence - followed by the AND - OR
Bind
Query
NOT
SELECT
20. Deletes selected rows
Query
DELETE
Subqueries
Central Control of data
21. All Columns indicated and selected
HAVING
*
Dynamic
Application Programers
22. Data stored by DAd
Empty Elements
Data Elements
Information
Tags
23. Has the highest precedence - followed by the AND - OR
NOT
*
Negation Operator
Data Dictionary
24. Concatenated in SQL Server Database software using the addition symbol
Information
to update
Fields
Web server
25. Used in a SELECT clause in place of a column
Database
Database Administrator (DBA)
Foreign Keys
Aggregate Functions
26. Begins an element
Opening tag
Views
Web Applications
Cookie
27. Definition of commands it can do
Word
Scripting
Data Definition
AVG
28. Executes commands one at a time - results being displayed immediately
Interactive SQL
Outer SELECT query
Cookie
AVG
29. Used to close a tag properly
Data Administrator (DAd)
Forward Slash
Hierarchial
Joins
30. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Functions
Query
Hardware
31. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
accident
Aliases
Data Definition
SUM
32. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
End Users
Data Administrator (DAd)
FROM
single value
33. Join a table to a copy of itself
Self Join
Application Programmers
COUNT
MIN
34. Meaningful info related to database
Cookie
Embedded SQL
Data Dictionary
Data
35. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Dynamic
Web server
INSERT INTO
Structured Query Language (SQL)
36. Combines rows from a SELECT statements result table into a group
Integrated
GROUP BY
Candidate Keys
Scripting
37. Used to combine one query to another
Subqueries
Data Elements
Structured Query Language (SQL)
Cookie
38. Fields in a relational table that match the primary key from one column to the primary key of another table.
Foreign Keys
Web server
Outer SELECT query
hidden fields
39. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Scripting
Subqueries
hidden fields
single value
40. SQL Commands - Two Things Specify data interested in - Indicate the ________
Interactive SQL
Interactive SQL
accident
Joins
41. Copies multiple records at the same time using a SELECT statement
AVG
Application Programmers
INSERT INTO
Cookie
42. Straight implementation of raw data formatted into rows and columns
FROM
Service Provider
Flat File
End Users
43. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
accident
Users
Closing tag
44. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Information
Tags
Application Programmers
hidden fields
45. Ongoing record of data reflecting the info defining the database
Attributes
Data Dictionary
Comparison Operators
Application Programers
46. Everything in enviroment becomes an object - expands on Priniples of relational databases
Closing tag
Structured Query Language (SQL)
Object-Oriented Relational (OOR)
Aliases
47. One huge database to hold all data; Access to data - and use of system to add - update & print records
Performance
Data Dictionary
Database Management Systems (DBMS)
Self Join
48. Table displayed in ascending order
ASC
Bind
ORDER BY
Dynamic
49. 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.
Primary Keys
Precedence of Logical Operators
Query
ORDER BY
50. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Flat File
Service-Oriented Architecture (SOA)
Views
SUM