Table Database Object: ====================== 1) Creation of the table object: -------------------------------- Syntax: create table (col1 datatype, col2 datatype, col3 datatype,...); 2) Insert the data into the table: ---------------------------------- => to insert the data, we need to use one of the DML command named as "insert". 1) Simple method: ----------------- Syntax: insert into (col1, col2, col3,...) values(v1, v2, v3,...); Ex: Insert the tuple (row information) using simple method insert into CustomerInfo(SNo, CId, CName, Age, Gender, Location) values(1, 101021, "XYZ", 23, "Female", "Delhi"); 2) Direct Method: ----------------- Syntax: insert into values(v1, v2, v3,...); Ex: Inserting data into the table using direct method insert into CustomerInfo values(2, 112233, 'PQR', 22, 'Male', 'Mumbai'); 3) Run-time approach: -------------------- Syntax: insert into values(&col1, &col2, &col3,...); 3) Validation of the data: -------------------------- => to validate the data of the table after the insertion we need to use DRL Command named as "select". Syntax: select * from ; Note: ----- Before the validation, we must perform the commit operation. The operation is used with TCL command named as "commit". Syntax: commit; Ex: select * from CustomerInfo; 4) Formatting of the data: -------------------------- => to format the data, we need to use "set" Syntax: set linesize value; Assignment: ------------ Q-1: Write a Query to list all tables in the database of user account? Q-2: Write a query to create the table with name of "StudentData" which includes the below columns: SNo number, StuId number, StuName string, StuAge number, Gender, Division, Grade Ph.no After that, insert the data into the table and validate the data which was inserted.