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. A window that displays the SQL statement for the current query or is used to create a SQL specific query. When you create a query in design view - Access constructs the SQL equivalent in the SQL view.
Currency Data Type
Data Manipulation Language
One-To-Many Relationship
SQL View
2. 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.
Database Window
Referential Integrity
Select Query
Table
3. An association/link established between common fields in two different tables. A relationship can be one-to-one - many-to-many or more usually one-to-many.
Boyce-Codd Normal Form
Primary Key
Expression Builder
Relation
4. An association between two tables in which several records in one table can relate to 0 - 1 or many records in the other table.
Many-to-many Relationship
Form
Functional Dependency
Hierarchical Database
5. 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.
Default Value
Group
Referential Integrity Constraint
Index
6. Refers to the number of associations that can exist between two record types.
SQL
Object-Oriented Database
Compound Key
Cardinality
7. A function such as sum - count or average that you use to include summary data in a report.
Criteria
Access 2007
Select Query
Aggregate Function
8. A query that asks a question about the data stored in your tables and returns a results set in the form of a data sheet without changing the actual data in the table(s).
Field
Data Integrity Rules
Select Query
Functional Dependency
9. A database computer language designed for the retrieval and management of data in relational database management systems (RDBMS) - database schema creation and modification - and database object access control management.
Field
Data Definiton Language
Database Management System (DBMS)
SQL
10. A normalization which falls between 3NF and 4NF and involves the elimination of non-trivial dependencies
Multi-valued Dependency
Boyce-Codd Normal Form
Database
Object-Oriented Database
11. DOC MADE UP
Transact
Normalization
Recursive Dependency
Database
12. A query that removes records which match the criteria you specify from one or more tables
Trigger
Access
Delete Query
Column Selector
13. A field data type that automatically stores a unique number for each record as it is added to a table.
Autonumber
Database Object
Index
Fourth 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.
Tuple
Totals Query
Metadata
Data Type
15. A table which is not only in 2NF but whose non-primary key fields are dependent only on the primary key and therefore have no dependence on (relationship to) any other non-primary key field in the table.
Transact
Third Normal Form
Text Box
Compound Key
16. A query that copies data or changes data in some way. This includes append - delete - make-table and update queries.
Totals Query
Action Query
Select Query
View
17. The components of a data abase i.e. tables - queries - forms - reports - pages - macros and modules.
Access
Table Window
Database Object
Group
18. A way of looking at a database object - usually looking at the design or at the contents/results
Data Model
View
Data
Compound Key
19. Specialized engines designed specifically to store objects. Users can interact with objects only through designated methods.
Entities
Hierarchical Database
Object-Oriented Database
Third Normal Form
20. Two or more controls that can be treated as one unit while designing a form or report. You can select the group instead of selecting each individual control as you are arranging controls or assigning properties.
Group
Primary Key
Transaction
Attribute
21. A query ( SQL statement ) that creates a new table and then creates records in it by coping records from an existing table.
Append Query
Make Table Query
Boyce-Codd Normal Form
Default Value
22. A database object that prints information formatted and organised according to your specifications.
Data
Report
Comparison Operator
Many-to-many Relationship
23. When a table is not only in 1NF but each non key field is functionally dependent on the full primary key
Super key
Entity Relationship Diagram
Second Normal Form
Tuple
24. A section of a record containing data relating to one single characteristic of an entity; also called an attribute
Key
Field
Domain/Key Normal Form
One-To-Many Relationship
25. Table has no anomalies.
Third Normal Form
Query
Criteria
Domain/Key Normal Form
26. A relation that contains no multivalued attributes.
Currency Data Type
First Normal Form
Aggregate Function
One-To-Many Relationship
27. 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
Design Vie
Compound Key
Access 2007
28. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Database Window
Database Object
Table
Compound Key
29. One or more fields whose values uniquely identify each record in a table.
Query
Primary Key
Default Value
Data Definiton Language
30. An action query that adds the records in a query's result set to the end of an existing table.
Functional Dependency
Table
Index
Append Query
31. A self-describing collection of integrated tables. The tables are called integrated because they store data about the relationships between the rows of data.
Table Window
Table
Database
Column
32. The process of organizing data to minimize redundancy and produce smaller - well-structured relations/tables.
Query
Normalization
Trigger
One-To-Many Relationship
33. 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
Select Query
Append Query
Super key
Autonumber
34. Groups of database commands which are to be treated as a single atomic event.
Compound Key
Transaction
Append Query
Index
35. 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.
Database Object
Referential Integrity Constraint
Data Definiton Language
Database Window
36. No partial functional-dependencies.
Triggers
Entity Relationship Diagram
Second Normal Form
Many-to-Many Relationships
37. No multiple multi-valued dependencies.
Null
Fourth Normal Form
Triggers
Third Normal Form
38. A central repository for databases across an entire enterprise.
Data Warehouse
Database Diagram
Primary Key
Foreign Key
39. An operator used to compare two values or expressions; For example - < (less than) - > (greater than) - = (equal to)
Best Normal Form
Data Model
Database Object
Comparison Operator
40. A data type that is used for fields and calculations involving money
Group
Currency Data Type
Secondary Key
Table
41. The conditional expession that is to be used to select particular data records from a larger set of records.
Criteria
Null
Default Value
SQL
42. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.
Data Type
Field
Numeric Data Type
View
43. 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
Database
Select Query
Join
Column Selector
44. 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.
Object-Oriented Database
Alternate Key
Super key
One-To-Many Relationship
45. Attribute that determines the value of another attribute.
Many-to-many Relationship
Currency Data Type
Determinant
Relation
46. A graphical representation of entities and their relationship to each other - typically used in computing in regard to the organization of data within databases or information systems
Best Normal Form
Report
E-R diagram
Alternate Key
47. A programming language designed for managing & obtaining data in relational database management systems (RDBMS)
Compound Key
Recursive Dependency
SQL
Criteria
48. 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
Entity Relationship Diagram
Action Query
Composite Key
49. A collection of fields that together describe one entity.
Fourth Normal Form
One-To-Many Relationship
Record
Metadata
50. A control that indicates whether an option is selected or not. A tick mark appears in the box when the option is selected.
Aggregate Function
Check Box
Transaction
Record
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