SQL Quiz

Which word is missing from the following SQL statement? Select * table_name

• With

• Where

• From

• And

Which SQL statement would add a record to the database?

• INSERT INTO Designer VALUES ('SMI01', 'M Smith', '[e-mail]', '01224123456')

• INSERT VALUES ('SMI01', 'M Smith', '[e-mail]', 01224123456') INTO Designer

• INSERT ('SMI01', 'M Smith', '[e-mail]', '01224123456') INTO Designer

• INSERT Designer INTO VALUES (''SMI01', 'M Smith', '[e-mail]', '01224123456')

Where does the CREATE Command belong?

• DML

• DDL

• DCL

It is a DML command that is used to display record.

• DISPLAY

• STRUCTURE

• WHERE

• SELECT

______________ constraint prevents NULL values

• UNIQUE

• NOT NULL

• NULL

• FOREIGN KEY

A primary key can be NULL in the table? TRUE or FALSE

• TRUE

• FALSE

You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

• UPDATE Designer SET PhoneNo = '01224123456'

• UPDATE Designer (PhoneNo) VALUES ('01224123456')

• UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

• UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

• SELECT * FROM Items ORDER BY Price ASCENDING

• SELECT * FROM Items ORDER BY Price ASC

• SELECT * FROM Items BY Price LOWEST TO HIGHEST

• SELECT * FROM Items ORDER BY Price DESC

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" ends with an "a"?

• SELECT * FROM Persons WHERE FirstName='a'

• SELECT * FROM Persons WHERE FirstName LIKE 'a%'

• SELECT * FROM Persons WHERE FirstName LIKE '%a'

• SELECT * FROM Persons WHERE FirstName='%a%'

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

• SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy')

• SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy')

• SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy')

• SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy')