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. Software system designed to support interface for a software asset that manages a specific set of tasks
ORDER BY
IN
Service Requestor
Service Provider
2. Used to combine one query to another
DELETE
Element Content
Subqueries
Opening tag
3. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Central Control of data
Web Service
SUM
Web Applications
4. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Application Programmers
Database
Outer SELECT query
5. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Object-Oriented Relational (OOR)
Integrated
IN
single value
6. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
SUM
Interactive SQL
Service Requestor
Data
7. Concatenated in SQL Server Database software using the addition symbol
Embedded SQL
Data Definition
Scripting
Fields
8. Fields in a relational table that match the primary key from one column to the primary key of another table.
Aliases
Foreign Keys
Service Broker
MIN
9. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Cookie
Inner SELECT query
Public Key Infrastructure (PKI)
Hypertext Markup Language (HTML)
10. Begins an element
DELETE
COUNT
Object-Oriented Relational (OOR)
Opening tag
11. All Columns indicated and selected
Information
Database
*
Application Programers
12. Selects from specific values in list
Aliases
HAVING
IN
Empty Elements
13. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
Tables
Calculated Column
Data Recovery & Concurrance
14. Table displayed in ascending order
Dynamic
Negation Operator
sp_help
ASC
15. Straight implementation of raw data formatted into rows and columns
Flat File
SUM
to update
*
16. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Information
Bind
SELECT
ALL
17. Limits the output of the established groups into the derived result table
Scripting
Outer SELECT query
HAVING
Hypertext Markup Language (HTML)
18. Describe information in a tree styled format
Comparison Operators
Hierarchial
Outer SELECT query
FROM
19. Attribute in quotes
Inner SELECT query
Flat File
Property
Interactive SQL
20. Columns containing numbers only
End Users
Indexes
Aggregate Functions
SUM
21. Specifies the tables or views from which rows and columns are retrieved
Hardware
Calculated Column
FROM
Query
22. Large structured set of persistent data
Aggregate Functions
COUNT
Database
Users
23. Used with another comparison operator - values become inverted
Web Applications
Negation Operator
AVG
ESC
24. Meaningful info related to database
Session
Central control of data
Data
LIKE
25. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
AVG
Fields
Attributes
26. Writes programs that use or allow acces to databse with specific purpose
Structured Query Language (SQL)
Application Programers
Fields
Database Administrator (DBA)
27. Browser requests page - code is delivered - executed and done with
Dynamic
Outer SELECT query
SUM
MAX
28. 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.
Candidate Keys
Subqueries
Service Provider
Tables
29. Ensures data is correct casings
Outer SELECT query
American Standard Code for Information Interchange (ASCII)
Outer SELECT query
Data Elements
30. Characterizes operation of a relational database
Joins
Performance
Aggregate Functions
Aggregate Functions
31. Command based way to ask the database a question
single value
Query
Embedded SQL
Object-Oriented Relational (OOR)
32. Combines rows from a SELECT statements result table into a group
Empty Elements
NOT
GROUP BY
Dynamic
33. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
*
Shared
Hierarchial
Application Programmers
34. Attribute in quotes
Property
Flat File
Foreign Keys
Database Management Systems (DBMS)
35. Definition of commands it can do
Negation Operator
Inner SELECT query
Stateless
Data Definition
36. Give the browser more specific information about that tag
IN
Indexes
Attributes
Application Programmers
37. Give the browser more specific information about that tag
Empty Elements
Indexes
Attributes
Service-Oriented Architecture (SOA)
38. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Flat File
Negation Operator
Tags
Central Control of data
39. Ongoing record of data reflecting the info defining the database
Database Management Systems (DBMS)
Indexes
Data Dictionary
SUM
40. Used to close a tag properly
Application Programers
Web Service
DELETE
Forward Slash
41. Ensures functions are done efficiently
American Standard Code for Information Interchange (ASCII)
Performance
hidden fields
to update
42. SQL Commands: Define tables - views - _____ - delete or insert info
to update
Service-Oriented Architecture (SOA)
INSERT INTO
single value
43. Concatenated in SQL Server Database software using the addition symbol
Data Manipulation
Self Join
American Standard Code for Information Interchange (ASCII)
Fields
44. Allow useres to retrieve data and interact with content located on web pages within website
BETWEEN
Performance
Data Dictionary
Web Browser
45. Closed in the start tag by adding a slash to the start tag
Empty Elements
Functions
Persistent
DELETE
46. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Data Definition
Database
Aliases
Service-Oriented Architecture (SOA)
47. Looks like opening tag - but with a forward slash
Web Service
AVG
Closing tag
Aggregate Functions
48. Some form of output - usually - printed - containing information
ASC
AVG
Report
Data Elements
49. Tally of how many rows meet criteria specified
Inner SELECT query
Service Requestor
Foreign Keys
COUNT
50. Combines rows from a SELECT statements result table into a group
GROUP BY
Property
HAVING
Service Requestor