Given a table 'StudAtt' with the structure (Rno, Attdate, Attendance). Identify the correct SQL command to add a composite primary key consisting of both 'Rno' and 'Attdate' columns after table creation.

Question

Computer Science · Structured Query Language

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

ALTER TABLE StudAtt ADD PRIMARY KEY(Rno, Attdate);

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on Structured Query Language?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · Structured Query Language

The Dandi March, also known as the Salt Satyagraha, was led by which influential leader?

Which act formally granted independence to India, marking the end of British rule?

Who was the key figure in establishing the Indian National Congress?

Answer 1

ALTER TABLE StudAtt ADD PRIMARY KEY(Rno, Attdate);

Answer 2

CREATE TABLE StudAtt ADD PRIMARY KEY(Rno);

Answer 3

ALTER TABLE StudAtt ADD PRIMARY KEY

Answer 4

ALTER TABLE StudAtt ADD PRIMARY KEY(Rno) AND PRIMARY KEY(Attdate);

Related Practice Questions