Database Administration Important Questions

BCA Database Administration Important Questions For Exam Preparations

Unit 1: Introduction to Oracle Database

1. What is database administration? Explain the roles and responsibilities of a DBA.
2. What is indexing? Why is it important in a database? Explain the guidelines to create an index.
3. What is partitioning? Explain the different methods of table partitioning.
4. Explain the use of sequence in Oracle database with example.
5. What is a synonym? Why is it important? Explain with an example.
6. Explain views and materialized views in Oracle database with examples.
7. Write SQL commands for the following: create a table with given fields; add primary key; add check constraint; rename the table; insert some rows and delete one record; create a logical backup using Export Data Pump utility; give select/update privilege to another user; add a foreign key referencing another table; modify a field to increase character length; rename a field.

Unit 2: Managing Database Instances

1. Explain the Oracle database architecture in detail, including memory, process, and storage structure.
2. Describe the memory structure of Oracle database. Explain how PGA differs from SGA. Also explain Oracle instance and different components of SGA.
3. What do you mean by Oracle instance? Explain the different data structures used in SGA.
4. Explain the purpose of the Automatic Diagnostic Repository (ADR) in Oracle. How does it help in database diagnostics and troubleshooting?
5. Explain the process of starting up and shutting down an Oracle instance, including different startup/shutdown modes.
6. Explain the Alert Log and Trace Files — their purpose and use in troubleshooting.
7. Explain how initialization parameter files are managed in Oracle database.

Unit 3: Tablespace and Storage Management

1. What is multiplexing? Why is it needed? Write the steps of multiplexing the control files.
2. What is multiplexing? Why is it needed? Write the steps of multiplexing the online redo log files.
3. What are data files? How are they related to a tablespace? Write a command to add a datafile to an existing tablespace.
4. What is database archiving? Why is it important? Write the steps to keep your database in archive log mode.
5. Explain how to create and add a new tablespace in Oracle database.
6. Explain the purpose and management of control files in Oracle database.

Unit 4: Managing Users, Roles and Privileges

1. What is a profile? Why is it important? Explain with an example.
2. What is a user profile? Write the commands to create a user profile and assign it to a user.
3. Explain the different privileges in an Oracle database and explain how you can grant and revoke privileges to/from a user with examples.
4. What is privilege and why is it required? Explain the different system and object privileges used in Oracle database with their importance. Write commands to: create a common user and local user; create a role, assign two system privileges to it, and assign the role to a user; allocate unlimited space to a user on the ‘users’ tablespace; create a profile with given parameters (failed login attempts, idle time, sessions per user); assign the profile to the user.
5. Describe the steps to manage user passwords in Oracle database, including password expiration, complexity, and locking/unlocking accounts.
6. Explain how to monitor and manage user accounts in Oracle database, including account locking, unlocking, and password expiration.
7. Explain the principle of least privilege and how it applies to database user management.
8. Explain how quotas are assigned to users in Oracle database.

Unit 5: Multitenant Database Architecture

1. What is CDB and PDB in Oracle multitenant architecture? Explain how they are related.
2. Explain the Oracle multitenant architecture with CDB and PDB concept.
3. Explain how PDBs are related to CDB in multitenant architecture. Also mention the common things that they share with each other.
4. Create a Container Database named CDB_TEST. Provide the SQL commands you would use to create it and verify its creation.
5. Explain how privileges and roles are managed in multitenant architecture. Distinguish between common and local privileges.
6. Explain the steps to create a Pluggable Database (PDB) within a CDB.
7. Explain how security is managed in a multitenant database environment.

Unit 6: Configure the Oracle Network Environment

1. Explain the different methods of network configuration to connect to the Oracle database.
2. Explain the different Oracle Net service components.
3. How can you start and stop an Oracle Listener? Explain the commands with examples.
4. What is TNSPING? Explain how it is used to test Oracle Net connectivity.
5. Explain the different Oracle Net naming methods.

Unit 7: Backup and Recovery

1. Discuss backup, restore, and recovery in Oracle database. As a DBA in an organization, explain your backup and recovery strategy. Explain how you can recover the database in case of different types of failure. Also explain the process of media recovery.
2. What do you mean by database recovery? Explain in which situations a database needs to be recovered. Explain the difference between crash recovery and media recovery. Also explain the steps involved in media recovery.
3. As a DBA, explain how you can define a backup policy in your organization.
4. Explain the term backup, restore, and recovery in Oracle database. Also explain the different backup and recovery processes with examples using RMAN and Data Pump utility.
5. Describe the steps involved in configuring RMAN for performing database backups. Include commands or procedures used to set up RMAN.
6. Explain user-managed backup and recovery in Oracle database.
7. Explain the process of CDB and PDB flashback.

Unit 8: Automate Tasks with the Scheduler

1. List and briefly describe the main components of a scheduler. Explain how these components interact in a typical scheduling workflow.
2. What is scheduler and why is scheduler important in Oracle database? Explain the different components of the scheduler with their workflow. Also explain the difference between time-based scheduling and event-based scheduling.
3. What is job scheduling in Oracle database? Explain the difference between time-based and event-based schedule.
4. Explain how to create a job and job class using the Oracle Scheduler.
5. Explain the steps to create an event-based schedule with an example.

Note: This list is for reference purposes only, to help you prepare smartly and cover all the critical areas. Always review your class notes, teacher guidelines, and syllabus coverage.

Don’t use our content without permission. 📸⚠️

Thank you for sharing you everyone! If you’d like to share your notes, lab reports, solution, assignments, projects, or any other academic materials, feel free to contact us through social media (Uni Bytes), email us at unibytesofficials@gmail.com, or visit our website at www.unibytes.xyz.

We regularly provide updates on BCA news, results, exam routines, and other important information. Stay connected with Uni Bytes for all your academic needs

📢 Stay Connected with Us!

Follow us on social media for the latest updates, events, and more: