MIS105-Quiz04

 

Multiple Choice

                 

NARRBEGIN: Figure 1

Figure 1: Student-Teacher Relationship

NARREND

 

                  1.   Consider two tables:  TEACHER & STUDENT in a University database (shown in Figure 1). Considering the facts that:

· A teacher can teach many students

· A student can be taught by many teachers.

 

Select the relationship type between STUDENT & TEACHER from the below given list which can properly represent the fact listed above.

A)

Many to one

C)

One to one

B)

One to many

D)

Many to many

 

 

ANS: D            NAR: Figure 1

 

                  2.   Many-to-many relationship can be implemented by decomposing it into two ________ relationships.

A)

one-to-one

C)

many-to-many

B)

one-to-many

D)

none of the above

 

ANS: B

 

                  3.   Which of the following would be returned in a query result if you type “like H*L*L” as a criteria for a text field of a Select query?

A)

Hil

C)

Hall

B)

Hiel

D)

None of the above

 

ANS: C

 

 

 

 

 

 

 

 

 

 

 

 

 

NARRBEGIN: Figure 2

           

Figure 2

NARREND

 

                  4.   Consider the QBE query design shown in Figure 2. You want a query to display all employees arranged in ascending order of their names and with earnings not more than  $60,000. You need to:

A.

Use two conditions under Earnings and Name on the same criteria row

B.

Use only one condition under Name and select a sorting option for Earnings

C.

Use only one condition under Earnings and select a sorting option for Name

D.

None of the above

ANS: C            NAR: Figure 2

 

                  5.   In a QBE grid, when two criteria expressions are entered on the DIFFERENT criteria row, it’ll make an effect of

A.

OR

C.

BETWEEN

B.

NOT

D.

AND

ANS: A

 

NARRBEGIN: Figure 3

Consider a database having 2 tables DEPARTMENT & STUDENT, having a one-to-many relationship between them. Also, suppose the cascaded update and delete option has been selected to Yes. The situation could be shown clearly from the below given Access screen shots.

 

Figure 3a: Department-Student Relationship Details

 

Consider the following data records inside the tables STUDENT & DEPARTMENT:

 

Figure 3b: Department Data Table

 

Figure 3c: Student Data Table

 

NARREND

 

                  6.   Considering the given data in the tables shown in Figure3b and Figure3c respectively and the fact that the referential integrity rules are implemented shown in Figure3a. Which one of the following record when entered to the STUDENT table will not be accepted by the DBMS ?

A.

ID Number=201238, Name=”Idris”, Admission Date=12/11/00,Dept Code=100, GPA=3.2

B.

ID Number=201238, Name=”Idris”, Admission Date=12/12/00, Dept Code=104, GPA=3.2

C.

Both A & B

D.

Neither A nor B

 

ANS: B            NAR: Figure 3

                  7.   Considering the given data in the tables shown in Figure3b and Figure3c respectively and the fact that the referential integrity rules are implemented shown in Figure3a. Which one of the following record when entered to the DEPARTMENT table will not be accepted by the DBMS ?

A.

Dept Code=103, Dept Name=MATH, Building Number=4

B.

Dept Code=104, Dept Name=PHY, Building Number=7

C.

Both A & B will be accepted

D.

None of A or B will be accepted

 

ANS: C            NAR: Figure 3

                  8.   If the record for COE is deleted from the DEPARTMENT table, the records for which ID numbers will automatically be deleted in the STUDENT table?

A.

201234,201235

C.

201234,201236

B.

201235,201236

D.

201236,201237

 

ANS: b            NAR: Figure 3

                  9.   If the ‘Dept Code’ of ICS department is changed to 111 in the DEPARTMENT table, the records for which ID numbers will automatically be updated for ‘Dept Code’ in the STUDENT table?

A.

201234

C.

201237

B.

201235

D.

None of the above

 

 

ANS: C            NAR: Figure 3

 

 

10. What will happen if record for 'Husam' is deleted from STUDENT table?

  1. A message will appear saying 'You cannot delete this record because.....'
  2. The record will be deleted after deletion is confirmed by the user
  3. The record can not be deleted because of the relationship with DEPARTMENT table.
  4. None of the above

ANS: B            NAR: Figure 3

 

True/False

 

                  1.   CREATE QUERY is a valid SQL Command.

ANS: F

 

 

                  2.   Queries help the user to select information from tables for displaying purpose only.

ANS: F

 

 

                  3.   APPEND Queries which can add more database records to some existing table is an example of Data manipulation queries.

ANS: T

 

 

                  4.   In QBE approach of Query design, user can use tables or other queries to built new queries.

ANS: T

 

                  5.   A condition “MIS” AND “MKT” used under the field Major of STUDENT table will return records for MIS and Marketing students.

ANS: F