Mysql-quiz 0 votes, 0 avg 23 123456789101112131415 SQL Questions 1 / 15 1. In order to sort the records according to the columns, which clause is used? A. HAVING B. GROUP BY C. ORDER BY D. None of the above 2 / 15 2. What is joining a table to itself called? A. COMPLETE B. SELF C. OBSOLETE D. CROSS 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. In inner join, result is produced by matching rows in one table with rows in another table. A. true B. false 5 / 15 5. Which keyword in the UPDATE statement is used to assign values to columns? A. ASSIGN B. SET C. MARK D. GET 6 / 15 6. . A View can be used to select a subset of the table columns. A. true B. false 7 / 15 7. The comma operator can also be used to join tables. A. true B. false 8 / 15 8. Which datatype can store unstructured data in a column? A. CHAR B. RAW C. NUMERIC D. VARCHAR 9 / 15 9. Which among the following is the correct syntax for defining “Constraint Check” in Mysql? A. gender char(1) check( gender IN (‘M’, ‘F’)), B. gender char (1) check, C. gender char (1) check ( gender ), D. none of the mentioned 10 / 15 10. 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 11 / 15 11. In order to delete the database, which keyword is used? A. DROP B. DELETE C. ALTER D. None of the above 12 / 15 12. What operator tests column for absence of data A. NOT Operator B. Exists Operator C. IS NULL Operator D. None of the above 13 / 15 13. Which of the following is not a valid aggregate function? A. COUNT B. COMPUTE C. SUM D. MAX 14 / 15 14. CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B. NATURAL JOIN C. OUTER JOIN D. CARTESIAN JOIN 15 / 15 15. In which join all the rows from the left table appear in the output irrespective of the content of the other table? A. RIGHT JOIN B. LEFT JOIN C. INNER JOIN D. OUTER JOIN Your score is The average score is 47% LinkedIn Facebook Twitter VKontakte 0% Restart quiz
