In normalization, 1NF requires that: MCQ with Answer and Explanation

Question

Share Report Error

In normalization, 1NF requires that:

A. There are no transitive dependencies

B. The table has a primary key

C. All attributes have atomic values

D. There are no partial dependencies

Answer: Option C

Solution (By JKSSB Mock Tests)

First Normal Form (1NF) ensures that each attribute contains only atomic (indivisible) values.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Which of the following SQL commands belongs to the Data Definition Language (DDL) category?

A. CREATE

B. SELECT

C. UPDATE

D. INSERT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The CREATE command is a DDL statement because it defines, modifies, or creates database structures like tables, schemas, or indexes.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Which SQL statement is used to delete all rows from a table without logging individual row deletions?

A. REMOVE FROM table_name;

B. DROP TABLE table_name;

C. TRUNCATE TABLE table_name;

D. DELETE FROM table_name;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
TRUNCATE TABLE removes all rows and is a DDL operation with minimal logging, often faster than DELETE without WHERE.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Which aggregate function is used to count the number of rows in a table?

A. COUNT

B. MAX

C. SUM

D. AVG

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
COUNT returns the number of rows in a table or group.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs