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. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
LIKE
SUM
ASC
COUNT
2. Closed in the start tag by adding a slash to the start tag
Subqueries
Tags
Empty Elements
Comparison Operators
3. Used to combine one query to another
Embedded SQL
Subqueries
accident
WHERE
4. 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.
Subqueries
Attributes
DISTINCT
Primary Keys
5. SQL finds and retrieves date
UPDATE
Indexes
Tables
Inner SELECT query
6. Decides what data is stored in the databse and the manner it is stored
Fields
Data Administrator (DAd)
Data Elements
Flat File
7. Three Basic Operations of SP - SR - SB: Publish - Find - ____
WHERE
Fields
Bind
BETWEEN
8. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Data Definition
Hypertext Markup Language (HTML)
IN
American Standard Code for Information Interchange (ASCII)
9. Executes commands one at a time - results being displayed immediately
Tags
Interactive SQL
COUNT
Data Definition
10. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Equals Operator
Tables
Hierarchial
11. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
COUNT
Database
GROUP BY
Aliases
12. Begins an element
Outer SELECT query
NOT
Property
Opening tag
13. Data that has been processed into a format that is understandable by its audience
Information
to update
hidden fields
Data Manipulation
14. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Users
Relational
Web server
15. Used in a SELECT clause in place of a column
Scripting
to update
Aggregate Functions
Inner SELECT query
16. Command based way to ask the database a question
Data Elements
Query
single value
Attributes
17. Allow useres to retrieve data and interact with content located on web pages within website
Aggregate Functions
ASC
COUNT
Web Browser
18. Ongoing record of data reflecting the info defining the database
Information
Data Dictionary
Service-Oriented Architecture (SOA)
Joins
19. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Aggregate Functions
ALL
Report
Integrated
20. Join a table to a copy of itself
Self Join
Interactive SQL
Structured Query Language (SQL)
*
21. Data in database has ability to be accessed and manipulated by several users
Element Content
Shared
Functions
Outer SELECT query
22. Basic Component of SQL
Web server
Structured Query Language (SQL)
Data Manipulation
Tables
23. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Web server
Application Programmers
DISTINCT
Central Control of data
24. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Central control of data
Service Broker
WHERE
Word
25. Data that has been processed into a format that is understandable by its audience
Data Recovery & Concurrance
Information
Session
ALL
26. = - < - > - <= - >= - <> - !
Comparison Operators
Application Programmers
Database Management Systems (DBMS)
Closing tag
27. 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
Session
Application Programmers
Opening tag
Object-Oriented Relational (OOR)
28. Allows data recovery in case of corruption or loss
SELECT
Report
Web server
Data Recovery & Concurrance
29. Straight implementation of raw data formatted into rows and columns
SUM
Flat File
Session
Forward Slash
30. Practice of writing code into a webpage that is not directly visible to the user
Comparison Operators
IN
Database Administrator (DBA)
Scripting
31. Using product as intended for its audience
Data Recovery & Concurrance
End Users
Joins
Tables
32. Data stored by DAd
Bind
Tables
Data Elements
Data Recovery & Concurrance
33. Used to combine one query with another.
Subquery
Candidate Keys
ASC
Functions
34. Copies multiple records at the same time using a SELECT statement
ORDER BY
SELECT
INSERT INTO
Data
35. Create program files that include SQ after each command
Embedded SQL
Database
Object-Oriented Relational (OOR)
Cookie
36. Has the highest precedence - followed by the AND - OR
Application Programmers
NOT
Indexes
Query
37. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
sp_help
Service Broker
IN
DELETE
38. Identifies columns to appear in the result
Data Definition
SELECT
Functions
Application Programmers
39. Used in a SELECT clause in place of a column
Inner SELECT query
SUM
Relational
Aggregate Functions
40. Uses two values as limits - selecting any values between the two of them
to update
End Users
Integrated
BETWEEN
41. File stored on a user's machine that contains infor about application
Comparison Operators
Attributes
Joins
Cookie
42. Some form of output - usually - printed - containing information
Cookie
American Standard Code for Information Interchange (ASCII)
Report
Query
43. Uses two values as limits - selecting any values between the two of them
Data Administrator (DAd)
BETWEEN
Word
Hardware
44. Limits the rows that appear in the result mathcing a specified condition
hidden fields
WHERE
IN
Interactive SQL
45. Definition of commands it can do
COUNT
Data Definition
HAVING
COUNT
46. Change order of rows in result table
Data Definition
ORDER BY
Cookie
HAVING
47. Order in which WHERE clause is evaluated and combined
Database
LIKE
Precedence of Logical Operators
Closing tag
48. Fields in a relational table that match the primary key from one column to the primary key of another table.
GROUP BY
Structured Query Language (SQL)
Flat File
Foreign Keys
49. Compares value of the column in the specified condition with the value specified
IN
Equals Operator
SUM
UPDATE
50. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Self Join
Hierarchial
Bind
Tags