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. Defines a new column
Calculated Column
Functions
Indexes
to update
2. Flat File Examples: Excel Spreadsheets - _____
HAVING
Word
Structured Query Language (SQL)
MAX
3. Data in database interacts & corresponds with other data
Data Dictionary
Integrated
GROUP BY
Fields
4. Attribute in quotes
Information
Flat File
Property
hidden fields
5. Table displayed in descending order
Opening tag
INSERT INTO
FROM
ESC
6. Data that has been processed into a format that is understandable by its audience
Shared
Structured Query Language (SQL)
Information
Empty Elements
7. Cookies are more secure than______ - allowing travel on a website without loss of info
Fields
hidden fields
Data Definition
Inner SELECT query
8. Copies multiple records at the same time using a SELECT statement
INSERT INTO
LIKE
Outer SELECT query
Users
9. Text markups that form an element" sort of a "box" to hold things like text and other elements
Application Programmers
COUNT
Hypertext Markup Language (HTML)
Tags
10. Interact and manipulates the data in the database
NOT
Word
Attributes
Data Manipulation
11. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Precedence of Logical Operators
Scripting
Property
Central Control of data
12. Selects from specific values in list
IN
Views
Tags
Data Dictionary
13. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
BETWEEN
DISTINCT
ALL
Data Elements
14. Everything between the start and end tag
Element Content
Empty Elements
SUM
Primary Keys
15. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Interactive SQL
SELECT
Data Recovery & Concurrance
single value
16. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Object-Oriented Relational (OOR)
Service Broker
Primary Keys
Joins
17. Specifies the tables or views from which rows and columns are retrieved
Scripting
FROM
Web server
Inner SELECT query
18. Finds the lowest ACII value in column
Inner SELECT query
MIN
NOT
Comparison Operators
19. The Web is ___________
Dynamic
Web Browser
FROM
Stateless
20. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Inner SELECT query
Hypertext Markup Language (HTML)
*
Database Management Systems (DBMS)
21. SQL Commands - Two Things Specify data interested in - Indicate the ________
Foreign Keys
Data
accident
DELETE
22. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Central Control of data
Structured Query Language (SQL)
Closing tag
Query
23. Ongoing record of data reflecting the info defining the database
Data Dictionary
ALL
Subqueries
Service-Oriented Architecture (SOA)
24. Finds the lowest constant value in a column
Outer SELECT query
End Users
Tags
MAX
25. Limits the output of the established groups into the derived result table
End Users
*
MIN
HAVING
26. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Session
Service Broker
Functions
Data Definition
27. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Persistent
Web server
ASC
28. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Application Programers
Service-Oriented Architecture (SOA)
Word
29. Compares value of the column in the specified condition with the value specified
Service Requestor
Data
Information
Equals Operator
30. Tally of how many rows meet criteria specified
Indexes
single value
COUNT
End Users
31. SELECT statment containing the nested query
Outer SELECT query
Application Programmers
Web Service
SUM
32. Practice of writing code into a webpage that is not directly visible to the user
Precedence of Logical Operators
Web Browser
Scripting
Data Dictionary
33. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Object-Oriented Relational (OOR)
Primary Keys
Tables
34. Data remains unchanged in database
Views
Relational
Persistent
Subqueries
35. Basic Component of SQL
Shared
Tables
Data Dictionary
LIKE
36. Uses relationships between independent entities
Relational
*
Database Administrator (DBA)
*
37. Create program files that include SQ after each command
Service Broker
Users
Embedded SQL
FROM
38. One huge database to hold all data; Access to data - and use of system to add - update & print records
Tags
Subqueries
Database Management Systems (DBMS)
Central control of data
39. Used to close a tag properly
Forward Slash
Object-Oriented Relational (OOR)
Application Programmers
Scripting
40. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
UPDATE
MIN
single value
41. Tally of how many rows meet criteria specified
Property
Subqueries
Closing tag
COUNT
42. Straight implementation of raw data formatted into rows and columns
Equals Operator
Flat File
Outer SELECT query
HAVING
43. One huge database to hold all data; Access to data - and use of system to add - update & print records
Persistent
Shared
Database Management Systems (DBMS)
NOT
44. 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.
Primary Keys
Data Manipulation
SELECT
ALL
45. Uses relationships between independent entities
MAX
Relational
IN
IN
46. Grant acces and control to only specific information
Views
End Users
Comparison Operators
Property
47. Writes programs that use or allow acces to databse with specific purpose
Word
Application Programers
Opening tag
BETWEEN
48. Concatenated in SQL Server Database software using the addition symbol
FROM
Word
Closing tag
Fields
49. Used to combine one query to another
Inner SELECT query
Subqueries
ORDER BY
to update
50. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Central Control of data
Word
Service Broker