Question: Implement SQL statements for the followings: i. Create a tablespace with a suitable name. (1.0 Mark) ii. Create a user with any name and password

 Implement SQL statements for the followings: i. Create a tablespace with

Implement SQL statements for the followings: i. Create a tablespace with a suitable name. (1.0 Mark) ii. Create a user with any name and password and assign this user to the above-created tablespace. (1.0 Mark) iii. Grant connect and DBA permission to the user created in the above statement. (1.0 Mark) iv. Create a table salary with column (employeeID, employeename, basesalary, allowances). You must make an employeeID a Primary key. (1.0 Mark) v. Insert two records in the salary table. (1.0 Mark) vi. View the data by applying aggregate functions (MIN, MAX, AVG, SUM). (1.0 Mark) vii. Create a trigger that will uppercase the employeename to be inserted into the salary table. (1.0 Mark) viii. Delete the trigger created in the above statement. (1.0 Mark) ix. Create a function that will add 5% to the base salary. (1.0 Mark) x. Create an index on employeeID and employeename of the salary table. (1.0 Mark)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!