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
Question 25: What is the INSERT command used for? A. To get data. B. To insert data. C. To modify data. REMOVE 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
Question 14: What is Index in SQL? A. Is a database table attribute, which speeds up searching data in a table. B. A method to join 2 or more tables together. C. Same function as Alias A is the correct answer =============== Link Hoc va de thi 2021
Question 10: Which of the following SQL commands retrieves the string ‘Success’? A. SELECT ‘Success’ B. SELECT ‘Success’ C. SELECT LEFT(‘Success is all I need.’, 15) REMOVE is the correct answer =============== Link Hoc va de thi 2021
Question 6: Which of the following SQL statements is correct? A. SELECT * FROM Sales WHERE Date BETWEEN ’10/12/2005′ AND ’01/01/2006′ B. SELECT FROM Sales WHERE Date BETWEEN ’10/12/2005′ AND ’01/01/2006′ C. SELECT FROM Sales WHERE Date BETWEEN (’10/12/2005′, ’01/01/2006′) A is the correct answer =============== Link Hoc va de thi 2021
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 49: Which operator is used to get data in an interval? A. RANGE B. BETWEEN C. WITHIN REMOVE is the correct answer =============== Link Hoc va de thi 2021