Quiz5_CSCI_4410

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

• SELECT LEN(*) FROM Persons

• SELECT COLUMNS(*) FROM Persons

• SELECT COUNT(*) FROM Persons

• SELECT NO(*) FROM Persons

The following MySQL query selects all the records from table Students where the age is 19,20, or 21:

SELECT * FROM Students WHERE Age BETWEEN 18 AND 22;

• True

• False

Please Write a MySQL query to extract all the records from table Students where Age is 20.

Answer explanation

SELECT * FROM Students WHERE Age = 20;

What does SQL stand for?

• Structured Query Language

• Strong Question Language

• Structured Question Language

• Sequential Query Language

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

• EXTRACT FirstName FROM Persons

• SELECT FirstName FROM Persons  

• SELECT Persons.FirstName

• SELECT * FROM FirstName;

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

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

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

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

• SELECT * FROM Persons WHERE FirstName='a'

Which SQL statement is used to return only unique (different) values?

• SELECT DISTINCT 

• SELECT DIFFERENT

• SELECT UNIQUE

• SELECT NEW

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

• SELECT * FROM Persons ORDER FirstName DESC

• SELECT * FROM Persons SORT BY 'FirstName' DESC

• SELECT * FROM Persons SORT 'FirstName' DESC

• SELECT * FROM Persons ORDER BY FirstName DESC  

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

• INSERT INTO Persons (FirstName, LastName) VALUES ('John', 'Doe');

• ADD INTO Persons (FirstName, LastName) ('John', 'Doe');

• INSERT (FirstName, LastName) INTO Persons VALUES ('John', 'Doe');

• CREATE INTO Persons (FirstName, LastName) VALUES ('John', 'Doe');

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

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

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

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

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