Mysql-quiz 0 votes, 0 avg 112 123456789101112131415 SQL Questions 1 / 15 1. 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 2 / 15 2. 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 3 / 15 3. A multiple-table delete can apply any join. A. true B. false 4 / 15 4. By default, sorting by ORDER BY clause is done in which order? A. Ascending B. Descending 5 / 15 5. Types of SQL Commands are – A. DDL B. DML C. DCL D. All of the above 6 / 15 6. 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 7 / 15 7. What cannot be done on a view? A. display B. filter C. index D. drop 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. 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 10 / 15 10. What is joining a table to itself called? A. COMPLETE B. SELF C. OBSOLETE D. CROSS 11 / 15 11. In which join all the rows from the left table appear in the output irrespective of the content of the other table? A. RIGHT JOIN B. LEFT JOIN C. INNER JOIN D. OUTER JOIN 12 / 15 12. Which of these is also known as a virtual table? A. SCHEMA B. DATABASE C. JOIN D. VIEW 13 / 15 13. Commands that comes under DDL is/are – A. CREATE B. DROP C. TRUNCATE D. All of the above 14 / 15 14. 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 15 / 15 15. Which keyword in the UPDATE statement is used to assign values to columns? A. ASSIGN B. SET C. MARK D. GET Your score is The average score is 52% LinkedIn Facebook Twitter VKontakte 0% Restart quiz