SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 116 123456789101112131415 SQL Questions 1 / 15 1. In order to delete the database, which keyword is used? A. DROP B. DELETE C. ALTER D. None of the above 2 / 15 2. 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 3 / 15 3. Which statement can be used for modifying the definition for an existing table? A. ALTER B. Modified C. SELECT D. FROM 4 / 15 4. 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 5 / 15 5. A multiple-table delete can apply any join. A. true B. false 6 / 15 6. 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 7 / 15 7. SQL DELETE can be used to delete, A. Rows B. Database C. View D. All of the above 8 / 15 8. 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 9 / 15 9. . A View can be used to select a subset of the table columns. A. true B. false 10 / 15 10. Full form of DML is – A. Data Multiplication Language B. Data Manipulation Language C. Data Modify Language D. Data Mapping Language 11 / 15 11. 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 12 / 15 12. Views are not updatable. A. true B. false 13 / 15 13. 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 14 / 15 14. 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 15 / 15 15. What is joining a table to itself called? A. COMPLETE B. SELF C. OBSOLETE D. CROSS Your score is The average score is 53% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Questions, Quiz