CACS405 Database Administration

Database AdministrationTU Board 2026

Write SQL commands for following: i. Create the table named blank having fields (Acc no, name, address, ph no, Balance) ii. Add primary key in above table iii. Add check constraints in the balance…

10

Write SQL commands for following: i. Create the table named blank having fields (Acc-no, name, address, ph-no, Balance) ii. Add primary key in above table iii. Add check constraints in the balance field, value of balance > 300. iv. Rename the table blank to Bank. v. Insert some rows and delete one of the record from the table Bank. vi. Create the logical backup of above table using expdp utility vii. Give select, update privilege to another user Mohan. viii. Add loan_id field as foreign key referencing to the loan. ix. Modify the name field to increase the character length. x. Rename the name field to cname. [10]

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