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
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 actual pieces of facts that are stored in the fields in a database table.
Data Model
Trigger
Flat File
Data
2. An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of0 - 1 - or many records in the related table.
Calculated Field
Select Query
Database Diagram
One-To-Many Relationship
3. A normalization which falls between 3NF and 4NF and involves the elimination of non-trivial dependencies
Third Normal Form
Transaction
Data Warehouse
Boyce-Codd Normal Form
4. A value that may be assigned to an attribute when no other value applies or when the applicable value is unknown.
Access 2007
Recursive Dependency
Null
Hierarchical Database
5. An organised pool of related data files which can be easily accessed and managed and that may be used by a number of different application programs
Database
Expression Builder
Cardinality
Where clause
6. The DML statement used to choose data from a database. The result is stored in a temporary table - called the result-set.
Report
Domain/Key Normal Form
Transaction
Select
7. The horizontal bar at the top of a column. You can click a column selector to select the entire column in the query design grid or the filter design grid
Schema
Compound Key
Column Selector
SQL View
8. Functional dependency involving only non-key attributes.
Third Normal Form
Transitive Dependency
Secondary Key
Entity Relationship Diagram
9. A characteristic of a field that determines what kind of data it can store and what type of operations can be performed on it.
Tuple
Autonumber
Data Type
Transaction
10. A section of a record containing data relating to one single characteristic of an entity; also called an attribute
Compound Key
Form
Totals Query
Field
11. A way of looking at a database object - usually looking at the design or at the contents/results
Self-Join
Foreign Key
View
Boyce-Codd Normal Form
12. A field in a table with unique values that although it is not the primary key - it could have been used as such.
Determinant
Cardinality
Alternate Key
Design Vie
13. A relation that contains no multivalued attributes.
Data Sheet
Attribute
Referential Integrity Constraint
First Normal Form
14. A query that displays a summary calculation - such as an average or a sum - for values in a table or tables. A totals query is not a seperate kind of query; rather it extends the flexibility of select queries.
Self-Join
E-R diagram
Totals Query
Criteria
15. To modify a database - or the files associated with the database.
Third Normal Form
Transact
Multi-valued Dependency
Expression Builder
16. A link between two or more tables.
Action Query
Join
One-To-Many Relationship
Secondary Key
17. Contents of a Database: Tables of user data - Metadata - Indexes - Stored Procedures - _______ - Security Data - Backup/Recovery Data
Cardinality
Database
Triggers
Relational Database Model
18. A query that copies data or changes data in some way. This includes append - delete - make-table and update queries.
Alternate Key
Entity Relationship Diagram
Transaction
Action Query
19. A referential integrity constraint is a statement that limits the values of the foreign key to those already existing as primary key values in the corresponding table.
Secondary Key
Referential Integrity Constraint
Data Integrity Rules
Criteria
20. Table has no anomalies.
Primary Key
Domain/Key Normal Form
Calculated Field
Action Query
21. No partial functional-dependencies.
Alternate Key
Transaction
Second Normal Form
Data Integrity Rules
22. No Transitive Dependencies.
Candidate Key
Attribute
Multi-valued Dependency
Third Normal Form
23. a.k.a record
Data Manipulation Language
Tuple
SQL View
Join
24. Knowing the value of one attribute you can determine the value of another attribute.
Functional Dependency
Key
Text Box
Data Definiton Language
25. A location within a database table that stores one particular type of data i.e. a field
Column
Database Diagram
Database Management System (DBMS)
Second Normal Form
26. Knowingly violates one or more rules of normalization.
Secondary Key
Many-to-Many Relationships
Sort
Best Normal Form
27. A combination of attributes that can be used to uniquely identify a database record. Candidate keys are a special subset of super keys that do not have any extraneous information in them
Entities
Database
Super key
Criteria
28. A DBMS created by Microsoft - it is a collection of data and objects - such as tables - queries - or forms - related to a particular topic or purpose.
First Normal Form
Access
First Normal Form
Determinant
29. The process of organizing data to minimize redundancy and produce smaller - well-structured relations/tables.
Transaction
Object-Oriented Database
Normalization
Design Vie
30. The window that appears when you open an Access database or an Access project. It displays the commands for creating new database objects and opening and manipulating existing objects.
Third Normal Form
E-R diagram
Database Window
Relational Database Model
31. One or more fields whose values uniquely identify each record in a table.
Select
Data Integrity Rules
Primary Key
Field
32. A function such as sum - count or average that you use to include summary data in a report.
Aggregate Function
Form
Many-to-Many Relationships
Index
33. Attribute that determines the value of another attribute.
Access
Fourth Normal Form
Determinant
Data Manipulation Language
34. One (or more fields) in a table that refer to the primary key in another table.
Foreign Key
Transaction
Best Normal Form
Data Type
35. A database object on which you place controls for entering - displaying and editing records in a table.
Alternate Key
Transitive Dependency
Tuple
Form
36. This is a property of data which - when satisfied - requires every value of one field (attribute) of a table to exist as a value of another field in another related table.
Referential Integrity
E-R diagram
Autonumber
Database
37. A relational database management system from Microsoft that combines the relational MS Jet Database Engine with a graphical user interface and software-development tools.
Form
Access 2007
Boyce-Codd Normal Form
Normalization
38. Data about data.
Metadata
Database Object
Column Selector
Where clause
39. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.
Numeric Data Type
Relational Database Model
Data Warehouse
Primary Key
40. Specialized engines designed specifically to store objects. Users can interact with objects only through designated methods.
Object-Oriented Database
Text Box
Many-to-Many Relationships
View
41. A central repository for databases across an entire enterprise.
Data Warehouse
SQL
Transact
Metadata
42. An attribute utilized to sort and/or identify data in some manner. Each table should have a primary key which uniquely identifies records.
Column Selector
Data Sheet
Key
E-R diagram
43. The conditional expession that is to be used to select particular data records from a larger set of records.
Totals Query
Data Definiton Language
Normalization
Criteria
44. No multiple multi-valued dependencies.
Relational Database Model
Fourth Normal Form
Hierarchical Database
Data Integrity Rules
45. The persons or things that a database table is about.
Entities
Append Query
View
Null
46. A Key composed of more than one attribute.
Database
Determinant
Data Manipulation Language
Compound Key
47. A query ( SQL statement ) that creates a new table and then creates records in it by coping records from an existing table.
Composite Key
Make Table Query
Default Value
Entities
48. A feature that speeds up searching and sorting in a table based on key values and can enforce uniqueness on the rows of a table.
Fourth Normal Form
Design Vie
Field
Index
49. In an access databse - a window in which you work with tables in design view or datasheet view.
Self-Join
Table Window
Determinant
Normalization
50. DOC MADE UP
Hierarchical Database
Recursive Dependency
Transitive Dependency
Autonumber
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