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. SELECT statment containing the nested query
Subqueries
Outer SELECT query
Functions
Flat File
2. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Web Service
Hardware
Scripting
Users
3. Browser requests page - code is delivered - executed and done with
Attributes
Dynamic
American Standard Code for Information Interchange (ASCII)
IN
4. Data remains unchanged in database
Data Elements
Persistent
Equals Operator
Foreign Keys
5. Used to combine one query with another.
Subquery
*
BETWEEN
Indexes
6. 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
Data
Session
Functions
Data Dictionary
7. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Object-Oriented Relational (OOR)
Service Requestor
ALL
8. Data in database interacts & corresponds with other data
Aggregate Functions
SELECT
Integrated
Relational
9. SQL Commands: Define tables - views - _____ - delete or insert info
to update
Information
Performance
Application Programmers
10. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Joins
Aliases
Database
Structured Query Language (SQL)
11. Concatenated in SQL Server Database software using the addition symbol
Closing tag
Interactive SQL
Fields
American Standard Code for Information Interchange (ASCII)
12. Characterizes operation of a relational database
Joins
ESC
Closing tag
hidden fields
13. Browser requests page - code is delivered - executed and done with
HAVING
Session
IN
Dynamic
14. Command based way to ask the database a question
Joins
Session
Web Service
Query
15. Data stored by DAd
Information
Cookie
FROM
Data Elements
16. All Columns indicated and selected
*
Data Dictionary
ORDER BY
SUM
17. Defines a new column
Users
Calculated Column
Hardware
Application Programmers
18. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Functions
Web Applications
Calculated Column
DELETE
19. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Report
Self Join
FROM
20. Essentially a collection of services that communicate with eachother
Service-Oriented Architecture (SOA)
Shared
DISTINCT
Performance
21. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
accident
Service Broker
Self Join
22. Interact and manipulates the data in the database
Object-Oriented Relational (OOR)
hidden fields
Public Key Infrastructure (PKI)
Data Manipulation
23. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Comparison Operators
Precedence of Logical Operators
Public Key Infrastructure (PKI)
24. Join a table to a copy of itself
DISTINCT
Self Join
Persistent
MIN
25. Used to combine one query to another
Opening tag
Subqueries
Aliases
Hierarchial
26. 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)
Service Requestor
Cookie
COUNT
27. Basic Component of SQL
FROM
Tables
ALL
Web Service
28. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
Scripting
ASC
Persistent
29. Flat File Examples: Excel Spreadsheets - _____
Empty Elements
American Standard Code for Information Interchange (ASCII)
Word
INSERT INTO
30. Used to close a tag properly
MIN
ESC
Forward Slash
Object-Oriented Relational (OOR)
31. Allows use of single or multiple character wildcards with the underscore or percent symbol
Indexes
hidden fields
Session
LIKE
32. Used with another comparison operator - values become inverted
Negation Operator
HAVING
single value
Opening tag
33. Columns containing numbers only
Structured Query Language (SQL)
Scripting
Session
SUM
34. Table displayed in ascending order
Empty Elements
ASC
Data Definition
SUM
35. Flat File Examples: Excel Spreadsheets - _____
Service-Oriented Architecture (SOA)
Database
Word
Persistent
36. Fields in a relational table that match the primary key from one column to the primary key of another table.
Central Control of data
Foreign Keys
AVG
Data Administrator (DAd)
37. Uses two values as limits - selecting any values between the two of them
BETWEEN
ESC
single value
Aliases
38. SQL finds and retrieves date
accident
Integrated
Indexes
Tables
39. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
ESC
Performance
Report
40. Individuals that use - manipulate or maintain aspects of database
Users
Closing tag
COUNT
SUM
41. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Subqueries
ALL
single value
Functions
42. Command based way to ask the database a question
Joins
Forward Slash
single value
Query
43. Allows data recovery in case of corruption or loss
Negation Operator
Data Recovery & Concurrance
DISTINCT
Cookie
44. Identifies columns to appear in the result
Data Definition
HAVING
SELECT
Data
45. Using product as intended for its audience
Tags
End Users
Equals Operator
American Standard Code for Information Interchange (ASCII)
46. Compares value of the column in the specified condition with the value specified
AVG
Equals Operator
*
Indexes
47. Data that has been processed into a format that is understandable by its audience
Information
Service Requestor
Functions
Central control of data
48. Uses two values as limits - selecting any values between the two of them
Element Content
BETWEEN
Public Key Infrastructure (PKI)
Central Control of data
49. Writes programs that use or allow acces to databse with specific purpose
INSERT INTO
Fields
Application Programers
Hierarchial
50. Command used to show the attributes that define a table.
HAVING
Interactive SQL
Comparison Operators
sp_help