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. Allow useres to retrieve data and interact with content located on web pages within website
Stateless
Web Browser
GROUP BY
ASC
2. Used in a SELECT clause in place of a column
Foreign Keys
Service Requestor
Persistent
Aggregate Functions
3. Changes the values in one or more selected rows of a table
UPDATE
Public Key Infrastructure (PKI)
Integrated
Self Join
4. Basic Component of SQL
NOT
Element Content
Structured Query Language (SQL)
Tables
5. Browser requests page - code is delivered - executed and done with
Query
Dynamic
MAX
DELETE
6. Grant acces and control to only specific information
Functions
Closing tag
Views
Session
7. Everything between the start and end tag
hidden fields
Integrated
Database
Element Content
8. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Subquery
Dynamic
Persistent
single value
9. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service-Oriented Architecture (SOA)
Users
Service Broker
Data
10. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Flat File
Application Programmers
MAX
Interactive SQL
11. Ongoing record of data reflecting the info defining the database
Data Dictionary
Data Elements
Data Recovery & Concurrance
Subqueries
12. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Stateless
SUM
Public Key Infrastructure (PKI)
Scripting
13. Writes programs that use or allow acces to databse with specific purpose
Application Programers
COUNT
Cookie
Object-Oriented Relational (OOR)
14. One of the tools that SQL uses to find and retrieve data.
Session
Indexes
Web Service
ALL
15. Tally of how many rows meet criteria specified
*
Word
COUNT
Shared
16. Essentially a collection of services that communicate with eachother
Integrated
Outer SELECT query
Embedded SQL
Service-Oriented Architecture (SOA)
17. Most valuable asset of a database system.
Self Join
Subqueries
Central control of data
INSERT INTO
18. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
accident
Data Elements
Empty Elements
19. Used to combine one query to another
Data Manipulation
Subqueries
WHERE
Opening tag
20. 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
accident
Object-Oriented Relational (OOR)
MIN
21. Interact and manipulates the data in the database
Self Join
hidden fields
Tables
Data Manipulation
22. Software system designed to support interoperable machine - to - machine interaction over a network
Information
Web Service
Database
End Users
23. Closed in the start tag by adding a slash to the start tag
Empty Elements
Calculated Column
ASC
ASC
24. Used to combine one query to another
Subqueries
COUNT
Object-Oriented Relational (OOR)
NOT
25. Decides what data is stored in the databse and the manner it is stored
hidden fields
Object-Oriented Relational (OOR)
Data Administrator (DAd)
Self Join
26. Order in which WHERE clause is evaluated and combined
AVG
ASC
Query
Precedence of Logical Operators
27. Finds the lowest constant value in a column
Hierarchial
LIKE
MAX
Data Elements
28. Looks like opening tag - but with a forward slash
Closing tag
Data Definition
GROUP BY
Data Recovery & Concurrance
29. One huge database to hold all data; Access to data - and use of system to add - update & print records
Database Management Systems (DBMS)
Tables
hidden fields
ASC
30. Columns containing numbers only
SUM
IN
Persistent
Property
31. = - < - > - <= - >= - <> - !
Scripting
Comparison Operators
Information
Persistent
32. Data remains unchanged in database
Persistent
Central Control of data
Indexes
Functions
33. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
WHERE
AVG
SUM
FROM
34. Some form of output - usually - printed - containing information
Interactive SQL
Aggregate Functions
Report
Central control of data
35. Change order of rows in result table
Tags
NOT
Precedence of Logical Operators
ORDER BY
36. Finds the lowest constant value in a column
MAX
Web Applications
Object-Oriented Relational (OOR)
Opening tag
37. Give the browser more specific information about that tag
DELETE
Attributes
AVG
FROM
38. Individuals that use - manipulate or maintain aspects of database
Interactive SQL
Users
MAX
INSERT INTO
39. Closed in the start tag by adding a slash to the start tag
Equals Operator
Data Elements
American Standard Code for Information Interchange (ASCII)
Empty Elements
40. Compares value of the column in the specified condition with the value specified
Users
SELECT
Equals Operator
Outer SELECT query
41. Ongoing record of data reflecting the info defining the database
Subqueries
Integrated
MAX
Data Dictionary
42. Executes commands one at a time - results being displayed immediately
Scripting
Report
AVG
Interactive SQL
43. Defines a new column
single value
Calculated Column
Tags
Session
44. Create program files that include SQ after each command
Scripting
Views
Embedded SQL
Central control of data
45. Network node that discovers and invokes other software services to provide a buisness solution
Indexes
Tags
Service Requestor
hidden fields
46. Ensures functions are done efficiently
AVG
sp_help
Joins
Performance
47. Command based way to ask the database a question
Query
Flat File
HAVING
Element Content
48. Used with another comparison operator - values become inverted
Interactive SQL
Application Programers
Embedded SQL
Negation Operator
49. 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.
Report
UPDATE
Candidate Keys
Subqueries
50. Combines rows from a SELECT statements result table into a group
Word
End Users
GROUP BY
Relational
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