Question 40: In the procedure declaration, the main procedure body begins after which of the following keywords? A. create procedure B. begin C. create D. as EASY is the correct answer =============== Link Hoc va de thi 2021
You are here: Home / English test class 12 / Question 23: Mark the letter A, B, C, or D on your answer sheet to indicate the word(s) CLOSEST in meaning to the underlined word(s) in each of the following questions: The coach explained the regulations at length to make sure that none of his […]
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 24: To disable the trigger with the DISABLE TRIGGER command has the following structure: A. DISABLE TRIGGER name_trigger IN { object_name | DATABASE | SERVER } B. DISABLE TRIGGER name_trigger ON { object_name | DATABASE | SERVER } C. DEL TRIGGER name_trigger ON { object_name | DATABASE | SERVER } D. DRO TRIGGER name_trigger […]
Question 12: In the Like operator, the character [ ] denotes what? Choose the correct option from the options below: A. Any single character within the limit B. Only 1 character is required C. Shows multiple characters in a string D. Characters not within the limits A is the correct answer =============== Link Hoc va […]
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 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 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 6: Following the table below, which SQL statement will find the sales amount of each store? A. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG; B. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG ORDER BY ID_CUAHANG; C. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG GROUP BY ID_CUAHANG; D. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG HAVING UNIQUE ID_CUAHANG; OLD is the correct answer […]
Question 37: Which of the following SQL statements has the correct syntax? A. SELECT Username, Password WHERE Username=”user1″ B. SELECT Username AND Password FROM Users C. SELECT Username, Password FROM Users OLD is the correct answer =============== Link Hoc va de thi 2021