BCA 7th Semester
Database Administration Board Question Paper 2021

What do you mean by oracle Instance? Explain about the different data structures used in SGA.

What is synonym? why it is important? explain it with example.

What is database archiving? why it is important? Write the steps to keep your database in archive log mode.

Explain the term database administrator (DBA) and describe the different roles of DBA.

What is CDB and PDB in oracle multitenant architecture? explain how they are related.

What is user profile? write the commands to create the user profile and assign it to user.

What do you mean by database management system? Mention the clear architecture of oracle database management system including different files, process and memory structure.

Explain the term backup restore and recovery in oracle database. Also explain the different backups and recovery process with example using RMAN and datapump utility.

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.