in SQL Plus a. i- create tablespace having size of 0.5 MB. ii. create a table with four columns in the tablespace created. iii. Display current size and free size available in created tablespace in terms of bytes only. iv. Insert values until it now longer has space for new rows. v. use appropriate technique to increase its size and reinsert some rows, so that around 50% of tablespace size is free. b- Create two users using your DBA permissions. Allot tablespace created to these users. c. i. Create two different roles and Grant appropriate privileges to these roles. ii. Allot roles to created users. iii. Through the Login credentials of the appropriate user, create two table with four different types of constraints each including check constraint. iv. Create a view, combing the above created two tables using join and grant permission for another appropriate user for the created view. d. i. Revoke the permissions from the users. ii. Revoke the privileges from the roles.
in SQL Plus
a.
i- create tablespace having size of 0.5 MB.
ii. create a table with four columns in the tablespace created.
iii. Display current size and free size available in created tablespace in terms of bytes only.
iv. Insert values until it now longer has space for new rows.
v. use appropriate technique to increase its size and reinsert some rows, so that around 50% of tablespace size is free.
b- Create two users using your DBA permissions. Allot tablespace created to these users.
c.
i. Create two different roles and Grant appropriate privileges to these roles.
ii. Allot roles to created users.
iii. Through the Login credentials of the appropriate user, create two table with
four different types of constraints each including check constraint.
iv. Create a view, combing the above created two tables using join and grant permission for another appropriate user for the created view.
d.
i. Revoke the permissions from the users.
ii. Revoke the privileges from the roles.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
