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 process of examining and analyzing data with a view to extracting patterns from it. It is usually done on data warehouses
Data Manipulation Language
Data
Entities
Data Mining
2. Groups of database commands which are to be treated as a single atomic event.
Database Window
Fourth Normal Form
Transaction
View
3. A Key composed of more than one attribute.
Referential Integrity
Attribute
Self-Join
Compound Key
4. A query that copies data or changes data in some way. This includes append - delete - make-table and update queries.
Action Query
Default Value
Group
Totals Query
5. 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 of one and only one record in the related table.
Data Type
Transact
Record
One-To-One Relationship
6. Arrange the records in a view set in order according to a particular field
Sort
One-To-One Relationship
Boyce-Codd Normal Form
Record
7. A relation that contains no multivalued attributes.
Database Diagram
Referential Integrity
First Normal Form
Table Window
8. A way of looking at a database object - usually looking at the design or at the contents/results
Self-Join
SQL
View
Group
9. A query that removes records which match the criteria you specify from one or more tables
Select Query
Comparison Operator
Flat File
Delete Query
10. A section of a record containing data relating to one single characteristic of an entity; also called an attribute
Transaction
One-To-Many Relationship
Self-Join
Field
11. 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 Management System (DBMS)
Access
Database
Data
12. 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
Super key
Metadata
Expression Builder
Primary Key
13. Knowing the value of one attribute you can determine the value of another attribute.
Data Mining
Currency Data Type
Record
Functional Dependency
14. A characteristic of the items in a database i.e. a field
Form
Attribute
Cardinality
One-To-One Relationship
15. A database object that stores data in records and fields. The data is usually about a particular category of things.
Currency Data Type
Table
Database
Make Table Query
16. 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.
Table
Composite Key
Access
Select Query
17. One or more fields whose values uniquely identify each record in a table.
Primary Key
Recursive Dependency
Fourth Normal Form
Database
18. A record as seen in the data sheet view.
Entity Relationship Diagram
E-R diagram
Field
Row
19. 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.
Multi-valued Dependency
Flat File
SQL
Referential Integrity
20. Specialized engines designed specifically to store objects. Users can interact with objects only through designated methods.
Entities
Data Definiton Language
Second Normal Form
Object-Oriented Database
21. A graphical representation of all entity relationships (Data Model)
Entity Relationship Diagram
Candidate Key
Database
Alternate Key
22. 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.
One-To-One Relationship
Database Diagram
Metadata
Relation
23. A primary key that is comprised of more than one field.
Multi-valued Dependency
Recursive Dependency
Composite Key
Transact
24. The DML statement used to choose data from a database. The result is stored in a temporary table - called the result-set.
Select
Triggers
Database Diagram
Data Warehouse
25. A link between two or more tables.
Join
Access
Data Sheet
Database
26. A field - set up in a query - that displays the result of an evaluated expression rather than displaying stored data.The value of the calculated field is re-calculated each time a value in the expression changes.
Transaction
Transitive Dependency
Calculated Field
Sort
27. The set of fields in a table which stores unique values and so any one from the list can be selected to be the primary key.
Aggregate Function
Candidate Key
Second Normal Form
Flat File
28. The persons or things that a database table is about.
Entities
Domain/Key Normal Form
Field
Data Sheet
29. 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.
Relation
Data Definiton Language
Tuple
SQL
30. DOC MADE UP
Recursive Dependency
Boyce-Codd Normal Form
Database Management System (DBMS)
Triggers
31. When a table is not only in 1NF but each non key field is functionally dependent on the full primary key
Referential Integrity Constraint
Report
Second Normal Form
Index
32. 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.
Alternate Key
Database Diagram
SQL View
Column Selector
33. A collection of fields that together describe one entity.
Make Table Query
Record
Table Window
Data Definiton Language
34. A candidate key that coud have been the primary key but was not selected as such ; OR a field that is not the primary key but has been used for indexing nevertheless.
Data Manipulation Language
Secondary Key
Data Integrity Rules
Database Window
35. A window that shows the design or structure of the database objects: tables - queries - forms - reports - macros and data access pages.
Data Definiton Language
Where clause
Design Vie
Relation
36. An association between two tables in which several records in one table can relate to 0 - 1 or many records in the other table.
Data Mining
SQL
Many-to-many Relationship
Composite Key
37. A data type that is used for fields and calculations involving money
Flat File
Currency Data Type
Data Sheet
Database
38. A location within a database table that stores one particular type of data i.e. a field
Foreign Key
Criteria
Many-to-many Relationship
Column
39. That structure which contains description of objects created by a user - such as base tables - views and constraints - as a part of a database.
Schema
Database
Autonumber
Third Normal Form
40. Guidelines set in place to ensure the trustworthiness of data over its entire life cycle.
Data Integrity Rules
Numeric Data Type
Database Window
Record
41. Refers to the number of associations that can exist between two record types.
Fourth Normal Form
Cardinality
SQL
Expression Builder
42. An action query that adds the records in a query's result set to the end of an existing table.
Append Query
E-R diagram
Data Type
Default Value
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
Second Normal Form
Column Selector
Text Box
First Normal Form
44. Contents of a Database: Tables of user data - Metadata - Indexes - Stored Procedures - _______ - Security Data - Backup/Recovery Data
Row
Triggers
Calculated Field
Design Vie
45. 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.
SQL
Criteria
Compound Key
Index
46. A control that indicates whether an option is selected or not. A tick mark appears in the box when the option is selected.
Check Box
Relational Database Model
Expression Builder
Totals Query
47. DBMS (Database Management System) statements used to manage data (tables and other objects) within a database
Third Normal Form
Totals Query
Data Definiton Language
Data Manipulation Language
48. Data from a table - form - query which is displayed in a row-and-column format.
Key
Best Normal Form
Boyce-Codd Normal Form
Data Sheet
49. No partial functional-dependencies.
One-To-Many Relationship
Second Normal Form
Referential Integrity
Database
50. 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.
Referential Integrity Constraint
Database Object
Functional Dependency
First Normal Form
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