Answer & Explanation

4 Answers
Verified

Option A

CREATE TABLE customers (id TEXT UNIQUE, name VARCHAR(100));
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 1
Verified

Option B

CREATE TABLE customers (id BIGINT, name VARCHAR(100));
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 2
Verified

Option C

CREATE TABLE customers (id BIGINT INDEX, name VARCHAR(100));
Additional Explanation
This option is incorrect for the stated requirement.
Sarkari Resultess
Editorial Answer 3
Verified Correct Answer

Option D

CREATE TABLE customers (id BIGINT PRIMARY KEY, name VARCHAR(100));
Additional Explanation
Correct implementation. Prefer parameterized queries in application code, validate affected rows for UPDATE/DELETE, and use transactions for related writes.
Sarkari Resultess
Editorial Answer 4