Microsoft Access MCQs for Competitive Exams

181

A well-designed relational database minimizes:

A The number of tables B Data redundancy C The number of queries D The use of forms

Answer & Solution Discuss Save Report

182

Which data type is ideal for a primary key that has no real-world meaning but just needs to be unique?

A Short Text B Number (Long Integer) C AutoNumber D Date/Time

Answer & Solution Discuss Save Report

183

What happens if you try to enter a value into a foreign key field that does not exist in the related primary key field (with referential integrity enforced)?

A Access will automatically add the new value to the primary key table B Access will display an error message and prevent you from adding the record C Access will allow the entry but will highlight it in red D Access will delete the corresponding primary key record

Answer & Solution Discuss Save Report

184

A "Candidate Key" is:

A Another name for a Foreign Key B A field or set of fields that could potentially be used as the primary key C A key that has not yet been assigned D A key that is not unique

Answer & Solution Discuss Save Report

185

When Access displays a "Subdatasheet" (a small '+' sign next to a record), it is showing:

A Records from a related table based on a one-to-many relationship B A hidden field in the current table C A calculation error D A backup of the current record

Answer & Solution Discuss Save Report

186

A "self-join" or "self-referencing relationship" is when:

A Two tables are joined together B A table is joined to itself C A table has no primary key D A relationship is deleted

Answer & Solution Discuss Save Report

187

In a relationship between a "Departments" table and an "Employees" table, which is the "one" side?

A Employees B Departments C It could be either D Neither, this is a many-to-many relationship

Answer & Solution Discuss Save Report

188

Can a primary key field contain a Null (empty) value?

A Yes, if the record is temporary B Yes, but only for one record in the table C No, a primary key must always have a value D Only if it is a text field

Answer & Solution Discuss Save Report

189

What is the primary benefit of creating relationships between tables?

A It makes the database file smaller B It reduces data redundancy and improves data integrity C It makes data entry faster D It automatically creates forms and reports

Answer & Solution Discuss Save Report

190

An example of a many-to-many relationship would be between which two tables?

A Customers and Orders B States and Cities C Students and Classes D Products and Categories

Answer & Solution Discuss Save Report