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. Selects from specific values in list
MAX
Fields
SUM
IN
2. Cookies are more secure than______ - allowing travel on a website without loss of info
to update
ALL
Dynamic
hidden fields
3. Compares value of the column in the specified condition with the value specified
Application Programers
End Users
INSERT INTO
Equals Operator
4. Essentially a collection of services that communicate with eachother
Central Control of data
Service-Oriented Architecture (SOA)
Negation Operator
AVG
5. Used in a SELECT clause in place of a column
Joins
Aggregate Functions
MAX
sp_help
6. Some form of output - usually - printed - containing information
Opening tag
Report
hidden fields
Functions
7. Grant acces and control to only specific information
Database Management Systems (DBMS)
Data Administrator (DAd)
Outer SELECT query
Views
8. Interact and manipulates the data in the database
Data Manipulation
Closing tag
NOT
Tags
9. Interact and manipulates the data in the database
Tags
Data Manipulation
Web server
Relational
10. Defines a new column
Application Programmers
Calculated Column
Query
BETWEEN
11. Data in database interacts & corresponds with other data
DISTINCT
Service Broker
ALL
Integrated
12. Browser requests page - code is delivered - executed and done with
Outer SELECT query
Dynamic
Object-Oriented Relational (OOR)
Negation Operator
13. Specifies the tables or views from which rows and columns are retrieved
NOT
FROM
accident
Performance
14. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Closing tag
Structured Query Language (SQL)
Database Management Systems (DBMS)
hidden fields
15. Uses two values as limits - selecting any values between the two of them
Integrated
SUM
BETWEEN
Self Join
16. Specifies the tables or views from which rows and columns are retrieved
SELECT
FROM
Web Browser
Application Programers
17. Software system designed to support interoperable machine - to - machine interaction over a network
Service Requestor
Web Service
Database Management Systems (DBMS)
Hierarchial
18. Fields in a relational table that match the primary key from one column to the primary key of another table.
AVG
Indexes
Subquery
Foreign Keys
19. Supplies value for the search condition of the SELECT statement containing it
BETWEEN
Inner SELECT query
BETWEEN
Data
20. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Subqueries
Data Administrator (DAd)
Object-Oriented Relational (OOR)
21. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
accident
ALL
ESC
Functions
22. Create program files that include SQ after each command
Report
Closing tag
Embedded SQL
AVG
23. Used to close a tag properly
Forward Slash
Data Manipulation
Primary Keys
Indexes
24. Command based way to ask the database a question
Data Elements
Query
Embedded SQL
Attributes
25. All Columns indicated and selected
Structured Query Language (SQL)
Data Recovery & Concurrance
*
sp_help
26. Describe information in a tree styled format
Aliases
UPDATE
Hierarchial
Data Elements
27. Begins an element
Joins
Aliases
Opening tag
Web server
28. Decides what data is stored in the databse and the manner it is stored
NOT
GROUP BY
Data Administrator (DAd)
Views
29. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
Report
Attributes
Web Service
30. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Joins
Scripting
Hypertext Markup Language (HTML)
31. Meaningful info related to database
Empty Elements
Data
WHERE
Hardware
32. Straight implementation of raw data formatted into rows and columns
Views
American Standard Code for Information Interchange (ASCII)
Flat File
Service Broker
33. Limits the rows that appear in the result mathcing a specified condition
WHERE
Data Definition
Word
Negation Operator
34. Characterizes operation of a relational database
Joins
Cookie
Database Management Systems (DBMS)
Application Programmers
35. Ensures functions are done efficiently
Data Definition
Property
Comparison Operators
Performance
36. Data in database interacts & corresponds with other data
Data Recovery & Concurrance
Indexes
Integrated
Aliases
37. Table displayed in descending order
Property
SUM
Aliases
ESC
38. Ongoing record of data reflecting the info defining the database
Data Dictionary
Tables
Foreign Keys
Forward Slash
39. 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
Interactive SQL
COUNT
Structured Query Language (SQL)
40. Network node that discovers and invokes other software services to provide a buisness solution
Database Management Systems (DBMS)
Service Requestor
Integrated
DELETE
41. Changes the values in one or more selected rows of a table
Word
Attributes
UPDATE
single value
42. Ongoing record of data reflecting the info defining the database
Persistent
Calculated Column
Precedence of Logical Operators
Data Dictionary
43. Allow useres to retrieve data and interact with content located on web pages within website
Users
Web Browser
Data Definition
Data Administrator (DAd)
44. Compares value of the column in the specified condition with the value specified
American Standard Code for Information Interchange (ASCII)
Shared
SUM
Equals Operator
45. All Columns indicated and selected
GROUP BY
Cookie
Views
*
46. Command based way to ask the database a question
DELETE
Data Dictionary
Query
Opening tag
47. Text markups that form an element" sort of a "box" to hold things like text and other elements
SELECT
Tags
Fields
Session
48. 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.
Bind
Opening tag
Tags
Primary Keys
49. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
ORDER BY
ASC
ESC
50. SQL Commands - Two Things Specify data interested in - Indicate the ________
NOT
American Standard Code for Information Interchange (ASCII)
accident
LIKE