The database contains several tables. Two tables named Employees and Department are joined with each other through a column named EmpID . The EmpID column is a primary key column in the Employees table and a foreign key column in the Department table. Peter has to delete the Employees table. What will happen when he tries to delete the Employees table? A. The Employees and the Department tables with the relationship will be deleted. B. The Employees table and the relationship will be deleted. 90
C. The Employees table will not be deleted as it contains primary key. D. All columns except the EmpID column will be deleted. Answer: B Explanation: When Peter deletes the Employees table, Microsoft Access asks to delete the relationships also. If Peter clicks the Yes button, the Employees table with the relationship will be deleted. QUESTION: 125 Which of the following characteristics is the most important characteristic of a field that is elected as a primary key in a table? A. Unique B. Easily remembered C. Small in size D. Simple datatype Answer: A Explanation: A table usually has a column or combination of columns whose values uniquely identify each row in the table. This column (or columns) is called the primary key. Primary key ensures that no duplicate or null values are entered in the column (or columns) defined as primary key columns. This enforces integrity of the table. A primary key can be created by defining a primary key constraint while creating or altering a table. A table can have only one primary key constraint. As primary key constraints ensure uniqueness, they are often defined by using an identity column. Answer C is incorrect. It is not important to consider the size of a primary key. Answer B is incorrect. For using a database, it is not necessary to remember record keys. Answer D is incorrect. A simple datatype is helpful in the key indexing, but it is not a primary characteristic. QUESTION: 126 Which of the following features are considered as the preventive maintenance tasks for Microsoft Office Access 2007 databases? Each correct answer represents a complete solution. Choose three. 91
A. Linked Table Manager B. Backup Database C. Compact and Repair Database D. Filter Answer: B, C, A Explanation: The following features are considered as the preventive maintenance tasks for Microsoft Office Access 2007: Backup: It makes copies of data to restore the original data after a loss event. Compact and Repair Database: It is used to perform routine maintenance of a database. Linked Table Manager: It lists the paths to all currently linked tables. Answer D is incorrect. Filter is not a preventive maintenance tool. It is used to choose one or more of the current values in a table field to select records to display. QUESTION: 127 You are working with Microsoft Office Access 2007. You are creating a query using the Design view. You want that the extracted data will display in a specific order.
You've reached the end of your free preview.
Want to read all 13 pages?
- Fall '20
- Foreign key, Microsoft Office 2007