SQL Questions March 14, 2023 | No Comments 0 votes, 0 avg 72 123456789101112131415 SQL Questions 1 / 15 1. 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 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 statement is TRUE about the ORDER BY Clause? A. In order to return the rows in a specific order, ORDER BY Clause is used. B. In order to group the rows, ORDER BY Clause is used. C. In order to select the defined groups, ORDER BY Clause is used. D. None of the above 4 / 15 4. What operator tests column for absence of data A. NOT Operator B. Exists Operator C. IS NULL Operator D. None of the above 5 / 15 5. A view can be deleted using the command __________ A. REMOVE B. DELETE C. CLEAR D. DROP 6 / 15 6. . A View can be used to select a subset of the table columns. A. true B. false 7 / 15 7. 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 8 / 15 8. Which of these is also known as a virtual table? A. SCHEMA B. DATABASE C. JOIN D. VIEW 9 / 15 9. By default, sorting by ORDER BY clause is done in which order? A. Ascending B. Descending 10 / 15 10. Full form of DDL is – A. Data Describe Language B. Definition Data Language C. Data Definition Language D. Data Distinct Language 11 / 15 11. CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B. NATURAL JOIN C. OUTER JOIN D. CARTESIAN JOIN 12 / 15 12. Is it necessary to insert the value in each column of the table? A. Yes B. No C. Depends on the server D. Depends on the usage of the table 13 / 15 13. Which one is not the OPTIONAL Clause in SELECT statement? A. WHERE B. ORDER BY C. HAVE D. HAVING 14 / 15 14. The clause that filters JOIN results is called _________ A. WHERE B. SORT C. GROUP D. GROUP BY 15 / 15 15. Full form of DCL is – A. Data Control Language B. Data Commit Language C. Data Common Language D. Data Concatenate Language Your score is The average score is 54% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Questions, Quiz