Quiz#4- Databases

 

MULTIPLE CHOICE

 

           1.           In Microsoft Access, the row in a table represents a  __________

A)

Record

C)

Field

B)

Data file

D)

None of the above

 

 

ANS:  A

 

           2.           A Database Management System (DBMS) uses a hidden table in the database for the purpose of adopting any change done in the structure of data records. This table is called __________.

A)

Dummy table

C)

Data dictionary

B)

Hidden dictionary

D)

None of the above

 

 

ANS:  C

 

StudentName

CourseCode

Section

Grade

Mohammad

MIS105

1

B

Khalid

MIS105

2

C

Mohammad

MIS301

1

B

Figure 1

 

           3.           In Figure 1, the best choice for a key field is __________.

A)

CourseCode

B)

StudentName

C)

A composite key having CourseCode, StudentName and Section

D)

None of the above

 

 

ANS:  C                   

 

           4.           All objects in a Microsoft Access need ___________ to be there.

A)

Forms

C)

Web pages

B)

Tables

D)

None of the above

 

ANS:  B

 

           5.           The purpose of a Table object in a database is ___________

A)

To do calculations on existing data

C)

To show data records

B)

To modify data records

D)

All of the above

 

 

ANS:  D

 

6. Which of the following database personnel are responsible for identifying the logical database picture for an environment.

A.                 Database Administrator

B.                 Database Designer

C.                 Database Operator

D.                 None of the above

ANS: B

 

7. DB2 is a DBMS package manufactured by:

A.                 Microsoft

B.                 IBM

C.                 Sybase

D.                 None of the above

ANS: B

 

8. Which one of the following object is used for programming purposes in Microsoft Access.

A.                 Form

B.                 Table

C.                 Macro

D.                 Query

ANS: C

 

 

TRUE/FALSE

 

           1.           In Microsoft Access, it is possible to create a table without defining its key field.

 

ANS:  T

 

           2.           A deletion anomaly means loosing unwanted data while deleting some records in a table.

 

ANS:  T

 

           3.           In Microsoft Access, the data type Number can be used to store text data.

 

ANS:  F

 

           4.           In Microsoft Access, users can be forced to enter data values in a field by using the index property.

 

ANS:  F

 

           5.           The max value which can be saved in Number data type with field size Long Integer (4 bytes) is +231-1.

ANS:  T

 

 

6.  In Microsoft Access, DELETE Queries are used to change some fields in selected data records to new values.

 

ANS: F

 

7.  In Microsoft Access, the user Interface objects like table, queries etc. communicate with database engine through SQL commands.

 

ANS: T