SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 319 123456789101112131415 SQL Questions 1 / 15 1. Which keyword is used to delete all the rows from the table? A. TRUNCATE B. REMOVE C. DELETE ALL D. CLEAR 2 / 15 2. 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 3 / 15 3. CREATE VIEW xyz (abc) AS SELECT a FROM t; A. row name B. column name C. view D. database 4 / 15 4. 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 5 / 15 5. Will the following SQL command produce any error? INSERT INTO person (person_id, fname,lname) VALUES (1,’S’,’U’), VALUES (1,’T’,’U’); /* where person_id is a primary key */ A. Error B. No Error C. Depends D. None of the mentioned 6 / 15 6. Which keyword in the UPDATE statement is used to assign values to columns? A. ASSIGN B. SET C. MARK D. GET 7 / 15 7. Which of the following is not a valid aggregate function? A. COUNT B. COMPUTE C. SUM D. MAX 8 / 15 8. Which statement is TRUE about the GROUP BY Clause? A. In order to retrieve rows, GROUP BY Clause is used. B. In order to group the rows that share the same property, GROUP BY Clause is used. C. In order to select the defined groups, GROUP BY Clause is used. D. In order to return the rows, GROUP BY Clause is used. 9 / 15 9. Full form of DML is – A. Data Multiplication Language B. Data Manipulation Language C. Data Modify Language D. Data Mapping Language 10 / 15 10. Which of the following is not Constraint in SQL? A. Primary Key B. Not Null C. Check D. Union 11 / 15 11. Command that comes under DML is/are – A. ROLLBACK B. GRANT C. UPDATE D. All of the above 12 / 15 12. Which datatype can store unstructured data in a column? A. CHAR B. RAW C. NUMERIC D. VARCHAR 13 / 15 13. 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 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. Which operator is used to compare a value to a specified list of values? A. ANY B. BETWEEN C. ALL D. IN Your score is The average score is 58% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Questions, Quiz
