You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database named Details. The…

Question

Exhibit

Options

• AThe table is connected with another table.
• BThe table does not have a primary key.
• CThe table is opened in the Design view.
• DThe table uses referential integrity.

• A
  4% (2)
• B
  10% (5)
• C
  71% (37)
• D
  15% (8)

Explanation

The cause of the error is that the table is opened in the Design view. When a table is opened in the Design view, the Datasheet view, the PivotChart view, or the PivotTable view, it cannot be deleted. In order to delete the table, all views must be closed. Answer: A is incorrect. A table can be deleted successfully when it is connected to two or more Answer: B is incorrect. A table can be deleted successfully even if it contains a primary key. Answer: D is incorrect. A table can be deleted successfully when it uses referential integrity.

No community discussion yet for this question.