SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 376 123456789101112131415 SQL Questions 1 / 15 1. Command that comes under DCL is/are – A. GRANT B. REVOKE C. Both A. and B. D. None of the above 2 / 15 2. What is generally done if an error occurs during the transaction? A. delete B. rollback C. commit D. update 3 / 15 3. Which datatype can store unstructured data in a column? A. CHAR B. RAW C. NUMERIC D. VARCHAR 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. Which operator is used to compare a value to a specified list of values? A. ANY B. BETWEEN C. ALL D. IN 6 / 15 6. 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 7 / 15 7. 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. 8 / 15 8. 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 9 / 15 9. The join where all possible row combinations are produced is called _________ A. INNER JOIN B. OUTER C. NATURAL D. CARTESIAN 10 / 15 10. What is the meaning of “REFERENCES” in table definition? A. Primary key B. NULL C. Foreign Key D. A ”foreign Key” belong to this particular table 11 / 15 11. Which keyword in the UPDATE statement is used to assign values to columns? A. ASSIGN B. SET C. MARK D. GET 12 / 15 12. SQL DELETE can be used to delete, A. Rows B. Database C. View D. All of the above 13 / 15 13. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional? A. select_list B. table_list C. row_constraint D. grouping_columns 14 / 15 14. A view can be deleted using the command __________ A. REMOVE B. DELETE C. CLEAR D. DROP 15 / 15 15. SQL Views are also known as A. Simple tables B. Virtual tables C. Complex tables D. Actual Tables Your score isThe average score is 58% LinkedIn Facebook VKontakte 0% Restart quiz By WordPress Quiz plugin Questions, Quiz
