Question 45: How to change? “Hansen” Fort “Nilsen” in column “LastName” in the table “Persons”? A. MODIFY Persons SET LastName=”Nilsen” WHERE LastName=”Hansen” B. UPDATE Persons SET LastName=”Nilsen” WHERE LastName=”Hansen” C. MODIFY Persons SET LastName=”Hansen” INTO LastName=”Nilsen D. UPDATE Persons SET LastName=”Hansen” INTO LastName=”Nilsen” REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 42: In SQL, how can return all the records from the table “Persons” sorted in descending order by “FirstName”? A. SELECT * FROM Persons SORT BY ‘FirstName’ DESC B. SELECT * FROM Persons ORDER BY FirstName DESC C. SELECT * FROM Persons SORT ‘FirstName’ DESC D. SELECT * FROM Persons ORDER FirstName DESC REMOVE […]
Question 38: In SQL, how to select all the records from the table “Persons” where the value of column “FirstName” to be “Peter” and “LastName” to be “Jackson”? A. SELECT * FROM Persons WHERE FirstName=”Peter” AND LastName=”Jackson” B. SELECT * FROM Persons WHERE FirstName‘Peter’ AND LastName‘Jackson’ C. SELECT FirstName=”Peter”, LastName=”Jackson” FROM Persons A is the […]
Question 34: In SQL, how to select all columns from the table "Persons"? A. SELECT [all] FROM Persons B. SELECT * FROM Persons C. SELECT *.Persons D. SELECT Persons REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 30: Which SQL statement is used to update data in the database? A. MODIFY B. SAVE AS C. SAVE D. UPDATE EASY is the correct answer =============== Link Hoc va de thi 2021
Question 26: The only way to link two data tables together is to use ANSI standard syntax: A. Right B. Wrong REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 23: Sometimes, the syntax “select count ” will return less value than “select count(value)” A. Right B. Wrong REMOVEis the correct answer =============== Link Hoc va de thi 2021
Question 19: In SQL, how to delete the Peter record in the FirstName column of the Persons table: Question 19: In SQL, how to delete the Peter record in the FirstName column of the Persons table: =============== Link Hoc va de thi 2021
Question 15: In SQL, how to return all records data from Persons table in descending sort order in column FirstName: A. SELECT * FROM Persons SORT BY ‘FirstName’ DESC B. SELECT * FROM Persons ORDER BY FirstName DESC C. SELECT * FROM Persons ORDER FirstName DESC D. SELECT * FROM Persons SORT ‘FirstName’ DESC REMOVE […]
====================