Computer Officer/Bank IT Officer Exam Preparation Materials

Multiple Choice Question on Building Links, Relationships, and Indexes in MS-Access

1.  You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?

A)           5

B)           8

C)           24

D)           Not enough information to tell

 

2.  Which of the following types of joins displays records with the same value in the common field?

A)           Inner join

B)           Left outer join

C)           Right outer join

D)           Self join

 

3.  A global join will be created automatically when using tables in a(n) _______________.

A)           form

B)           report

C)           query

D)           field

 

4.  Which of the following is the default join between two recordsets?

A)           Inner join

B)           Left outer join

C)           Right outer join

D)           Self join

 

5.  In a query's Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?

A)           The join line but not the relationship between the two tables

B)           The relationship between the two tables locally

C)           The relationship between the two tables globally

D)           The primary key of the first table

 

6.  What is an index?

A)           A wizard that creates a functional database structure based on the user's selections

B)           A widely recognized naming convention for database objects

C)           A sort order for records, which is identified in the table design

D)           A set of relationship rules that enforce defined database relationships

 

7.  You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?

A)           7

B)           17

C)           60

D)           Not enough information to tell

 

8.  Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?

A)           Edit Relationships

B)           Indexes

C)           Option

D)           Show Table

 

9.  In a junction table, the _______________ field consists of the foreign key from both the linked tables.

A)           first defined

B)           last defined

C)           foreign key

D)           primary key

 

10.  What does an inner join display?

A)           Records from the second recordset and only records from the first recordset where the common fields are equal

B)           Records from the first recordset and only records from the second recordset where the common fields are equal

C)           Records that have the same value in the common field

D)           Records from the first recordset only

 

ANSWERS:

1

2

3

4

5

6

7

8

9

10

C

A

B

A

B

C

C

A

C

C

 

You are here: Home MCQs Computer Officer Exam Computer Operator Preparation Database System Multiple Choice Question on Building Links, Relationships, and Indexes in MS-Access