Question 47: Which of the following options is the syntax of the data input statement in SQL? A. INSERT INTO B. INSERT INTO VALUES () C. INSERT INTO D. INSERT VALUES REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 32: Create a table structure in SQL, if at the Data Type of the corresponding column the user chooses the type ”Datetime”, how does the data of that column receive the value in the options below? OLD is the correct answer =============== Link Hoc va de thi 2021
Question 9: To display the table in ascending order of column ”Ten”, in the select statement we use which of the following clauses: A. Having ten asc B. Group by ten asc C. Order by ten desc D. Order by ten asc EASY is the correct answer =============== Link Hoc va de thi 2021
Question 5: Please choose the option corresponding to the statement used to create Database in SQL: A. Create database named_database B. Update database named_database C. Create table named_database D. Create data named_database Link Hoc va de thi 2021
Question 48: To create a Faculty table including (makhoa char (10), tenkhoa char (30), dienthoai char (10)) where makhoa is the primary key use which of the following commands: A. Create table Khoa (makhoa char (10), tenkhoa char (30), dienthoai char (10)) B. Create table Khoa (makhoa char (10) not null, tenkhoa char (30), dienthoai […]
Question 29: What is Table? Which of the following options is correct: A. A database object containing Select . statements B. Is the object containing the scripts of T-SQL C. Is the object that stores the data of the database D. Not a data storage object of the database OLD is the correct answer =============== […]
Question 17: What SQL statement to use to find the names of all students who scored higher than 90 on test #2? A. SELECT TEN_SV, HO_SV FROM KETQUA_KIEMTRA WHERE ID_BAIKT = 2 OR DIEM_KT > 90; B. SELECT TEN_SV, HO_SV FROM KETQUA_KIEMTRA WHERE ID_BAIKT = 2 AND DIEM_KT > 90; C. SELECT TEN_SV, HO_SV FROM […]
Question 41: Which SQL statement selects all rows from the Products table and sorts the results by the ProductID column? A. SELECT * FROM Products ORDERED BY ProductID B. SELECT * FROM Products ORDER BY ProductID C. SELECT * FROM Products WHERE ProductID > 200 D. SELECT ProductID FROM Products REMOVE is the correct answer […]
Question 33: What does DML mean? A. Different Mode Level B. Data Manipulation language C. Data Mode Lane D. Data Model Language REMOVE is the correct answer =============== Link Hoc va de thi 2021
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