Thẻ: giao duc viet nam

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