Available Answers

1. 1.

   Multiple Choice Questions.

   1. This key uniquely identifies each record
      1. Primary Key
      2. Key Record
      3. Unique Key
      4. Field Name
   2. Which of the field has width 8 bytes?
      1. Memo
      2. Number
      3. Date/time
      4. Hyperlink
   3. Which of the following is not a database object ?
      1. Tables
      2. Queries
      3. Relationships
      4. Reports
   4. What are the columns in a Microsoft Access table called ?
      1. Row
      2. Records
      3. Fields
      4. Columns
   5. Which of the following is a method to  create a new table in MS Access ?
      1. Create Table in Design View
      2. Create Table Using Wizard
      3. Create Table by Entering Data
      4. All of the above
   6. To create a new table, in which method you don"t need to specify field type and size ?
      1. Create Table in Design View
      2. Create Table Using Wizard
      3. Create Table by Entering Data
      4. All of the above
   7. To sort records in a table
      1. Open table, click on the field on which there sorting is to be done, then click sort button on database toolbar.
      2. Open table, click sort button on database toolbar, choose field based on which to sort, click OK.
      3. Click the field heading to sort it ascending or descending.
      4. All of the above
   8. Which of the following is not a DBMS ?
      1. MS Excel
      2. MS Access
      3. Clipper
      4. FoxPro
   9. What are the different views to display table
      1. Datasheet View
      2. Design View
      3. Pivote Table & Pivot Chart View
      4. All of the above
   10. In MS Access, row of information are called
       1. Field
       2. Table
       3. Record
       4. None of the labove
2. 2.

   Fill in the blanks.

   1. A ___________ is a collection of interrelated data
   2. The __________ key is used to set relationship between two tables.
   3. The Table option on the ___________ menu is used to invoke the New Table dialog box.
   4. A record can be deleted using the ________ option on the Edit menu.
   5. The __________ option on the Record menu is used to remove an existing filter.
   6. The Sort option on the __________ menu is used to arrange the records.
   7. Full form of DBMS is _______________.
   8. Access __________ are a grid made up of rows and columns.
   9. The ____________ provides a step-by-step process to achieve the desired result.
   10. Database in Access have a default extension of ______________.
3. 3.

   What is a DBMS ? Give two examples.
4. 4.

   What are the advantages and disadvantage of DBMS ?
5. 5.

   What is a difference between primary key and foreign key ?
6. 6.

   Write steps of creating tables in design view.