Database administrator oracal SQL

Database administrator oracal SQL

Q1)

a) As part of providing data security for Bank GCC database, demonstrate practically the steps involved in user level data backup and recovery.

• You must create a user as your first name (e.g. Salim ), provide appropriate privileges for creating table(s) and insert records.

Your solution must include brief explanation of all the parameters and oracle SQL commands and screenshots showing the steps.

b) Create three database users assign the privileges as given below:

• Assign the privilege to the three users so that they can connect to the database.

• User1 should be able to create any table (e.g. table1) in the database and insert records into it. User1 should be allocated at least 5MB space in the Users tablespace.

• User2 should be able to insert records in the table created by User1 (i.e. table1).

• User3 should be only able to the view the records from the table created by User1 (i.e. table1).

• Both User1 and User2 should not be able to insert records on weekend holiday i.e. Friday.

Note: Your solution must include the necessary oracle SQL commands (as screenshots only) with brief explanation for each of the SQL commands. User name should be based on your first name (e.g. Salim1, Salim2, and Salim3).

DO NOT DIRECTLY COPY/PASTE FROM INTERNET/BOOKS! DO NOT COPY FROM ONE

ANOTHER! PRODUCE YOUR OWN ASSIGNMENT SOLUTION REPORT. The work submitted must

be your own and must not be based on inputs from others. Your assignments shall be

submitted to electronic databases to identify plagiarism. If assignment is found to be plagiarised, action will be initiated. Please refer to MEC policy on plagiarism the Student

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.

Discount Code: CIPD30

Click ORDER NOW..