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. Using product as intended for its audience
Precedence of Logical Operators
End Users
Web server
AVG
2. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Object-Oriented Relational (OOR)
ESC
Web server
Hardware
3. Create program files that include SQ after each command
Data Elements
Service Requestor
ORDER BY
Embedded SQL
4. Used with another comparison operator - values become inverted
Negation Operator
Candidate Keys
Web Browser
GROUP BY
5. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
MIN
ASC
Data Recovery & Concurrance
6. Command based way to ask the database a question
Property
Query
DELETE
Database Management Systems (DBMS)
7. Used to combine one query to another
INSERT INTO
Public Key Infrastructure (PKI)
Data Administrator (DAd)
Subqueries
8. Flat File Examples: Excel Spreadsheets - _____
Central Control of data
WHERE
Attributes
Word
9. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Application Programers
Data Manipulation
MAX
10. Browser requests page - code is delivered - executed and done with
Closing tag
Dynamic
Service Requestor
hidden fields
11. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Functions
to update
Object-Oriented Relational (OOR)
ALL
12. Join a table to a copy of itself
Tags
Self Join
Web Browser
Integrated
13. Some form of output - usually - printed - containing information
Database
Report
Opening tag
Application Programers
14. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Cookie
Report
Web server
INSERT INTO
15. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Attributes
Service Broker
SELECT
16. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Empty Elements
Web server
HAVING
17. Closed in the start tag by adding a slash to the start tag
Integrated
Outer SELECT query
Empty Elements
Web Applications
18. One huge database to hold all data; Access to data - and use of system to add - update & print records
Word
Database Management Systems (DBMS)
AVG
Data
19. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Data Manipulation
Aliases
Comparison Operators
Shared
20. Tally of how many rows meet criteria specified
COUNT
LIKE
Subqueries
Report
21. Ensures functions are done efficiently
Performance
Interactive SQL
Negation Operator
Web Service
22. Flat File Examples: Excel Spreadsheets - _____
Information
Service Broker
Word
Data Elements
23. SQL Commands - Two Things Specify data interested in - Indicate the ________
ALL
accident
Service Broker
COUNT
24. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Service Broker
Embedded SQL
MIN
Web Applications
25. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Embedded SQL
Relational
single value
GROUP BY
26. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
LIKE
Foreign Keys
WHERE
27. Combines rows from a SELECT statements result table into a group
GROUP BY
Shared
DELETE
Web Browser
28. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Data Dictionary
FROM
Relational
29. Limits the rows that appear in the result mathcing a specified condition
End Users
WHERE
Data Definition
Users
30. Responsible for technical implementation & maintenance of database on a design & physical level
ORDER BY
Service Provider
Database Administrator (DBA)
Public Key Infrastructure (PKI)
31. Change order of rows in result table
ORDER BY
Relational
Shared
UPDATE
32. Deletes selected rows
Application Programers
WHERE
DELETE
Self Join
33. Ensures functions are done efficiently
SELECT
MAX
Performance
Data Recovery & Concurrance
34. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Negation Operator
Central Control of data
Integrated
SUM
35. Definition of commands it can do
Data Definition
MIN
Fields
Aggregate Functions
36. Identifies columns to appear in the result
SELECT
Aggregate Functions
Session
Joins
37. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Property
Shared
Hardware
single value
38. Tally of how many rows meet criteria specified
COUNT
FROM
SUM
Comparison Operators
39. Attribute in quotes
Equals Operator
Property
SUM
INSERT INTO
40. Used in a SELECT clause in place of a column
Aggregate Functions
Precedence of Logical Operators
Property
UPDATE
41. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Negation Operator
Service Broker
Web Service
Closing tag
42. Fields in a relational table that match the primary key from one column to the primary key of another table.
Hierarchial
Aggregate Functions
Foreign Keys
Central control of data
43. Finds the lowest constant value in a column
single value
MAX
Web Service
Element Content
44. Finds the lowest ACII value in column
Public Key Infrastructure (PKI)
Web Browser
Data Recovery & Concurrance
MIN
45. Selects from specific values in list
IN
Session
Web Applications
Database
46. Some form of output - usually - printed - containing information
Hypertext Markup Language (HTML)
Dynamic
Report
SELECT
47. Data that has been processed into a format that is understandable by its audience
Aliases
Scripting
COUNT
Information
48. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
ORDER BY
WHERE
hidden fields
Service Broker
49. Ensures data is correct casings
INSERT INTO
American Standard Code for Information Interchange (ASCII)
Aliases
MIN
50. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Interactive SQL
*
Embedded SQL
Structured Query Language (SQL)
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