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