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. Combines rows from a SELECT statements result table into a group
GROUP BY
Tags
Bind
Subqueries
2. Software system designed to support interface for a software asset that manages a specific set of tasks
Equals Operator
Service Provider
Tags
Service Broker
3. Meaningful info related to database
Performance
Closing tag
Data
Hypertext Markup Language (HTML)
4. Uses relationships between independent entities
Web Service
MAX
Relational
ORDER BY
5. Data in database interacts & corresponds with other data
Interactive SQL
Calculated Column
Report
Integrated
6. Grant acces and control to only specific information
Views
NOT
American Standard Code for Information Interchange (ASCII)
Information
7. Most valuable asset of a database system.
Bind
Central control of data
Embedded SQL
Data Dictionary
8. 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.
HAVING
Element Content
Hypertext Markup Language (HTML)
Candidate Keys
9. Give the browser more specific information about that tag
Attributes
Primary Keys
Service Provider
Opening tag
10. Decides what data is stored in the databse and the manner it is stored
Data
Data Administrator (DAd)
Scripting
UPDATE
11. Interact and manipulates the data in the database
Database
Database Administrator (DBA)
Embedded SQL
Data Manipulation
12. Text markups that form an element" sort of a "box" to hold things like text and other elements
Web server
Closing tag
Outer SELECT query
Tags
13. Meaningful info related to database
Web Applications
Data
Tables
FROM
14. Has the highest precedence - followed by the AND - OR
Database Administrator (DBA)
NOT
HAVING
Element Content
15. Straight implementation of raw data formatted into rows and columns
Word
Flat File
Central Control of data
Inner SELECT query
16. Grant acces and control to only specific information
SUM
SUM
Views
Web Browser
17. Tally of how many rows meet criteria specified
COUNT
Attributes
SELECT
*
18. Specifies the tables or views from which rows and columns are retrieved
Central Control of data
Outer SELECT query
FROM
Data
19. SQL Commands - Two Things Specify data interested in - Indicate the ________
Application Programmers
Central Control of data
accident
Service Broker
20. Allows data recovery in case of corruption or loss
Fields
Embedded SQL
Data Recovery & Concurrance
BETWEEN
21. Finds the lowest ACII value in column
Subqueries
Session
Hypertext Markup Language (HTML)
MIN
22. Selects from specific values in list
Dynamic
End Users
IN
Scripting
23. Concatenated in SQL Server Database software using the addition symbol
to update
Fields
Tags
Object-Oriented Relational (OOR)
24. SQL Commands: Define tables - views - _____ - delete or insert info
Bind
Information
Data Definition
to update
25. 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.
Query
Web server
Primary Keys
to update
26. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
Inner SELECT query
Bind
ALL
Element Content
27. Used to remove duplicates from result table
DISTINCT
Outer SELECT query
Negation Operator
Joins
28. Changes the values in one or more selected rows of a table
Structured Query Language (SQL)
Forward Slash
UPDATE
Flat File
29. Data that has been processed into a format that is understandable by its audience
GROUP BY
Negation Operator
Primary Keys
Information
30. Give the browser more specific information about that tag
Foreign Keys
Joins
Attributes
Structured Query Language (SQL)
31. Columns containing numbers only
Persistent
Outer SELECT query
SUM
Web server
32. 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
DISTINCT
Inner SELECT query
single value
33. Executes commands one at a time - results being displayed immediately
Functions
Performance
IN
Interactive SQL
34. Data remains unchanged in database
Inner SELECT query
Opening tag
Persistent
to update
35. Describe information in a tree styled format
Interactive SQL
Service Requestor
Candidate Keys
Hierarchial
36. Combines rows from a SELECT statements result table into a group
Element Content
Empty Elements
accident
GROUP BY
37. Basic Component of SQL
Tables
Dynamic
American Standard Code for Information Interchange (ASCII)
Aggregate Functions
38. Everything in enviroment becomes an object - expands on Priniples of relational databases
Object-Oriented Relational (OOR)
Joins
Forward Slash
DELETE
39. Used in a SELECT clause in place of a column
Persistent
INSERT INTO
Web Browser
Aggregate Functions
40. Responsible for technical implementation & maintenance of database on a design & physical level
Database Administrator (DBA)
Relational
Hierarchial
Users
41. Concatenated in SQL Server Database software using the addition symbol
Data Definition
Element Content
Fields
Joins
42. SQL finds and retrieves date
Opening tag
Indexes
ALL
DELETE
43. Flat File Examples: Excel Spreadsheets - _____
Word
Bind
Web Browser
Performance
44. One huge database to hold all data; Access to data - and use of system to add - update & print records
Equals Operator
Application Programmers
Database Management Systems (DBMS)
INSERT INTO
45. All Columns indicated and selected
Database Administrator (DBA)
Cookie
*
Information
46. SELECT statment containing the nested query
Outer SELECT query
Fields
Service Broker
Data
47. Selects from specific values in list
ESC
Hierarchial
IN
Tables
48. Deletes selected rows
Web Browser
Functions
DELETE
Object-Oriented Relational (OOR)
49. Using product as intended for its audience
single value
Persistent
End Users
Dynamic
50. Supplies value for the search condition of the SELECT statement containing it
Query
Database Management Systems (DBMS)
Cookie
Inner SELECT query
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