Differentiate Unique and Primary Key constraint.

Distinguish Between

Unique Key Constraint	Primary Key Constraint
The constraint ensures that no two rows have the same value in the specified columns.	This constraint declares a field as a Primary Key which helps to uniquely identify a record.
The UNIQUE constraint can be applied only to fields that have also been declared as NOT NULL.	The Primary Key does not allow NULL values and therefore a field declared as Primary Key must have the NOT NULL constraint.

shaalaa.com

SQL Commands and Their Functions

Is there an error in this question or solution?

Chapter 12: Structured Query Language (SQL) - Evaluation [Page 230]

Chapter 12 Structured Query Language (SQL)
Evaluation | Q 2. | Page 230

Which component of SQL lets inserts values in tables and which lets to create a table?

What is a constraint?

Write a short note on Primary key constraints.

Write a SQL statement to modify the student table structure by adding a new field.

Write any three DDL commands.

Write the use of the Savepoint command with an example.

Write a SQL statement using the DISTINCT keyword.

Consider the following employee table. Write SQL commands for the question.

To add a new row.

Consider the following employee table. Write SQL commands for the question.

To display the details of all employees who are operators.

Construct the following SQL statement in the student table-

SELECT statement using GROUP BY clause.