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. All Columns indicated and selected
Tables
*
Session
Fields
2. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
Data Elements
Word
Tags
3. Used to remove duplicates from result table
Integrated
Application Programmers
ORDER BY
DISTINCT
4. Closed in the start tag by adding a slash to the start tag
Empty Elements
Tables
Information
Calculated Column
5. Table displayed in descending order
Embedded SQL
ESC
Data Manipulation
Fields
6. SQL Commands - Two Things Specify data interested in - Indicate the ________
Scripting
accident
Public Key Infrastructure (PKI)
Indexes
7. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Bind
Web server
ASC
8. Command used to show the attributes that define a table.
Hypertext Markup Language (HTML)
SELECT
sp_help
WHERE
9. Used with another comparison operator - values become inverted
Application Programmers
Negation Operator
Database Management Systems (DBMS)
Views
10. Finds the lowest ACII value in column
American Standard Code for Information Interchange (ASCII)
Empty Elements
MIN
Data Manipulation
11. Finds the lowest constant value in a column
Performance
Precedence of Logical Operators
MAX
to update
12. Command based way to ask the database a question
Hypertext Markup Language (HTML)
Query
Information
Data Manipulation
13. Ongoing record of data reflecting the info defining the database
Data Dictionary
Hypertext Markup Language (HTML)
Query
IN
14. Ongoing record of data reflecting the info defining the database
GROUP BY
Data Dictionary
FROM
Indexes
15. Individuals that use - manipulate or maintain aspects of database
ASC
Service Broker
Attributes
Users
16. Deletes selected rows
Object-Oriented Relational (OOR)
Data Definition
Web Browser
DELETE
17. 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.
SUM
Candidate Keys
SUM
Comparison Operators
18. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
WHERE
Scripting
ASC
Hardware
19. Columns containing numbers only
ASC
LIKE
SUM
Inner SELECT query
20. Definition of commands it can do
Flat File
American Standard Code for Information Interchange (ASCII)
Data Definition
Integrated
21. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Data
Web server
WHERE
Attributes
22. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
FROM
DISTINCT
Property
23. Everything between the start and end tag
Report
Equals Operator
Closing tag
Element Content
24. Interact and manipulates the data in the database
Application Programmers
FROM
Web Browser
Data Manipulation
25. Combines rows from a SELECT statements result table into a group
Joins
Shared
GROUP BY
Structured Query Language (SQL)
26. Essentially a collection of services that communicate with eachother
Users
WHERE
FROM
Service-Oriented Architecture (SOA)
27. Software system designed to support interface for a software asset that manages a specific set of tasks
Flat File
Data Administrator (DAd)
Data
Service Provider
28. Limits the rows that appear in the result mathcing a specified condition
American Standard Code for Information Interchange (ASCII)
Performance
WHERE
Cookie
29. Compares value of the column in the specified condition with the value specified
Data Definition
Element Content
Equals Operator
Fields
30. Compares value of the column in the specified condition with the value specified
Equals Operator
ASC
Interactive SQL
SELECT
31. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Service Requestor
Cookie
ALL
Web server
32. Limits the output of the established groups into the derived result table
Hierarchial
HAVING
ASC
Database Management Systems (DBMS)
33. Limits the rows that appear in the result mathcing a specified condition
Relational
Inner SELECT query
WHERE
SUM
34. Executes commands one at a time - results being displayed immediately
Interactive SQL
INSERT INTO
Opening tag
*
35. Software system designed to support interoperable machine - to - machine interaction over a network
Central Control of data
to update
Web Service
Dynamic
36. Create program files that include SQ after each command
AVG
Embedded SQL
Outer SELECT query
Object-Oriented Relational (OOR)
37. Concatenated in SQL Server Database software using the addition symbol
Fields
Service Broker
Tags
IN
38. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Interactive SQL
accident
Functions
Structured Query Language (SQL)
39. Using product as intended for its audience
Comparison Operators
Interactive SQL
Service Broker
End Users
40. Data remains unchanged in database
Database
Persistent
ESC
AVG
41. Cookies are more secure than______ - allowing travel on a website without loss of info
Database Administrator (DBA)
hidden fields
Fields
Service-Oriented Architecture (SOA)
42. Network node that discovers and invokes other software services to provide a buisness solution
*
Service Broker
INSERT INTO
Service Requestor
43. Fields in a relational table that match the primary key from one column to the primary key of another table.
IN
Foreign Keys
Attributes
Indexes
44. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Indexes
Scripting
Indexes
45. Table displayed in ascending order
Views
ASC
Tables
Self Join
46. Selects from specific values in list
IN
Subquery
Database Management Systems (DBMS)
Service-Oriented Architecture (SOA)
47. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
MIN
Interactive SQL
Joins
Hypertext Markup Language (HTML)
48. Specifies the tables or views from which rows and columns are retrieved
FROM
AVG
Web server
Web Service
49. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
DELETE
Central Control of data
American Standard Code for Information Interchange (ASCII)
Stateless
50. Individuals that use - manipulate or maintain aspects of database
Inner SELECT query
Application Programers
INSERT INTO
Users