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 characteristic or property of an entity
Field
Product
Attribute
Join
2. A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate
Entity-Relationship (E-R) Diagram
Aggregate Functions
Integrity
Integrity Constraint
3. A field whose value is computed from other fields in the database
Computed Field
Data File
WHERE Clause
Compound Criteria
4. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE
Database Design
Database Administrator (DBA)
Entity
Trigger
5. The most common form of a join
One-to-Many Relationship
Major Sort Key
Natural Join
Join Column
6. 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.
Repeating Groups
Row-and Column Subset View
Primary Key
Query
7. A screen object you use to maintain or view and print data from a database
Sysindexes
Trigger
Form
Column
8. The SQL clause that is used to enforce legal-values integrity
Repeating Groups
CHECK
Redundancy
Reserved Words
9. A file used to store data about a single entity. Such a file can be thought of as a table.
Computed Field
Compound Criteria
Database
Data File
10. A field whose value is computed from other fields in the database
Database Management System (DBMS)
Union Compatible
Database Design
Calculated Field
11. The individual who is responsible for a database or the head of database administration
Integrity Constraint
Relation
CHECK
Database Administrator (DBA)
12. The part of an SQL SELECT command that indicates a sort order
Data File
Arguments
ORDER BY Clause
Repeating Groups
13. The field or fields on which an index is built
Unnormalized Relation
Index Key
Single-Column Index
Entity
14. The SQL command used to delete a table
CREATE TABLE
DELETE
Relational Database
SELECT
15. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Sort
Primary Sort Key
Functions
Data Independence
16. An index built on more than one field
Referential Integrity
Attribute
Multiple Column Index
Database Design
17. A very popular relational data definition and manipulation language that is used in many relational DBMS's
Referential Integrity
SQL (Structured Query Language)
DROP INDEX
Sysindexes
18. When sorting on two fields this is the more important field
Comparison Operator
Criteria
Compound Conditions
Primary Sort Key
19. 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
Referential Integrity
Calculated Field
Validation Text
Statement History
20. When sorting on two fields - the less important field
Division
Secondary Sort Key
PROJECT
Sysviews
21. The individual who is responsible for a database or the head of database administration
Database Administrator (DBA)
Concatenation
Sort
Validation Rule
22. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types
Database Design
Form
Database Management System (DBMS)
Union Compatible
23. The SQL command used to make changes to existing table data
Catalog
Index
Functions
UPDATE
24. In an Access query the line drawn between tables to indicate how they are related
Join Line
Grouping
Integrity Constraint
Product
25. In relational algebra the operation in which two tables are connected on the basis of common data.
One-to-Many Relationship
Cascade Update
Join
Delimiter
26. An association between entities
Subquery
Design Grid
Relationship
Product
27. The column on which two tables are joined
SELECT
Delete Query
Join Column
Qualify
28. The part of an SQL SELECT command that indicates the condition rows must satisfy to be displayed in the query results
Database Administrator (DBA)
Intersection
Sysviews
WHERE Clause
29. The portion of the system catalog that contains index information
Sysindexes
Aggregate Functions
Cascade Delete
Relational Database
30. A view that consists of a subset of the rows and columns in a table
Union
Row-and Column Subset View
Relational Database
Data File
31. 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
Form
Entity
Sysindexes
Relation
32. A statement the can be either true or false. Also called a condition
Join Column
Data File
Comparison Operator
Criterion
33. A query in SQL that appears within another
Subquery
Trigger
GROUP BY Clause
One-to-Many Relationship
34. A person or place or object or event or idea for which you want to store and process data
One-to-Many Relationship
Update Query
Relation
Entity
35. 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
Redundancy
Intersection
One-to-Many Relationship
Data Independence
36. More than one entry at a single location in a table
Minor Sort Key
Integrity
Repeating Groups
SUBTRACT
37. An association between entities
Relationship
Update Query
Data Independence
Redundancy
38. The process of arranging rows in a table or results of a query in a particular order
Primary Sort Key
Entity Integrity
Sort
Qualify
39. A collection of relations
Column
FROM Clause
Relational Database
Simple Condition
40. A program or a collection of programs through which users interact with a database
WHERE Clause
Criteria
Database Management System (DBMS)
Make-Table Query
41. The SQL statement that is used to grant different types of privileges to users of a dataabase
Criteria
GRANT
AND Criterion
Database Administrator (DBA)
42. An access query that creates a table using the results of a query
Relational Database
Subquery
Design Grid
Make-Table Query
43. Combination of criteria in which both criteria must be true
AND Criterion
Criteria
Computed Field
PROJECT
44. A word that is part of the SQL language
Data Independence
Relational Algebra
Database Administrator (DBA)
Reserved Words
45. Combination of criteria in which both criteria must be true
AND Criterion
Repeating Groups
Cascade Delete
Relation
46. 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
Delimiter
Join Line
Database Design
HAVING Clause
47. A collection of relations
Relational Database
Attribute
Primary Sort Key
Make-Table Query
48. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
PROJECT
HAVING Clause
Criterion
Database
49. A collection of relations
Database Administration (DBA)
Database
Relational Database
Database Design
50. A field whose value is computed from other fields in the database
Relational Database
Calculated Field
Sort Key
Aggregate 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