Database - Part 1

What kind of relationship is this?

• one-way

• one-to-many

• many-to-one

• two-way

Which one is the correct example of a Boolean data type?

• left/right

• true/false

• yes/no

• 0/-1

What is a primary key?

• A primary key sets the data types in a table

• A primary key uniquely identifies each table in a database

• A primary key uniquely identifies each record in a table

• A primary key links two tables or more

Which one is the primary key?

• Qual_Code

• Full_Time

• None of the above

• Course_Code

Which button do we press to see the filtered results in the query?

• Run

• View

• Update

• Make Table

Which one is the correct example of a double data type?

• ABC

• 2.532

• 589

• $12.50

A table is in a …. format. But when importing, it is selected as a ...... format.

• excel... text...

• csv... text...

• text... csv....

• csv... excel...

What is a foreign key?

• A foreign key is a set of attributes in a record that refers to a database.

• A foreign key is a key to have a successful database system

• A foreign key is another name for a primary key

• A foreign key is a set of attributes in a table that refers to the primary key of another table.

Before we are creating a report, we must first create the…?

• Table

• Query

• Relationship

• All of the above

When we are doing a data entry into a table, we are actually creating a new …?

• query

• table

• record

• form