SQL Server Course for Beginners with 100+ examples - ALTER TABLE Statement

The video tutorial explains the concept of primary keys in SQL, highlighting their importance in uniquely identifying records in a table. It demonstrates how to set up a database in SQL Server, create a table with a primary key, and insert records into the table. The tutorial also covers executing SQL commands to display records, emphasizing the primary key's role in maintaining data integrity.

What is a primary key used for in a SQL table?

• To allow duplicate records

• To uniquely identify each record

• To create multiple keys in a table

• To store NULL values

Which of the following can be a primary key in a student table?

• Student address

• Student age

• Student roll number

• Student name

How do you set a primary key on a column in SQL Server?

• By writing 'foreign key' after the column name

• By writing 'primary key' after the column name

• By writing 'unique key' after the column name

• By writing 'index key' after the column name

Which SQL command is used to insert records into a table?

• SELECT FROM

• UPDATE SET

• DELETE FROM

• INSERT INTO

What is the purpose of the SELECT statement in SQL?

• To delete records from a table

• To insert records into a table

• To display records from a table

• To update records in a table