Page 1 of 1
9. Duplicate records will be eliminated, when a query uses A. Select Only Clause B. Where Distinct Clause C. Select Dist
Posted: Fri Jul 08, 2022 6:44 am
by answerhappygod
- 9 Duplicate Records Will Be Eliminated When A Query Uses A Select Only Clause B Where Distinct Clause C Select Dist 1 (100.52 KiB) Viewed 46 times
9. Duplicate records will be eliminated, when a query uses A. Select Only Clause B. Where Distinct Clause C. Select Distinct Clause D. From Distinct Clause 10. Which of the following is similar to "HAVING" clause in SQL
statement? A. SELECT B. WHERE C. FROM D. None of the mentioned 11. INSERT INTO Instructor VALUES (10211, 'Smith', 'Biology', 66000); What type of
statement is this? A. Query B. DML C. Relational D. DDL 12. What is the meaning of "GROUP BY" clause in SQL
statement? A. Group data by column values B. Group data by row values C. Group data by column and row values D. None of the mentioned 13. Which among the following belongs to an aggregate function? Select all that apply. A. COUNT B. TOTAL C. LOWER D. All of the above