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 database contains several tables. You open a table named Staffs which contains all information
about employees working in 1997. The structure of the table is given in the image below:
Now, you want to delete this table from the database. You get an error while deleting the table.
Which of the following is the most likely cause of the error?
A.
The table is connected with another table.
B.
The table does not have a primary key.
C.
The table is opened in the Design view.
D.
The table uses referential integrity.
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
tables.
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.