SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 403 123456789101112131415 SQL Questions 1 / 15 1. Is it necessary to insert the value in each column of the table? A. Yes B. No C. Depends on the server D. Depends on the usage of the table 2 / 15 2. What is xyz in the following MySQL statement?CREATE VIEW xyz AS SELECT a, b FROM t; A. table B. column C. view D. database 3 / 15 3. Which statement is TRUE about the WHERE Clause? A. In order to retrieve rows, WHERE Clause is used. B. In order to group the rows, WHERE Clause is used. C. In order to select the defined groups, WHERE Clause is used. D. In order to return the rows, WHERE Clause is used. 4 / 15 4. Full form of DCL is – A. Data Control Language B. Data Commit Language C. Data Common Language D. Data Concatenate Language 5 / 15 5. Which statement is TRUE about the ORDER BY Clause? A. In order to return the rows in a specific order, ORDER BY Clause is used. B. In order to group the rows, ORDER BY Clause is used. C. In order to select the defined groups, ORDER BY Clause is used. D. None of the above 6 / 15 6. 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 7 / 15 7. A multiple-table delete can apply any join. A. true B. false 8 / 15 8. What default value gets stored in columns of the table? A. NULL B. 1 C. -1 D. o 9 / 15 9. SQL INSERT is used to insert a – A. Single or Multiple record B. Single or Multiple database C. Single or Multiple table D. None of the above 10 / 15 10. Which command is used for the table definition in Mysql? A. DESC table_name; B. DESC table_name C. DESC D. None of the mentioned 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. What is the clause to delete all rows from the table? A. SQL DELETE ALL ROWS Table_Name; B. SQL DELETE ROWS Table_Name; C. DELETE FROM ALL ROWS Table_Name; D. DELETE FROM Table_Name; 13 / 15 13. 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 14 / 15 14. The clause that filters JOIN results is called _________ A. WHERE B. SORT C. GROUP D. GROUP BY 15 / 15 15. 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 Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By WordPress Quiz plugin Questions, Quiz
