9. Duplicate records will be eliminated, when a query uses A. Select Only Clause B. Where Distinct Clause C. Select Dist

[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 45 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