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 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. The SQL command that is used to change the structure of a table
ALTER TABLE
Repeating Groups
Integrity Constraint
DROP TABLE
2. A database has integrity if the data in it satisfies all established integrity constraints
Integrity
Database Management System (DBMS)
Secondary Sort Key
Criteria
3. The individual who is responsible for a database or the head of database administration
Database Administrator (DBA)
Make-Table Query
AND Criterion
Primary Sort Key
4. The most common form of a join
Entity
DELETE
Natural Join
Compound Conditions
5. A combination of criteria in which at least on the criteria must be true
AND Criterion
OR Criterion
CREATE INDEX
Cascade Update
6. What type of an operator is >= ?
Integrity Constraint
Column
Comparison Operator
Criteria
7. An index built on a single field
DROP INDEX
Single-Field Index
HAVING Clause
CREATE TABLE
8. The portion of the system catalog the contains column information
Syscolumns
Data Independence
Difference
Aggregate Functions
9. A query that deletes all records that satisfy some criterion
Delete Query
CREATE INDEX
Relation
Update Query
10. The process of determining the content and structure of data in a database in order to support some activity on behalf of a user or group of users
Trigger
Product
Database Design
Form
11. A delete option in which related records are automatically deleted
Qualify
Natural Join
Cascade Delete
Sort
12. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Cartesian Product
Delete Query
Form
Database
13. The area of memory in MySQL that stores the most recently entered command
Statement History
Redundancy
Field
Design Grid
14. The field on which data are sorted
Sort Key
Compound Conditions
Server
DROP INDEX
15. The part of an SQL SELECT command that indicates grouping
Sysindexes
Relational Algebra
FROM Clause
GROUP BY Clause
16. The process of creating collections of records that share some common characteristics
Data File
Grouping
Arguments
INTERSECT
17. A question the answer to which is found in the database
Primary Sort Key
UPDATE
WHERE Clause
Query
18. The relational algebra command for performing the difference of two tables
Sort
Query
SUBTRACT
FROM Clause
19. The plural of Criterion
Minor Sort Key
Computed Field
Aggregate Functions
Criteria
20. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Join Column
Stored Procedure
Design Grid
Qualify
21. A file used to store data about a single entity. Such a file can be thought of as a table.
One-to-Many Relationship
Comparison Operator
Data File
Delete Query
22. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Redundancy
Relational Database
View
Unnormalized Relation
23. Duplication of data or the storing of the same data in more than one place.
Redundancy
Unnormalized Relation
Simple Condition
Entity
24. When comparing tables the set of all rows that are in the first table but that are not in the second table
Column
Outer Join
Primary Sort Key
Difference
25. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column
View
Functions
Update Query
Join
26. Two simple criteria in a query the are combined with the AND or OR operators
Field
Compound Conditions
Integrity
Natural Join
27. A person or place or object or event or idea for which you want to store and process data
Entity
Reserved Words
Union Compatible
Simple Condition
28. The SQL command that drops (deletes) a table from a database
Join
Column
Form
DROP TABLE
29. A minimal collection of columns (attributes) in a table on which all columns are functionally dependent and that is chosen as the main direct-access vehicle to individual rows.
Integrity Constraint
Primary Key
Statement History
Repeating Groups
30. A rule in Access that data entered in a field must satisfy
Relation
Computed Field
Validation Rule
Stored Procedure
31. An update option in which related records are automatically updated
FOREIGN KEY
System Catalog
Cascade Update
Join Line
32. In relational algebra the operation in which two tables are connected on the basis of common data.
Repeating Groups
Relational Database
Join
Data Macro
33. A combination of two tables consisting of all records that are in either table
Union
Statement History
Compound Criteria
Foreign Key
34. The individual or group that is responsible for a database
Redundancy
Delete Query
Statement History
Database Administration (DBA)
35. The form of a join in which all records appear - even if they don't match
Security
Outer Join
Relation
Database Management System (DBMS)
36. A characteristic or property of an entity
Primary Key
Field
System Catalog
Database Administrator (DBA)
37. More than one entry at a single location in a table
Compound Conditions
Null
Database
Repeating Groups
38. An association between entities
Intersection
Data File
Relationship
Stored Procedure
39. A computer that provides services to the clients in a client/server system
Database Administrator (DBA)
Legal-Values Integrity
Server
View
40. The relational algebra command that combines tables and searches for rows in the first table that match all rows in the second table
Single-Column Index
PRIMARY KEY
Relational Database
Division
41. The part of an SQL SELECT command that restricts the groups to be displayed
Qualify
Relational Database
HAVING Clause
Compound Conditions
42. A Characteristic or property of an entity
Column
DELETE
Primary Key
Qualify
43. The query that is used to define the structure of a viewk
Aggregate Functions
Defining Query
Entity-Relationship (E-R) Diagram
Database Design
44. The process of creating collections of records that share some common characteristics
Foreign Key
Grouping
Primary Key
Qualify
45. A two-dimensional table-style collection of data in which all entries are single-valued - each column has a distinct name and all the values in a column are values of the attribute that is identified by the column name - and the order of the columns
Intersection
Primary Key
Relation
Grouping
46. Two simple criteria in a query the are combined with the AND or OR operators
Relational Algebra
Entity-Relationship (E-R) Diagram
Compound Conditions
CHECK
47. The part of an SQL SELECT command that indicates the tables in the query
FROM Clause
DROP INDEX
Compound Criteria
Database Design
48. A statement the can be either true or false. Also called a condition
FROM Clause
Join Line
GRANT
Criterion
49. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Catalog
Trigger
Functions
Relation
50. The field or fields on which an index is built
Repeating Groups
Index Key
Design Grid
PRIMARY KEY
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