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. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
Data Manipulation
Dynamic
Closing tag
2. Data remains unchanged in database
Persistent
Negation Operator
UPDATE
MAX
3. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Forward Slash
SUM
Query
4. Ongoing record of data reflecting the info defining the database
Tags
Data Dictionary
Element Content
Dynamic
5. Looks like opening tag - but with a forward slash
Users
Aliases
Closing tag
Data Administrator (DAd)
6. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Negation Operator
Application Programmers
Aggregate Functions
GROUP BY
7. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Aliases
Opening tag
Data Definition
8. Grant acces and control to only specific information
Empty Elements
Views
MIN
Relational
9. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Scripting
MAX
Web server
FROM
10. Identifies columns to appear in the result
Joins
SELECT
Users
Data Manipulation
11. Order in which WHERE clause is evaluated and combined
Property
accident
Precedence of Logical Operators
Service Broker
12. Meaningful info related to database
Relational
Data Dictionary
Subqueries
Data
13. Table displayed in ascending order
ASC
End Users
Attributes
Data Administrator (DAd)
14. Data in database interacts & corresponds with other data
Integrated
DISTINCT
MIN
Service Requestor
15. Definition of commands it can do
Data Definition
WHERE
Fields
Dynamic
16. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Users
Bind
Integrated
Relational
17. Selects from specific values in list
Opening tag
IN
hidden fields
accident
18. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
accident
Word
Data Administrator (DAd)
single value
19. Begins an element
Opening tag
ALL
American Standard Code for Information Interchange (ASCII)
Hypertext Markup Language (HTML)
20. Used to remove duplicates from result table
Foreign Keys
Inner SELECT query
DISTINCT
Data Manipulation
21. Begins an element
Opening tag
Dynamic
Aggregate Functions
UPDATE
22. Has the highest precedence - followed by the AND - OR
Outer SELECT query
Integrated
Hardware
NOT
23. Limits the rows that appear in the result mathcing a specified condition
Web server
MAX
WHERE
Indexes
24. SELECT statment containing the nested query
Cookie
Database Administrator (DBA)
Views
Outer SELECT query
25. Characterizes operation of a relational database
Web server
Tags
Tables
Joins
26. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Structured Query Language (SQL)
Application Programers
Indexes
Web Service
27. Command used to show the attributes that define a table.
LIKE
Service Provider
Shared
sp_help
28. All Columns indicated and selected
Performance
Service Broker
MAX
*
29. Change order of rows in result table
MAX
Hardware
ORDER BY
Information
30. Give the browser more specific information about that tag
Data Dictionary
Application Programmers
Attributes
WHERE
31. Used to close a tag properly
Forward Slash
HAVING
Subqueries
HAVING
32. Using product as intended for its audience
Users
End Users
DISTINCT
Application Programmers
33. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Flat File
Self Join
Structured Query Language (SQL)
Hierarchial
34. Limits the output of the established groups into the derived result table
Foreign Keys
HAVING
Views
WHERE
35. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Database
Central Control of data
Aliases
single value
36. Specifies the tables or views from which rows and columns are retrieved
Service-Oriented Architecture (SOA)
SUM
FROM
COUNT
37. Data in database has ability to be accessed and manipulated by several users
Interactive SQL
Users
SUM
Shared
38. Everything between the start and end tag
Indexes
Element Content
hidden fields
Session
39. Combines rows from a SELECT statements result table into a group
Web Browser
GROUP BY
UPDATE
Candidate Keys
40. Flat File Examples: Excel Spreadsheets - _____
Public Key Infrastructure (PKI)
UPDATE
Calculated Column
Word
41. Data stored by DAd
WHERE
Data Elements
Database Management Systems (DBMS)
Data Recovery & Concurrance
42. Command based way to ask the database a question
Web Browser
Negation Operator
Query
Joins
43. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Closing tag
Data
Web server
Data
44. Attribute in quotes
Query
Tags
hidden fields
Property
45. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
ESC
BETWEEN
ORDER BY
46. Large structured set of persistent data
Query
Stateless
Web Service
Database
47. Has the highest precedence - followed by the AND - OR
Stateless
GROUP BY
NOT
Data Definition
48. Identifies columns to appear in the result
ASC
Central Control of data
accident
SELECT
49. Finds the lowest constant value in a column
MAX
Relational
Data Definition
Data Administrator (DAd)
50. Characterizes operation of a relational database
Dynamic
NOT
Joins
HAVING
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