database mangment ch 2 pratice quiz

• Just that row (TeamId = 400) in te Team table will update its TeamID will chnage from 400 to 1400. There are no related ROWS in player table

• That row (TeamID = 400) in the team table will be updated to have a teamId of 1400 and so will related row(s) in the Player table that refer to it

• Nothing will be updated in the team table and nothing will be updated in the player table

• That row (teamid = 400) will not be updated in the reams teable but the related row(S) in teh layers table wil be updated to have a teamId of 1400

Player Id = 5600

• That row in the player table will be deleted and so will the related row(s) in the team table that refer to it

• That row will not be deleted from the Player table but related row or rows in the team table will be deleted

• Nothing will be deleted from the team table and nothing will be deleted from the players table

• Just that row in the Player table will be delted

Team id 500

• that row will not be updated in the teams table but the related rows in the player table will be updated

• Just that row in the team table will be updated/ its teamId will change from 500 to 550. There are no related rows in the Players table

• Nothing will be updated in the teams ore players table

• That row in the team table will be updated to have a new TEAMID of 550 and so will the related rows in teh player table that refer to it

team id 500

• Just that row in the team table will be deleted. There are no related rows in the Player table

• Nothing will be deleted from teams deleted or players

• That row will not be deleted from the team table the related rows in the players table will be deleted

• That row in the team table will be deleted and so will the related rows in teh player table that refer to it

teamid 200

• That row in the Team table will be updated to have a TeamID of 1200 and so will the related rows in the player table that refer to it

• Nothing will be updated

• Just that row in the team table will be updated to a new TeamId of 1200. There are no related row in the player table

• That row will not be updated in the team table but the relate rows in the player table will be ypdated to have teamId of 1200

Which of the following is not true about a primary key?

• The primary key can be used to created a foreign key

• The primary key should be composed of the fewest number of columns possible

• The primary key ensure each row in the relation is unquie

• The primary key can be a value or it can be null

Which of the following is used to represent an entity in a database?

• a primary key

• a relation

• a tuple

• an attribute

Review the Employeeroject relation below where EmpNumber plus ProiNumber plus Date is the Primary Key, What type of primary key does this relation have

• Surrogate primary key

• Transitive primary key

• Alternate primary key

• Composite primary key

• EmployeeID

• Dependents

• Employee

• All columns are vaild

• foreign key

• Alternate key

• Surrogate key

• composite key