Question 1: Choose the option corresponding to the syntax of the command to delete data in the options below: A. DROP B. DELETE WHERE C. DROP WHERE D. DELETE REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 40: To delete the database, how do we follow the steps in the options below: A. Right-click on the database name/Properties B. Right-click on the database name/Delete C. Right click on the database name/ Task D. Right click on the database name/ Rename REMOVE is the correct answer =============== Link Hoc va de thi […]
Question 21: Please choose the option corresponding to the acronym DBMS: A. Database Management System B. Database Management System C. Database makeup System D. Database Management System EASY is the correct answer =============== Link Hoc va de thi 2021
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