Question 14: Which SQL statement to use to print out the records of all students whose last name starts with ‘L’? A. SELECT * FROM KETQUA_KIEMTRA WHERE HO_SV LIKE ‘L%’; B. SELECT * FROM KETQUA_KIEMTRA WHERE HO_SV LIKE ‘L’; C. SELECT * FROM KETQUA_KIEMTRA WHERE HO_SV = ‘L’; D. SELECT * FROM KETQUA_KIEMTRA WHERE HO_SV […]
Question 49: Which SQL statement allows to sort all books by price from high to low? A. SELECT ID_SACH, TEN_SACH, GIA FROM THONGTIN_SACH ORDER BY GIA DESC; B. SELECT ID_SACH, TEN_SACH, GIA FROM THONGTIN_SACH SORT BY GIA DESC; C. SELECT ID_SACH, TEN_SACH, GIA FROM THONGTIN_SACH SORT BY GIA ASC; D. SELECT ID_SACH, TEN_SACH, GIA FROM […]
Question 29: The GROUP BY command cannot be used with set functions A. Right B. Wrong REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 25: What is the INSERT command used for? A. To get data. B. To insert data. C. To modify data. REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 21: BETWEEN in SQL is used to…? A. Specify a column as the primary key. B. Specify the tables to use. C. Specify a range to test. OLD is the correct answer =============== Link Hoc va de thi 2021
Question 10: Which of the following SQL commands retrieves the string ‘Success’? A. SELECT ‘Success’ B. SELECT ‘Success’ C. SELECT LEFT(‘Success is all I need.’, 15) REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 6: Which of the following SQL statements is correct? A. SELECT * FROM Sales WHERE Date BETWEEN ’10/12/2005′ AND ’01/01/2006′ B. SELECT FROM Sales WHERE Date BETWEEN ’10/12/2005′ AND ’01/01/2006′ C. SELECT FROM Sales WHERE Date BETWEEN (’10/12/2005′, ’01/01/2006′) A is the correct answer =============== Link Hoc va de thi 2021
Question 2: Which SQL statement is used to create a table in the database? A. CREATE DB B. CREATE TABLE C. CREATE DATABASE TAB D. CREATE DATABASE TABLE REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 49: Which operator is used to get data in an interval? A. RANGE B. BETWEEN C. WITHIN REMOVE is the correct answer =============== Link Hoc va de thi 2021
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