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

Which of the following is not the MS-Access database object?

• Print
• Table
• Form
• Report

Query is used to ...

• Create table
• Retrieve data from database
• Print data
• Add data

What is the maximum length of text field?

• 512 characters
• 25 characters
• 255 characters
• No limit

Which of the following is true for uniquely identifies any record from the database?

• Index
• Memo
• Row
• Primary key

The maximum field size of Date/Time data type in MS-Access is …

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

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

• up to 512 mb
• up to 1 gb
• up to 4 gb
• no limit

Which of the following is/are the example of database?

• Marks ledger
• MS-Access
• MySQL
• Dictionary

Which of the following is/are the object of MS-Access?

• Table

• Record

• Form

• Query

When the field in the table is set to primary key the user can not …

• add new data record
• leave the field blank
• delete the data record
• insert the duplicate data value

What is/are the use of action query in MS-Access?

• Retrieve data records in crosstab view
• Mass changes in one operation
• Print all records at once
• None