Structured Query Language (SQL) is the standard language used to interact with relational databases. It enables users to create database objects, insert records, retrieve information, update existing data, and remove unwanted records. In a DBMS and Java Lab, SQL queries are commonly executed on a sample database containing tables such as Student, Course, Employee, or Department. The following SQL commands demonstrate the basic operations performed on a database. Create a table: ```sql CREATE TABLE Student ( StudentID INT PRIMARY KEY, Name VARCHAR(50), Age INT, Gender VARCHAR(10), Course VARCHAR(50), Marks INT ); ``` Insert records into the table: ```sql INSERT INTO Student VALUES (101, 'Amit', 20, 'Male', 'BCA', 85); INSERT INTO Student VALUES (102, 'Neha', 21, 'Female', 'BCA', 90); INSERT INTO Student VALUES (103, 'Rahul', 22, 'Male', 'MCA', 78); INSERT INTO Student VALUES (104, 'Priya', 20, 'Female', 'BCA', 88); INSERT INTO Student VALUES (105, 'Karan', 23, 'Male', 'MCA', 82); ``` Display all records: ```sql SELECT * FROM Student; ``` Display specific columns: ```sql SELECT StudentID, Name, Course FROM Student; ``` Display students whose marks are greater than 80: ```sql SELECT * FROM Student WHERE Marks > 80; ``` Display students of the BCA course: ```sql SELECT * FROM Student WHERE Course = 'BCA'; ``` Update the marks of a student: ```sql UPDATE Student SET Marks = 92 WHERE StudentID =