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. One of the tools that SQL uses to find and retrieve data.
Embedded SQL
Shared
Indexes
Central Control of data
2. Averages the numeric values
ASC
Closing tag
AVG
Joins
3. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Attributes
Aliases
HAVING
to update
4. Tally of how many rows meet criteria specified
Stateless
Persistent
SUM
COUNT
5. Table displayed in ascending order
ASC
Web Service
Attributes
Performance
6. Limits the output of the established groups into the derived result table
Application Programers
NOT
Web Service
HAVING
7. Allow useres to retrieve data and interact with content located on web pages within website
Bind
Service Broker
Web Browser
Integrated
8. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Cookie
Central Control of data
Views
AVG
9. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
BETWEEN
ESC
Performance
10. Grant acces and control to only specific information
Aliases
Indexes
Views
Fields
11. Averages the numeric values
AVG
Empty Elements
Embedded SQL
Cookie
12. Finds the lowest ACII value in column
Service Requestor
Data Manipulation
Database
MIN
13. The Web is ___________
Query
Stateless
GROUP BY
to update
14. Data remains unchanged in database
Functions
Comparison Operators
IN
Persistent
15. Identifies columns to appear in the result
Indexes
Central control of data
SELECT
Data Administrator (DAd)
16. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
MAX
Session
Service Provider
SUM
17. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Web Service
Data Manipulation
Web Applications
Report
18. Cookies are more secure than______ - allowing travel on a website without loss of info
Users
Application Programers
hidden fields
ORDER BY
19. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Hierarchial
ALL
Central control of data
Aliases
20. Software system designed to support interface for a software asset that manages a specific set of tasks
DISTINCT
Web Applications
to update
Service Provider
21. Concatenated in SQL Server Database software using the addition symbol
Database
Fields
IN
single value
22. Create program files that include SQ after each command
Calculated Column
Embedded SQL
Joins
American Standard Code for Information Interchange (ASCII)
23. Data in database interacts & corresponds with other data
Integrated
IN
Indexes
SELECT
24. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
Integrated
Self Join
BETWEEN
25. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Tables
SELECT
Central Control of data
26. Ensures functions are done efficiently
ESC
Performance
Flat File
Persistent
27. Identifies columns to appear in the result
Fields
SELECT
Application Programers
WHERE
28. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Central Control of data
accident
DELETE
29. = - < - > - <= - >= - <> - !
Relational
Database Administrator (DBA)
End Users
Comparison Operators
30. = - < - > - <= - >= - <> - !
Web server
Comparison Operators
Embedded SQL
Attributes
31. Meaningful info related to database
IN
Data
Joins
Application Programers
32. 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.
Application Programers
Forward Slash
Primary Keys
Object-Oriented Relational (OOR)
33. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
ESC
Attributes
Scripting
single value
34. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
DELETE
Report
Data Administrator (DAd)
35. Changes the values in one or more selected rows of a table
UPDATE
Hierarchial
Application Programmers
ORDER BY
36. Writes programs that use or allow acces to databse with specific purpose
UPDATE
Database Administrator (DBA)
Application Programers
Outer SELECT query
37. Fields in a relational table that match the primary key from one column to the primary key of another table.
Application Programmers
Hierarchial
End Users
Foreign Keys
38. Uses relationships between independent entities
Hardware
Precedence of Logical Operators
Relational
sp_help
39. SQL Commands: Define tables - views - _____ - delete or insert info
COUNT
Persistent
HAVING
to update
40. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Hierarchial
single value
Central Control of data
Structured Query Language (SQL)
41. 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
Functions
Web server
Inner SELECT query
42. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Opening tag
End Users
Bind
43. Used to remove duplicates from result table
DISTINCT
Subqueries
Hypertext Markup Language (HTML)
Web Browser
44. Table displayed in ascending order
Users
Application Programers
ASC
Hypertext Markup Language (HTML)
45. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
BETWEEN
Application Programers
Structured Query Language (SQL)
46. Some form of output - usually - printed - containing information
Self Join
Report
Hypertext Markup Language (HTML)
Application Programers
47. Essentially a collection of services that communicate with eachother
Inner SELECT query
Indexes
accident
Service-Oriented Architecture (SOA)
48. Used to close a tag properly
Forward Slash
Report
Functions
Object-Oriented Relational (OOR)
49. Describe information in a tree styled format
Stateless
GROUP BY
Hierarchial
MAX
50. Limits the rows that appear in the result mathcing a specified condition
Functions
SUM
Data Administrator (DAd)
WHERE