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. Grant acces and control to only specific information
Word
Views
Aggregate Functions
SELECT
2. Definition of commands it can do
Data Definition
ESC
Property
Database
3. Table displayed in descending order
Interactive SQL
Functions
Aliases
ESC
4. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Service Requestor
Web server
INSERT INTO
Tables
5. Used in a SELECT clause in place of a column
Service Broker
Cookie
Aggregate Functions
to update
6. Finds the lowest ACII value in column
SELECT
*
Web server
MIN
7. Used with another comparison operator - values become inverted
Negation Operator
Tags
Empty Elements
Web server
8. Finds the lowest constant value in a column
Central Control of data
MAX
COUNT
ORDER BY
9. Large structured set of persistent data
Views
Calculated Column
Database
Integrated
10. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
ESC
ASC
ORDER BY
11. Command used to show the attributes that define a table.
GROUP BY
ALL
sp_help
Functions
12. = - < - > - <= - >= - <> - !
Application Programers
Views
Relational
Comparison Operators
13. Change order of rows in result table
ORDER BY
Web Service
hidden fields
Service Requestor
14. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Embedded SQL
Functions
Functions
Web Applications
15. Used in a SELECT clause in place of a column
Data Manipulation
Aggregate Functions
ORDER BY
Web server
16. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Web Applications
Relational
Data
17. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Query
Web Service
INSERT INTO
18. Software system designed to support interoperable machine - to - machine interaction over a network
Web Service
Shared
MAX
DELETE
19. Flat File Examples: Excel Spreadsheets - _____
Tables
Word
Central Control of data
Attributes
20. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Views
Session
Central Control of data
BETWEEN
21. Grant acces and control to only specific information
MIN
ALL
Views
Service Requestor
22. Ensures functions are done efficiently
Service Provider
Performance
Word
Negation Operator
23. Concatenated in SQL Server Database software using the addition symbol
Fields
Information
Data Definition
AVG
24. Uses two values as limits - selecting any values between the two of them
BETWEEN
Inner SELECT query
HAVING
Persistent
25. Allows use of single or multiple character wildcards with the underscore or percent symbol
Performance
LIKE
Attributes
Service Broker
26. 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
COUNT
Session
WHERE
ORDER BY
27. Begins an element
Information
Opening tag
Application Programmers
hidden fields
28. Compares value of the column in the specified condition with the value specified
NOT
Equals Operator
SUM
IN
29. Data remains unchanged in database
Persistent
Element Content
Relational
GROUP BY
30. Executes commands one at a time - results being displayed immediately
Interactive SQL
Primary Keys
MIN
DISTINCT
31. Network node that discovers and invokes other software services to provide a buisness solution
MAX
Service-Oriented Architecture (SOA)
single value
Service Requestor
32. Defines a new column
Session
Hypertext Markup Language (HTML)
Calculated Column
Relational
33. = - < - > - <= - >= - <> - !
Comparison Operators
American Standard Code for Information Interchange (ASCII)
UPDATE
to update
34. Looks like opening tag - but with a forward slash
Relational
Outer SELECT query
Closing tag
Query
35. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
COUNT
Functions
Candidate Keys
GROUP BY
36. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Scripting
Fields
Bind
ORDER BY
37. Change order of rows in result table
Report
ORDER BY
DELETE
Outer SELECT query
38. Limits the output of the established groups into the derived result table
Embedded SQL
Data Definition
HAVING
Users
39. Ongoing record of data reflecting the info defining the database
Views
Data Dictionary
Bind
LIKE
40. All Columns indicated and selected
Word
Web server
Users
*
41. Changes the values in one or more selected rows of a table
AVG
SELECT
Functions
UPDATE
42. Uses relationships between independent entities
BETWEEN
Query
Precedence of Logical Operators
Relational
43. One huge database to hold all data; Access to data - and use of system to add - update & print records
Integrated
Database Management Systems (DBMS)
Database Administrator (DBA)
NOT
44. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Empty Elements
Negation Operator
to update
45. Meaningful info related to database
SUM
Attributes
Data
Joins
46. SQL Commands - Two Things Specify data interested in - Indicate the ________
AVG
Opening tag
accident
Object-Oriented Relational (OOR)
47. Characterizes operation of a relational database
Hypertext Markup Language (HTML)
Performance
Data Administrator (DAd)
Joins
48. Concatenated in SQL Server Database software using the addition symbol
DELETE
Fields
DELETE
Hierarchial
49. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
UPDATE
Application Programers
Property
50. Writes programs that use or allow acces to databse with specific purpose
Inner SELECT query
Subqueries
to update
Application Programers
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