Word Count : 592

---

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); __________ _______ _____ _____ ___.
_____ _____ _________ ________ ___ _______ ________ _____ ____ ________ _____ ______.
_________ __________ ___ ________ ____ __________ ___ _______ _____.
______ _______ ______ ____ ______.
_________ __________ ________ ________ __________ __________.
________ ______ _________ _______ ______.
_______ ___ ________ ___ _________ ___ _____ _________ ______.
________ __________ _____ ____ _________.
_______ ____ _______ _________ ___ __________ ____ __________ ___ _________ _____ ____.
__________ _______ _________ ______ ______ __________ ________ _______ ___.
______ _____ __________ ___ ________ _______ ___ _____ ______ _________.
__________ ______ __________ _______ _______.
__________ _________ __________ ___ ________ _______ _______ _________.
_________ _______ ______ _________ ________.
_______ ________ __________ __________ _______ ________ ________ ______ _______ __________.
______ ___ ________ ___ ______ __________ ___ _________ _____ ______ _______.
_____ _____ __________ _________ _________ ___ ________ ______ _____.
______ _______ ______ _________ _________.
_____ _________ _________ ________ _______ _____.
__________ _______ _______ _______ _____ ______ ______ ____ ____.
_____ __________ __________ ______ _______ __________ ________ __________.
_____ ___ ________ ___ _________ _____.
________ _______ ____ ____ _______ __________ _________ __________ _________ ______.
________ ________ _____ ______ ________ ___ ______ __________.
_____ ______ _________ _______ _______ ____ ________ _____ ______ __________ _________.
____ _____ ___ ________ _______ _______.
_________ _________ ____ _________ _____ ___ __________.
__________ _______ ________ ________ __________ ______ ______ _____ ____ _________ ________ __________.
_________ ___ ___ _________ ____ _____ _________ _____ _________ _________ _____.
____ ________ _______ ______ _____ ________ ____ _______ _______ ______ ___ ___.
_____ _______ _____ __________ _________ ____ __________ _____ ____ ___ __________ __________.
_______ ___ _______ ________ __________.
________ _________ _____ ________ _____ ___ ___.
_____ ______ _____ ___ ___ _______ ___ _______ ________ ______.
_______ ________ ________ _______ ______.
____ _______ __________ __________ ________ _______ _______ ___ ____ ______ ___.
___ ___ ______ ________ _______ _______ ________ __________.
_____ _____ ________ ______ ___ ___ _______ _______ ______ ______ _________ __________.
_____ __________ ____ ________ _______ ___ ______ ______ __________.
__________ ____ ______ ________ __________ _____ _____ _____ _________ _______.
______ _________ _____ ____ __________ ________.
____ ________ ____ ______ _________ ____ __________ ___ ___ _________ __________ ____.
_____ __________ ___ ___ ________ ____.
______ _____ ______ ____ _________ ___ ____ _______.
____ ____ _____ ___ ____ ______ ___.
______ ________ ______ ________ ___ ___ ___ _________ ________ _______.
_______ ___ ___ _____ __________.
___ __________ ________ _________ _________ _____ ______ ___.
______ ________ __________ ________ ________ _____.
_____ ___ _______ ________ ____ ________ _____ ____ ______ ____ _______.
_______ ____ ______ _________ __________ ___.
________ _______ _____ ______ __________ __________ ____ ______ ___.
______ ____ __________ _____ ____ ________ _________ _______.
_______ ____ ___ ______ _____ _________ __________ __________ ____ _____.
________ _______ _______ _____ __________ _____ _________ _______ _____ __________ _________.
____ ___ ____ ________ _____ __________ __________ ____ ________ _________.
_______ _______ __________ __________ ________ __________.
Get Full Answer on WhatsApp