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. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
ALL
Dynamic
Functions
Data Definition
2. Allow useres to retrieve data and interact with content located on web pages within website
Data Recovery & Concurrance
Word
Web Browser
to update
3. One huge database to hold all data; Access to data - and use of system to add - update & print records
Joins
Database Management Systems (DBMS)
Service-Oriented Architecture (SOA)
AVG
4. Give the browser more specific information about that tag
Property
GROUP BY
Attributes
accident
5. Data in database interacts & corresponds with other data
Integrated
DISTINCT
Dynamic
Tags
6. Finds the lowest ACII value in column
Bind
MIN
Data Definition
Precedence of Logical Operators
7. Allows data recovery in case of corruption or loss
Aggregate Functions
SELECT
Data Recovery & Concurrance
Opening tag
8. Copies multiple records at the same time using a SELECT statement
ALL
INSERT INTO
MIN
WHERE
9. Executes commands one at a time - results being displayed immediately
Database Administrator (DBA)
UPDATE
Performance
Interactive SQL
10. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hypertext Markup Language (HTML)
Hardware
Outer SELECT query
IN
11. Grant acces and control to only specific information
Views
WHERE
ALL
Data Manipulation
12. Concatenated in SQL Server Database software using the addition symbol
GROUP BY
Fields
Database
MIN
13. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Aliases
Structured Query Language (SQL)
Empty Elements
FROM
14. Ensures functions are done efficiently
Indexes
Embedded SQL
ESC
Performance
15. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Closing tag
Service Broker
Data Administrator (DAd)
Functions
16. Identifies columns to appear in the result
Joins
Functions
BETWEEN
SELECT
17. Characterizes operation of a relational database
Joins
American Standard Code for Information Interchange (ASCII)
INSERT INTO
Shared
18. SQL finds and retrieves date
Negation Operator
Indexes
DISTINCT
Central Control of data
19. Columns containing numbers only
Functions
Self Join
SUM
SELECT
20. Deletes selected rows
Relational
American Standard Code for Information Interchange (ASCII)
Performance
DELETE
21. Used in a SELECT clause in place of a column
Joins
Service Requestor
Fields
Aggregate Functions
22. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities
Public Key Infrastructure (PKI)
Aliases
single value
Indexes
23. All Columns indicated and selected
Embedded SQL
Data Definition
IN
*
24. Used to combine one query with another.
accident
Subquery
Service Requestor
ASC
25. Averages the numeric values
Web Browser
AVG
Joins
Service Broker
26. Compares value of the column in the specified condition with the value specified
Equals Operator
MAX
Aliases
Information
27. Table displayed in descending order
Hierarchial
Information
Attributes
ESC
28. Software system designed to support interface for a software asset that manages a specific set of tasks
FROM
Web Applications
Web Service
Service Provider
29. Ongoing record of data reflecting the info defining the database
Central Control of data
Web server
Service Requestor
Data Dictionary
30. Data that has been processed into a format that is understandable by its audience
Information
Outer SELECT query
single value
Equals Operator
31. SQL Commands: Define tables - views - _____ - delete or insert info
Negation Operator
to update
End Users
Report
32. Begins an element
MIN
Shared
Indexes
Opening tag
33. Used to combine one query to another
MIN
Subqueries
Central control of data
Report
34. Used to remove duplicates from result table
Report
Database Management Systems (DBMS)
Application Programers
DISTINCT
35. Data in database has ability to be accessed and manipulated by several users
to update
Shared
ALL
Report
36. Network node that discovers and invokes other software services to provide a buisness solution
NOT
Word
IN
Service Requestor
37. Join a table to a copy of itself
MAX
Persistent
Self Join
Data Dictionary
38. Defines a new column
SUM
Calculated Column
Subqueries
Candidate Keys
39. Flat File Examples: Excel Spreadsheets - _____
ASC
Cookie
Word
Data Administrator (DAd)
40. Specifies the tables or views from which rows and columns are retrieved
Attributes
ASC
Attributes
FROM
41. Writes programs that use or allow acces to databse with specific purpose
Application Programers
Aggregate Functions
Web Service
Data Administrator (DAd)
42. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Session
Equals Operator
Aliases
single value
43. Cookies are more secure than______ - allowing travel on a website without loss of info
single value
hidden fields
American Standard Code for Information Interchange (ASCII)
*
44. Data that has been processed into a format that is understandable by its audience
Information
Bind
Outer SELECT query
Hypertext Markup Language (HTML)
45. Software system designed to support interoperable machine - to - machine interaction over a network
Central control of data
Web Service
AVG
Views
46. Decides what data is stored in the databse and the manner it is stored
Application Programers
Data Administrator (DAd)
Database
single value
47. Give the browser more specific information about that tag
Information
Structured Query Language (SQL)
Attributes
Service Provider
48. Averages the numeric values
Public Key Infrastructure (PKI)
Fields
AVG
Joins
49. Order in which WHERE clause is evaluated and combined
COUNT
Precedence of Logical Operators
Relational
single value
50. = - < - > - <= - >= - <> - !
Fields
Persistent
Joins
Comparison Operators