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. Has the highest precedence - followed by the AND - OR
Opening tag
NOT
Bind
Fields
2. Interact and manipulates the data in the database
Data Manipulation
GROUP BY
to update
Attributes
3. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Comparison Operators
single value
Application Programmers
Web Applications
4. Straight implementation of raw data formatted into rows and columns
Outer SELECT query
GROUP BY
Flat File
Structured Query Language (SQL)
5. Data remains unchanged in database
Web server
Persistent
Indexes
Comparison Operators
6. Data that has been processed into a format that is understandable by its audience
Service-Oriented Architecture (SOA)
SUM
Word
Information
7. SELECT statment containing the nested query
*
Outer SELECT query
Application Programmers
single value
8. Used to close a tag properly
Dynamic
Forward Slash
Central control of data
Interactive SQL
9. Limits the output of the established groups into the derived result table
to update
HAVING
Forward Slash
Web Applications
10. File stored on a user's machine that contains infor about application
to update
Bind
Central control of data
Cookie
11. Allows use of single or multiple character wildcards with the underscore or percent symbol
LIKE
UPDATE
Session
Subqueries
12. Averages the numeric values
AVG
Subqueries
*
hidden fields
13. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Aggregate Functions
Web server
single value
MAX
14. Network node that discovers and invokes other software services to provide a buisness solution
Service-Oriented Architecture (SOA)
Service Requestor
COUNT
IN
15. Ongoing record of data reflecting the info defining the database
Flat File
Application Programers
Data Dictionary
Web Service
16. Basic Component of SQL
Data Manipulation
Shared
Data Definition
Tables
17. Changes the values in one or more selected rows of a table
UPDATE
Service Provider
Database Management Systems (DBMS)
Cookie
18. Deletes selected rows
Information
Data Manipulation
DELETE
Empty Elements
19. Finds the lowest ACII value in column
DELETE
Hypertext Markup Language (HTML)
ORDER BY
MIN
20. Used to remove duplicates from result table
Central control of data
Public Key Infrastructure (PKI)
Central Control of data
DISTINCT
21. Used to combine one query to another
SELECT
Interactive SQL
SUM
Subqueries
22. Used to remove duplicates from result table
Closing tag
Application Programmers
DISTINCT
SUM
23. Table displayed in descending order
ESC
Data Administrator (DAd)
MIN
Application Programers
24. Meaningful info related to database
Data
Embedded SQL
NOT
Object-Oriented Relational (OOR)
25. Create program files that include SQ after each command
Embedded SQL
WHERE
Hardware
Report
26. Changes the values in one or more selected rows of a table
ESC
Equals Operator
UPDATE
MAX
27. Data that has been processed into a format that is understandable by its audience
HAVING
Database
Database Administrator (DBA)
Information
28. Data remains unchanged in database
MAX
AVG
*
Persistent
29. Browser requests page - code is delivered - executed and done with
Precedence of Logical Operators
Dynamic
Service Broker
SELECT
30. Closed in the start tag by adding a slash to the start tag
Empty Elements
Session
Service Provider
Opening tag
31. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Session
Data Elements
Self Join
single value
32. Using product as intended for its audience
End Users
Application Programmers
INSERT INTO
Information
33. Grant acces and control to only specific information
Views
Service-Oriented Architecture (SOA)
Tables
DISTINCT
34. Concatenated in SQL Server Database software using the addition symbol
Candidate Keys
Fields
Relational
Subquery
35. Command used to show the attributes that define a table.
Word
sp_help
Query
SUM
36. Command based way to ask the database a question
ASC
Information
Attributes
Query
37. Give the browser more specific information about that tag
Self Join
Attributes
Service Broker
GROUP BY
38. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
Hierarchial
single value
SUM
39. Software system designed to support interoperable machine - to - machine interaction over a network
MIN
AVG
Web Service
SELECT
40. Characterizes operation of a relational database
Joins
MIN
Hypertext Markup Language (HTML)
SELECT
41. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
*
Public Key Infrastructure (PKI)
Calculated Column
42. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Self Join
hidden fields
Hardware
Views
43. Some form of output - usually - printed - containing information
Tags
Closing tag
Report
Integrated
44. Everything in enviroment becomes an object - expands on Priniples of relational databases
Property
Data Manipulation
Interactive SQL
Object-Oriented Relational (OOR)
45. All Columns indicated and selected
*
MAX
Stateless
Empty Elements
46. Ongoing record of data reflecting the info defining the database
Data Dictionary
ALL
HAVING
Report
47. Data in database has ability to be accessed and manipulated by several users
Property
Data Dictionary
Shared
Attributes
48. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Inner SELECT query
ESC
Service Requestor
49. Describe information in a tree styled format
Outer SELECT query
Hierarchial
hidden fields
Indexes
50. Used to combine one query to another
Report
Web Browser
Subqueries
BETWEEN
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests