GKwizard Which filter method lets you filter records based on criterion you specify? A. Filter by form B. Filter by selection C. Auto filter D. Advanced filter Answer: Option A
1 Which of the following is a NoSQL database? A. MySQL B. MongoDB C. PostgreSQL D. Oracle View Answer
2 What does the SQL 'TRUNCATE' command do? A. Deletes all rows from a table without logging individual row deletions B. Deletes only duplicate records C. Removes table structure D. Backs up the table View Answer
3 Which SQL clause is used to filter records based on conditions? A. GROUP BY B. ORDER BY C. HAVING D. WHERE View Answer
4 Which SQL clause is used to aggregate rows based on a condition? A. ORDER BY B. GROUP BY C. HAVING D. FILTER View Answer
5 Which SQL keyword is used to remove duplicate records in a SELECT query? A. DISTINCT B. UNIQUE C. REMOVE D. EXCLUDE View Answer