Question 50: Which of the following options is a structure to declare a stored procedure? A. create procedure [] as B. create procedure ([]) as C. create procedure [] as D. create stored procedure [] as Link Hoc va de thi 2021
You are here: Home / English test class 12 / Question 16: 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 questions following: I’ll take the new job whose salary is fantastic Link Hoc va de thi […]
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 37: What is the Tempdb database used for? Which of the following options is correct: A. For scheduling or some routine work B. Store temporary objects C. Sample database to create user databases D. Store all system information of Sql Server REMOVE is the correct answer =============== Link Hoc va de thi 2021
Q25: The edition of SQL Server Express is: A. Application Test Edition B. All is wrong C. Publication for data administration and analysis D. Free edition EASY is the correct answer =============== Link Hoc va de thi 2021
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 […]
Q10: Which SQL statement allows you to find the total sales of stores with ID 25 and stores with ID 45? A. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG WHERE ID_CUAHANG IN (25,45) GROUP BY ID_CUAHANG; B. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG GROUP BY ID_CUAHANG HAVING ID_CUAHANG IN (25,45); C. SELECT ID_CUAHANG, SUM(REVENUE) FROM BANHANG WHERE ID_CUAHANG […]
Question 45: What does TRANSACTION in SQL have properties often abbreviated as ACID? A. Access. Consistency. Isolation. Data. B. Access. Constraint. Index. Data. C. Atomicity. Consistency. Isolation. Durability. OLD 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 18: Which is not a keyword or clause in SQL? A. INSERT B. SELECT C. INVERT D. UPDATE OLD is the correct answer =============== Link Hoc va de thi 2021