Sign up for FREE

Oracle DML Exercise imp(03/03/24)

Last updated almost 2 years ago

5 questions

1

Question 1

1.

figure 1 : employee table

Attached are the employee table. Based on the data given construct SQL INSERT syntax to add all employee data in one command.

1

1

1

1

Question 2

2.

Based on employees table, apply SQL syntax to display/view all data from employee table

Question 3

3.

Apply SQL syntax to calculate sum of salary from employee table

Question 4

4.

Write SQL statement to show all employee data from dept_id 500

Question 5

5.

Apply SQL statement to calculate sum of salary employee table group by dept_id