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. Concatenated in SQL Server Database software using the addition symbol
Web Service
Fields
Dynamic
Hierarchial
2. Allows use of single or multiple character wildcards with the underscore or percent symbol
Comparison Operators
ALL
Views
LIKE
3. Ensures data is correct casings
Attributes
Data Manipulation
American Standard Code for Information Interchange (ASCII)
UPDATE
4. SQL Commands - Two Things Specify data interested in - Indicate the ________
Fields
Views
accident
Functions
5. Command used to show the attributes that define a table.
Users
Web Service
IN
sp_help
6. Uses two values as limits - selecting any values between the two of them
ALL
Primary Keys
HAVING
BETWEEN
7. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Web Browser
Opening tag
Tables
SUM
8. Interact and manipulates the data in the database
Data Manipulation
Joins
Outer SELECT query
INSERT INTO
9. Software system designed to support interface for a software asset that manages a specific set of tasks
Property
Closing tag
Service Provider
Data Dictionary
10. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Application Programmers
Web Applications
Aliases
MAX
11. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Stateless
single value
Joins
Aggregate Functions
12. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
SUM
Service Requestor
Element Content
13. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Service Requestor
sp_help
DELETE
Application Programmers
14. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
Application Programers
Precedence of Logical Operators
Subqueries
15. Limits the output of the established groups into the derived result table
GROUP BY
HAVING
Database Management Systems (DBMS)
LIKE
16. Meaningful info related to database
Candidate Keys
single value
BETWEEN
Data
17. Looks like opening tag - but with a forward slash
to update
Closing tag
LIKE
ORDER BY
18. Used with another comparison operator - values become inverted
Database Management Systems (DBMS)
Candidate Keys
Negation Operator
Data Dictionary
19. Allow useres to retrieve data and interact with content located on web pages within website
SUM
Public Key Infrastructure (PKI)
Query
Web Browser
20. Responsible for technical implementation & maintenance of database on a design & physical level
Integrated
American Standard Code for Information Interchange (ASCII)
WHERE
Database Administrator (DBA)
21. Data that has been processed into a format that is understandable by its audience
Information
Outer SELECT query
Negation Operator
Precedence of Logical Operators
22. Three Basic Operations of SP - SR - SB: Publish - Find - ____
WHERE
Outer SELECT query
SUM
Bind
23. All Columns indicated and selected
*
single value
Information
Structured Query Language (SQL)
24. Grant acces and control to only specific information
Database
Views
Database Administrator (DBA)
Property
25. Uses relationships between independent entities
Relational
Subquery
Users
Self Join
26. Everything in enviroment becomes an object - expands on Priniples of relational databases
Report
Hierarchial
Object-Oriented Relational (OOR)
Data
27. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
SUM
hidden fields
Empty Elements
Hardware
28. Copies multiple records at the same time using a SELECT statement
INSERT INTO
GROUP BY
Aggregate Functions
SUM
29. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Element Content
NOT
Data Administrator (DAd)
30. Finds the lowest constant value in a column
End Users
Indexes
SUM
MAX
31. Combines rows from a SELECT statements result table into a group
to update
GROUP BY
Report
Structured Query Language (SQL)
32. Data in database has ability to be accessed and manipulated by several users
Query
Integrated
Hardware
Shared
33. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Database Administrator (DBA)
INSERT INTO
Application Programmers
Self Join
34. 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.
Object-Oriented Relational (OOR)
Primary Keys
GROUP BY
Tags
35. SELECT statment containing the nested query
DELETE
Central Control of data
Outer SELECT query
ALL
36. Data in database interacts & corresponds with other data
Stateless
Hierarchial
Integrated
Database
37. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Indexes
Functions
Users
Comparison Operators
38. Most valuable asset of a database system.
Central control of data
LIKE
SUM
Tables
39. Attribute in quotes
Closing tag
Property
Application Programers
Aggregate Functions
40. Used in a SELECT clause in place of a column
ASC
single value
Hypertext Markup Language (HTML)
Aggregate Functions
41. Using product as intended for its audience
accident
End Users
Data Definition
Session
42. Some form of output - usually - printed - containing information
American Standard Code for Information Interchange (ASCII)
NOT
Report
Data
43. Looks like opening tag - but with a forward slash
Hardware
Closing tag
accident
Database
44. Basic Component of SQL
Web server
Indexes
Tables
DELETE
45. Cookies are more secure than______ - allowing travel on a website without loss of info
Central Control of data
Attributes
Data
hidden fields
46. Everything in enviroment becomes an object - expands on Priniples of relational databases
Fields
Inner SELECT query
Hierarchial
Object-Oriented Relational (OOR)
47. File stored on a user's machine that contains infor about application
Object-Oriented Relational (OOR)
Cookie
Users
MAX
48. Specifies the tables or views from which rows and columns are retrieved
FROM
*
Calculated Column
LIKE
49. Software system designed to support interoperable machine - to - machine interaction over a network
INSERT INTO
Service-Oriented Architecture (SOA)
Attributes
Web Service
50. Individuals that use - manipulate or maintain aspects of database
Users
Element Content
Calculated Column
to update