Python with Data Science Set 1

What is the default file extension for a Microsoft Access database file?

• .xls

• .doc

• .accdb

• .mdb

Which data type should be used to store large text in Access?

• Short Text

• Long Text

• Memo

• Number

Which of the following is not a valid Access data type?

• Currency

• Date/ Time

• Email

• OLE Object

What type of data is stored using the “AutoNumber” datatype?

• Random Characters

• Sequential Numbers

• Currency Values

• Yes/ No Data

Which data type allows you to store a true/false value?

• Boolean

• Yes/ No

• Date/ Time

• Short Text

What is a primary key in a table?

• A field that allows duplicate values

• A unique identifier for each record

• A foreign key

• A field that contains the largest number

In Microsoft Access, which of the following is used to link two tables together?

• Query

• Foreign Key

• Primary Key

• Form

Which view allows you to modify the structure of a table in Access?

• Datasheet View

• Design View

• Layout View

• Print View

What does setting a field as "Required" do in a table?

• Ensures the field accepts only unique values

• Prevents the field from accepting null values

• Converts the field into a primary key

• Automatically generates values

Which of the following field properties defines the maximum amount of characters in a Short Text field?

• Field Size

• Data Type

• Indexed

• Default Value