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. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Scripting
Aliases
*
MIN
2. Used to remove duplicates from result table
AVG
DISTINCT
Application Programers
Cookie
3. Begins an element
BETWEEN
Word
Hypertext Markup Language (HTML)
Opening tag
4. Limits the rows that appear in the result mathcing a specified condition
American Standard Code for Information Interchange (ASCII)
WHERE
Bind
Tags
5. Has the highest precedence - followed by the AND - OR
Interactive SQL
Data Elements
NOT
Cookie
6. Data in database interacts & corresponds with other data
Data Administrator (DAd)
Interactive SQL
ALL
Integrated
7. Allow useres to retrieve data and interact with content located on web pages within website
Subqueries
SELECT
single value
Web Browser
8. Finds the lowest constant value in a column
End Users
Central control of data
MAX
Web server
9. Averages the numeric values
AVG
Service Provider
Database Administrator (DBA)
DISTINCT
10. Data in database interacts & corresponds with other data
Indexes
Integrated
Shared
Data Dictionary
11. Limits the rows that appear in the result mathcing a specified condition
Database Administrator (DBA)
Application Programmers
WHERE
Service Requestor
12. Practice of writing code into a webpage that is not directly visible to the user
ASC
Tags
DELETE
Scripting
13. Looks like opening tag - but with a forward slash
hidden fields
Closing tag
Data
Data Recovery & Concurrance
14. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
SUM
MIN
ORDER BY
Application Programmers
15. Meaningful info related to database
Data
Foreign Keys
Calculated Column
Attributes
16. SQL Commands - Two Things Specify data interested in - Indicate the ________
Database Administrator (DBA)
accident
HAVING
Hierarchial
17. SELECT statment containing the nested query
MIN
Service-Oriented Architecture (SOA)
Outer SELECT query
Primary Keys
18. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Inner SELECT query
Service-Oriented Architecture (SOA)
COUNT
Bind
19. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
HAVING
Equals Operator
Shared
Aliases
20. Used to combine one query with another.
Subquery
Application Programmers
Bind
UPDATE
21. 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.
End Users
Primary Keys
Scripting
Subquery
22. Combines rows from a SELECT statements result table into a group
AVG
Information
GROUP BY
Query
23. Most valuable asset of a database system.
Foreign Keys
Central control of data
SUM
Stateless
24. Fields in a relational table that match the primary key from one column to the primary key of another table.
Application Programmers
Foreign Keys
Flat File
Self Join
25. Everything in enviroment becomes an object - expands on Priniples of relational databases
Data Elements
Object-Oriented Relational (OOR)
single value
IN
26. Compares value of the column in the specified condition with the value specified
Shared
*
Equals Operator
COUNT
27. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Service-Oriented Architecture (SOA)
UPDATE
Structured Query Language (SQL)
Subqueries
28. 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
Session
Web Browser
Public Key Infrastructure (PKI)
COUNT
29. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
Users
Joins
Aggregate Functions
30. Used to combine one query to another
Joins
Views
Hypertext Markup Language (HTML)
Subqueries
31. SQL Commands: Define tables - views - _____ - delete or insert info
to update
Calculated Column
Tables
Information
32. Defines a new column
Indexes
Calculated Column
ESC
IN
33. Finds the lowest ACII value in column
Aliases
Database
Hierarchial
MIN
34. = - < - > - <= - >= - <> - !
Comparison Operators
Foreign Keys
Report
BETWEEN
35. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Information
Hardware
Web Applications
Information
36. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
to update
Aliases
Dynamic
37. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Flat File
DELETE
ALL
Application Programmers
38. Straight implementation of raw data formatted into rows and columns
Central Control of data
Flat File
Candidate Keys
Forward Slash
39. Characterizes operation of a relational database
Joins
Integrated
UPDATE
Tags
40. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
End Users
Dynamic
accident
41. Order in which WHERE clause is evaluated and combined
ALL
Aggregate Functions
Data Definition
Precedence of Logical Operators
42. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Application Programmers
Equals Operator
ALL
NOT
43. Ongoing record of data reflecting the info defining the database
Element Content
Data Dictionary
Attributes
IN
44. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
GROUP BY
Data Definition
Aliases
45. Concatenated in SQL Server Database software using the addition symbol
Interactive SQL
Scripting
Data Manipulation
Fields
46. Identifies columns to appear in the result
IN
SELECT
Information
Application Programmers
47. Data remains unchanged in database
Structured Query Language (SQL)
DISTINCT
Persistent
AVG
48. Executes commands one at a time - results being displayed immediately
LIKE
Interactive SQL
INSERT INTO
Users
49. Allows use of single or multiple character wildcards with the underscore or percent symbol
Subquery
LIKE
Inner SELECT query
Query
50. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Word
Subqueries
ASC