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 discovers and invokes other software services to provide a buisness solution
Session
Service Requestor
DISTINCT
End Users
2. Limits the output of the established groups into the derived result table
Session
Structured Query Language (SQL)
Primary Keys
HAVING
3. Limits the output of the established groups into the derived result table
HAVING
MAX
SELECT
Database Management Systems (DBMS)
4. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Subquery
Service Broker
Views
MIN
5. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
ESC
Central Control of data
Bind
Outer SELECT query
6. Text markups that form an element" sort of a "box" to hold things like text and other elements
Data Definition
Aggregate Functions
Tags
INSERT INTO
7. Compares value of the column in the specified condition with the value specified
COUNT
Calculated Column
Web server
Equals Operator
8. Responsible for technical implementation & maintenance of database on a design & physical level
Equals Operator
Hypertext Markup Language (HTML)
Object-Oriented Relational (OOR)
Database Administrator (DBA)
9. Identifies columns to appear in the result
Negation Operator
Information
INSERT INTO
SELECT
10. Writes programs that use or allow acces to databse with specific purpose
FROM
DISTINCT
Application Programers
Query
11. Join a table to a copy of itself
Dynamic
Self Join
hidden fields
Comparison Operators
12. Command based way to ask the database a question
Query
Tags
Data Dictionary
Fields
13. Three Basic Operations of SP - SR - SB: Publish - Find - ____
FROM
Service Broker
Performance
Bind
14. Using product as intended for its audience
SELECT
End Users
single value
Data Dictionary
15. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Data
Application Programmers
Aliases
single value
16. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Information
Query
Interactive SQL
17. Software system designed to support interface for a software asset that manages a specific set of tasks
SUM
ESC
LIKE
Service Provider
18. Interact and manipulates the data in the database
Data
Data Manipulation
Closing tag
Information
19. Used to remove duplicates from result table
UPDATE
Opening tag
Shared
DISTINCT
20. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Dynamic
Application Programmers
Bind
MAX
21. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
to update
Closing tag
Attributes
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
Application Programers
Public Key Infrastructure (PKI)
Central control of data
INSERT INTO
23. Ongoing record of data reflecting the info defining the database
Data Dictionary
ALL
Indexes
ORDER BY
24. Data stored by DAd
Cookie
Interactive SQL
Data Elements
Object-Oriented Relational (OOR)
25. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Data
Hypertext Markup Language (HTML)
Data Administrator (DAd)
Query
26. Individuals that use - manipulate or maintain aspects of database
Aggregate Functions
Users
Opening tag
Inner SELECT query
27. Selects from specific values in list
IN
Service Requestor
Tags
Data Manipulation
28. SELECT statment containing the nested query
Attributes
Outer SELECT query
Self Join
Database Management Systems (DBMS)
29. Data remains unchanged in database
GROUP BY
Persistent
Element Content
Service Requestor
30. Table displayed in descending order
Tables
Information
Property
ESC
31. Table displayed in ascending order
ASC
SUM
Shared
Service Requestor
32. Tally of how many rows meet criteria specified
Service-Oriented Architecture (SOA)
Embedded SQL
Object-Oriented Relational (OOR)
COUNT
33. Give the browser more specific information about that tag
Element Content
Indexes
Attributes
Scripting
34. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Opening tag
Bind
Service Broker
Shared
35. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Functions
WHERE
Data Manipulation
Structured Query Language (SQL)
36. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
WHERE
Embedded SQL
Data Elements
37. Specifies the tables or views from which rows and columns are retrieved
DISTINCT
FROM
Subquery
End Users
38. Allow useres to retrieve data and interact with content located on web pages within website
single value
Web Browser
accident
Structured Query Language (SQL)
39. Uses relationships between independent entities
Relational
GROUP BY
Indexes
ASC
40. Change order of rows in result table
ORDER BY
Inner SELECT query
hidden fields
Scripting
41. One huge database to hold all data; Access to data - and use of system to add - update & print records
Data Administrator (DAd)
*
Database Management Systems (DBMS)
Application Programers
42. 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.
Persistent
Candidate Keys
Bind
AVG
43. Characterizes operation of a relational database
Interactive SQL
Joins
Hierarchial
American Standard Code for Information Interchange (ASCII)
44. Most valuable asset of a database system.
Web Service
hidden fields
Central control of data
UPDATE
45. Allows use of single or multiple character wildcards with the underscore or percent symbol
Data Manipulation
LIKE
COUNT
Session
46. Ongoing record of data reflecting the info defining the database
Data Dictionary
Outer SELECT query
COUNT
BETWEEN
47. Grant acces and control to only specific information
GROUP BY
Views
Scripting
INSERT INTO
48. Defines a new column
Calculated Column
UPDATE
IN
Embedded SQL
49. Everything in enviroment becomes an object - expands on Priniples of relational databases
Comparison Operators
Tables
Data
Object-Oriented Relational (OOR)
50. Changes the values in one or more selected rows of a table
Web Service
Hypertext Markup Language (HTML)
UPDATE
Service-Oriented Architecture (SOA)