Microsoft Access - Theory

What does the acronym RDBMSstand for?

• Relational Database Management System
• Revision Database Management Server
• Replicated Database Main System
• Relation Data Binary Management System

What kind of a relational model is a DBMS?

• Formats records to related tables and fields.
• It is formatted as a tree layout.
• Contains the data in a file.
• It is formatted in cycles starting from tables.

Which of the below is not an advantage of a relational database?

• It can filter and display information located in different tables or queries.
• It can gather information located in different tables.
• The tables' structure is sorted by category.
• We can perform complex searches.

What happens when a primary key is set on a table?

• The referenced field is locked and cannot be modified.
• A security layer is created in the table.
• The relationships between the table and the rest of the tables are automatically created.
• An index of unique records is automatically created.

Where is an index used?

• For quick sorting of the records.
• For quick locating of the records.
• For checking the records for duplicate records.
• All of the above.

What are the requirements to set a relationship between two tables?

• Both tables must be located in the same database.
• Other relationships should already exist in the database.
• Field names should be in Latin characters.
• All of the above.

Which of the below table relationships is more common?

• There is no common relationship.
• One to many.
• Many to many.
• One to one.

Where is referential integrity used?

• When the records between tables are related and valid.
• When the records must have an index to be related.
• When table fields have repeated elements.
• When there are common elements in more than one table.

In which field do we insert unique data?

• In the field related to another table.
• In the field which has a list of values.
• In the field which has a primary key.
• In the field which has an index that allows duplicate records.

What must two tables have in order to draw data from both?

• Grouping.
• Primary key.
• Index.
• Relationship.