Duplication of data or the storing of the same data in more than one place

Integrity B. Security C. Redundancy D. Attribute

Ans c

Structure that can store information about different categories of information and relationships between those categories of information

Non-Database B. Database C. Database Design D. Entity/Table

Ans b

Person, place, object, event or idea for which you want to store and process data.

Entity B. Database C. Spreadsheet D. Attribute

Ans a

Characteristic or property of an entity, may also be called a field or column

Integrity B. Security C. Attribute D. Entity

Ans c

File used to store data, Computer counterpart to ordinary paper file

Table B. Form C. Data File D. Report

Ans c

Visual way to represent a database

Data independence B. Forms C. Entity-relationship (E-R) diagram D. Reports

Ans c

Program, or collection of programs, through which users interact with a database

DBMS B. Data File C. Spread Sheet D. Forms

Ans A

Column or collection of columns of a table (relation) that uniquely identifies a given row in that table

Foreign Key B. Column Name C. Primary Key D. Record

Ans c

Question represented in a way the DBMS can recognize and process

Form B. Report C. Relationship D. Query

Ans D

Each individual criterion must be true in order for the compound criterion to be true

AND B. OR C. Group D. Aggregate

Ans A

Finding the values in a particular field on all the records; each calculation involves groups of records

Crosstab Query B. Text Data C. Aggregate function D. Group calculation

Ans D

A query that prompts for input whenever it is used.

Cross Tab Query B. Parameter Query C. Sub Query D. Function

ANS b

A condition that involves only a single field and a single value

reserved word B. simple condition C. HAVING clause D. compound

ANS B

An instruction by a user that directs a database to perform a certain action

The part of an SQL SELECT command that indicates grouping

GROUP BY clause B. FROM clause C. ORDER BY clause D. HAVING clause

The part of an SQL SELECT command that indicates a sort order

GROUP BY clause B. FROM clause C. ORDER BY clause D. HAVING clause

Two simple criteria in a query that are combines with the AND or OR operators

FROM clause B. Simple condition C. Compound condition D. HAVING clause

The first sort field

Major/Primary Sort key B. QBE (Query-by-Example)

C. Minor/Secondary Sort key D. Design Grid

Similar to the natural join except that it also includes records from each original table that are not common in both tables.

Natural Join B. Outer Join C. Join operation D. Join line

Includes operations that act on existing tables to produce new tables, similar to the way the operations of addition and subtraction act on numbers to produce new numbers in the mathematical algebra with which you are familiar.

SELECT command B. Relational Algebra C. Relational Database

D. Function

Language that is used to manipulate relational databases

SQL B. Programs C. Forms D. Reports

Command to describe table layout to the DBMS, which creates the table

SELECT B. UPDATE C. CREATE D. DELETE

Application programs or individual users picture of the database

Query B. Image C. Report D. View

Record numbers automatically assigned and used by DBMS to increase data retrieval efficiency

Row B. View C. Index D. Field

No field that is part of primary key may accept null values

Entity Integrity B. Referential Integrity C. Primary Key D. Foreign key

Foreign key field(s) whose value is required to match the value of the primary key for a second table

Entity Integrity B. Referential Integrity C. Primary Key D. Foreign key

No record can exist with a value in the field other than one of the legal values

Entity Integrity B. Legal value Integrity C. Primary Key D. Foreign key

A computer that is connect to a network and has access through the server to the database.

Server B. Index C. Client D. Documenter

An index with more than one key field.

Arguments B. Row-and-Column Subset View C. Multiple-field(column) Index D. Documenter

SQL command that changes tables structure

SELECT B. UPDATE C. CREATE D. ALTER

SQL command for deleting the table.

SELECT B. DROP C. DELETE D. ALTER

Contains information about tables in the database

Systables B. Syscolumns C. System catalog D. Sysindexes

Special file used to store a query that is run often and is placed on the server

Systables B. stored procedure C. System catalog D. Sysindexes

A column in a table that determines at least one other column

Alternate Key B. Interrelation Constraint C. Nonkey Column

D. Determinant

A dependency of a column on only a portion of the primary key

Partial Dependency B. Dependency Diagram C. Nonkey Attribute

D. Functional Dependence

In a table with columns A, B, and C, B is multi-dependent on A if each value for A is associated with a specific collection of values for B and, further, this collection is independent of any values for C

Multidetermine B. Multidependent C. Multivalued Dependence

D. Candidate key

A candidate key that was not chosen to be the primary key

Nonkey Column B. Nonkey Attribute C. Candidate Key D. Alternate Key

More than one entry at a single location in a table

Repeating Group B. Dependency Diagram C. Alternate Key

D. Candidate Key

The process of removing repeating groups to produce a first normal form table. Sometimes refers to the process of creating a third normal form table

Normalization Process B. Functional Dependence C. Primary Key

D. Dependency Diagram

The combination of two or more rows in an operation, such as join, or the combination of two or more columns for a primary key field to uniquely identify a given row in the table

Multidetermine B. Normalization C. Concatenation D. Candidate key

A relation (table) that contains a repeating group (or multiple entries for a single record)

1NF B. 2NF C. 3NF D. Unnormalized relation

In MS Access, Text Data type may contain maximum character of

255 Character B. 256 Character C. 1064 Character D. No Limit

Which of the following is not a valid Data Type in MS Access?

Memo B. Picture C. Currency D. Autonumber

In MS Access Hyperlink Data Type can store

Web address B. Email address C. Path of a file D. All the above

Which of the following data type is used to store logical value in MS Access?

True/ False B. Yes/No C. On/Off D. All the above

The appropriate Data Type to store Time in MS Access?

Date/Time B. Date C. Time D. Time cannot be stored

In MS Access Lookup Wizard is used to

To select from previous values B. To select values from Excel Sheet

C. To select value from another table D. Not a valid Data Type

In MS Access, AutoNumber Data Type can be

Random B. Sequential C. Edited D. Both A and B

Which object is used to create a form?

Tables and queries B. Tables only C. Tables and Reports D. Queries and reports

What is an intersection of a row and a column?

Form B. Cursor C. Cell D. Record