Mysql-quiz 0 votes, 0 avg 5 123456789101112131415 SQL Questions 1 / 15 1. CREATE VIEW xyz (abc) AS SELECT a FROM t; A. row name B. column name C. view D. database 2 / 15 2. 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 3 / 15 3. Which of the following is not Constraint in SQL? A. Primary Key B. Not Null C. Check D. Union 4 / 15 4. How many Primary keys can have in a table? A. Only 1 B. Only 2 C. Depends on no of Columns D. Depends on DBA 5 / 15 5. A multiple-table delete can apply any join. A. true B. false 6 / 15 6. The clause that filters JOIN results is called _________ A. WHERE B. SORT C. GROUP D. GROUP BY 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. Full form of DDL is – A. Data Describe Language B. Definition Data Language C. Data Definition Language D. Data Distinct Language 9 / 15 9. Which operator is used to compare a value to a specified list of values? A. ANY B. BETWEEN C. ALL D. IN 10 / 15 10. UPDATE statement is a DML statement. What does DML stand for? A. Data Manipulation Language B. Data Manipulation Level C. Data Markup Language D. Data Markup Level 11 / 15 11. 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 12 / 15 12. Full form of DCL is - A. Data Control Language B. Data Commit Language C. Data Common Language D. Data Concatenate Language 13 / 15 13. A view can be deleted using the command __________ A. REMOVE B. DELETE C. CLEAR D. DROP 14 / 15 14. What is the difference between HAVING and WHERE clause? A. HAVING clause is used in column operation whereas WHERE clause is used in row operation. B. HAVING clause is post-filter whereas WHERE clause is pre-filter. C. HAVING clause filters the groups whereas WHERE clauses filter the single record of the table. D. All of the above 15 / 15 15. What is the functionality of SQL COUNT? A. It returns the no of record of table B. It returns the no of record of database C. It returns the no of record of row D. It returns the no of record of column Your score is The average score is 50% LinkedIn Facebook Twitter VKontakte 0% Restart quiz
