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. Everything in enviroment becomes an object - expands on Priniples of relational databases
Data Definition
SELECT
*
Object-Oriented Relational (OOR)
2. Everything between the start and end tag
Element Content
Shared
Application Programmers
Aliases
3. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
DISTINCT
Opening tag
SELECT
4. Browser requests page - code is delivered - executed and done with
Self Join
Relational
Dynamic
Performance
5. Finds the lowest ACII value in column
MAX
MIN
Tags
SUM
6. Defines a new column
Self Join
Calculated Column
hidden fields
Relational
7. Has the highest precedence - followed by the AND - OR
Web Service
NOT
Joins
hidden fields
8. Ensures functions are done efficiently
Outer SELECT query
Performance
Embedded SQL
Outer SELECT query
9. Used to combine one query to another
Database
Integrated
Subqueries
Session
10. Uses two values as limits - selecting any values between the two of them
BETWEEN
SUM
SUM
Database Management Systems (DBMS)
11. Create program files that include SQ after each command
Data Recovery & Concurrance
FROM
Embedded SQL
UPDATE
12. Essentially a collection of services that communicate with eachother
Persistent
Service-Oriented Architecture (SOA)
Hardware
Bind
13. Characterizes operation of a relational database
Joins
Interactive SQL
Foreign Keys
Negation Operator
14. Tally of how many rows meet criteria specified
Integrated
FROM
Data Recovery & Concurrance
COUNT
15. Deletes selected rows
DELETE
Service Requestor
Tables
Query
16. Selects from specific values in list
Database
Equals Operator
Candidate Keys
IN
17. Table displayed in descending order
Data Dictionary
Indexes
Aggregate Functions
ESC
18. Straight implementation of raw data formatted into rows and columns
Embedded SQL
Data Definition
hidden fields
Flat File
19. SELECT statment containing the nested query
Data Recovery & Concurrance
Closing tag
to update
Outer SELECT query
20. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Database Administrator (DBA)
Central Control of data
Session
MIN
21. 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.
Service Broker
Primary Keys
COUNT
Data Elements
22. The Web is ___________
Web server
Stateless
BETWEEN
COUNT
23. Most valuable asset of a database system.
Data Administrator (DAd)
End Users
Central control of data
Persistent
24. Executes commands one at a time - results being displayed immediately
Interactive SQL
FROM
ORDER BY
Object-Oriented Relational (OOR)
25. Interact and manipulates the data in the database
Public Key Infrastructure (PKI)
Data Manipulation
*
Bind
26. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Aggregate Functions
Opening tag
Structured Query Language (SQL)
Application Programers
27. Decides what data is stored in the databse and the manner it is stored
Web Browser
Fields
Data Administrator (DAd)
MAX
28. Writes programs that use or allow acces to databse with specific purpose
Bind
Tags
Application Programers
Hardware
29. All Columns indicated and selected
End Users
Service Broker
*
Shared
30. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Dynamic
Property
Relational
31. 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
Outer SELECT query
hidden fields
Web Service
Session
32. Limits the rows that appear in the result mathcing a specified condition
Service-Oriented Architecture (SOA)
Opening tag
Word
WHERE
33. Used to combine one query with another.
Indexes
Subquery
Integrated
MAX
34. Uses relationships between independent entities
Candidate Keys
Relational
Data
ALL
35. Combines rows from a SELECT statements result table into a group
Web server
Subqueries
GROUP BY
Shared
36. Changes the values in one or more selected rows of a table
Relational
Public Key Infrastructure (PKI)
UPDATE
Element Content
37. Large structured set of persistent data
BETWEEN
Data Definition
DISTINCT
Database
38. Allows data recovery in case of corruption or loss
DISTINCT
Data Dictionary
Data Recovery & Concurrance
COUNT
39. Flat File Examples: Excel Spreadsheets - _____
Word
Forward Slash
Hierarchial
SUM
40. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Opening tag
Attributes
Equals Operator
41. Meaningful info related to database
Report
Data
Subqueries
SUM
42. Responsible for technical implementation & maintenance of database on a design & physical level
Empty Elements
Calculated Column
Database Administrator (DBA)
Bind
43. = - < - > - <= - >= - <> - !
Comparison Operators
Performance
Application Programers
Embedded SQL
44. Allows data recovery in case of corruption or loss
Web server
Data Recovery & Concurrance
DELETE
Scripting
45. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
UPDATE
Service Broker
Application Programmers
Data Recovery & Concurrance
46. 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.
sp_help
Equals Operator
Information
Candidate Keys
47. Defines a new column
*
Performance
Calculated Column
Property
48. Three Basic Operations of SP - SR - SB: Publish - Find - ____
accident
to update
Bind
Word
49. Meaningful info related to database
Views
Web Service
Query
Data
50. Identifies columns to appear in the result
Data Administrator (DAd)
Joins
Database Management Systems (DBMS)
SELECT