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. Some form of output - usually - printed - containing information
Report
HAVING
Query
Data Manipulation
2. Limits the rows that appear in the result mathcing a specified condition
Word
ORDER BY
WHERE
Web server
3. Begins an element
Opening tag
Report
MIN
Performance
4. Selects from specific values in list
Web Service
IN
Word
Relational
5. Ensures functions are done efficiently
Performance
IN
Hardware
Aggregate Functions
6. Begins an element
BETWEEN
UPDATE
Opening tag
Tags
7. Used to remove duplicates from result table
Property
DISTINCT
Tables
Dynamic
8. Copies multiple records at the same time using a SELECT statement
MAX
Subqueries
INSERT INTO
MIN
9. Looks like opening tag - but with a forward slash
MAX
Property
SUM
Closing tag
10. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programers
Attributes
Application Programmers
Opening tag
11. Most valuable asset of a database system.
Central control of data
Query
Stateless
ALL
12. Used to close a tag properly
Database Administrator (DBA)
Data Manipulation
Forward Slash
Object-Oriented Relational (OOR)
13. Finds the lowest constant value in a column
Forward Slash
Central Control of data
Cookie
MAX
14. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
AVG
Central Control of data
Element Content
ORDER BY
15. Browser requests page - code is delivered - executed and done with
GROUP BY
American Standard Code for Information Interchange (ASCII)
Dynamic
Data
16. Has the highest precedence - followed by the AND - OR
Empty Elements
LIKE
NOT
Central control of data
17. Allows use of single or multiple character wildcards with the underscore or percent symbol
Inner SELECT query
LIKE
Application Programmers
Web Applications
18. Table displayed in ascending order
Subqueries
Tables
Relational
ASC
19. Change order of rows in result table
ORDER BY
Application Programmers
Structured Query Language (SQL)
Database Management Systems (DBMS)
20. Change order of rows in result table
Session
Service Broker
ORDER BY
Self Join
21. Data in database interacts & corresponds with other data
UPDATE
Database
Integrated
Service Provider
22. Used in a SELECT clause in place of a column
Report
ALL
Aggregate Functions
Functions
23. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
AVG
Report
Subquery
Hypertext Markup Language (HTML)
24. Table displayed in descending order
ESC
Database
Service Provider
Shared
25. Table displayed in descending order
Integrated
*
GROUP BY
ESC
26. Characterizes operation of a relational database
Application Programmers
Self Join
Joins
WHERE
27. SQL Commands - Two Things Specify data interested in - Indicate the ________
Equals Operator
ASC
SELECT
accident
28. File stored on a user's machine that contains infor about application
GROUP BY
hidden fields
Cookie
ASC
29. Decides what data is stored in the databse and the manner it is stored
Flat File
Persistent
Data Administrator (DAd)
LIKE
30. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Calculated Column
Users
Object-Oriented Relational (OOR)
Service Broker
31. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Candidate Keys
Application Programmers
Web Service
Functions
32. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Structured Query Language (SQL)
Data Administrator (DAd)
BETWEEN
MAX
33. Network node that discovers and invokes other software services to provide a buisness solution
*
Service Requestor
Subqueries
SELECT
34. Interact and manipulates the data in the database
Embedded SQL
Data Manipulation
Relational
Users
35. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Structured Query Language (SQL)
MAX
ASC
Inner SELECT query
36. Averages the numeric values
WHERE
Database
Self Join
AVG
37. Closed in the start tag by adding a slash to the start tag
Empty Elements
Application Programers
Equals Operator
Web server
38. Practice of writing code into a webpage that is not directly visible to the user
Self Join
Service Broker
Scripting
Persistent
39. Describe information in a tree styled format
Integrated
Hierarchial
Query
MIN
40. All Columns indicated and selected
COUNT
*
AVG
DELETE
41. Data stored by DAd
Data Elements
Opening tag
GROUP BY
to update
42. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities
Public Key Infrastructure (PKI)
Cookie
GROUP BY
Candidate Keys
43. Uses two values as limits - selecting any values between the two of them
GROUP BY
Database Management Systems (DBMS)
Hypertext Markup Language (HTML)
BETWEEN
44. Data remains unchanged in database
FROM
Interactive SQL
LIKE
Persistent
45. Definition of commands it can do
BETWEEN
Query
Data Definition
Precedence of Logical Operators
46. Attribute in quotes
ESC
Data Definition
Property
Query
47. Specifies the tables or views from which rows and columns are retrieved
Opening tag
Database Administrator (DBA)
FROM
Functions
48. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Joins
MAX
ALL
Application Programmers
49. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Functions
INSERT INTO
MAX
Hypertext Markup Language (HTML)
50. Responsible for technical implementation & maintenance of database on a design & physical level
Performance
Fields
Database Administrator (DBA)
Users