CACS485 Database Administration

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,…

10

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, 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

All Database Administration old questions