🏠 Home
← Back Start Quiz
MCQ Practice

Computer & IT MCQs

Form Wizard in MS Access can build forms that can display ____ fields from table(s).

  • A. One
  • B. Two
  • C. Three
  • D. Many
Explanation:
The Form Wizard can pull fields from multiple related tables to create complex forms.

In MS Access, what is the minimum number of data types that can be assigned to a field?

  • A. 02
  • B. 06
  • C. 10
  • D. None of these
Explanation:
MS Access provides approximately 10 main data types that can be assigned to fields.

In MS Access, which of the following data types allows alphanumeric characters and special symbols?

  • A. Text
  • B. Memo
  • C. Auto number
  • D. None of these
Explanation:
The Text data type (Short Text) supports alphanumeric characters and special symbols up to 255 characters.

In MS Access, which data type is appropriate to store large text and numbers?

  • A. Text
  • B. Memo
  • C. OLE
  • D. None of these
Explanation:
The Memo data type (now Long Text) is designed for storing large amounts of text and numbers.

MS Access is used for ____.

  • A. Create web pages
  • B. Tool development
  • C. Data table
  • D. None of these
Explanation:
Microsoft Access is a database management system primarily used to create and manage data tables.

After creating the table, which of the following is correct?

  • A. Fields cannot be deleted
  • B. Fields cannot be added, but only once
  • C. Fields cannot be deleted
  • D. None of these
Explanation:
After the table is created, fields can normally be added or deleted.

Functional Dependencies are the types of constraints that are based on ____.

  • A. Key
  • B. Key revisited
  • C. Superset key
  • D. None of these
Explanation:
Functional dependencies are constraints that describe how one set of attributes determines another, typically based on keys.

Which type of table constraint will prevent the entry of duplicate rows?

  • A. Primary Key
  • B. Unique
  • C. Foreign Key
  • D. Check
Explanation:
The Unique constraint ensures no duplicate values in a column (Primary Key also enforces uniqueness, but is a special case).

What does SQL stand for?

  • A. System Query Language
  • B. Software Quality Language
  • C. Structured Query Language
  • D. Syntax Query Language
Explanation:
SQL is the standard language for managing and querying relational databases (Structured Query Language).

Which of the following is not a valid data type in MS Access?

  • A. Text
  • B. Picture
  • C. Numeric
  • D. Time
Explanation:
“Picture” is not a native data type in MS Access (use OLE Object or Attachment instead).