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. Flat File Examples: Excel Spreadsheets - _____
Empty Elements
Word
Data Definition
LIKE
2. Defines a new column
Data Recovery & Concurrance
Subqueries
Calculated Column
Indexes
3. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Relational
American Standard Code for Information Interchange (ASCII)
Performance
4. Ongoing record of data reflecting the info defining the database
Data Dictionary
Scripting
Query
Web Browser
5. Order in which WHERE clause is evaluated and combined
DISTINCT
Service-Oriented Architecture (SOA)
Precedence of Logical Operators
accident
6. Uses two values as limits - selecting any values between the two of them
Outer SELECT query
sp_help
Functions
BETWEEN
7. Some form of output - usually - printed - containing information
Calculated Column
Report
FROM
Database
8. Interact and manipulates the data in the database
Data Manipulation
Empty Elements
IN
Views
9. Executes commands one at a time - results being displayed immediately
Word
Embedded SQL
to update
Interactive SQL
10. SQL Commands: Define tables - views - _____ - delete or insert info
to update
MAX
MIN
Views
11. Ensures data is correct casings
American Standard Code for Information Interchange (ASCII)
Service Provider
Empty Elements
Data Elements
12. Grant acces and control to only specific information
DELETE
Subqueries
Views
INSERT INTO
13. Meaningful info related to database
Subqueries
NOT
WHERE
Data
14. SQL finds and retrieves date
Query
SUM
Indexes
Stateless
15. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Comparison Operators
Joins
Calculated Column
Structured Query Language (SQL)
16. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Report
Data Administrator (DAd)
Service Broker
Structured Query Language (SQL)
17. Table displayed in descending order
ESC
Data Administrator (DAd)
Report
Self Join
18. Create program files that include SQ after each command
WHERE
Embedded SQL
Calculated Column
Functions
19. Has the highest precedence - followed by the AND - OR
DISTINCT
to update
NOT
Service Requestor
20. Used in a SELECT clause in place of a column
Aggregate Functions
SELECT
Dynamic
LIKE
21. Concatenated in SQL Server Database software using the addition symbol
Service Requestor
Data
FROM
Fields
22. Characterizes operation of a relational database
Subquery
to update
Joins
Dynamic
23. Used to remove duplicates from result table
Shared
ORDER BY
DISTINCT
Service Broker
24. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Service-Oriented Architecture (SOA)
MAX
single value
ALL
25. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
SUM
Inner SELECT query
Service-Oriented Architecture (SOA)
26. Table displayed in ascending order
Query
Comparison Operators
DISTINCT
ASC
27. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Tags
Element Content
Web Browser
Hypertext Markup Language (HTML)
28. Interact and manipulates the data in the database
Data Manipulation
Property
Shared
Outer SELECT query
29. Data in database has ability to be accessed and manipulated by several users
Shared
Negation Operator
Inner SELECT query
Session
30. Characterizes operation of a relational database
Joins
Data Administrator (DAd)
NOT
Database Management Systems (DBMS)
31. Create program files that include SQ after each command
ASC
Shared
Embedded SQL
Application Programmers
32. Data that has been processed into a format that is understandable by its audience
COUNT
Element Content
*
Information
33. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Relational
Application Programers
Word
34. Used in a SELECT clause in place of a column
Aggregate Functions
hidden fields
GROUP BY
Element Content
35. Decides what data is stored in the databse and the manner it is stored
Calculated Column
Data Administrator (DAd)
HAVING
Stateless
36. One huge database to hold all data; Access to data - and use of system to add - update & print records
Flat File
WHERE
Database Management Systems (DBMS)
DELETE
37. Data stored by DAd
Data Administrator (DAd)
Word
SELECT
Data Elements
38. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Web Service
Service Broker
Application Programmers
Report
39. Order in which WHERE clause is evaluated and combined
ALL
End Users
Data Recovery & Concurrance
Precedence of Logical Operators
40. Averages the numeric values
AVG
single value
Data Elements
INSERT INTO
41. 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
Session
Data
SELECT
Service-Oriented Architecture (SOA)
42. SQL Commands - Two Things Specify data interested in - Indicate the ________
Central control of data
Element Content
Interactive SQL
accident
43. SQL Commands: Define tables - views - _____ - delete or insert info
ASC
to update
Dynamic
Flat File
44. Supplies value for the search condition of the SELECT statement containing it
Empty Elements
Fields
Session
Inner SELECT query
45. Definition of commands it can do
Data Elements
AVG
Data Definition
UPDATE
46. Finds the lowest ACII value in column
SUM
Calculated Column
ALL
MIN
47. Flat File Examples: Excel Spreadsheets - _____
Shared
Central Control of data
Dynamic
Word
48. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Data Elements
SELECT
IN
49. Join a table to a copy of itself
Negation Operator
ASC
Self Join
Attributes
50. Deletes selected rows
Data Elements
DELETE
Functions
Application Programers
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