GKwizard

Which of following relationship type is not possible to realize in Access Database directly?

A. One to one

B. One to many

C. Many to many

D. None of above

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