Databases Nat 5

What field type would be used to store the following data "0125-5221"

• Text

• Number

• Time/Date

What does the data values from a field need to be in order for it to be named as a Primary Key

• Values need to be number

• Values need to be even

• Values need to be unique

• Values need to be a combination of letters and numbers

Which field is the best fit to be a primary key?

• FilmName

• FilmID

• AverageRating

• Director

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

• SELECT FilmName, YearReleased

  FROM Films

  WHERE YearReleased = "2018"

• SELECT FilmName, Director

  FROM Films

  WHERE FilmName ="Jurassic Park"

• 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?

• When the primary key is different from the foreign key and no changes are applied to either

• When the foreign key is similar to the primary key any changes are just applied to the foreign key

• When the primary key and the foreign key are the same and any changes are applied to both keys

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

• Presence Check

• Field Length Check

• Restricted Choice

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 of any user who's played for longer than 50 mins

• 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: check to see if data has been entered

• Presence Check

• Field Length Check

• Restricted Choice

What kind of cardinality is displayed here?

• One to one

• One to many

• Many to many