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. A relationship between two entities in which each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to or at most one occurrence of the first entity
Criterion
One-to-Many Relationship
DROP TABLE
Data Independence
2. More than one entry at a single location in a table
Foreign Key
Repeating Groups
ALTER TABLE
SELECT Clause
3. More than one entry at a single location in a table
Repeating Groups
Form
Compound Criteria
Index Key
4. A field whose value is computed from other fields in the database
System Catalog
Calculated Field
Repeating Groups
Sort
5. The relational algebra command for performing the difference of two tables
DELETE
Repeating Groups
Join
SUBTRACT
6. A punctuation mark - such as a semicolon - that separates pieces of data
Security
Delimiter
Product
Field
7. A screen object you use to maintain or view and print data from a database
Integrity
SELECT Clause
ALTER TABLE
Form
8. When sorting on two fields - the less important field
Join Line
PROJECT
Secondary Sort Key
One-to-Many Relationship
9. An index built on a single field
Data File
Single-Column Index
Redundancy
Aggregate Functions
10. 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
Union
Union Compatible
Aggregate Functions
Design Grid
11. An association between entities
Integrity
Null
Relationship
Data File
12. A structure that contains information about the objects (tables or columns or indexes or views and so on) in a database
Union
System Catalog
GRANT
Data Independence
13. The most common form of a join
Natural Join
One-to-Many Relationship
Sysviews
Qualify
14. The query that is used to define the structure of a viewk
Defining Query
Null
Data Independence
Qualify
15. Combination of criteria in which both criteria must be true
Database
Sort Key
AND Criterion
Command
16. In an Access query the line drawn between tables to indicate how they are related
Aggregate Functions
Delete Query
Join Line
Cascade Update
17. The individual or group that is responsible for a database
Form
Database Administration (DBA)
Entity Integrity
ORDER BY Clause
18. A Characteristic or property of an entity
Column
Update Query
Minor Sort Key
Relationship
19. An access query that creates a table using the results of a query
Make-Table Query
Compound Criteria
AND Criterion
Join Line
20. An association between entities
CHECK
Relationship
Database Management System (DBMS)
Compound Criteria
21. When sorting on two fields this is the more important field
Form
Major Sort Key
Relational Database
GRANT
22. What type of an operator is >= ?
AND Criterion
Comparison Operator
Catalog
Minor Sort Key
23. The SQL command used to delete a table
Systables
Repeating Groups
Field
DELETE
24. A file that relates key values to records that contain those key values
Database Administration (DBA)
Index
Sort Key
UPDATE
25. Two simple criteria in a query the are combined with the AND or OR operators
Compound Criteria
Stored Procedure
Database Administration (DBA)
Sort
26. The SQL clause that is used in a CREATE TABLE or ALTER TABLE command to set a table's primary key field(s)
Database Management System (DBMS)
Entity
PRIMARY KEY
Design Grid
27. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Qualify
Database
Join
View
28. The part of an SQL SELECT command that indicates the columns to be included in the query results
Intersection
Arguments
Repeating Groups
SELECT Clause
29. 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
Aggregate Functions
Attribute
Natural Join
Validation Text
30. When sorting on two fields this is the more important field
Join Line
Major Sort Key
DELETE
Qualify
31. An index built on more than one field
Product
Multiple Column Index
Union
Integrity
32. A rule that must be followed by data in a database
Integrity Constraint
SELECT
SELECT
Database Administrator (DBA)
33. In relational algebra the operation in which two tables are connected on the basis of common data.
Single-Column Index
Delete Query
Join
Computed Field
34. A program or a collection of programs through which users interact with a database
DROP INDEX
Secondary Sort Key
Row-and Column Subset View
Database Management System (DBMS)
35. A file containing a collection of compiled and optimized SQL statements that are available for future use
Primary Sort Key
FOREIGN KEY
Stored Procedure
Criteria
36. A Characteristic or property of an entity
Secondary Sort Key
Delimiter
Data Independence
Column
37. The prevention of unauthorized access to a database
Qualify
Primary Key
Security
Make-Table Query
38. When sorting on two fields this is the more important field
Concatenation
ORDER BY Clause
Primary Sort Key
Minor Sort Key
39. The property that lets you change the structure of a database without requiring you to change the programs that access the database
View
Union Compatible
Compound Conditions
Data Independence
40. 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.
Relational Database
Primary Key
Defining Query
Entity-Relationship (E-R) Diagram
41. A field whose value is computed from other fields in the database
Query
Computed Field
Delete Query
Join Column
42. A characteristic or property of an entity
Entity Integrity
Attribute
Query
Difference
43. A query that deletes all records that satisfy some criterion
Delete Query
Cascade Delete
GROUP BY Clause
Index
44. More than one entry at a single location in a table
Repeating Groups
Multiple-Field Index
OR Criterion
Qualify
45. The rule that if table A contains a foreign key that matches the primary key of table B then the value of this foreign key must either match the value of the primary key for some row in table B or be null
Trigger
Qualify
Referential Integrity
Relationship
46. A condition that involves only a single field and a single value
Sort Key
Simple Condition
Arguments
Minor Sort Key
47. The field or fields on which an index is built
Index Key
Database Design
Cascade Delete
Design Grid
48. 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
Redundancy
Redundancy
Database Design
Relation
49. 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
SELECT
Major Sort Key
Database
Relation
50. 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
Database
Entity Integrity
FROM Clause
Functions
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