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. Browser requests page - code is delivered - executed and done with
Data Administrator (DAd)
Cookie
Dynamic
hidden fields
2. 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
Subquery
Indexes
Flat File
Session
3. Ongoing record of data reflecting the info defining the database
Data Dictionary
Negation Operator
accident
Query
4. Cookies are more secure than______ - allowing travel on a website without loss of info
sp_help
Inner SELECT query
hidden fields
FROM
5. Decides what data is stored in the databse and the manner it is stored
single value
Data
SUM
Data Administrator (DAd)
6. Data stored by DAd
Database Management Systems (DBMS)
Data Elements
Hypertext Markup Language (HTML)
Performance
7. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
single value
Tags
UPDATE
8. Change order of rows in result table
Data Elements
Service-Oriented Architecture (SOA)
Web server
ORDER BY
9. Ensures functions are done efficiently
Performance
NOT
SELECT
Bind
10. Finds the lowest constant value in a column
MAX
Database Management Systems (DBMS)
Aliases
Data Recovery & Concurrance
11. Responsible for technical implementation & maintenance of database on a design & physical level
DISTINCT
Web Service
Database Administrator (DBA)
Hardware
12. Defines a new column
Service Broker
Calculated Column
Subquery
Stateless
13. Command based way to ask the database a question
Data
Interactive SQL
American Standard Code for Information Interchange (ASCII)
Query
14. 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
Comparison Operators
Calculated Column
SUM
Session
15. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Calculated Column
Stateless
Empty Elements
single value
16. Columns containing numbers only
ORDER BY
hidden fields
SUM
HAVING
17. Everything between the start and end tag
Query
Element Content
Views
hidden fields
18. Begins an element
Opening tag
UPDATE
Data Elements
Report
19. Command based way to ask the database a question
DISTINCT
Data Dictionary
Web Service
Query
20. Averages the numeric values
Data Manipulation
AVG
BETWEEN
Database Administrator (DBA)
21. Join a table to a copy of itself
Self Join
Word
Database
Service Broker
22. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Service-Oriented Architecture (SOA)
Central Control of data
Report
Structured Query Language (SQL)
23. Individuals that use - manipulate or maintain aspects of database
Negation Operator
Data Elements
Users
Property
24. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.
Primary Keys
Self Join
GROUP BY
Aliases
25. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Tables
Data Manipulation
Database
Central Control of data
26. Used with another comparison operator - values become inverted
Central Control of data
UPDATE
Negation Operator
Empty Elements
27. Data stored by DAd
Object-Oriented Relational (OOR)
SUM
Negation Operator
Data Elements
28. Most valuable asset of a database system.
Central control of data
Database
DISTINCT
Tables
29. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Web server
Tables
Data Administrator (DAd)
to update
30. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
INSERT INTO
Empty Elements
Web Applications
hidden fields
31. Deletes selected rows
WHERE
DELETE
Relational
Opening tag
32. Selects from specific values in list
American Standard Code for Information Interchange (ASCII)
Users
Aggregate Functions
IN
33. SELECT statment containing the nested query
Outer SELECT query
*
Embedded SQL
Hierarchial
34. Used to combine one query with another.
Application Programmers
MAX
Subquery
MIN
35. Practice of writing code into a webpage that is not directly visible to the user
AVG
Scripting
*
Report
36. Finds the lowest constant value in a column
Service Provider
Self Join
MAX
accident
37. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
FROM
Cookie
Attributes
38. Writes programs that use or allow acces to databse with specific purpose
Users
Application Programmers
Database Management Systems (DBMS)
Application Programers
39. Describe information in a tree styled format
Service Broker
Data Administrator (DAd)
Data Elements
Hierarchial
40. Individuals that use - manipulate or maintain aspects of database
Users
Element Content
Hierarchial
MAX
41. Compares value of the column in the specified condition with the value specified
Views
Equals Operator
Persistent
Calculated Column
42. Used with another comparison operator - values become inverted
Service-Oriented Architecture (SOA)
Negation Operator
Object-Oriented Relational (OOR)
MIN
43. Give the browser more specific information about that tag
LIKE
Attributes
Web Applications
Application Programers
44. Used to remove duplicates from result table
Scripting
LIKE
Performance
DISTINCT
45. Data in database has ability to be accessed and manipulated by several users
Data Dictionary
Data Manipulation
Shared
BETWEEN
46. Grant acces and control to only specific information
Service-Oriented Architecture (SOA)
Views
Service Broker
Data Administrator (DAd)
47. Ongoing record of data reflecting the info defining the database
ALL
Bind
Application Programers
Data Dictionary
48. Basic Component of SQL
IN
Tables
SUM
Word
49. Join a table to a copy of itself
Central control of data
Self Join
Element Content
Calculated Column
50. Looks like opening tag - but with a forward slash
Closing tag
Precedence of Logical Operators
Outer SELECT query
Data
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