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. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Persistent
Indexes
SUM
Service Provider
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)
LIKE
Web Service
Data Elements
3. Allow useres to retrieve data and interact with content located on web pages within website
Attributes
Web Browser
Indexes
Data Definition
4. Definition of commands it can do
Precedence of Logical Operators
Service-Oriented Architecture (SOA)
Service Broker
Data Definition
5. Columns containing numbers only
Public Key Infrastructure (PKI)
SUM
COUNT
Database Management Systems (DBMS)
6. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Bind
ALL
Persistent
Word
7. Software system designed to support interoperable machine - to - machine interaction over a network
ASC
End Users
Web Service
Shared
8. File stored on a user's machine that contains infor about application
Element Content
Flat File
Cookie
Opening tag
9. Compares value of the column in the specified condition with the value specified
Word
Database Administrator (DBA)
Negation Operator
Equals Operator
10. Cookies are more secure than______ - allowing travel on a website without loss of info
Negation Operator
Service-Oriented Architecture (SOA)
hidden fields
Hierarchial
11. Fields in a relational table that match the primary key from one column to the primary key of another table.
Indexes
Integrated
Data Recovery & Concurrance
Foreign Keys
12. Flat File Examples: Excel Spreadsheets - _____
Data Recovery & Concurrance
Web Browser
SELECT
Word
13. SELECT statment containing the nested query
Service Broker
Primary Keys
Forward Slash
Outer SELECT query
14. Responsible for technical implementation & maintenance of database on a design & physical level
Element Content
Database Administrator (DBA)
Subqueries
Web Browser
15. Ensures data is correct casings
Data
Functions
American Standard Code for Information Interchange (ASCII)
DISTINCT
16. Averages the numeric values
hidden fields
AVG
Web Browser
Web Browser
17. Meaningful info related to database
Data Definition
Aggregate Functions
Data Administrator (DAd)
Data
18. Closed in the start tag by adding a slash to the start tag
Empty Elements
Inner SELECT query
Data Recovery & Concurrance
Data Manipulation
19. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
SELECT
Property
single value
Aliases
20. Large structured set of persistent data
American Standard Code for Information Interchange (ASCII)
Database
Empty Elements
Integrated
21. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
hidden fields
NOT
Structured Query Language (SQL)
Web server
22. Join a table to a copy of itself
*
Self Join
Web server
Data Recovery & Concurrance
23. Individuals that use - manipulate or maintain aspects of database
Users
Data Elements
Aggregate Functions
Tables
24. Limits the rows that appear in the result mathcing a specified condition
Primary Keys
WHERE
accident
*
25. Data in database interacts & corresponds with other data
SELECT
Integrated
Hardware
Subqueries
26. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Database Management Systems (DBMS)
WHERE
Comparison Operators
27. Uses relationships between independent entities
Relational
Persistent
Embedded SQL
Data Elements
28. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Application Programmers
Dynamic
FROM
Service Requestor
29. Writes programs that use or allow acces to databse with specific purpose
Application Programers
Views
Stateless
Service Broker
30. Columns containing numbers only
Inner SELECT query
Service-Oriented Architecture (SOA)
Subqueries
SUM
31. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Indexes
Data Manipulation
Aliases
32. Meaningful info related to database
Data
ASC
Data Manipulation
Integrated
33. Create program files that include SQ after each command
INSERT INTO
Bind
Data
Embedded SQL
34. Characterizes operation of a relational database
Cookie
Data
Persistent
Joins
35. Order in which WHERE clause is evaluated and combined
Precedence of Logical Operators
Persistent
SUM
Application Programers
36. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Persistent
ALL
Web Browser
Candidate Keys
37. Change order of rows in result table
AVG
ORDER BY
IN
ALL
38. One huge database to hold all data; Access to data - and use of system to add - update & print records
Data
Word
INSERT INTO
Database Management Systems (DBMS)
39. Describe information in a tree styled format
Hierarchial
Web Service
Subquery
Subqueries
40. Uses two values as limits - selecting any values between the two of them
WHERE
Indexes
INSERT INTO
BETWEEN
41. Command used to show the attributes that define a table.
sp_help
Calculated Column
UPDATE
Embedded SQL
42. Finds the lowest constant value in a column
MAX
Public Key Infrastructure (PKI)
BETWEEN
to update
43. Command based way to ask the database a question
Empty Elements
Attributes
Query
Foreign Keys
44. Executes commands one at a time - results being displayed immediately
Service Requestor
Interactive SQL
Indexes
Property
45. Command based way to ask the database a question
Relational
Hierarchial
Data Administrator (DAd)
Query
46. Everything between the start and end tag
INSERT INTO
Element Content
SUM
Central Control of data
47. Supplies value for the search condition of the SELECT statement containing it
Negation Operator
Central control of data
Web server
Inner SELECT query
48. One of the tools that SQL uses to find and retrieve data.
ASC
Indexes
Central Control of data
Aliases
49. Writes programs that use or allow acces to databse with specific purpose
Data Administrator (DAd)
Data Manipulation
Application Programers
MAX
50. Used in a SELECT clause in place of a column
Structured Query Language (SQL)
Hypertext Markup Language (HTML)
Users
Aggregate Functions
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