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. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Inner SELECT query
Service Broker
Attributes
Aggregate Functions
2. Allows data recovery in case of corruption or loss
Outer SELECT query
Candidate Keys
Relational
Data Recovery & Concurrance
3. Closed in the start tag by adding a slash to the start tag
Web Browser
Empty Elements
Data
to update
4. Essentially a collection of services that communicate with eachother
Hypertext Markup Language (HTML)
Service-Oriented Architecture (SOA)
Public Key Infrastructure (PKI)
Data
5. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
NOT
IN
SUM
Negation Operator
6. Looks like opening tag - but with a forward slash
Foreign Keys
Calculated Column
SUM
Closing tag
7. Cookies are more secure than______ - allowing travel on a website without loss of info
Property
hidden fields
MIN
Forward Slash
8. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
WHERE
Comparison Operators
Information
9. Allows use of single or multiple character wildcards with the underscore or percent symbol
Outer SELECT query
MAX
Performance
LIKE
10. Large structured set of persistent data
Web Browser
Query
SUM
Database
11. Concatenated in SQL Server Database software using the addition symbol
American Standard Code for Information Interchange (ASCII)
Fields
Precedence of Logical Operators
Interactive SQL
12. Decides what data is stored in the databse and the manner it is stored
ALL
Database Administrator (DBA)
Data Administrator (DAd)
Scripting
13. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
*
Views
single value
Subqueries
14. Meaningful info related to database
HAVING
Data
Service Requestor
Property
15. SQL finds and retrieves date
Indexes
Service Broker
ALL
Central Control of data
16. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.
Dynamic
Candidate Keys
Joins
COUNT
17. Identifies columns to appear in the result
SELECT
Self Join
Relational
Subqueries
18. Interact and manipulates the data in the database
Data Manipulation
UPDATE
DISTINCT
ASC
19. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Joins
Data Dictionary
Tags
Structured Query Language (SQL)
20. Give the browser more specific information about that tag
Comparison Operators
Attributes
Tags
Service Broker
21. Selects from specific values in list
Shared
Session
Embedded SQL
IN
22. Grant acces and control to only specific information
ASC
Views
single value
accident
23. SQL Commands: Define tables - views - _____ - delete or insert info
Fields
Word
to update
Web server
24. Table displayed in descending order
ESC
End Users
MIN
hidden fields
25. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Database
Data Definition
Inner SELECT query
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
Application Programers
Service-Oriented Architecture (SOA)
Public Key Infrastructure (PKI)
AVG
27. Writes programs that use or allow acces to databse with specific purpose
Aggregate Functions
Hypertext Markup Language (HTML)
Application Programers
Hypertext Markup Language (HTML)
28. Specifies the tables or views from which rows and columns are retrieved
Integrated
End Users
Joins
FROM
29. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Cookie
Application Programmers
Data Dictionary
Hypertext Markup Language (HTML)
30. Everything in enviroment becomes an object - expands on Priniples of relational databases
Database Management Systems (DBMS)
INSERT INTO
Object-Oriented Relational (OOR)
Data Manipulation
31. Command used to show the attributes that define a table.
Aliases
Data Definition
sp_help
Performance
32. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Primary Keys
Functions
Database Administrator (DBA)
Bind
33. Some form of output - usually - printed - containing information
*
Report
Interactive SQL
DISTINCT
34. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Outer SELECT query
Web Service
Bind
Structured Query Language (SQL)
35. SQL finds and retrieves date
American Standard Code for Information Interchange (ASCII)
Indexes
NOT
Functions
36. SQL Commands: Define tables - views - _____ - delete or insert info
Session
Equals Operator
to update
Precedence of Logical Operators
37. 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
single value
Tables
Hypertext Markup Language (HTML)
38. Join a table to a copy of itself
WHERE
Cookie
Self Join
Precedence of Logical Operators
39. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Closing tag
Report
Application Programmers
Central Control of data
40. Used to close a tag properly
Forward Slash
COUNT
FROM
ALL
41. Ensures data is correct casings
FROM
ORDER BY
Interactive SQL
American Standard Code for Information Interchange (ASCII)
42. Change order of rows in result table
Application Programers
Object-Oriented Relational (OOR)
SELECT
ORDER BY
43. Text markups that form an element" sort of a "box" to hold things like text and other elements
HAVING
Dynamic
Tags
FROM
44. Browser requests page - code is delivered - executed and done with
Dynamic
Data Recovery & Concurrance
AVG
Hierarchial
45. Some form of output - usually - printed - containing information
Report
Word
Primary Keys
Closing tag
46. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
HAVING
Data Dictionary
ALL
MIN
47. Finds the lowest ACII value in column
UPDATE
UPDATE
MIN
AVG
48. Changes the values in one or more selected rows of a table
UPDATE
Hierarchial
Tags
Hardware
49. Ensures data is correct casings
Service-Oriented Architecture (SOA)
American Standard Code for Information Interchange (ASCII)
Web Browser
Data Definition
50. One huge database to hold all data; Access to data - and use of system to add - update & print records
End Users
Database Management Systems (DBMS)
LIKE
Structured Query Language (SQL)