Mysql-quiz 0 votes, 0 avg 72 123456789101112131415 SQL Questions 1 / 15 1. What cannot be done on a view? A. display B. filter C. index D. drop 2 / 15 2. Select the correct syntax of SELECT TOP clause? A. SELECT TOP name B. SELECT TOP column C. SELECT TOP FROM D. SELECT TOP Number 3 / 15 3. Which data manipulation command is used to combines the records from one or more tables? A. SELECT B. PROJECT C. JOIN D. PRODUCT 4 / 15 4. Full form of TCL is - A. Transaction Common Language B. Transaction Commit Language C. Transaction Concatenate Language D. Transaction Control Language 5 / 15 5. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional? A. select_list B. table_list C. row_constraint D. grouping_columns 6 / 15 6. UPDATE statement is a DML statement. What does DML stand for? A. Data Manipulation Language B. Data Manipulation Level C. Data Markup Language D. Data Markup Level 7 / 15 7. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________ A. CARTESIAN JOIN B. CROSS JOIN C. INNER JOIN D. RIGHT JOIN 8 / 15 8. In order to delete the database, which keyword is used? A. DROP B. DELETE C. ALTER D. None of the above 9 / 15 9. In order to insert a row directly in the table, which command is used? A. INSERT IN B. INSERT INSIDE C. INSERT UNDER D. INSERT INTO 10 / 15 10. A view can be deleted using the command __________ A. REMOVE B. DELETE C. CLEAR D. DROP 11 / 15 11. Which clause is used to retrieve a unique element from the table? A. SELECT B. SELECT DISTINCT C. Both A) and B) D. None of the above 12 / 15 12. SQL Views are also known as A. Simple tables B. Virtual tables C. Complex tables D. Actual Tables 13 / 15 13. Will the following SQL command produce any error? INSERT INTO person (person_id, fname,lname) VALUES (1,’S’,’U’), VALUES (1,’T’,’U’); /* where person_id is a primary key */ A. Error B. No Error C. Depends D. None of the mentioned 14 / 15 14. What is the difference between HAVING and WHERE clause? A. HAVING clause is used in column operation whereas WHERE clause is used in row operation. B. HAVING clause is post-filter whereas WHERE clause is pre-filter. C. HAVING clause filters the groups whereas WHERE clauses filter the single record of the table. D. All of the above 15 / 15 15. Which of the following is not a valid aggregate function? A. COUNT B. COMPUTE C. SUM D. MAX Your score is The average score is 54% LinkedIn Facebook Twitter VKontakte 0% Restart quiz