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. Some form of output - usually - printed - containing information
Word
Report
Persistent
Opening tag
2. 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)
COUNT
Flat File
Application Programmers
3. Closed in the start tag by adding a slash to the start tag
Cookie
Empty Elements
Property
INSERT INTO
4. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Session
Central Control of data
Service-Oriented Architecture (SOA)
Indexes
5. Uses two values as limits - selecting any values between the two of them
BETWEEN
MIN
Database Management Systems (DBMS)
Data Recovery & Concurrance
6. Used with another comparison operator - values become inverted
Negation Operator
Tags
Structured Query Language (SQL)
Report
7. Interact and manipulates the data in the database
LIKE
SELECT
Data Manipulation
Query
8. The Web is ___________
Joins
INSERT INTO
Shared
Stateless
9. Table displayed in ascending order
DELETE
ASC
Users
COUNT
10. Command used to show the attributes that define a table.
to update
*
ASC
sp_help
11. Individuals that use - manipulate or maintain aspects of database
Web Applications
Information
Users
*
12. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
INSERT INTO
Joins
GROUP BY
13. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Shared
Data Administrator (DAd)
SUM
14. Browser requests page - code is delivered - executed and done with
Dynamic
UPDATE
Web Applications
Empty Elements
15. Text markups that form an element" sort of a "box" to hold things like text and other elements
MAX
Tags
Opening tag
Negation Operator
16. Join a table to a copy of itself
Primary Keys
Users
single value
Self Join
17. Allow useres to retrieve data and interact with content located on web pages within website
Database Management Systems (DBMS)
Web Browser
Precedence of Logical Operators
Element Content
18. Writes programs that use or allow acces to databse with specific purpose
Application Programers
Dynamic
Primary Keys
Forward Slash
19. SQL finds and retrieves date
Indexes
*
Information
Element Content
20. All Columns indicated and selected
Service Broker
Database
*
Aliases
21. Deletes selected rows
Aggregate Functions
DELETE
ASC
Shared
22. 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.
WHERE
Information
Primary Keys
Joins
23. Used to remove duplicates from result table
AVG
WHERE
INSERT INTO
DISTINCT
24. Allow useres to retrieve data and interact with content located on web pages within website
Data Administrator (DAd)
Information
ESC
Web Browser
25. Create program files that include SQ after each command
Embedded SQL
Data Definition
to update
Data Administrator (DAd)
26. Concatenated in SQL Server Database software using the addition symbol
Application Programmers
Fields
Negation Operator
Web Service
27. Practice of writing code into a webpage that is not directly visible to the user
Data Manipulation
Scripting
DISTINCT
Information
28. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
NOT
Indexes
Web server
BETWEEN
29. Software system designed to support interface for a software asset that manages a specific set of tasks
UPDATE
Data Dictionary
Service Provider
Aliases
30. Defines a new column
Calculated Column
WHERE
Hardware
BETWEEN
31. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Users
Data
Equals Operator
32. Used to combine one query to another
IN
Calculated Column
Subqueries
Hypertext Markup Language (HTML)
33. Specifies the tables or views from which rows and columns are retrieved
Attributes
Public Key Infrastructure (PKI)
Tags
FROM
34. Some form of output - usually - printed - containing information
Data Elements
ESC
Report
Cookie
35. Describe information in a tree styled format
Database Management Systems (DBMS)
Hierarchial
Element Content
MIN
36. Allows use of single or multiple character wildcards with the underscore or percent symbol
COUNT
Application Programmers
Service-Oriented Architecture (SOA)
LIKE
37. Identifies columns to appear in the result
SELECT
Service-Oriented Architecture (SOA)
Data Administrator (DAd)
GROUP BY
38. Change order of rows in result table
Inner SELECT query
ORDER BY
sp_help
Subquery
39. Meaningful info related to database
Query
Data
ESC
Comparison Operators
40. Three Basic Operations of SP - SR - SB: Publish - Find - ____
MIN
Service Provider
Bind
Users
41. Concatenated in SQL Server Database software using the addition symbol
Web Browser
sp_help
Fields
Tags
42. Table displayed in ascending order
Interactive SQL
Hierarchial
ASC
Application Programers
43. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
MIN
Empty Elements
hidden fields
Web server
44. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Data Administrator (DAd)
Hardware
INSERT INTO
Service Requestor
45. Limits the output of the established groups into the derived result table
MAX
Application Programers
Data Manipulation
HAVING
46. Flat File Examples: Excel Spreadsheets - _____
Cookie
Word
Application Programers
Precedence of Logical Operators
47. Everything between the start and end tag
Comparison Operators
Element Content
Comparison Operators
Application Programers
48. Uses relationships between independent entities
Persistent
Flat File
Relational
Database Management Systems (DBMS)
49. Used in a SELECT clause in place of a column
Database Management Systems (DBMS)
Interactive SQL
Web server
Aggregate Functions
50. Individuals that use - manipulate or maintain aspects of database
DELETE
MIN
Users
FROM