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. Data that has been processed into a format that is understandable by its audience
ESC
Web Browser
Data Elements
Information
2. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Data Administrator (DAd)
Shared
ORDER BY
3. Defines a new column
Foreign Keys
HAVING
Element Content
Calculated Column
4. Identifies columns to appear in the result
SELECT
Embedded SQL
Service Provider
Word
5. File stored on a user's machine that contains infor about application
SUM
HAVING
Cookie
Performance
6. Compares value of the column in the specified condition with the value specified
Scripting
Equals Operator
Data Definition
sp_help
7. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Subqueries
Functions
Embedded SQL
Bind
8. Data in database has ability to be accessed and manipulated by several users
Shared
NOT
ORDER BY
End Users
9. Columns containing numbers only
ASC
Calculated Column
SUM
Self Join
10. Using product as intended for its audience
Inner SELECT query
End Users
Data Elements
Users
11. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Attributes
Data Dictionary
ALL
Web Applications
12. Looks like opening tag - but with a forward slash
Closing tag
Flat File
Information
to update
13. SELECT statment containing the nested query
Database
Dynamic
Outer SELECT query
Hypertext Markup Language (HTML)
14. Limits the rows that appear in the result mathcing a specified condition
WHERE
Web Applications
Shared
Information
15. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Flat File
Users
Performance
16. Decides what data is stored in the databse and the manner it is stored
Property
Data Administrator (DAd)
Service Provider
Indexes
17. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Comparison Operators
Application Programers
Database Management Systems (DBMS)
18. Columns containing numbers only
Query
Equals Operator
Application Programmers
SUM
19. Uses two values as limits - selecting any values between the two of them
DELETE
Cookie
Subquery
BETWEEN
20. Selects from specific values in list
SELECT
MIN
IN
Subquery
21. Browser requests page - code is delivered - executed and done with
Dynamic
Indexes
Information
ESC
22. SQL Commands - Two Things Specify data interested in - Indicate the ________
Central Control of data
accident
Closing tag
Information
23. Tally of how many rows meet criteria specified
IN
COUNT
Comparison Operators
MAX
24. Most valuable asset of a database system.
Application Programers
Central control of data
ASC
Functions
25. Describe information in a tree styled format
Empty Elements
Service Requestor
ESC
Hierarchial
26. Limits the output of the established groups into the derived result table
Joins
Database Administrator (DBA)
HAVING
to update
27. Grant acces and control to only specific information
Negation Operator
Scripting
sp_help
Views
28. Create program files that include SQ after each command
Embedded SQL
Data Manipulation
Tags
to update
29. = - < - > - <= - >= - <> - !
Comparison Operators
HAVING
Information
LIKE
30. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
FROM
Flat File
ALL
MIN
31. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Data Manipulation
Aliases
AVG
Functions
32. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
WHERE
AVG
Indexes
Hypertext Markup Language (HTML)
33. Finds the lowest constant value in a column
Data
MAX
Element Content
Report
34. Used to combine one query to another
Outer SELECT query
SUM
Service Broker
Subqueries
35. Grant acces and control to only specific information
Views
ESC
Data Administrator (DAd)
Public Key Infrastructure (PKI)
36. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
HAVING
WHERE
ALL
Data Dictionary
37. Create program files that include SQ after each command
INSERT INTO
Aggregate Functions
Embedded SQL
Session
38. 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
Closing tag
Application Programmers
Public Key Infrastructure (PKI)
Scripting
39. Deletes selected rows
DELETE
AVG
Data
Database
40. 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
Public Key Infrastructure (PKI)
Report
Session
Web Service
41. All Columns indicated and selected
Subqueries
DISTINCT
*
Negation Operator
42. Software system designed to support interface for a software asset that manages a specific set of tasks
Object-Oriented Relational (OOR)
ORDER BY
Service Provider
Web server
43. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Web Service
Foreign Keys
Application Programmers
single value
44. Used in a SELECT clause in place of a column
Aggregate Functions
Central Control of data
Joins
Application Programers
45. Specifies the tables or views from which rows and columns are retrieved
FROM
single value
Opening tag
Users
46. Uses relationships between independent entities
Relational
Closing tag
Application Programmers
SELECT
47. Limits the output of the established groups into the derived result table
HAVING
Integrated
WHERE
Data Definition
48. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Data Manipulation
Application Programmers
DELETE
Functions
49. All Columns indicated and selected
*
Embedded SQL
MIN
Data Elements
50. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Service-Oriented Architecture (SOA)
Application Programers
SELECT