Practice Pakistan's most useful MCQs for competitive exams

In MS Access query, which of the fields is derived field? Query: SELECT product.qty AS Quantity, product.rate AS Rate, product.qty*product.rate AS Amount FROM product;

• (A)  Quantity
• (B)  Rate
• (C)  Amount
• (D)  Product

Answer

Submitted By :Ali Uppal

Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called

• (A)  Foreign key
• (B)  Native key
• (C)  Composite key
• (D)  Primary key

Answer

Submitted By :Ali Uppal

If I create Student field in Fees table to store student_id of Students table, then this Student field in Fees table is called:

• (A)  Foreign key
• (B)  Native key
• (C)  Composite key
• (D)  Primary key

Answer

Submitted By :Ali Uppal

A composite key is in MS Access

• (A)  Required when a table does not have any unique fields in it
• (B)  The primary key with AutoNumber as the field type
• (C)  Made up of two or more fields to uniquely identify records
• (D)  Is a foreign key that uniquely identifies records

Answer

Submitted By :Ali Uppal

A primary key in any table has the properties

• (A)  Not Null
• (B)  No Duplicates
• (C)  Both of above
• (D)  None of above

Answer

Submitted By :Ali Uppal

To create primary key for a table when in design view

• (A)  Type PRIMARY in field type box when creating required field
• (B)  Mark the Primary check box in field name of required field
• (C)  Click the Primary Key button in Design ribbon when the cursor is in required field
• (D)  None of the above

Answer

Submitted By :Ali Uppal

How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:

• (A)  Query Wizard
• (B)  Look up Wizard
• (C)  Form Wizard
• (D)  Report Wizard

Answer

Submitted By :Ali Uppal

The task of arranging data in order is called

• (A)  Searching
• (B)  Sorting
• (C)  Ordering
• (D)  Shorting

Answer

Submitted By :Ali Uppal

Each record is constituted by a number of individual data items which are called

• (A)  Fields
• (B)  Data Types
• (C)  Relations
• (D)  Tables

Answer

Submitted By :Ali Uppal

Which of the following is not a database object in MS Access?

• (A)  Tables
• (B)  Query
• (C)  Report
• (D)  Relationship

Answer

Submitted By :Ali Uppal