2324 SABIS IT8 Periodic 1 Revision Sheet T#

What is a flat-file database?

• A database with multiple tables

• A database made up of one table that stores all the information

• A database with no tables

• A database with relational tables

What is a foreign key in a database?

• A key that cannot be duplicated

• A key in one table that references the primary key in another table

• A key that can be null

• A key that must be unique and not null

What is a one-to-many relationship in a database?

• A record in Table A may have only one corresponding record in Table B

• A record in Table A may have many corresponding records in Table B

• A record in Table A may have no corresponding records in Table B

• None of the above

Which view allows you to create or modify a query visually?

• SQL View

• Design View

• Datasheet View

• Layout View

What does a 'Select Query' do?

• Deletes data from a table

• Retrieves data from one or more tables

• Updates data in a table

• Creates a new table

What is the purpose of the 'Database Tools' tab in Access?

• To insert data into tables

• To define relationships between tables

• To delete tables

• None of the above

What is the purpose of a junction table in a database?

• To store the primary keys of two tables

• To store the foreign keys of two tables

• To establish a many-to-many relationship between two tables

• None of the above

What is the purpose of the 'Run' button in query design?

• To save the query

• To execute the query and display the results

• To print the query

• To check the query for errors

How do you sort data in a query?

• By using the 'Sort' button in the Home tab

• By selecting a sort order in the 'Sort' row in Design View

• By arranging the fields alphabetically

• By writing a sort algorithm

What is a relational database?

• A database with no relations between tables

• A database with one table

• A database that allows storing information in several tables that are linked together

• A database that does not allow linking tables