Question

Create department table with the following structure.
Name Type
Deptno Number
Deptname Varchar2(10)
location Varchar2(10)
a. Add column designation to the department table.

b. Insert values into the table.

c. List the records of dept table grouped by deptno.

d. Update the record where deptno is 9.

e. Delete any column data from the table.

Answer 1

Explanation:

Zamindari System was introduced by Cornwallis in 1793 through Permanent Settlement Act. It was introduced in provinces of Bengal, Bihar, Orissa and Varanasi. Also known as Permanent Settlement System. Zamindars were recognized as owner of the lands. Zamindars were given the rights to collect the rent from the peasants.toZamindari System was introduced by Cornwallis in 1793 through Permanent Settlement Act. It was introduced in provinces of Bengal, Bihar, Orissa and Varanasi. Also known as Permanent Settlement System. Zamindars were recognized as owner of the lands. Zamindars were given the rights to collect the rent from Zamindari System was introduced by Cornwallis in 1793 through Permanent Settlement Act. It was introduced in provinces of Bengal, Bihar, Orissa and Varanasi. Also known as Permanent Settlement System. Zamindars were recognized as owner of the lands. Zamindars were given the rights to collect the rent from Zamindari System was introduced by Cornwallis in 1793 through Permanent Settlement Act. It was introduced in provinces of Bengal, Bihar, Orissa and Varanasi. Also known as Permanent Settlement System. Zamindars were recognized as owner of the lands. Zamindars were given the rights to collect the rent Zamindari System was introduced by Cornwallis in 1793 through Permanent Settlement Act. It was introduced in provinces of Bengal, Bihar, Orissa and Varanasi. Also known as Permanent Settlement System. Zamindars were recognized as owner of the lands. Zamindars were given the rights to collect the rent from Zamindari System was introduced by Cornwallis in 1793 through Permanent Settlement Act. It was introduced in provinces of Bengal, Bihar, Orissa and Varanasi. Also known as Permanent Settlement System. Zamindars were recognized as owner of the lands. Zamindars were given the rights to collect the rent from the peasants.to peasants.to the peasants.to peasants.to peasants.toZamindari System was introduced by Cornwallis in 1793 through Permanent Settlement Act. It was introduced in provinces of Bengal, Bihar, Orissa and Varanasi. Also known as Permanent Settlement System. Zamindars were recognized as owner of the lands. Zamindars were given the rights to collect the rent from the peasants.toZamindari System was introduced by Cornwallis in 1793 through Permanent Settlement Act. It was introduced in provinces of Bengal, Bihar, Orissa and Varanasi. Also known as Permanent Settlement System. Zamindars were recognized as owner of the lands. Zamindars were given the rights to collect the rent from the Zamindari System was introduced by Cornwallis in 1793 through Permanent Settlement Act. It was introduced in provinces of Bengal, Bihar, Orissa and Varanasi. Also known as Permanent Settlement System. Zamindars were recognized as owner of the lands. Zamindars were given the rights to collect the rent from the peasants.to

Answer 2

Answer:

a) create table dept ( Deptno int, Deptname varchar (10), location varchar (10));

b) insert into dept values( 9, "Finance", "Japan");

c) Select * from dept group by Deptno;

c) Update dept set location= "China" where Deptno=9;

d) Alter table dept drop column location;

Explanation:

• CREATE TABLE: Command creates table as per column demands further.
• INSERT INTO TABLE_NAME VALUE(a,b,c): Inserts records a,b,c in the table.
• GROUP BY : Returns the records group under distinct values in the field it's been applied upon.
• UPDATE : Updates the values.
• DROP: A DDL command interferes with the structure of the table with ALTER TABLE command.