GKwizard

The feature that database allows to access only certain records in database is:

A. Forms

B. Reports

C. Queries

D. Tables

Answer: Option C

Discussion

1

Which of the following is a NoSQL database?

A. MySQL

B. MongoDB

C. PostgreSQL

D. Oracle

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

3

Which SQL clause is used to filter records based on conditions?

A. GROUP BY

B. ORDER BY

C. HAVING

D. WHERE

4

Which SQL clause is used to aggregate rows based on a condition?

A. ORDER BY

B. GROUP BY

C. HAVING

D. FILTER

5

Which SQL keyword is used to remove duplicate records in a SELECT query?

A. DISTINCT

B. UNIQUE

C. REMOVE

D. EXCLUDE