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. Columns containing numbers only
Structured Query Language (SQL)
SUM
Views
American Standard Code for Information Interchange (ASCII)
2. Allows use of single or multiple character wildcards with the underscore or percent symbol
*
LIKE
Attributes
Precedence of Logical Operators
3. Identifies columns to appear in the result
SELECT
Flat File
UPDATE
DELETE
4. Selects from specific values in list
Inner SELECT query
IN
MAX
DISTINCT
5. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
*
Persistent
Hypertext Markup Language (HTML)
SELECT
6. Deletes selected rows
DELETE
IN
FROM
Report
7. Command used to show the attributes that define a table.
sp_help
ALL
Indexes
Inner SELECT query
8. Used to combine one query to another
Inner SELECT query
*
ORDER BY
Subqueries
9. Join a table to a copy of itself
Word
Self Join
ESC
Data Dictionary
10. Meaningful info related to database
Users
Object-Oriented Relational (OOR)
Data
to update
11. Changes the values in one or more selected rows of a table
UPDATE
DELETE
COUNT
Service Provider
12. Grant acces and control to only specific information
Hypertext Markup Language (HTML)
GROUP BY
Views
Hierarchial
13. File stored on a user's machine that contains infor about application
INSERT INTO
Subqueries
FROM
Cookie
14. One huge database to hold all data; Access to data - and use of system to add - update & print records
Fields
SUM
ALL
Database Management Systems (DBMS)
15. Copies multiple records at the same time using a SELECT statement
INSERT INTO
NOT
GROUP BY
ESC
16. Cookies are more secure than______ - allowing travel on a website without loss of info
Database Administrator (DBA)
Information
hidden fields
Shared
17. Finds the lowest ACII value in column
Inner SELECT query
MIN
Web Service
Flat File
18. Most valuable asset of a database system.
Empty Elements
Data Recovery & Concurrance
Central control of data
Scripting
19. One huge database to hold all data; Access to data - and use of system to add - update & print records
Comparison Operators
Database Management Systems (DBMS)
Session
Empty Elements
20. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Data Dictionary
Object-Oriented Relational (OOR)
Aliases
Data
21. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Database
LIKE
Service Requestor
ALL
22. Change order of rows in result table
ORDER BY
Database Management Systems (DBMS)
Word
Tags
23. Browser requests page - code is delivered - executed and done with
Aliases
Dynamic
Hypertext Markup Language (HTML)
Functions
24. File stored on a user's machine that contains infor about application
Session
COUNT
WHERE
Cookie
25. Used to remove duplicates from result table
Data
Central control of data
DISTINCT
UPDATE
26. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Flat File
Application Programmers
Candidate Keys
27. 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.
Interactive SQL
American Standard Code for Information Interchange (ASCII)
Candidate Keys
Web Service
28. Looks like opening tag - but with a forward slash
Data Dictionary
Embedded SQL
Element Content
Closing tag
29. Flat File Examples: Excel Spreadsheets - _____
Service Broker
Indexes
AVG
Word
30. One of the tools that SQL uses to find and retrieve data.
Service-Oriented Architecture (SOA)
Indexes
Data Dictionary
Web server
31. Allows use of single or multiple character wildcards with the underscore or percent symbol
Dynamic
Relational
LIKE
Empty Elements
32. Network node that acts as a repository - yellow pages - or clearing house for interfaces that are published by service providers
Service Broker
Report
End Users
HAVING
33. Finds the lowest constant value in a column
NOT
GROUP BY
Interactive SQL
MAX
34. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
Opening tag
Public Key Infrastructure (PKI)
Comparison Operators
35. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Aggregate Functions
hidden fields
Application Programers
36. Compares value of the column in the specified condition with the value specified
MAX
DELETE
Equals Operator
Forward Slash
37. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Data Administrator (DAd)
AVG
ALL
Object-Oriented Relational (OOR)
38. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
INSERT INTO
Negation Operator
Service Broker
single value
39. Data in database interacts & corresponds with other data
ALL
Integrated
SUM
SUM
40. Everything between the start and end tag
Central Control of data
Element Content
Structured Query Language (SQL)
*
41. = - < - > - <= - >= - <> - !
hidden fields
DISTINCT
Comparison Operators
ALL
42. Looks like opening tag - but with a forward slash
SUM
accident
Closing tag
Stateless
43. Practice of writing code into a webpage that is not directly visible to the user
LIKE
Scripting
Closing tag
Query
44. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Service-Oriented Architecture (SOA)
Data Dictionary
Outer SELECT query
Web server
45. Flat File Examples: Excel Spreadsheets - _____
Public Key Infrastructure (PKI)
Word
WHERE
to update
46. Specifies the tables or views from which rows and columns are retrieved
FROM
Candidate Keys
Database
Hardware
47. Order in which WHERE clause is evaluated and combined
Functions
Report
Precedence of Logical Operators
Service Broker
48. Allow useres to retrieve data and interact with content located on web pages within website
Web Browser
Joins
single value
LIKE
49. The Web is ___________
LIKE
Stateless
accident
Database Administrator (DBA)
50. Data stored by DAd
LIKE
Candidate Keys
Functions
Data Elements
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