BCA 7th Semester
Database Administration Board Question Paper 2023

What is partitioning? Explain the different method of table partitioning.

As a DBA, explain how you can define a backup policy in your organization.

What is multiplexing? Why is it needed! Write the steps of multiplexing the online redo log files.

What is indexing? Why it is important in database? Explain the different guidelines to create index in database.

Explain the oracle multitenant architecture with CDB and PDB concept.

What is database administration? Explain the roles and responsibilities of DBA.

What do you mean by database recovery Explain in which situation database needs to be recovered. Explain the difference between crash recovery and media recovery. Also explain the steps involved in media recovery.

Describe the memory structure of oracle database. Explain how PGA differs from SGA. Also explain about oracle instance and different components of SGA.

What is privilege and why is it required? Explain the different system and object privileges used in ORACLE database with their importance. Write command to do following:
a) Create common user and local user.
b) Create a role, assign two system privileges on role and assign role to user.
c) Allocate unlimited space to user on 'users' tablespace
d) Create profile with following parameter.
i) Failed_login_attempts 2
ii) Idle time 5
iii) Sessions per user 3
e) Assign profile to the user.