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. Everything in enviroment becomes an object - expands on Priniples of relational databases
BETWEEN
Object-Oriented Relational (OOR)
Central Control of data
MIN
2. Used to remove duplicates from result table
Service Requestor
DISTINCT
Outer SELECT query
Cookie
3. Cookies are more secure than______ - allowing travel on a website without loss of info
Empty Elements
hidden fields
*
Aliases
4. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Service Requestor
Application Programers
Web Applications
MIN
5. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
End Users
Application Programmers
Service Provider
Functions
6. Ensures functions are done efficiently
Web Browser
Performance
Service Requestor
Self Join
7. Flat File Examples: Excel Spreadsheets - _____
Embedded SQL
Word
FROM
Web Browser
8. Identifies columns to appear in the result
Bind
Functions
Comparison Operators
SELECT
9. Used to remove duplicates from result table
Subqueries
Dynamic
DISTINCT
Hierarchial
10. Interact and manipulates the data in the database
Word
Data Manipulation
Opening tag
INSERT INTO
11. Limits the rows that appear in the result mathcing a specified condition
Stateless
Flat File
WHERE
Relational
12. Averages the numeric values
AVG
Data Manipulation
Application Programmers
Performance
13. Data remains unchanged in database
Inner SELECT query
Application Programmers
Persistent
Tags
14. Large structured set of persistent data
ASC
Object-Oriented Relational (OOR)
to update
Database
15. SELECT statment containing the nested query
Web server
MIN
Flat File
Outer SELECT query
16. Practice of writing code into a webpage that is not directly visible to the user
DELETE
Scripting
Dynamic
LIKE
17. Order in which WHERE clause is evaluated and combined
Application Programmers
Comparison Operators
Precedence of Logical Operators
WHERE
18. Tally of how many rows meet criteria specified
Fields
ORDER BY
Service Requestor
COUNT
19. Begins an element
FROM
ALL
Fields
Opening tag
20. Limits the output of the established groups into the derived result table
HAVING
Central control of data
Property
LIKE
21. Executes commands one at a time - results being displayed immediately
Interactive SQL
Shared
Hypertext Markup Language (HTML)
IN
22. Changes the values in one or more selected rows of a table
Self Join
FROM
UPDATE
Object-Oriented Relational (OOR)
23. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
ALL
Structured Query Language (SQL)
Hardware
24. Used with another comparison operator - values become inverted
Web Applications
Subqueries
Negation Operator
Bind
25. Flat File Examples: Excel Spreadsheets - _____
Word
Flat File
Performance
DELETE
26. Table displayed in descending order
ESC
DELETE
Interactive SQL
Views
27. Data that has been processed into a format that is understandable by its audience
ASC
NOT
Information
Database
28. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Application Programmers
Fields
Word
29. Text markups that form an element" sort of a "box" to hold things like text and other elements
Service Provider
to update
Property
Tags
30. Changes the values in one or more selected rows of a table
Web server
Persistent
UPDATE
DISTINCT
31. Create program files that include SQ after each command
Application Programers
Empty Elements
Service-Oriented Architecture (SOA)
Embedded SQL
32. Uses relationships between independent entities
Tables
Tables
Persistent
Relational
33. Interact and manipulates the data in the database
Web server
Data Manipulation
American Standard Code for Information Interchange (ASCII)
Closing tag
34. Data remains unchanged in database
Persistent
Property
Attributes
LIKE
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)
Database Administrator (DBA)
Users
Dynamic
36. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
to update
Functions
Hierarchial
Database Management Systems (DBMS)
37. Concatenated in SQL Server Database software using the addition symbol
Aggregate Functions
Tags
Fields
Inner SELECT query
38. Command based way to ask the database a question
Cookie
Embedded SQL
Web server
Query
39. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Dynamic
BETWEEN
ALL
Structured Query Language (SQL)
40. Attribute in quotes
AVG
Property
Dynamic
Service Requestor
41. Ongoing record of data reflecting the info defining the database
Outer SELECT query
Inner SELECT query
Data Dictionary
Database Management Systems (DBMS)
42. Command based way to ask the database a question
Indexes
Functions
Query
Service-Oriented Architecture (SOA)
43. Some form of output - usually - printed - containing information
Database Administrator (DBA)
Report
single value
DISTINCT
44. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
hidden fields
Equals Operator
Shared
Hardware
45. Writes programs that use or allow acces to databse with specific purpose
American Standard Code for Information Interchange (ASCII)
Application Programers
Data Recovery & Concurrance
Tags
46. Used in a SELECT clause in place of a column
Aggregate Functions
COUNT
Service-Oriented Architecture (SOA)
Hypertext Markup Language (HTML)
47. Data in database interacts & corresponds with other data
Relational
Integrated
Equals Operator
COUNT
48. Supplies value for the search condition of the SELECT statement containing it
WHERE
Element Content
single value
Inner SELECT query
49. Compares value of the column in the specified condition with the value specified
Equals Operator
Service Provider
NOT
Session
50. Used to combine one query to another
Subqueries
Persistent
Cookie
Foreign Keys