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. Columns containing numbers only
Session
SUM
Interactive SQL
Tags
2. Ongoing record of data reflecting the info defining the database
Data Dictionary
Subquery
Shared
Structured Query Language (SQL)
3. Join a table to a copy of itself
Data Elements
WHERE
Self Join
accident
4. Straight implementation of raw data formatted into rows and columns
Information
End Users
MIN
Flat File
5. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Data Definition
single value
GROUP BY
Data Elements
6. Software system designed to support interoperable machine - to - machine interaction over a network
Data Elements
Database Management Systems (DBMS)
to update
Web Service
7. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Broker
Service Provider
Negation Operator
Aliases
8. Deletes selected rows
SUM
Service Provider
UPDATE
DELETE
9. Data that has been processed into a format that is understandable by its audience
FROM
Web Service
Central Control of data
Information
10. SELECT statment containing the nested query
Outer SELECT query
Word
Hypertext Markup Language (HTML)
NOT
11. Allows data recovery in case of corruption or loss
Performance
SUM
Data Recovery & Concurrance
Indexes
12. Selects from specific values in list
IN
Attributes
Precedence of Logical Operators
*
13. Command based way to ask the database a question
INSERT INTO
Word
Subquery
Query
14. Practice of writing code into a webpage that is not directly visible to the user
Scripting
Comparison Operators
BETWEEN
Calculated Column
15. Used to close a tag properly
Application Programmers
hidden fields
Database Administrator (DBA)
Forward Slash
16. Text markups that form an element" sort of a "box" to hold things like text and other elements
Database Administrator (DBA)
DELETE
HAVING
Tags
17. Tally of how many rows meet criteria specified
Indexes
LIKE
COUNT
Self Join
18. Cookies are more secure than______ - allowing travel on a website without loss of info
Aliases
hidden fields
Application Programers
Word
19. Limits the rows that appear in the result mathcing a specified condition
Service Provider
Closing tag
WHERE
Web Applications
20. Change order of rows in result table
ORDER BY
ALL
Interactive SQL
Data Manipulation
21. Responsible for technical implementation & maintenance of database on a design & physical level
Performance
Empty Elements
Database Administrator (DBA)
NOT
22. = - < - > - <= - >= - <> - !
Web server
Comparison Operators
FROM
SUM
23. Used in a SELECT clause in place of a column
Subqueries
Views
Indexes
Aggregate Functions
24. Data in database has ability to be accessed and manipulated by several users
Shared
Relational
Tags
ESC
25. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Negation Operator
Element Content
Aliases
Web server
26. Used in a SELECT clause in place of a column
Aggregate Functions
Service Provider
Service Requestor
Information
27. Averages the numeric values
Flat File
Relational
Functions
AVG
28. Practice of writing code into a webpage that is not directly visible to the user
Scripting
IN
accident
Application Programers
29. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Web server
MAX
Data Definition
Hardware
30. Cookies are more secure than______ - allowing travel on a website without loss of info
Data Recovery & Concurrance
hidden fields
Performance
Service-Oriented Architecture (SOA)
31. Data in database interacts & corresponds with other data
Integrated
Shared
Hypertext Markup Language (HTML)
Hypertext Markup Language (HTML)
32. Change order of rows in result table
Database
Interactive SQL
ORDER BY
Subqueries
33. Decides what data is stored in the databse and the manner it is stored
sp_help
IN
Service Requestor
Data Administrator (DAd)
34. 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
ASC
Equals Operator
Property
35. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Central control of data
COUNT
Subqueries
36. Using product as intended for its audience
BETWEEN
Attributes
Joins
End Users
37. Data stored by DAd
Report
Service Provider
Integrated
Data Elements
38. Data remains unchanged in database
Subquery
Shared
Persistent
Interactive SQL
39. File stored on a user's machine that contains infor about application
Cookie
Primary Keys
hidden fields
HAVING
40. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
End Users
Aliases
Indexes
COUNT
41. Everything between the start and end tag
Element Content
Data Elements
Web server
Database Administrator (DBA)
42. Finds the lowest constant value in a column
Web Service
MAX
Precedence of Logical Operators
Tags
43. = - < - > - <= - >= - <> - !
Hierarchial
ASC
Embedded SQL
Comparison Operators
44. Large structured set of persistent data
Negation Operator
Forward Slash
Database
Cookie
45. Identifies columns to appear in the result
Public Key Infrastructure (PKI)
Subqueries
SELECT
WHERE
46. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Scripting
Web Applications
End Users
Calculated Column
47. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
SELECT
Structured Query Language (SQL)
Database
INSERT INTO
48. Used with another comparison operator - values become inverted
Outer SELECT query
Negation Operator
to update
Fields
49. Attribute in quotes
Property
Dynamic
Precedence of Logical Operators
Aliases
50. Everything in enviroment becomes an object - expands on Priniples of relational databases
Information
Object-Oriented Relational (OOR)
Attributes
Outer SELECT query