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 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
Catalog
PRIMARY KEY
Database Administrator (DBA)
Relation
2. Duplication of data or the storing of the same data in more than one place.
Referential Integrity
Redundancy
Catalog
Grouping
3. An access query that creates a table using the results of a query
Make-Table Query
Cascade Delete
FOREIGN KEY
Primary Key
4. A column (attribute) or collection of columns in a table whose value is required either to match the value of a primary key in a table or to be null
Criterion
Redundancy
Compound Conditions
Foreign Key
5. An index built on a single field
Join Line
One-to-Many Relationship
Single-Column Index
Field
6. The process of arranging rows in a table or results of a query in a particular order
Entity-Relationship (E-R) Diagram
Data File
Design Grid
Sort
7. The SQL statement that is used to grant different types of privileges to users of a dataabase
GRANT
Database Administrator (DBA)
Arguments
Security
8. The property that lets you change the structure of a database without requiring you to change the programs that access the database
FROM Clause
Server
Data Independence
Security
9. A collection of actions in Access that are performed in response to an associated database operation - such as inserting or updating or deleting records.
Data Macro
FROM Clause
Database Design
Difference
10. A program or a collection of programs through which users interact with a database
CREATE TABLE
Database Design
Redundancy
Database Management System (DBMS)
11. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
WHERE Clause
Unnormalized Relation
Field
Entity
12. A characteristic or property of an entity
Attribute
Major Sort Key
Secondary Sort Key
Sysindexes
13. When sorting on two fields - the less important field
Database Design
Update Query
Secondary Sort Key
Documenter
14. A collection of relations
Concatenation
SQL (Structured Query Language)
Relational Database
HAVING Clause
15. The field on which data are sorted
Relational Algebra
Sort Key
INSERT
System Catalog
16. The portion of the system catalog that contains table information
Redundancy
Difference
DROP INDEX
Systables
17. A rule that must be followed by data in a database
Intersection
Delete Query
Field
Integrity Constraint
18. An association between entities
Relationship
Index
Statement History
Unnormalized Relation
19. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Database Administrator (DBA)
Foreign Key
Major Sort Key
Query-By-Example (QBE)
20. Combination of criteria in which both criteria must be true
Single-Field Index
AND Criterion
Data File
Division
21. A very popular relational data definition and manipulation language that is used in many relational DBMS's
Outer Join
SQL (Structured Query Language)
Stored Procedure
Data Independence
22. 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
Sort
Database Design
Query-By-Example (QBE)
FROM Clause
23. The part of an SQL SELECT command that indicates the condition rows must satisfy to be displayed in the query results
WHERE Clause
Entity Integrity
Form
Relation
24. In an Access query the line drawn between tables to indicate how they are related
Join Line
Database Administrator (DBA)
Validation Text
CHECK
25. The plural of Criterion
DELETE
Sort
Criteria
Cascade Update
26. The individual who is responsible for a database or the head of database administration
Primary Key
Relationship
Database Administrator (DBA)
Entity-Relationship (E-R) Diagram
27. More than one entry at a single location in a table
Compound Conditions
Field
Repeating Groups
Entity-Relationship (E-R) Diagram
28. A statement the can be either true or false. Also called a condition
Join Column
Criterion
Redundancy
Entity
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.
Primary Key
Database Administrator (DBA)
Criteria
Database
30. A file used to store data about a single entity. Such a file can be thought of as a table.
Data File
Form
Integrity
Intersection
31. The individual or group that is responsible for a database
Unnormalized Relation
Database
Multiple Column Index
Database Administration (DBA)
32. 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
Comparison Operator
Primary Key
Security
33. The SQL command that drops (deletes) a table from a database
DROP TABLE
SQL (Structured Query Language)
Integrity Constraint
Data File
34. A characteristic or property of an entity
Secondary Sort Key
Form
Attribute
System Catalog
35. A data value meaning "unknown" or "not applicable"
Primary Sort Key
Join Column
Null
Criteria
36. The most common form of a join
Primary Key
Natural Join
Design Grid
FROM Clause
37. A field whose value is computed from other fields in the database
Relation
Relational Algebra
Computed Field
Minor Sort Key
38. 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.
Primary Key
SELECT
Integrity Constraint
Delete Query
39. When sorting on two fields - the less important field
Minor Sort Key
Computed Field
Attribute
DROP INDEX
40. The SQL command that creates an index in a table
CREATE INDEX
Foreign Key
Index Key
Database
41. The portion of the system catalog the contains column information
Primary Sort Key
Query-By-Example (QBE)
Syscolumns
Compound Criteria
42. When comparing tables an intersection is a new table containing all rows that are in both original tables
Intersection
Relationship
Concatenation
Database Management System (DBMS)
43. A query in SQL that appears within another
Criterion
Data File
SUBTRACT
Subquery
44. A person or place or object or event or idea for which you want to store and process data
Database Management System (DBMS)
Relation
Entity
Intersection
45. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Product
Repeating Groups
AND Criterion
Database
46. A characteristic or property of an entity
INSERT
Attribute
Comparison Operator
Natural Join
47. More than one entry at a single location in a table
Delimiter
Database Administration (DBA)
Repeating Groups
Null
48. A database has integrity if the data in it satisfies all established integrity constraints
Entity-Relationship (E-R) Diagram
Relational Database
Integrity
Outer Join
49. When sorting on two fields - the less important field
Qualify
Relational Database
Data File
Secondary Sort Key
50. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Join Column
Database
Integrity Constraint
CREATE TABLE
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