SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 110 123456789101112131415 SQL Questions 1 / 15 1. What is x in the following MySQL statement? DELETE FROM x USING x LEFT JOIN y ON x.col = y.col; A. column name B. table name C. server name D. database name 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. A view can refer to multiple tables via __________ A. UNION B. JOIN C. GROUP D. SELECT 4 / 15 4. Which among the following is the correct syntax for modifying the definition of an existing table? A. ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT; B. ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT; C. ALTER TABLE person MODIFY person_id ; D. ALTER TABLE person 5 / 15 5. Which among the following are the correct definitions for “NULL” in Mysql? A. Absence of value B. Unknown C. Empty set D. All of the mentioned 6 / 15 6. CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B. NATURAL JOIN C. OUTER JOIN D. CARTESIAN JOIN 7 / 15 7. Command that comes under DCL is/are – A. GRANT B. REVOKE C. Both A. and B. D. None of the above 8 / 15 8. What is xyz in the following SQL statement? DELETE FROM xyz WHERE abc = 5; A. database name B. column name C. table name D. row name 9 / 15 9. Types of SQL Commands are – A. DDL B. DML C. DCL D. All of the above 10 / 15 10. Which datatype can store unstructured data in a column? A. CHAR B. RAW C. NUMERIC D. VARCHAR 11 / 15 11. In inner join, result is produced by matching rows in one table with rows in another table. A. true B. false 12 / 15 12. How many Primary keys can have in a table? A. Only 1 B. Only 2 C. Depends on no of Columns D. Depends on DBA 13 / 15 13. Command that comes under DML is/are – A. ROLLBACK B. GRANT C. UPDATE D. All of the above 14 / 15 14. What operator tests column for absence of data A. NOT Operator B. Exists Operator C. IS NULL Operator D. None of the above 15 / 15 15. By default, sorting by ORDER BY clause is done in which order? A. Ascending B. Descending Your score is The average score is 52% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Questions, Quiz
