SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 382 123456789101112131415 SQL Questions 1 / 15 1. Select the correct statement. A. With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration. B. With the DML commands, any structural changes can be made to the table, including creation, deletion, and alteration. C. With the DCL commands, any structural changes can be made to the table, including creation, deletion, and alteration. D. With the TCL commands, any structural changes can be made to the table, including creation, deletion, and alteration. 2 / 15 2. 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 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. 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 5 / 15 5. By default, sorting by ORDER BY clause is done in which order? A. Ascending B. Descending 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. The comma operator can also be used to join tables. A. true B. false 8 / 15 8. CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B. NATURAL JOIN C. OUTER JOIN D. CARTESIAN JOIN 9 / 15 9. 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 10 / 15 10. What is the role of “CONSTRAINS” in defining a table in Mysql? A. Declaring primary key B. Declaring Foreign Key C. Restrictions on columns D. All of the mentioned 11 / 15 11. 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 12 / 15 12. Which operator is used to compare a value to a specified list of values? A. ANY B. BETWEEN C. ALL D. IN 13 / 15 13. 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 14 / 15 14. 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; 15 / 15 15. CREATE VIEW xyz (abc) AS SELECT a FROM t; A. row name B. column name C. view D. database Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By WordPress Quiz plugin Questions, Quiz
