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. Supplies value for the search condition of the SELECT statement containing it
Functions
Inner SELECT query
SELECT
SUM
2. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Users
Negation Operator
BETWEEN
Service Broker
3. Changes the values in one or more selected rows of a table
HAVING
UPDATE
ALL
Scripting
4. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Hypertext Markup Language (HTML)
SUM
Application Programmers
AVG
5. Flat File Examples: Excel Spreadsheets - _____
Shared
SELECT
UPDATE
Word
6. Command based way to ask the database a question
HAVING
Element Content
Query
Precedence of Logical Operators
7. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Report
End Users
Functions
Application Programmers
8. Command based way to ask the database a question
Query
HAVING
Shared
LIKE
9. Limits the output of the established groups into the derived result table
Fields
HAVING
hidden fields
Closing tag
10. Limits the rows that appear in the result mathcing a specified condition
WHERE
Comparison Operators
FROM
AVG
11. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Web Browser
Bind
Data
Relational
12. Data remains unchanged in database
Fields
Report
Equals Operator
Persistent
13. Begins an element
Aggregate Functions
Shared
Opening tag
Data Definition
14. Selects from specific values in list
Shared
IN
Data Manipulation
Word
15. Describe information in a tree styled format
Cookie
Hierarchial
Data Administrator (DAd)
Outer SELECT query
16. Concatenated in SQL Server Database software using the addition symbol
Hardware
Structured Query Language (SQL)
WHERE
Fields
17. SELECT statment containing the nested query
Inner SELECT query
Outer SELECT query
BETWEEN
Attributes
18. Tally of how many rows meet criteria specified
Shared
Service Broker
Object-Oriented Relational (OOR)
COUNT
19. Practice of writing code into a webpage that is not directly visible to the user
Primary Keys
Scripting
Candidate Keys
Attributes
20. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Application Programers
Query
Forward Slash
SUM
21. Used to remove duplicates from result table
Fields
NOT
Tags
DISTINCT
22. Looks like opening tag - but with a forward slash
Opening tag
ASC
single value
Closing tag
23. Combines rows from a SELECT statements result table into a group
Equals Operator
DELETE
ESC
GROUP BY
24. Copies multiple records at the same time using a SELECT statement
Aggregate Functions
INSERT INTO
Tables
FROM
25. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Precedence of Logical Operators
Subqueries
Fields
Hypertext Markup Language (HTML)
26. Definition of commands it can do
Data Definition
DELETE
FROM
American Standard Code for Information Interchange (ASCII)
27. Columns containing numbers only
Service Requestor
Interactive SQL
SUM
Dynamic
28. Looks like opening tag - but with a forward slash
Bind
ORDER BY
Closing tag
Web Service
29. Decides what data is stored in the databse and the manner it is stored
Interactive SQL
Data Administrator (DAd)
Forward Slash
Data Recovery & Concurrance
30. Data in database has ability to be accessed and manipulated by several users
Tags
Cookie
Element Content
Shared
31. File stored on a user's machine that contains infor about application
SUM
Cookie
ORDER BY
accident
32. Large structured set of persistent data
GROUP BY
Interactive SQL
ESC
Database
33. Defines a new column
Attributes
WHERE
Calculated Column
GROUP BY
34. One of the tools that SQL uses to find and retrieve data.
Query
Indexes
End Users
single value
35. Interact and manipulates the data in the database
Integrated
Structured Query Language (SQL)
ORDER BY
Data Manipulation
36. Used to close a tag properly
DELETE
Data Manipulation
Forward Slash
Structured Query Language (SQL)
37. Data that has been processed into a format that is understandable by its audience
Web server
Central control of data
Information
Tables
38. Software system designed to support interoperable machine - to - machine interaction over a network
accident
Web Service
Database
FROM
39. Characterizes operation of a relational database
Bind
Shared
Joins
Structured Query Language (SQL)
40. Has the highest precedence - followed by the AND - OR
NOT
MIN
Bind
ALL
41. Everything in enviroment becomes an object - expands on Priniples of relational databases
Hypertext Markup Language (HTML)
Object-Oriented Relational (OOR)
COUNT
to update
42. Finds the lowest constant value in a column
Service Requestor
Inner SELECT query
Central control of data
MAX
43. Used to combine one query to another
Tags
Subqueries
Central Control of data
Stateless
44. Closed in the start tag by adding a slash to the start tag
LIKE
Database Management Systems (DBMS)
Empty Elements
COUNT
45. One huge database to hold all data; Access to data - and use of system to add - update & print records
MAX
Database Management Systems (DBMS)
Web server
ORDER BY
46. Change order of rows in result table
ORDER BY
Web Service
Equals Operator
WHERE
47. Allows use of single or multiple character wildcards with the underscore or percent symbol
Closing tag
LIKE
ORDER BY
UPDATE
48. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tables
Tags
Bind
Equals Operator
49. Specifies the tables or views from which rows and columns are retrieved
Indexes
Central Control of data
ESC
FROM
50. Data in database has ability to be accessed and manipulated by several users
Information
Database
Indexes
Shared