Databases Autoevaluation Quiz

What is a primary key in a database?

• A primary key is a field in a database that must always be unique (never repeat itself)

• A primary key is a record in a database that must always be unique(never repeat itself)

• Is a collection of fields for one thing, person or object. This essencially means a horizontal row of a database table.

• One piece of information about a thing or object in the form of a header for example Gender, Age, Address.

What is a record in a database?

• A primary key is a field in a database that must always be unique (never repeat itself)

• A primary key is a record in a database that must always be unique(never repeat itself)

• Is a collection of fields for one thing, person or object. This essencially means a horizontal row of a database table.

• One piece of information about a thing or object in the form of a header for example Gender, Age, Address.

What is a field in a database?

• A primary key is a field in a database that must always be unique (never repeat itself)

• A primary key is a record in a database that must always be unique(never repeat itself)

• Is a collection of fields for one thing, person or object. This essencially means a horizontal row of a database table.

• One piece of information about a thing or object in the form of a header for example Gender, Age, Address.

How many records are in the shown image?

• 15

• 75

• 5

• 16

How many fields are in the shown image?

• 15

• 75

• 5

• 16

Which one do you think is the most appropriate primary key from this database?

• Liner ID

• Year Built

• Gross Tonnage

• Country of Registration

• Country of Construction

What are SQL's in a database?

• Is a programming language for storing and processing information in a relationship with a database. (We can use it to store, update, remove, search and retrieve information from it)

• Is a programming language in Python that allows me to store, update, remove, search and retrieve information.

• Is a programming language in pseudocode that allows me to store, update, remove, search and retrieve information.

What will be the output for the following querry:

SELECT FirstName, Gender

FROM Colombia

WHERE (Gender == 'Male') OR (Gender == 'Female')

ORDER BY FirstName

• Iit will list the first name and the gender of all the people from Colombia who's gender is either male or female.

• Iit will list the first name and the gender of all the people from Colombia who's gender is either male or female, organizing them in order of their first names.

• Iit will list the first name and the gender of all the people from Romania who's gender is either male or female, organizing them in order of their first names.

• Iit will list the first name and the gender of all the people from Colombia who's gender is male and female at the same time.