CS-10 Chapter-8 DBMS Part 2: Rabin Ghimire

Which of the following data type is appropriate to store gender of person?

• Memo
• Currency
• Auto number
• Yes/No

Report is used for …

• Filter data records
• Print data records
• Add data records
• Create tables

Which of the following is not a field property?

• Indexed
• Field size
• Format
• Color

The maximum field size of Memo data type in MS-Access is … characters.

• 64000
• 255
• No limit
• 1024

The maximum field size of AutoNumber data type in MS-Access is …

• 4 bytes
• 2 bytes
• 6 bytes
• 8 bytes

The maximum field size of Hyperlink data type in MS-Access is … characters.

• 2000
• 1000
• 64000
• no limit

Which of the following is/are the examples of DBMS?

• Salary sheet
• Telephone directory
• ORACLE
• dBase

Which of the following is/are the data type of MS-Access?

• Table

• Auto number

• Caption

• Lookup wizard

Using the form object user can

• add new data record
• modify existing data record
• print the data record
• view the data record

Which of the following data type has/have 8 bytes field size in MS-Access?

• Date/Time
• Lookup Wizard
• Currency
• Yes/No