Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 employeelD and employeename of the salary table. (1.0 Mark)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started