SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
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. Allows use of single or multiple character wildcards with the underscore or percent symbol
NOT
IN
DELETE
LIKE
2. Data stored by DAd
Data Elements
Inner SELECT query
single value
Attributes
3. Create program files that include SQ after each command
Embedded SQL
Database Management Systems (DBMS)
Views
Outer SELECT query
4. Writes programs that use or allow acces to databse with specific purpose
GROUP BY
Scripting
UPDATE
Application Programers
5. Everything between the start and end tag
Element Content
Embedded SQL
Data Recovery & Concurrance
UPDATE
6. Data in database has ability to be accessed and manipulated by several users
SUM
NOT
Shared
Subqueries
7. Uses two values as limits - selecting any values between the two of them
HAVING
*
Hierarchial
BETWEEN
8. One huge database to hold all data; Access to data - and use of system to add - update & print records
Property
Database Management Systems (DBMS)
LIKE
Service Broker
9. Used in a SELECT clause in place of a column
HAVING
Aggregate Functions
Opening tag
Database Management Systems (DBMS)
10. 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
UPDATE
Element Content
Tags
Session
11. Table displayed in ascending order
BETWEEN
ASC
Embedded SQL
Object-Oriented Relational (OOR)
12. Command based way to ask the database a question
Query
Data Dictionary
WHERE
Database Administrator (DBA)
13. Ensures functions are done efficiently
Relational
Performance
Application Programers
Bind
14. Some form of output - usually - printed - containing information
WHERE
SUM
Report
Outer SELECT query
15. SQL Commands - Two Things Specify data interested in - Indicate the ________
accident
Web Browser
Central control of data
ALL
16. 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)
to update
Tables
Opening tag
17. Limits the output of the established groups into the derived result table
ASC
Application Programmers
HAVING
Scripting
18. One of the tools that SQL uses to find and retrieve data.
HAVING
Bind
MIN
Indexes
19. Combines rows from a SELECT statements result table into a group
GROUP BY
Central control of data
ORDER BY
accident
20. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Fields
Web Applications
Structured Query Language (SQL)
Views
21. Data in database interacts & corresponds with other data
ESC
hidden fields
Integrated
accident
22. Identifies columns to appear in the result
SELECT
IN
Equals Operator
Inner SELECT query
23. Averages the numeric values
AVG
FROM
Closing tag
Hypertext Markup Language (HTML)
24. Essentially a collection of services that communicate with eachother
Relational
Interactive SQL
Object-Oriented Relational (OOR)
Service-Oriented Architecture (SOA)
25. Three Basic Operations of SP - SR - SB: Publish - Find - ____
LIKE
Application Programers
Bind
Database
26. Individuals that use - manipulate or maintain aspects of database
Data Elements
Users
Negation Operator
Persistent
27. Identifies columns to appear in the result
Negation Operator
Empty Elements
FROM
SELECT
28. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
sp_help
Interactive SQL
Interactive SQL
29. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Functions
SUM
Hierarchial
Service Broker
30. Grant acces and control to only specific information
Relational
Cookie
Views
HAVING
31. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
ESC
Foreign Keys
Structured Query Language (SQL)
32. Most valuable asset of a database system.
Data Recovery & Concurrance
Outer SELECT query
Central control of data
Data Definition
33. Used in a SELECT clause in place of a column
Tables
INSERT INTO
Aggregate Functions
Data Recovery & Concurrance
34. Basic Component of SQL
Structured Query Language (SQL)
SELECT
Tables
Property
35. Begins an element
GROUP BY
Flat File
Structured Query Language (SQL)
Opening tag
36. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Joins
GROUP BY
Indexes
Hypertext Markup Language (HTML)
37. Supplies value for the search condition of the SELECT statement containing it
Shared
Inner SELECT query
ESC
Object-Oriented Relational (OOR)
38. Individuals that use - manipulate or maintain aspects of database
Users
Relational
Property
MAX
39. Ensures functions are done efficiently
to update
Performance
Subqueries
Attributes
40. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
COUNT
Bind
single value
Service Provider
41. Straight implementation of raw data formatted into rows and columns
End Users
Data
Flat File
Object-Oriented Relational (OOR)
42. Some form of output - usually - printed - containing information
Report
SUM
GROUP BY
UPDATE
43. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.
SUM
Candidate Keys
Shared
Embedded SQL
44. SQL finds and retrieves date
Application Programers
Indexes
Fields
Object-Oriented Relational (OOR)
45. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
SUM
Scripting
Comparison Operators
46. Browser requests page - code is delivered - executed and done with
Dynamic
Views
Database Administrator (DBA)
Tables
47. Deletes selected rows
Inner SELECT query
DELETE
Structured Query Language (SQL)
Users
48. Software system designed to support interface for a software asset that manages a specific set of tasks
Data Elements
COUNT
Service Provider
Central Control of data
49. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Database
*
Bind
Hierarchial
50. Has the highest precedence - followed by the AND - OR
Opening tag
Indexes
Web server
NOT