Databases Nat 5

What field type would be used to store the the following phone number 07845774415

• Text

• Number

• Time/Date

• String

Which of the following statements is TRUE?

• A Primary Key needs to be a number.

• A Primary Key needs to already exist in another table.

• A Primary Key needs to be unique for each record.

• A Primary Key needs to be AutoNumber.

Which of the following fields should be used as the Primary Key in this entity?

• FilmName

• FilmID

• AverageRating

• Director

Which of these queries would display the name of all the films directed by Steven Spielberg?

• SELECT Director, YearReleased

  FROM Films

  WHERE Director="Steven Spielberg"

• SELECT FilmName, Director

  FROM Director

  WHERE Director="Steven Spielberg"

• SELECT FilmName, Director

  FROM Films

  WHERE Director="Steven Spielberg"

• SELECT FilmName, Director

  FROM Films

How is the table being sorted?

• YearReleased Ascending

• AverageRating Descending

• AverageRating Ascending

• FilmName Ascending

What is referential integrity?

• Ensuring the foreign key exists as a primary key before it can be used.

• Ensuring the primary key exists as a foreign key before it can be used.

• Ensuring the integrity of the database is upheld by validating all the entered data.

• Ensuring that the referenced type of validation is carried out on the specified data.

What kind of validation fits this description: Provides a list of options for the user to choose from.

• Presence Check

• Field Length Check

• Restricted Choice

• Range Check

What will this SQL statement do?

SELECT username, activetime

FROM userdetails

WHERE online = True;

• It will show all information from current online players.

• It will show the username and active time of any player who has ever played online games before.

• It will show the username and amount of time they've been active of any user that is currently online.

• It will show the username and amount of time they've been active of any user that is currently not online.

What kind of validation fits this description: Ensures that data has been entered in that field.

• Presence Check

• Field Length Check

• Restricted Choice

• Range Check

What kind of cardinality is displayed here?

• One to one

• One to many

• Many to many

• Many to one