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

Question

Share Report Error

In normalization, 1NF requires that:

A. The table has a primary key

B. There are no partial dependencies

C. All attributes have atomic values

D. There are no transitive 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

Share Report

Which data model uses objects, classes, and inheritance features, mirroring concepts from object-oriented programming?

A. Flat Data Model

B. Object-Oriented Data Model

C. Network Data Model

D. Relational Data Model

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Object-Oriented Data Model integrates object-oriented programming languages directly with databases, storing data as objects with attributes and methods.

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

Question #2

Share Report

What is the difference between a clustered and a non-clustered index?

A. Non-clustered determines physical order; clustered is logical

B. There is no difference

C. Clustered index determines physical order; non-clustered is a logical order

D. They both determine physical order

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A clustered index sorts the data rows and stores them in that order; a non-clustered index is a separate structure with pointers to data rows.

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