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. Basic Component of SQL
Tables
Query
HAVING
Shared
2. Limits the output of the established groups into the derived result table
HAVING
Performance
Closing tag
Element Content
3. 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.
Outer SELECT query
Hardware
Self Join
Primary Keys
4. Give the browser more specific information about that tag
Persistent
Attributes
Aliases
Flat File
5. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Object-Oriented Relational (OOR)
sp_help
Service-Oriented Architecture (SOA)
Bind
6. Definition of commands it can do
BETWEEN
ASC
Data Definition
Query
7. Writes programs that use or allow acces to databse with specific purpose
Hypertext Markup Language (HTML)
End Users
Application Programers
Users
8. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Data
Relational
Service Requestor
9. Compares value of the column in the specified condition with the value specified
Empty Elements
COUNT
SUM
Equals Operator
10. Data in database interacts & corresponds with other data
Integrated
MAX
hidden fields
Opening tag
11. Meaningful info related to database
End Users
Subqueries
SUM
Data
12. Browser requests page - code is delivered - executed and done with
Dynamic
Closing tag
Opening tag
Database
13. Averages the numeric values
Empty Elements
AVG
Calculated Column
MAX
14. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Web Service
Performance
Service Broker
Structured Query Language (SQL)
15. Closed in the start tag by adding a slash to the start tag
Closing tag
Empty Elements
Primary Keys
Database Management Systems (DBMS)
16. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Data Definition
COUNT
Subquery
SUM
17. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Dynamic
Views
End Users
18. Used to combine one query with another.
Subquery
Data Administrator (DAd)
Session
SELECT
19. Compares value of the column in the specified condition with the value specified
Equals Operator
Persistent
Users
Performance
20. Data remains unchanged in database
Bind
Persistent
Data Definition
Empty Elements
21. Cookies are more secure than______ - allowing travel on a website without loss of info
MIN
Element Content
hidden fields
INSERT INTO
22. Changes the values in one or more selected rows of a table
Integrated
Closing tag
Service-Oriented Architecture (SOA)
UPDATE
23. Finds the lowest constant value in a column
DISTINCT
MAX
Query
Aliases
24. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Indexes
Equals Operator
Information
25. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
ESC
SELECT
Hypertext Markup Language (HTML)
Hierarchial
26. Finds the lowest ACII value in column
Web Service
Shared
MIN
IN
27. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Web Applications
Database Management Systems (DBMS)
Flat File
Service Broker
28. SQL Commands - Two Things Specify data interested in - Indicate the ________
Hierarchial
Report
Calculated Column
accident
29. Browser requests page - code is delivered - executed and done with
Web Service
Aliases
AVG
Dynamic
30. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Subqueries
Data Definition
Comparison Operators
31. Table displayed in ascending order
Report
ASC
Cookie
Comparison Operators
32. Describe information in a tree styled format
Hierarchial
Information
Aggregate Functions
Application Programers
33. SQL Commands: Define tables - views - _____ - delete or insert info
to update
Session
Users
INSERT INTO
34. Uses relationships between independent entities
WHERE
WHERE
ASC
Relational
35. Software system designed to support interoperable machine - to - machine interaction over a network
Service Provider
Primary Keys
Report
Web Service
36. Flat File Examples: Excel Spreadsheets - _____
Hierarchial
Equals Operator
Word
Tags
37. Network node that discovers and invokes other software services to provide a buisness solution
Service Requestor
MIN
Service Broker
DELETE
38. One of the tools that SQL uses to find and retrieve data.
Indexes
Data Elements
Data Recovery & Concurrance
Interactive SQL
39. Command based way to ask the database a question
Closing tag
Inner SELECT query
Query
Data Recovery & Concurrance
40. SELECT statment containing the nested query
SUM
Outer SELECT query
NOT
Tables
41. Create program files that include SQ after each command
FROM
Candidate Keys
Embedded SQL
Joins
42. Executes commands one at a time - results being displayed immediately
Interactive SQL
Word
Flat File
Dynamic
43. Defines a new column
SUM
Data Recovery & Concurrance
Cookie
Calculated Column
44. Text markups that form an element" sort of a "box" to hold things like text and other elements
Central control of data
Comparison Operators
Tags
Functions
45. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Database Administrator (DBA)
Query
Tables
46. All Columns indicated and selected
accident
*
Data Administrator (DAd)
ALL
47. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
SUM
Indexes
Application Programmers
Data Definition
48. Has the highest precedence - followed by the AND - OR
Foreign Keys
Property
NOT
Central Control of data
49. The Web is ___________
Bind
Database Management Systems (DBMS)
Session
Stateless
50. Uses two values as limits - selecting any values between the two of them
BETWEEN
hidden fields
Data Recovery & Concurrance
Fields