SQL MIDTERM EXAM

What does SQL stand for?

• Structured Query Language

• Structured Question Language

• Strong Question Language

• Standard Query Language

Which SQL statement is used to create a database table called 'Customers'?

• CREATE DB Customers

• CREATE DATABASE TAB Customers

• CREATE DATABASE TABLE Customers

• CREATE TABLE Customers

Which operator is used to search for a specified pattern in a column?

• GET

• LIKE

• FROM

• ILIKE

The NOT NULL constraint enforces a column to not accept NULL values.

• TRUE

• FALSE

Which operator is used to select values within a range?

• RANGE

• ORDER BY

• BETWEEN

• WITHIN

What is the most common type of join?

• INNER JOIN

• INSIDE JOIN

• JOINED

• JOINED TABLE

With SQL, how can you return the number of records in the "Persons" table?

• SELECT COUNT(*) FROM Persons

• SELECT NO(*) FROM Persons

• SELECT COLUMNS(*) FROM Persons

• SELECT LEN(*) FROM Persons

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

• DELETE ROW FirstName = 'Peter' FROM Persons

• DELETE FROM Persons WHERE FirstName = 'Peter'

• DELETE FirstName = 'Peter' FROM Persons

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

• UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

• MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

• MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

• UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

• INSERT INTO Persons ('Olsen') INTO LastName

• INSERT ('Olsen') INTO Persons (LastName)

• INSERT INTO Persons (LastName) VALUES ('Olsen')