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. Limits the output of the established groups into the derived result table
Data Elements
DELETE
HAVING
accident
2. Allows use of single or multiple character wildcards with the underscore or percent symbol
sp_help
LIKE
INSERT INTO
Service Provider
3. Data in database interacts & corresponds with other data
ASC
Integrated
Database Management Systems (DBMS)
Web server
4. Concatenated in SQL Server Database software using the addition symbol
Information
Fields
Subqueries
Views
5. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Indexes
Property
Web Browser
6. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Indexes
SUM
Information
Object-Oriented Relational (OOR)
7. Grant acces and control to only specific information
ALL
Aliases
Views
ASC
8. Finds the lowest ACII value in column
Bind
Property
Embedded SQL
MIN
9. Essentially a collection of services that communicate with eachother
Data Elements
Performance
Service-Oriented Architecture (SOA)
MIN
10. SELECT statment containing the nested query
Outer SELECT query
Shared
Tables
Negation Operator
11. Cookies are more secure than______ - allowing travel on a website without loss of info
Calculated Column
MAX
Service-Oriented Architecture (SOA)
hidden fields
12. SQL Commands: Define tables - views - _____ - delete or insert info
Fields
Database
Subquery
to update
13. Characterizes operation of a relational database
ORDER BY
Data Recovery & Concurrance
WHERE
Joins
14. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Tags
Web server
Database Administrator (DBA)
SELECT
15. Begins an element
Web Browser
Word
Opening tag
Service Broker
16. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
HAVING
ASC
single value
Hypertext Markup Language (HTML)
17. Specifies the tables or views from which rows and columns are retrieved
Property
Joins
FROM
Shared
18. Give the browser more specific information about that tag
ALL
Word
Object-Oriented Relational (OOR)
Attributes
19. Create program files that include SQ after each command
Application Programers
Joins
Embedded SQL
Data Definition
20. All Columns indicated and selected
hidden fields
Word
*
accident
21. Copies multiple records at the same time using a SELECT statement
Service Broker
INSERT INTO
Database Administrator (DBA)
SUM
22. Flat File Examples: Excel Spreadsheets - _____
Calculated Column
Scripting
GROUP BY
Word
23. Characterizes operation of a relational database
Functions
Calculated Column
Joins
AVG
24. Using product as intended for its audience
Database Management Systems (DBMS)
FROM
End Users
to update
25. Most valuable asset of a database system.
COUNT
Database Management Systems (DBMS)
Central control of data
COUNT
26. Allows data recovery in case of corruption or loss
Aggregate Functions
Precedence of Logical Operators
Data Recovery & Concurrance
Service-Oriented Architecture (SOA)
27. Compares value of the column in the specified condition with the value specified
Subqueries
Embedded SQL
MIN
Equals Operator
28. Columns containing numbers only
WHERE
SUM
Aliases
Flat File
29. Meaningful info related to database
Indexes
SELECT
Data
Closing tag
30. Compares value of the column in the specified condition with the value specified
FROM
Query
Equals Operator
Persistent
31. Supplies value for the search condition of the SELECT statement containing it
Scripting
Subqueries
Inner SELECT query
UPDATE
32. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
IN
Web server
Tags
33. 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
Precedence of Logical Operators
accident
Application Programmers
34. Begins an element
Information
ASC
Data Elements
Opening tag
35. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
*
American Standard Code for Information Interchange (ASCII)
ALL
36. Responsible for technical implementation & maintenance of database on a design & physical level
Report
Database Administrator (DBA)
IN
COUNT
37. Selects from specific values in list
Precedence of Logical Operators
End Users
IN
Web Service
38. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
COUNT
Service Broker
AVG
BETWEEN
39. Decides what data is stored in the databse and the manner it is stored
Views
Data
Data Administrator (DAd)
IN
40. Ensures data is correct casings
Forward Slash
IN
American Standard Code for Information Interchange (ASCII)
Property
41. Looks like opening tag - but with a forward slash
Closing tag
Central Control of data
Embedded SQL
Element Content
42. Everything between the start and end tag
Data Definition
Users
Element Content
Joins
43. Allows data recovery in case of corruption or loss
Data
Application Programers
NOT
Data Recovery & Concurrance
44. Looks like opening tag - but with a forward slash
Closing tag
INSERT INTO
Application Programers
Users
45. Writes programs that use or allow acces to databse with specific purpose
Tags
Application Programers
Outer SELECT query
Performance
46. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Fields
Hypertext Markup Language (HTML)
Data
WHERE
47. Used with another comparison operator - values become inverted
Indexes
Views
LIKE
Negation Operator
48. Data that has been processed into a format that is understandable by its audience
Hierarchial
Information
Element Content
Subqueries
49. Tally of how many rows meet criteria specified
Performance
COUNT
Data Dictionary
LIKE
50. Responsible for technical implementation & maintenance of database on a design & physical level
Web Service
Database Administrator (DBA)
*
Primary Keys