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. Tally of how many rows meet criteria specified
COUNT
Empty Elements
Precedence of Logical Operators
BETWEEN
2. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
LIKE
Empty Elements
Structured Query Language (SQL)
End Users
3. Supplies value for the search condition of the SELECT statement containing it
Web server
Inner SELECT query
End Users
ESC
4. Finds the lowest constant value in a column
Empty Elements
Service Requestor
SUM
MAX
5. Supplies value for the search condition of the SELECT statement containing it
Opening tag
Hardware
Inner SELECT query
Database Administrator (DBA)
6. Grant acces and control to only specific information
hidden fields
Bind
Views
Calculated Column
7. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Aliases
single value
Joins
LIKE
8. Combines rows from a SELECT statements result table into a group
Subqueries
BETWEEN
Precedence of Logical Operators
GROUP BY
9. Definition of commands it can do
COUNT
Candidate Keys
Data Recovery & Concurrance
Data Definition
10. Changes the values in one or more selected rows of a table
Central Control of data
Database
UPDATE
SUM
11. Give the browser more specific information about that tag
Foreign Keys
Aliases
Attributes
Word
12. Uses relationships between independent entities
MAX
IN
Relational
Comparison Operators
13. Writes programs that use or allow acces to databse with specific purpose
Application Programers
MAX
Closing tag
DISTINCT
14. Individuals that use - manipulate or maintain aspects of database
Precedence of Logical Operators
Calculated Column
Users
Views
15. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Provider
Hypertext Markup Language (HTML)
Service Broker
Bind
16. Flat File Examples: Excel Spreadsheets - _____
Opening tag
Aggregate Functions
SELECT
Word
17. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Outer SELECT query
Web server
to update
Functions
18. Data stored by DAd
Public Key Infrastructure (PKI)
LIKE
Data Elements
Web server
19. Changes the values in one or more selected rows of a table
UPDATE
Database Management Systems (DBMS)
SUM
IN
20. Straight implementation of raw data formatted into rows and columns
Flat File
Opening tag
Service Broker
Object-Oriented Relational (OOR)
21. Basic Component of SQL
*
Performance
Self Join
Tables
22. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Aliases
Web Applications
FROM
Service Requestor
23. Averages the numeric values
Subqueries
Self Join
AVG
Interactive SQL
24. Used to remove duplicates from result table
DISTINCT
Central Control of data
Inner SELECT query
BETWEEN
25. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Structured Query Language (SQL)
Outer SELECT query
Web server
26. Closed in the start tag by adding a slash to the start tag
Dynamic
Empty Elements
Subquery
Data Recovery & Concurrance
27. Data in database has ability to be accessed and manipulated by several users
WHERE
Shared
Joins
Aliases
28. Finds the lowest ACII value in column
Central Control of data
Subqueries
MIN
Report
29. Basic Component of SQL
Object-Oriented Relational (OOR)
Hardware
Query
Tables
30. Cookies are more secure than______ - allowing travel on a website without loss of info
Interactive SQL
Indexes
hidden fields
Data Administrator (DAd)
31. Closed in the start tag by adding a slash to the start tag
Empty Elements
Hypertext Markup Language (HTML)
Indexes
Web Browser
32. Specifies the tables or views from which rows and columns are retrieved
Forward Slash
Service-Oriented Architecture (SOA)
Relational
FROM
33. Table displayed in descending order
ESC
Data
Web server
Word
34. SELECT statment containing the nested query
BETWEEN
Embedded SQL
Web server
Outer SELECT query
35. File stored on a user's machine that contains infor about application
Cookie
Service-Oriented Architecture (SOA)
Database Administrator (DBA)
DISTINCT
36. Using product as intended for its audience
Persistent
End Users
Session
Outer SELECT query
37. 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.
Session
Application Programmers
Primary Keys
Candidate Keys
38. 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.
Object-Oriented Relational (OOR)
Service Provider
Primary Keys
ALL
39. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Hierarchial
Service Broker
to update
Query
40. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
single value
ALL
Precedence of Logical Operators
41. Responsible for technical implementation & maintenance of database on a design & physical level
Flat File
Hardware
Element Content
Database Administrator (DBA)
42. Practice of writing code into a webpage that is not directly visible to the user
Aliases
Hardware
Scripting
Element Content
43. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Session
Structured Query Language (SQL)
INSERT INTO
Service Broker
44. Used to remove duplicates from result table
ESC
INSERT INTO
Calculated Column
DISTINCT
45. Everything between the start and end tag
Element Content
Application Programmers
Negation Operator
Interactive SQL
46. Definition of commands it can do
Data
Precedence of Logical Operators
Data Definition
AVG
47. Specifies the tables or views from which rows and columns are retrieved
Subqueries
Interactive SQL
FROM
Data
48. Describe information in a tree styled format
Hierarchial
Data Definition
IN
Comparison Operators
49. Looks like opening tag - but with a forward slash
ESC
Tags
Closing tag
ASC
50. Network node that discovers and invokes other software services to provide a buisness solution
FROM
Web Service
Central Control of data
Service Requestor