Mysql-quiz 0 votes, 0 avg 158 123456789101112131415 SQL Questions 1 / 15 1. 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 2 / 15 2. 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 3 / 15 3. Which keyword is used to delete all the rows from the table? A. TRUNCATE B. REMOVE C. DELETE ALL D. CLEAR 4 / 15 4. 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 5 / 15 5. 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. 6 / 15 6. 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 7 / 15 7. Which operator is used to compare a value to a specified list of values? A. ANY B. BETWEEN C. ALL D. IN 8 / 15 8. In the following SQL query, what does “person” stands for? INSERT INTO person (person_id, fname, lname) VALUES (1,’S’,’P’); A. Composite attributes B. Multivalued attributes C. Table name D. None of the mentioned 9 / 15 9. Commands that come under TCL is/are - A. COMMIT B. ROLLBACK C. SAVEPOINT D. All of the above 10 / 15 10. Types of SQL Commands are – A. DDL B. DML C. DCL D. All of the above 11 / 15 11. 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. 12 / 15 12. 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 13 / 15 13. What is generally done after the transactions are executed successfully? A. delete B. rollback C. commit D. update 14 / 15 14. Full form of DML is – A. Data Multiplication Language B. Data Manipulation Language C. Data Modify Language D. Data Mapping Language 15 / 15 15. Which function combines the two different columns? A. ADD B. MERGE C. CONCAT D. None of the above Your score is The average score is 54% LinkedIn Facebook Twitter VKontakte 0% Restart quiz
