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
Service Broker
Functions
Relational
accident
2. Meaningful info related to database
Data
BETWEEN
NOT
Self Join
3. Data in database interacts & corresponds with other data
End Users
Integrated
*
Database Administrator (DBA)
4. Compares value of the column in the specified condition with the value specified
Equals Operator
Embedded SQL
Web Browser
Application Programmers
5. Defines a new column
SUM
Data Definition
ORDER BY
Calculated Column
6. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Equals Operator
End Users
Self Join
Aliases
7. Finds the lowest ACII value in column
DELETE
UPDATE
MIN
BETWEEN
8. Browser requests page - code is delivered - executed and done with
Subqueries
Dynamic
ORDER BY
Tables
9. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Database Administrator (DBA)
Hardware
Calculated Column
DELETE
10. 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.
Candidate Keys
Primary Keys
Central Control of data
Views
11. Essentially a collection of services that communicate with eachother
Web Browser
Data Manipulation
Hierarchial
Service-Oriented Architecture (SOA)
12. Join a table to a copy of itself
Relational
Service-Oriented Architecture (SOA)
Self Join
Web server
13. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
accident
Persistent
accident
14. Ongoing record of data reflecting the info defining the database
Persistent
FROM
Service-Oriented Architecture (SOA)
Data Dictionary
15. Closed in the start tag by adding a slash to the start tag
hidden fields
SUM
Application Programers
Empty Elements
16. Used to close a tag properly
Outer SELECT query
Forward Slash
American Standard Code for Information Interchange (ASCII)
accident
17. Essentially a collection of services that communicate with eachother
Property
American Standard Code for Information Interchange (ASCII)
Service-Oriented Architecture (SOA)
INSERT INTO
18. Command based way to ask the database a question
Self Join
Functions
Query
Hardware
19. 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
Session
SUM
Application Programers
IN
20. Begins an element
Bind
MIN
Query
Opening tag
21. Finds the lowest ACII value in column
Inner SELECT query
Data
Embedded SQL
MIN
22. Ongoing record of data reflecting the info defining the database
Database Administrator (DBA)
Dynamic
Data Dictionary
ALL
23. One of the tools that SQL uses to find and retrieve data.
COUNT
Query
Indexes
Web Service
24. Meaningful info related to database
Embedded SQL
Tags
Data
Fields
25. Tally of how many rows meet criteria specified
Indexes
Hierarchial
COUNT
Application Programers
26. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Session
Forward Slash
single value
Hypertext Markup Language (HTML)
27. All Columns indicated and selected
*
Persistent
Users
Forward Slash
28. Specifies the tables or views from which rows and columns are retrieved
Data Manipulation
Application Programmers
FROM
Data Elements
29. Order in which WHERE clause is evaluated and combined
Indexes
SELECT
Precedence of Logical Operators
sp_help
30. SELECT statment containing the nested query
Performance
Public Key Infrastructure (PKI)
Web Service
Outer SELECT query
31. Table displayed in descending order
Inner SELECT query
Functions
Database Management Systems (DBMS)
ESC
32. Used to combine one query to another
Property
Element Content
ASC
Subqueries
33. Large structured set of persistent data
Database
Foreign Keys
accident
IN
34. Create program files that include SQ after each command
Embedded SQL
Cookie
SUM
Data Recovery & Concurrance
35. Columns containing numbers only
Data Recovery & Concurrance
Query
SUM
Dynamic
36. Ensures functions are done efficiently
Session
Service-Oriented Architecture (SOA)
Performance
ASC
37. SELECT statment containing the nested query
Outer SELECT query
Data Elements
Functions
MAX
38. Network node that discovers and invokes other software services to provide a buisness solution
Attributes
Joins
Service Requestor
COUNT
39. Identifies columns to appear in the result
Negation Operator
SELECT
Fields
UPDATE
40. Changes the values in one or more selected rows of a table
UPDATE
INSERT INTO
Precedence of Logical Operators
Central Control of data
41. Decides what data is stored in the databse and the manner it is stored
Word
Data Administrator (DAd)
SUM
DELETE
42. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Public Key Infrastructure (PKI)
Service Broker
Hypertext Markup Language (HTML)
Data Administrator (DAd)
43. Used in a SELECT clause in place of a column
Primary Keys
Aggregate Functions
FROM
Attributes
44. Table displayed in ascending order
Web Service
Functions
SELECT
ASC
45. Allows use of single or multiple character wildcards with the underscore or percent symbol
FROM
LIKE
Calculated Column
DELETE
46. Limits the rows that appear in the result mathcing a specified condition
Session
Element Content
WHERE
COUNT
47. Copies multiple records at the same time using a SELECT statement
INSERT INTO
NOT
Indexes
GROUP BY
48. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
DISTINCT
Application Programers
UPDATE
49. Software system designed to support interoperable machine - to - machine interaction over a network
Integrated
Web Service
GROUP BY
Embedded SQL
50. Basic Component of SQL
Inner SELECT query
Tables
IN
MIN