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. Large structured set of persistent data
Hardware
Dynamic
Negation Operator
Database
2. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Flat File
hidden fields
Web server
3. Attribute in quotes
Equals Operator
hidden fields
Functions
Property
4. Copies multiple records at the same time using a SELECT statement
ESC
Flat File
Inner SELECT query
INSERT INTO
5. Interact and manipulates the data in the database
single value
Self Join
American Standard Code for Information Interchange (ASCII)
Data Manipulation
6. Data that has been processed into a format that is understandable by its audience
Functions
Information
Data Administrator (DAd)
Hierarchial
7. Identifies columns to appear in the result
End Users
GROUP BY
MAX
SELECT
8. Browser requests page - code is delivered - executed and done with
hidden fields
Session
Dynamic
single value
9. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Data Elements
Aliases
Service Provider
SUM
10. 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
Attributes
Dynamic
UPDATE
11. Allow useres to retrieve data and interact with content located on web pages within website
MAX
Hypertext Markup Language (HTML)
Service Provider
Web Browser
12. Responsible for technical implementation & maintenance of database on a design & physical level
Views
Database Administrator (DBA)
Data
Application Programers
13. Individuals that use - manipulate or maintain aspects of database
FROM
Users
GROUP BY
Candidate Keys
14. Used with another comparison operator - values become inverted
Relational
Negation Operator
Functions
DISTINCT
15. Ensures functions are done efficiently
Word
NOT
DELETE
Performance
16. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Central Control of data
Structured Query Language (SQL)
MAX
Forward Slash
17. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Data Elements
Bind
Session
Data Manipulation
18. Meaningful info related to database
Calculated Column
Data Recovery & Concurrance
HAVING
Data
19. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Information
Service Broker
Object-Oriented Relational (OOR)
20. Finds the lowest ACII value in column
accident
MIN
Persistent
Attributes
21. Specifies the tables or views from which rows and columns are retrieved
FROM
accident
GROUP BY
MAX
22. Used to remove duplicates from result table
DISTINCT
FROM
Web Browser
BETWEEN
23. Limits the output of the established groups into the derived result table
HAVING
Web Browser
Performance
Database Management Systems (DBMS)
24. All Columns indicated and selected
AVG
HAVING
Interactive SQL
*
25. Essentially a collection of services that communicate with eachother
LIKE
*
Service-Oriented Architecture (SOA)
Tables
26. Allow useres to retrieve data and interact with content located on web pages within website
SUM
Database Management Systems (DBMS)
Aggregate Functions
Web Browser
27. Meaningful info related to database
Web Service
Data
SUM
Aliases
28. Join a table to a copy of itself
Query
Calculated Column
INSERT INTO
Self Join
29. Uses relationships between independent entities
AVG
Public Key Infrastructure (PKI)
Structured Query Language (SQL)
Relational
30. Text markups that form an element" sort of a "box" to hold things like text and other elements
Opening tag
Tables
Tags
Outer SELECT query
31. Combines rows from a SELECT statements result table into a group
Central Control of data
GROUP BY
Tables
Embedded SQL
32. Closed in the start tag by adding a slash to the start tag
Empty Elements
Structured Query Language (SQL)
Service-Oriented Architecture (SOA)
NOT
33. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Data
Web Applications
ESC
WHERE
34. Straight implementation of raw data formatted into rows and columns
Flat File
Outer SELECT query
GROUP BY
American Standard Code for Information Interchange (ASCII)
35. Data in database has ability to be accessed and manipulated by several users
Flat File
SUM
Shared
Views
36. Create program files that include SQ after each command
Indexes
Hierarchial
Information
Embedded SQL
37. Software system designed to support interface for a software asset that manages a specific set of tasks
to update
ASC
Service Provider
Dynamic
38. Columns containing numbers only
ESC
Precedence of Logical Operators
SUM
Self Join
39. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Empty Elements
Stateless
Hypertext Markup Language (HTML)
Precedence of Logical Operators
40. Some form of output - usually - printed - containing information
Report
COUNT
Tags
Equals Operator
41. Limits the rows that appear in the result mathcing a specified condition
Outer SELECT query
WHERE
IN
single value
42. Finds the lowest constant value in a column
MAX
Subqueries
Primary Keys
COUNT
43. Change order of rows in result table
MAX
Cookie
ORDER BY
Tables
44. Used to combine one query to another
Subqueries
Query
UPDATE
American Standard Code for Information Interchange (ASCII)
45. Some form of output - usually - printed - containing information
Relational
NOT
Service Requestor
Report
46. One huge database to hold all data; Access to data - and use of system to add - update & print records
Performance
Opening tag
Database Management Systems (DBMS)
Service Provider
47. Allows use of single or multiple character wildcards with the underscore or percent symbol
Flat File
LIKE
FROM
Database
48. Defines a new column
Joins
WHERE
*
Calculated Column
49. Finds the lowest ACII value in column
Tables
MIN
Web Service
Service Broker
50. Tally of how many rows meet criteria specified
SELECT
Query
Service Provider
COUNT
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