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. Limits the output of the established groups into the derived result table
Data Dictionary
HAVING
Closing tag
SELECT
2. 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)
Service Provider
End Users
single value
3. Using product as intended for its audience
End Users
Opening tag
to update
Bind
4. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
Opening tag
Structured Query Language (SQL)
DELETE
5. Some form of output - usually - printed - containing information
Report
COUNT
DISTINCT
Tags
6. Large structured set of persistent data
SUM
Database
Attributes
DELETE
7. Defines a new column
Object-Oriented Relational (OOR)
Flat File
Calculated Column
ASC
8. Using product as intended for its audience
End Users
Information
Shared
ALL
9. Compares value of the column in the specified condition with the value specified
MAX
Word
Equals Operator
Closing tag
10. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
NOT
WHERE
Functions
11. Ongoing record of data reflecting the info defining the database
Data Dictionary
DELETE
Session
FROM
12. Text markups that form an element" sort of a "box" to hold things like text and other elements
Data Recovery & Concurrance
Tags
Users
Inner SELECT query
13. Defines a new column
Negation Operator
Calculated Column
Service Requestor
Application Programers
14. Tally of how many rows meet criteria specified
COUNT
Web Browser
Scripting
Web Browser
15. Software system designed to support interface for a software asset that manages a specific set of tasks
HAVING
DISTINCT
Service Provider
Joins
16. Command based way to ask the database a question
DISTINCT
Report
Query
Data Recovery & Concurrance
17. Browser requests page - code is delivered - executed and done with
ORDER BY
Query
DELETE
Dynamic
18. Grant acces and control to only specific information
Views
Forward Slash
Performance
Object-Oriented Relational (OOR)
19. SQL finds and retrieves date
Indexes
Web Applications
Flat File
hidden fields
20. Uses two values as limits - selecting any values between the two of them
UPDATE
BETWEEN
Cookie
Database Administrator (DBA)
21. Everything in enviroment becomes an object - expands on Priniples of relational databases
Tags
Object-Oriented Relational (OOR)
Database Management Systems (DBMS)
to update
22. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Database Management Systems (DBMS)
Foreign Keys
Negation Operator
Web server
23. Attribute in quotes
Persistent
DELETE
Property
Integrated
24. Changes the values in one or more selected rows of a table
Subqueries
Equals Operator
UPDATE
Service Provider
25. Interact and manipulates the data in the database
Data Elements
ALL
Web Applications
Data Manipulation
26. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Tables
Application Programmers
Web Service
27. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Candidate Keys
Tags
Functions
IN
28. Finds the lowest constant value in a column
ESC
Primary Keys
MAX
Inner SELECT query
29. Finds the lowest ACII value in column
Joins
single value
MIN
Functions
30. Data remains unchanged in database
Persistent
Service Broker
accident
Relational
31. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Service-Oriented Architecture (SOA)
NOT
Hierarchial
32. Flat File Examples: Excel Spreadsheets - _____
Word
Web server
Service-Oriented Architecture (SOA)
sp_help
33. Uses relationships between independent entities
Calculated Column
Relational
SUM
Subqueries
34. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Attributes
Cookie
Hypertext Markup Language (HTML)
Service Broker
35. Straight implementation of raw data formatted into rows and columns
Flat File
Persistent
Data
ORDER BY
36. Tally of how many rows meet criteria specified
COUNT
Comparison Operators
Indexes
Embedded SQL
37. Used to combine one query to another
to update
Subqueries
Information
UPDATE
38. Join a table to a copy of itself
Indexes
Self Join
GROUP BY
Attributes
39. File stored on a user's machine that contains infor about application
Bind
Aliases
Cookie
Data Definition
40. Copies multiple records at the same time using a SELECT statement
hidden fields
End Users
INSERT INTO
Calculated Column
41. Data in database interacts & corresponds with other data
Integrated
BETWEEN
Tags
DISTINCT
42. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
ORDER BY
BETWEEN
Self Join
43. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
BETWEEN
SELECT
Central Control of data
Web Service
44. Software system designed to support interface for a software asset that manages a specific set of tasks
WHERE
Element Content
Service Provider
Joins
45. Closed in the start tag by adding a slash to the start tag
Database Management Systems (DBMS)
Users
Dynamic
Empty Elements
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
Flat File
Service Requestor
End Users
47. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Database Administrator (DBA)
Bind
Hardware
48. Looks like opening tag - but with a forward slash
Foreign Keys
Closing tag
DISTINCT
Persistent
49. Concatenated in SQL Server Database software using the addition symbol
Inner SELECT query
Property
Fields
INSERT INTO
50. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
HAVING
Web server
HAVING
*
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