Thẻ: Hoc tap 2022

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 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 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 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 […]

Question 8: In SQL how to select all records from Persons table with value in column FirstName is Peter: A. Select [all] FROM Persons WHERE FirstName=’Peter’ B. Select * FROM Persons WHERE FirstName LIKE’Peter’ C. Select [all] FROM Persons WHERE FirstName LIKE’Peter’ D. Select * FROM Persons WHERE FirstName=’Peter’ EASY is the correct answer =============== […]