Database AdministrationTU Board 2021
Write SQL commands for following i. Create the table named emp having fields (emp id, name, address DOB, Salary) ii. Add primary key in above table iii. Add check constraints in the salary fields,…
10Write SQL commands for following i. Create the table named emp having fields (emp-id, name, address DOB, Salary) ii. Add primary key in above table iii. Add check constraints in the salary fields, value of salary> 10000 iv. Rename the table emp to employee v. V Insert some rows and delete one of the record from the table employee vi. Create the logical backup-of above table using expdp utility vii. Give select, update privilege to another user Userl. viii.Add department_id field as foreign key referencing the table department. ix. Modify the name field to increase the character length x. Rename the name field to ename.
A worked answer is on its wayMeanwhile, read the Database Administration notes for this topic.
Discussion
Loading…
More Database Administration questions
What are data files? How it is related with tablespace? Write a command to add a datafile in existing tablespace.TU Board 20255Explain the different methods of network configuration to connect to the oracle database.TU Board 20255Explain the different privileges in an oracle database and explain how you can grant and revoke the privileges to the user with examples.TU Board 20255What is profile? Why is it important? Explain with an example.TU Board 20255Explain how PDBs are related to CDB in multitenant architecture. Also mention the common things that they share with each other.TU Board 20255What is multiplexing? Why is it needed? Write the steps of multiplexing the control files.TU Board 20255