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
ASC
Comparison Operators
Service Broker
Data Manipulation
2. Closed in the start tag by adding a slash to the start tag
to update
Empty Elements
Application Programmers
Subqueries
3. Used to remove duplicates from result table
INSERT INTO
Data Manipulation
DISTINCT
Equals Operator
4. Order in which WHERE clause is evaluated and combined
Service-Oriented Architecture (SOA)
Interactive SQL
Aggregate Functions
Precedence of Logical Operators
5. Give the browser more specific information about that tag
Attributes
Central Control of data
ESC
Data Dictionary
6. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Calculated Column
Central Control of data
Data Administrator (DAd)
ASC
7. Some form of output - usually - printed - containing information
American Standard Code for Information Interchange (ASCII)
Shared
Report
Bind
8. Command based way to ask the database a question
Functions
Outer SELECT query
Service Broker
Query
9. Ongoing record of data reflecting the info defining the database
Data Dictionary
Flat File
ORDER BY
Report
10. Software system designed to support interoperable machine - to - machine interaction over a network
ALL
Web Service
Property
Data Administrator (DAd)
11. Large structured set of persistent data
Database
Service Requestor
Service-Oriented Architecture (SOA)
Views
12. Allows use of single or multiple character wildcards with the underscore or percent symbol
Element Content
single value
Inner SELECT query
LIKE
13. Table displayed in ascending order
Service Broker
ASC
INSERT INTO
BETWEEN
14. Basic Component of SQL
Interactive SQL
Outer SELECT query
Web server
Tables
15. Join a table to a copy of itself
Subqueries
Self Join
UPDATE
Service Requestor
16. Table displayed in ascending order
End Users
Empty Elements
ASC
Cookie
17. Definition of commands it can do
Data Definition
Empty Elements
Interactive SQL
Application Programers
18. Uses relationships between independent entities
Relational
Service Broker
Attributes
Closing tag
19. Ensures data is correct casings
Users
Views
American Standard Code for Information Interchange (ASCII)
Embedded SQL
20. Characterizes operation of a relational database
Users
Joins
Hierarchial
Data
21. Basic Component of SQL
Joins
SELECT
Data Administrator (DAd)
Tables
22. All Columns indicated and selected
Hardware
SELECT
*
Central Control of data
23. Essentially a collection of services that communicate with eachother
single value
Service-Oriented Architecture (SOA)
End Users
Data Manipulation
24. Limits the output of the established groups into the derived result table
HAVING
*
Public Key Infrastructure (PKI)
Interactive SQL
25. Deletes selected rows
Cookie
Functions
MAX
DELETE
26. Used to combine one query to another
Opening tag
IN
NOT
Subqueries
27. Deletes selected rows
Performance
DELETE
Query
American Standard Code for Information Interchange (ASCII)
28. Used to combine one query to another
Candidate Keys
hidden fields
Integrated
Subqueries
29. Tally of how many rows meet criteria specified
COUNT
Calculated Column
Hardware
Service-Oriented Architecture (SOA)
30. Command used to show the attributes that define a table.
Forward Slash
Database Management Systems (DBMS)
Self Join
sp_help
31. Responsible for technical implementation & maintenance of database on a design & physical level
to update
Equals Operator
Database Administrator (DBA)
Users
32. Combines rows from a SELECT statements result table into a group
American Standard Code for Information Interchange (ASCII)
GROUP BY
to update
Central control of data
33. Everything between the start and end tag
Element Content
Cookie
Application Programmers
BETWEEN
34. Individuals that use - manipulate or maintain aspects of database
Users
sp_help
MAX
Aliases
35. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Inner SELECT query
Opening tag
Scripting
36. Change order of rows in result table
Functions
Cookie
Database Administrator (DBA)
ORDER BY
37. Compares value of the column in the specified condition with the value specified
Cookie
ESC
Application Programmers
Equals Operator
38. Decides what data is stored in the databse and the manner it is stored
Data Dictionary
Subqueries
Data Administrator (DAd)
Embedded SQL
39. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Forward Slash
Web Browser
Web Applications
40. Describe information in a tree styled format
Data Definition
Hierarchial
Performance
Tables
41. Browser requests page - code is delivered - executed and done with
Hierarchial
Dynamic
Negation Operator
Database Administrator (DBA)
42. Finds the lowest constant value in a column
Negation Operator
Report
MAX
Scripting
43. Data that has been processed into a format that is understandable by its audience
Aliases
Data Recovery & Concurrance
Information
Tags
44. Software system designed to support interoperable machine - to - machine interaction over a network
ALL
Cookie
Tables
Web Service
45. Describe information in a tree styled format
Hierarchial
Self Join
Bind
Subquery
46. Defines a new column
GROUP BY
Session
COUNT
Calculated Column
47. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
DISTINCT
Hypertext Markup Language (HTML)
Information
Aggregate Functions
48. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Session
Aliases
Closing tag
Precedence of Logical Operators
49. Columns containing numbers only
Data Elements
INSERT INTO
SUM
COUNT
50. Using product as intended for its audience
Web Browser
End Users
Joins
MIN