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. Data in database has ability to be accessed and manipulated by several users
Empty Elements
Shared
hidden fields
Service Broker
2. Some form of output - usually - printed - containing information
Shared
Report
Service Broker
Web server
3. SQL Commands - Two Things Specify data interested in - Indicate the ________
Flat File
Hardware
Information
accident
4. Individuals that use - manipulate or maintain aspects of database
Inner SELECT query
Users
MIN
End Users
5. Executes commands one at a time - results being displayed immediately
BETWEEN
Functions
Negation Operator
Interactive SQL
6. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Persistent
UPDATE
Performance
7. Deletes selected rows
*
DELETE
Persistent
Comparison Operators
8. Everything between the start and end tag
Closing tag
Element Content
HAVING
Opening tag
9. Software system designed to support interface for a software asset that manages a specific set of tasks
Web Browser
Service-Oriented Architecture (SOA)
Service Provider
Indexes
10. Finds the lowest constant value in a column
MAX
Web Browser
Data Manipulation
Web Service
11. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Web server
Inner SELECT query
Session
12. Ensures functions are done efficiently
DISTINCT
Database Management Systems (DBMS)
Performance
Fields
13. Changes the values in one or more selected rows of a table
SUM
Service Provider
Tags
UPDATE
14. Deletes selected rows
Service Broker
Data Dictionary
DELETE
single value
15. 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.
Performance
Word
ASC
Candidate Keys
16. Combines rows from a SELECT statements result table into a group
UPDATE
GROUP BY
Tables
Primary Keys
17. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Service Requestor
Bind
Fields
Negation Operator
18. One of the tools that SQL uses to find and retrieve data.
Session
Hypertext Markup Language (HTML)
Indexes
Service-Oriented Architecture (SOA)
19. Ensures functions are done efficiently
WHERE
Performance
to update
Aliases
20. Attribute in quotes
Database
Negation Operator
Property
Web Service
21. Concatenated in SQL Server Database software using the addition symbol
Functions
Fields
Integrated
Views
22. Begins an element
Outer SELECT query
MAX
Opening tag
Data Definition
23. Compares value of the column in the specified condition with the value specified
Data Definition
MIN
Equals Operator
LIKE
24. Identifies columns to appear in the result
Web Service
Data Elements
Web Browser
SELECT
25. Identifies columns to appear in the result
Shared
American Standard Code for Information Interchange (ASCII)
SELECT
GROUP BY
26. Limits the output of the established groups into the derived result table
Application Programmers
Word
HAVING
Negation Operator
27. Allows data recovery in case of corruption or loss
Interactive SQL
Web server
Data Recovery & Concurrance
Shared
28. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Web Browser
End Users
Stateless
29. Data that has been processed into a format that is understandable by its audience
Application Programers
Information
Property
DISTINCT
30. Characterizes operation of a relational database
American Standard Code for Information Interchange (ASCII)
Joins
Database Management Systems (DBMS)
Views
31. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
HAVING
Application Programers
Service Broker
ORDER BY
32. Data stored by DAd
Opening tag
Data Elements
*
Fields
33. Browser requests page - code is delivered - executed and done with
Data Elements
Dynamic
Scripting
Candidate Keys
34. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Fields
Flat File
Aliases
Data Recovery & Concurrance
35. Large structured set of persistent data
Data Elements
IN
Database
sp_help
36. Join a table to a copy of itself
Precedence of Logical Operators
Opening tag
Service Broker
Self Join
37. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
IN
Data Elements
single value
Data Recovery & Concurrance
38. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
Self Join
SUM
Session
Hardware
39. SQL Commands: Define tables - views - _____ - delete or insert info
sp_help
Functions
DISTINCT
to update
40. Straight implementation of raw data formatted into rows and columns
Shared
Comparison Operators
Flat File
Data Manipulation
41. SELECT statment containing the nested query
Views
Outer SELECT query
SUM
Data Definition
42. Grant acces and control to only specific information
Views
Central Control of data
Integrated
ORDER BY
43. Averages the numeric values
American Standard Code for Information Interchange (ASCII)
Tags
Service Broker
AVG
44. Text markups that form an element" sort of a "box" to hold things like text and other elements
Structured Query Language (SQL)
Hypertext Markup Language (HTML)
Scripting
Tags
45. Table displayed in descending order
ESC
Web Service
Service-Oriented Architecture (SOA)
to update
46. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
to update
Hardware
Negation Operator
47. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Bind
Hardware
Fields
LIKE
48. Used with another comparison operator - values become inverted
Indexes
Negation Operator
Equals Operator
IN
49. Limits the output of the established groups into the derived result table
Self Join
Aliases
End Users
HAVING
50. Selects from specific values in list
Closing tag
Structured Query Language (SQL)
Report
IN
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