SQL

Question 1

What formats can be stored in database?

Answer 1

Text, Number, Date-time

Question 2

Before deleting a record or records from a table

Answer 2

You MUST use a where statement

The record must not be referenced via its foreign key by any other entity

Question 3

Which is the key used with SELECT to return only unique values?

Answer 3

DISTINCT

Question 4

Which of the following would be the correct operator to use with a partial string match utilizing the wildcard?

Answer 4

Like

Question 5

Which SQL statement is used to update data in a database?

Answer 5

UPDATE

Question 6

With SQL, how do you select all the columns from a table named ‘Persons’?

Answer 6

SELECT * FROM Persons

Question 7

With SQL, how do you select all the records from a table named ‘Persons’ where the FirstName is equal to ‘Peter’?

Answer 7

SELECT * FROM Persons WHERE FirstName=’Peter’

Question 8

With SQL, how can you insert a new record into the ‘Persons’ table?

Answer 8

INSERT INTO Persons VALUES (‘Jimmy’,’Jackson’)