Python With Data Science Set 2

What happens when you save a database file in the older .mdb format in Access 2016 or later?

• All features are preserved

• Some advanced features, like data macros, are disabled

• The file size is reduced

• It improves compatibility with newer systems

Which data type is most suitable for storing a large binary file, such as an image or PDF, in Microsoft Access?

• OLE Object

• Attachment

• Long Text

• Hyperlink

Which of the following can result in a loss of precision when converting a field from a “Number” data type to “Currency”?

• Decimal rounding

• The field length limit

• Incorrect primary key settings

• Conversion to AutoNumber

When you import data from Excel into Access, which data type is most often chosen for numeric fields with decimals?

• Integer

• Double

• Currency

• Byte

Which datatype should be used when storing the result of a calculation in a table?

• Autonumber

• Calculated Field

• Lookup Field

• Hyperlink

What is a composite primary key?

• A primary key composed of multiple fields

• A foreign key combined with a primary key

• A primary key with non-unique values

• A primary key in a related table

In a table, what is the purpose of indexing a field?

• It allows duplicate values

• It speeds up searching and sorting based on that field

• It links tables together

• It removes duplicates from the table

What happens when you enforce referential integrity in Access?

• Duplicate records are automatically deleted

• It prevents inconsistent data between related tables

• It allows records to be deleted without warning

• It ensures all fields are indexed

Which of the following is NOT an advantage of using a lookup field in a table?

• It improves data entry speed

• It ensures that all entries follow a predefined list

• It makes data entry more intuitive

• It increases the speed of queries

What does the Cascade Delete option do in a relationship between tables?

• It prevents deletion of records with foreign key relationships

• It deletes all related records in another table

• It makes copies of the deleted records

• It asks for confirmation before deleting any record