Selected MCQ

Current Question
Which type of table constraint will prevent the entry of duplicate rows?
  • A. Primary Key
  • B. Unique
  • C. Foreign Key
  • D. Check
Correct Answer: B
Explanation:
The Unique constraint ensures no duplicate values in a column (Primary Key also enforces uniqueness, but is a special case).
Related Question 1
In MS Access, in which method do you not need to specify the field type and size when creating a new table?
  • A. Create a table in Design View
  • B. Create a table using the wizard
  • C. Create a table by entering data
  • D. All of these
Correct Answer: C
Explanation:
“Create Table by Entering data” (Datasheet View) lets Access automatically detect and assign field types.
Related Question 2
Functional Dependencies are the types of constraints that are based on ____.
  • A. Key
  • B. Key revisited
  • C. Superset key
  • D. None of these
Correct Answer: A
Explanation:
Functional dependencies are constraints that describe how one set of attributes determines another, typically based on keys.
Related Question 3
In Excel, the rows of a table correspond to ____.
  • A. Table
  • B. Record
  • C. Field
  • D. Cell
Correct Answer: B
Explanation:
Each row in a table represents one complete record.
Related Question 4
To create a table of columns and rows for statistical or mathematical calculations, using spreadsheet software is used.
  • A. Excel
  • B. Word Pad
  • C. WordPerfect
  • D. Corel Draw
Correct Answer: A
Explanation:
Excel is used for tables and calculations.
Related Question 5
By default, Word automatically formats each heading in a table of contents as ____.
  • A. Bookmarks
  • B. Cross-references
  • C. Hyperlinks
  • D. Word-fields
Correct Answer: C
Explanation:
Headings in a generated Table of Contents are automatically formatted as hyperlinks.