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…
10Write 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
Explain the purpose of the Automatic Diagnostic Repository (ADR) in Oracle. How does it help in database diagnostics and troubleshooting? [2+3]TU Board 20265Explain multiplexing of online redo logs and control files. How does it improve database reliability? [5]TU Board 20265Describe the steps to manage user passwords in Oracle Database, including password expiration, complexity, and locking/unlocking accounts. [5]TU Board 20265Create a Container Database named CDB TEST. Provide the SQL commands you would use to create it and verify its creation. [5]TU Board 20265How can you start an Oracle Listener? Explain the commands with examples. [5]TU Board 20265Describe the steps involved in configuring RMAN for performing database backups. Include commands or procedures used to set up RMAN. [5]TU Board 20265