SQL Commands for your Handphone Contacts

Your friend has just changed handphone number

What is the most appropriate SQL statement to use?

• Select

• Insert

• Update

• Delete

You want to find out your friend's address

What is the most appropriate SQL statement to use?

• Select

• Insert

• Update

• Delete

You want to check if you already added your Friend into your Contacts

What is the most appropriate SQL statement to use?

• Select

• Insert

• Update

• Delete

You want to create a new contact in Contacts

What is the most appropriate SQL statement to use?

• Select

• Insert

• Update

• Delete

You want to find out how many friends called 'Mackenzy' are in your Contacts

What is the most appropriate SQL statement to use?

• Select

• Insert

• Update

• Delete

You want to get rid of a duplicate contact

What is the most appropriate SQL statement to use?

• Select

• Insert

• Update

• Delete

You want to change the name of a particular contact

What is the most appropriate SQL statement to use?

• Select

• Insert

• Update

• Delete

You want to add a new phone number to an existing Contact

What is the most appropriate SQL statement to use?

• Select

• Insert

• Update

• Delete

You want to add a photo to an existing Contact

What is the most appropriate SQL statement to use?

• Select

• Insert

• Update

• Delete

You want to find out the email address of a person in your Contacts

What is the most appropriate SQL statement to use?

• Select

• Insert

• Update

• Delete