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. Looks like opening tag - but with a forward slash
Closing tag
Hardware
*
Forward Slash
2. Individuals that use - manipulate or maintain aspects of database
Hierarchial
Relational
Web server
Users
3. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Data Manipulation
Dynamic
Views
Service Broker
4. SELECT statment containing the nested query
Precedence of Logical Operators
ASC
Outer SELECT query
AVG
5. Describe information in a tree styled format
Service Broker
Element Content
Word
Hierarchial
6. Data that has been processed into a format that is understandable by its audience
Information
Negation Operator
LIKE
Comparison Operators
7. Basic Component of SQL
Tables
Web server
Equals Operator
Bind
8. Defines a new column
Calculated Column
Comparison Operators
Hierarchial
Data
9. Used with another comparison operator - values become inverted
hidden fields
Negation Operator
Performance
Hypertext Markup Language (HTML)
10. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
Relational
UPDATE
IN
11. Fields in a relational table that match the primary key from one column to the primary key of another table.
Foreign Keys
Hierarchial
Web Service
MAX
12. Data in database has ability to be accessed and manipulated by several users
American Standard Code for Information Interchange (ASCII)
WHERE
Shared
SELECT
13. Uses relationships between independent entities
Opening tag
Relational
Database
Data Manipulation
14. Table displayed in descending order
ESC
Session
GROUP BY
Central control of data
15. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Tags
Application Programmers
Object-Oriented Relational (OOR)
Aliases
16. Using product as intended for its audience
COUNT
End Users
Word
Service Requestor
17. Practice of writing code into a webpage that is not directly visible to the user
ESC
Scripting
Database Management Systems (DBMS)
Hardware
18. Interact and manipulates the data in the database
Data Definition
Joins
Data Manipulation
Fields
19. Large structured set of persistent data
Aliases
Information
Data Administrator (DAd)
Database
20. Individuals that use - manipulate or maintain aspects of database
AVG
Users
Inner SELECT query
Database Administrator (DBA)
21. Large structured set of persistent data
Database
SUM
MIN
Views
22. Limits the output of the established groups into the derived result table
Interactive SQL
HAVING
Web Browser
Indexes
23. Supplies value for the search condition of the SELECT statement containing it
Dynamic
Service-Oriented Architecture (SOA)
Inner SELECT query
Tables
24. Table displayed in ascending order
Performance
Precedence of Logical Operators
ASC
Hypertext Markup Language (HTML)
25. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
MAX
ESC
Web server
Report
26. Compares value of the column in the specified condition with the value specified
Aliases
WHERE
Candidate Keys
Equals Operator
27. Combines rows from a SELECT statements result table into a group
single value
ORDER BY
GROUP BY
Report
28. Limits the output of the established groups into the derived result table
BETWEEN
Forward Slash
HAVING
Service Requestor
29. Three Basic Operations of SP - SR - SB: Publish - Find - ____
SUM
Service Broker
Bind
Service-Oriented Architecture (SOA)
30. Everything between the start and end tag
accident
Element Content
SUM
Scripting
31. Command used to show the attributes that define a table.
sp_help
Self Join
to update
Report
32. Used in a SELECT clause in place of a column
Aggregate Functions
ALL
ORDER BY
NOT
33. Deletes selected rows
Subquery
Word
Data Recovery & Concurrance
DELETE
34. Browser requests page - code is delivered - executed and done with
Users
Indexes
Dynamic
Negation Operator
35. Selects from specific values in list
accident
IN
Scripting
BETWEEN
36. Columns containing numbers only
SUM
Information
Scripting
ESC
37. Characterizes operation of a relational database
ALL
Joins
AVG
Web Browser
38. Used to remove duplicates from result table
DISTINCT
Calculated Column
Comparison Operators
IN
39. Data stored by DAd
Data Elements
Information
Hypertext Markup Language (HTML)
Joins
40. Used to combine one query to another
Subqueries
Empty Elements
Aggregate Functions
Attributes
41. SELECT statment containing the nested query
MAX
Candidate Keys
Outer SELECT query
Interactive SQL
42. Executes commands one at a time - results being displayed immediately
Interactive SQL
Service-Oriented Architecture (SOA)
Report
hidden fields
43. Grant acces and control to only specific information
Views
Persistent
Database Management Systems (DBMS)
Data Recovery & Concurrance
44. Writes programs that use or allow acces to databse with specific purpose
Session
Database
Closing tag
Application Programers
45. Finds the lowest ACII value in column
GROUP BY
Foreign Keys
MIN
ALL
46. Browser requests page - code is delivered - executed and done with
Hierarchial
to update
Report
Dynamic
47. Used to close a tag properly
Data
Forward Slash
UPDATE
Joins
48. Characterizes operation of a relational database
Structured Query Language (SQL)
Property
Data Elements
Joins
49. File stored on a user's machine that contains infor about application
to update
Comparison Operators
Cookie
Web Browser
50. Writes programs that use or allow acces to databse with specific purpose
Application Programers
FROM
Web server
Empty Elements