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. There are no partial dependencies

C. The table has a primary key

D. All attributes have atomic values

Answer: Option D

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 SQL keyword is used to give users permission to access database objects?

A. ASSIGN

B. GRANT

C. REVOKE

D. PERMIT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
GRANT is a DCL command used to assign privileges to users.

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

Question #2

Which of the following best defines a Database?

A. A single file containing text

B. Hardware used to store programs

C. A collection of related data organized for easy access

D. Software for creating spreadsheets

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A database is an organized collection of related data stored electronically for efficient retrieval and management.

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

Question #3

Which type of relationship is represented by a foreign key in a relational database?

A. All of the above

B. Many-to-many

C. One-to-many

D. One-to-one

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Foreign keys can represent various relationships, including one-to-one, one-to-many, and many-to-many (via junction tables).

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

Explore All Database Management System (DBMS) MCQs