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. Begins an element
Opening tag
INSERT INTO
DELETE
Element Content
2. Everything between the start and end tag
Bind
Dynamic
Element Content
Integrated
3. One huge database to hold all data; Access to data - and use of system to add - update & print records
Bind
Hierarchial
Empty Elements
Database Management Systems (DBMS)
4. Compares value of the column in the specified condition with the value specified
Equals Operator
Service Requestor
LIKE
Information
5. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Database Management Systems (DBMS)
MAX
Negation Operator
Application Programmers
6. Ongoing record of data reflecting the info defining the database
Data Dictionary
Outer SELECT query
ASC
Scripting
7. Three Basic Operations of SP - SR - SB: Publish - Find - ____
End Users
American Standard Code for Information Interchange (ASCII)
Cookie
Bind
8. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Hierarchial
Application Programmers
Report
9. SELECT statment containing the nested query
Outer SELECT query
Primary Keys
hidden fields
Web Browser
10. Limits the output of the established groups into the derived result table
FROM
Comparison Operators
AVG
HAVING
11. Used to remove duplicates from result table
Indexes
ASC
Bind
DISTINCT
12. Characterizes operation of a relational database
Data Definition
Joins
Structured Query Language (SQL)
Negation Operator
13. Data that has been processed into a format that is understandable by its audience
Opening tag
Hypertext Markup Language (HTML)
FROM
Information
14. Deletes selected rows
IN
DELETE
Aggregate Functions
Dynamic
15. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
Web Browser
single value
Web Browser
Self Join
16. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Self Join
Hardware
Service Requestor
ORDER BY
17. Flat File Examples: Excel Spreadsheets - _____
ASC
Word
ORDER BY
MAX
18. SQL Commands: Define tables - views - _____ - delete or insert info
Aggregate Functions
to update
Embedded SQL
Session
19. One of the tools that SQL uses to find and retrieve data.
Self Join
Data
Indexes
BETWEEN
20. Grant acces and control to only specific information
Views
Empty Elements
Data Elements
Database
21. Changes the values in one or more selected rows of a table
hidden fields
ASC
UPDATE
Self Join
22. Table displayed in ascending order
Indexes
HAVING
Hardware
ASC
23. Concatenated in SQL Server Database software using the addition symbol
Fields
Indexes
Joins
single value
24. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
single value
Object-Oriented Relational (OOR)
Data Dictionary
25. Some form of output - usually - printed - containing information
Database
Relational
Element Content
Report
26. Cookies are more secure than______ - allowing travel on a website without loss of info
Aggregate Functions
Tables
INSERT INTO
hidden fields
27. Browser requests page - code is delivered - executed and done with
Data Manipulation
Property
Hardware
Dynamic
28. Cookies are more secure than______ - allowing travel on a website without loss of info
Application Programmers
Web server
hidden fields
UPDATE
29. Copies multiple records at the same time using a SELECT statement
Database Administrator (DBA)
Attributes
Hardware
INSERT INTO
30. Begins an element
Relational
SUM
Opening tag
Functions
31. Interact and manipulates the data in the database
single value
Structured Query Language (SQL)
Data Manipulation
Database Management Systems (DBMS)
32. Limits the rows that appear in the result mathcing a specified condition
SUM
WHERE
Application Programmers
Data Administrator (DAd)
33. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Views
Structured Query Language (SQL)
Application Programmers
WHERE
34. Some form of output - usually - printed - containing information
hidden fields
Scripting
Report
Equals Operator
35. Compares value of the column in the specified condition with the value specified
Primary Keys
NOT
Equals Operator
SELECT
36. SQL Commands: Define tables - views - _____ - delete or insert info
Property
Hierarchial
INSERT INTO
to update
37. Ensures functions are done efficiently
Performance
Empty Elements
single value
Relational
38. Everything between the start and end tag
Element Content
ASC
Hardware
Query
39. Data in database has ability to be accessed and manipulated by several users
Shared
Functions
INSERT INTO
Bind
40. Table displayed in descending order
Public Key Infrastructure (PKI)
MAX
Equals Operator
ESC
41. Executes commands one at a time - results being displayed immediately
Interactive SQL
single value
Self Join
to update
42. Closed in the start tag by adding a slash to the start tag
Subquery
Shared
Empty Elements
Application Programers
43. Used with another comparison operator - values become inverted
Web Browser
Subqueries
Negation Operator
Inner SELECT query
44. SQL finds and retrieves date
Foreign Keys
Indexes
Hypertext Markup Language (HTML)
Integrated
45. Join a table to a copy of itself
Service Requestor
Data
Aliases
Self Join
46. Attribute in quotes
Element Content
ORDER BY
Property
UPDATE
47. Selects from specific values in list
Views
IN
HAVING
Primary Keys
48. Responsible for technical implementation & maintenance of database on a design & physical level
Hardware
Database Administrator (DBA)
MAX
Indexes
49. The Web is ___________
Database Management Systems (DBMS)
single value
Stateless
Data Elements
50. Defines a new column
Integrated
Calculated Column
Performance
Database Administrator (DBA)
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