• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register

3.8 (6 reviews)
( 22 Students )
10 Hours


Oracle Multitenant DBA

Learn how to create an Oracle multitenant capabilities.
( add to cart )
Save 59% Offer ends on 31-Dec-2023
View Course Curriculum   Price Match Guarantee   Full Lifetime Access     Access on any Device   Technical Support    Secure Checkout   Course Completion Certificate
Instant access

Students also bought -

Completed the course? Request here for Certificate. ALL COURSES

Oracle Multitenant is a new option for Oracle database. It consists of a database and at least an instance. Oracle Multitenant enables an Oracle Database to function as a container database (CDB). All Oracle databases before Oracle Database 12c were non-CDBs. A CDB includes zero, one, or many customer-created pluggable databases (PDBs).  It consolidates multiple pluggable databases (PDB), a portable collection of schemas, schema objects, and non-schema objects.


Oracle multitenant databases were developed to help companies take advantage of all the above technologies and cost savings. There are different methods of creating a pluggable database like (i) creating a PDB from the seed (ii) Cloning PDBs from local or remote PDBs including the refreshable PDBs (iii) Plugging in an Unplugged PDB (iv) Relocating a PDB and others.


Oracle Multitenant DBA course by Uplatz will take you all the way to create an Oracle multitenant capabilities.  This is a good opportunity for the students to not only learn the concepts but also gain practical experiences in implementing them.

Course/Topic - Oracle Multitenant DBA - all lectures

  • In this tutorial you will provides an overview of the Oracle Database DBA from which you will get to know about the multitenant which represents one of the biggest architectural changes in the history of the Oracle database.

    • 21:35
  • This video describes step by step process of setting up Oracle Linux 7.8 in Oracle VirtualBox. This is the exactly same method we use every-time when we have to create a VM and practice Oracle.

    • 21:59
  • In this video we will show you how to properly install Oracle Database 19c software. Just to make the installation less complex and easy to understand we create simple sections.

    • 20:37
  • This tutorial shows you how to create the Container Database (CDB) and non-container database with a typical configuration. You can also create a non-CDB either automatically or manually. Oracle suggest that you can use the automatic creation procedure outlined in creating a Database automatically.

    • 23:29
  • In this video you will know to about CREATE PLUGGABLE DATABASE statement to create a new PDB by using the files of the PDB seed or an application PDB from the files of an application seed or the PDB seed.The statement copies these files to a new location and associates them with the new PDB. The following figure illustrates how this technique creates a new PDB in a CDB with the CDB root as the current container.

    • 26:10
  • As an Oracle database administrator (DBA), you can expect to be involved in the following tasks such as Installing Oracle software, Creating Oracle databases, Performing upgrades of the database and software to new release levels, Starting and shutting down the database instance, Managing the storage structures of the database and many more.

    • 35:15
  • In this video you will learn how to Creating a PDB by Cloning from Local and Remote PDBs and how to use them.

    • 16:56
  • In this session, Create and define a destination for the new data files, plug the unplugged PDB into the CDB, and then copy the data files of the unplugged PDB. Use the data files of the unplugged PDB to plug the PDB into the CDB and copy the data files to a new location.

    • 21:11
  • In this video, you need to convert a non-CDB database into a CDB pluggable database. This video describes methods that you can use to convert a non-CDB database into a CDB database.

    • 40:18
  • To Connect to the local database to initiate the relocate. Check the local CDB is in local undo mode and archive log mode. Create a public database link in the local CDB, pointing to the remote CDB. Remember to remove this once the relocate is complete.

    • 24:18
  • A Common user is a user which have the same username and password authentication across of PDBs of CDB. Common users and Local users: This concept came with Oracle Database 12c. Common Users.

    • 40:05
  • A backup of the root container is a backup of the CDB, excluding any of the PDBs. Connect to RMAN using OS authentication and backup the root container using the command in this video.

    • 31:59
  • Oracle Flashback Database gives a more efficient direct alternative to database point-in-time recovery. It is unlike the other flashback features in that it operates at a physical level. When you use Flashback Database, your current datafiles revert to their contents at a past time.

    • 38:17
  • In this video, you can use PL/SQL package procedures to administer Oracle Resource Manager (Resource Manager) to allocate resources to pluggable databases (PDBs) in a multitenant container database (CDB).

    • 25:23
  • A PDB is a portable set of schemas, schema objects, and non-schema objects that appear to an Oracle Net client as a non-CDB. A multitenant container database (CDB) is an Oracle database that includes zero, one, or many user-created pluggable databases (PDBs).

    • 17:03
  • In this last video You can learn the administer application containers, including application roots and application PDBs. You can also administer the applications installed in application containers.

    • 38:49
Objectives Back to Top

End-to-end knowledge of Oracle Multitenant Database Administration

Become a top Oracle DBA

Learn Oracle Multitenant Database Administration & Management

Manage Oracle Database Multitenant Architecture

Overview of Oracle Multitenant DBA

Installing Oracle Linux 7.8 in Oracle Virtual Box

Installing Oracle Database 19c Software

Creating CDB and non-CDB databases

Creating PDBs from the Seed

Performing Basic CDB Administration Tasks

Creating a PDB by Cloning from Local and Remote PDBs

Creating PDB by Plugging in an Unplugged PDB

Creating a PDB from non-CDB

Creating a PDB by Relocating a PDB

Managing Common and Local Users

Backup and Recovery in CDB and PDBs

Flashback and Point-in-time Recovery

Using Resource Manager with CDB and PDBs

Using Data Pump Utility with PDBs

Managing Applications and Application Containers


Syllabus Back to Top

Oracle Multitenant DBA - Course Syllabus

1. Overview of Oracle Multitenant DBA

2. Installing Oracle Linux 7.8 in Oracle Virtual Box

3. Installing Oracle Database 19c Software

4. Creating CDB and non-CDB databases

5. Creating PDBs from the Seed

6. Performing Basic CDB Administration Tasks

7. Creating a PDB by Cloning from Local and Remote PDBs

8. Creating PDB by Plugging in an Unplugged PDB

9. Creating a PDB from non-CDB

10. Creating a PDB by Relocating a PDB

11. Managing Common and Local Users

12. Backup and Recovery in CDB and PDBs

13. Flashback and Point-in-time Recovery

14. Using Resource Manager with CDB and PDBs

15. Using Data Pump Utility with PDBs

16. Managing Applications and Application Containers


Certification Back to Top

The Oracle Multitenant DBA Certification ensures you know planning, production and measurement techniques needed to stand out from the competition. 

Multi-tenancy means that a single instance of the software and its supporting infrastructure serves multiple customers. Each customer shares the software application and also shares a single database. Each tenant's data is isolated and remains invisible to other tenants.

A pluggable database (PDB) is a portable collection of schemas, schema objects, and non schema objects that appears to an Oracle Net client as a non-CDB. PDBs can be plugged into CDBs. A CDB can contain multiple PDBs. Each PDB appears on the network as a separate database.

A multi-instance architecture provides each customer with their own unique database. Rather than using a large centralized database, instances are deployed on a per-customer basis, allowing the multi-instance cloud to scale horizontally and infinitely.

The Oracle Certified Associate (OCA) credential is the first step toward achieving an Oracle Certified Professional certification. The OCA credential ensures a candidate is equipped with fundamental skills, providing a strong foundation for supporting Oracle products.

Oracle's Java Certification has a tough passing percentage, close to 65% for both OCAJP (the Oracle Certified Associate Java Programmer) and OCPJP (the Oracle Certified Professional Java Programmer). You need in-depth knowledge of the Java language and API to succeed in the exam.

Database administrator (DBA): Responsible for installing, configuring and maintaining a database management system (DBMS). Often tied to a specific platform such as Oracle, MySQL, DB2 or SQL Server.

Uplatz online training guarantees the participants to successfully go through the  Oracle Multitenant DBA Certification provided by Uplatz. Uplatz provides appropriate teaching and expertise training to equip the participants for implementing the learnt concepts in an organization.

Course Completion Certificate will be awarded by Uplatz upon successful completion of the  Oracle Multitenant DBA online course.

Career & Jobs Back to Top

The  Oracle Multitenant DBA draws an average salary of $115,000 per year depending on their knowledge and hands-on experience.

A career on the same is always a very key role for any candidate who is really expert in Oracle database management system. Also, looking for some challenging role and job satisfaction will be a good career to choose.

You'll find Oracle DBAs in virtually any and all industries as generally, every business needs some form of database management. According to the National Bureau of Labor Statistics, the demand for Oracle database jobs is set to rise 11% through 2026.

Note that salaries are generally higher at large companies rather than small ones. Your salary will also differ based on the market you work in.

Oracle WebLogic Administrator.

Senior Oracle WebLogic Administrator.

Oracle Applications DBA.

WebLogic Administrator.


Interview Questions Back to Top

Q1. List four possible ways (direct or indirect) to execute an SQL query against an Oracle Database?


  • Using the SQL*Plus command-line tool. With this tool, you can directly execute SQL commands.
  • Using a GUI (Graphical User Interface) tool like SQL Developer. You can directly execute SQL commands with such tools.
  • Using Oracle Enterprise Manager. This is an indirect way of executing an SQL query. When you perform certain operations with Oracle Enterprise Manager, they are converted to SQL queries implicitly and these SQL queries are executed against the database.
  • Writing your own program. This is not a conventional way of executing your queries but actually, it is widely used. Any web or windows program that uses an Oracle database at the backend, executes SQL queries. These programs are written using a programming language like .NET or JAVA and they use a driver to connect to the database.

Q2. What Is SQL*Plus? How can one acquire it and what kind of operations can be performed with it?


  • SQL*Plus is a command-line tool developed by Oracle Corporation.
  • It is freely distributed. It is shipped with Oracle client installations or Oracle database installations as a default. So, if Oracle client or Oracle database software is installed on a computer, you can find it under the “$ORACLE_HOME/bin/” directory. The name of the executable is “surplus” on Linux systems and “sqlplus.exe” on Microsoft Window Systems.
  • You can connect to an Oracle database with it. Once connected, you can execute Oracle commands or SQL queries against the connected database. SQL*Plus has also its own commands for formatting the output so that you can display the results in a meat way.

Q3. Who is responsible to update the indexes?

Ans. Oracle automatically maintains and uses indexes and when any change is made in the table data Oracle automatically distributes it into relevant indexes.

Q4. In our organization, we’re using an Oracle database whose version is Explain what each digit shows?

Ans. “11”: This first digit shows the major database version. Oracle usually publishes a major release once a 4 year. This digit is usually followed by a character describing the nature of the release. For example: 9i (internet), 10g (grid), 11g (grid), 12c (cloud).

“2”: This second digit shows the maintenance release number of the software. Oracle publishes the major release as maintenance release 1 and then usually publishes a second maintenance release during the lifetime of the software. New features are added to database Software with maintenance releases.

“o”: This third digit is Fusion Middleware Number. This will be o for database software.

“4”: This fourth digit is called Component-Specific Release Number and it shows the path set update that was applied to the software. Patch set updates are published 4 times a year by Oracle and as you apply them to your database software, this fourth digit advances.

Q5. In Oracle terminology, what is a Synonym?

Ans. A synonym is an identifier that can be used to reference another database object in a SQL statement. The types of database objects for which a synonym may be created are a table, view, sequence, or another synonym.

Q6. Your client said that he forgot the password for the “SYSTEM” user of his database and he no longer could connect. How would you recover this admin password?


  • If there are other users who have “DBA” privileges, you can connect with those users and change the password for the “SYSTEM” user. The users who have DBA privileges have the privilege to change any user’s password. This option is the easiest method but this may not be the case in all scenarios.
  • If there are no other users with “DBA” privileges then the only way to connect to the database is to connect using operating system privileges. The Oracle software runs under a specific user at the operating system. This user is usually named “oracle”. Also, there needs to be a user group that the “oracle” user belongs to. This user group is usually named “dba”. The operating system users who belong to the “dba” group can connect to the database with “SYSDBA” privileges. So, you need to ask the system administrator to logon to a server as an “oracle” user or any user who belongs to this “dba” group. Once logged on to the operating system, you can connect to the database locally using operating system authentication with SYSDBA privileges. After connecting to the database, you can change the reset the password for this system user.

Q7. What is a password file and why is it needed?

Ans. Passwords for database users are stored in the data dictionary of the database. When a user wants to log into the database, the username and password provided by the user are checked against the values stored in the database.

If the username and password match, the user is granted access to the database. The data dictionary is part of the database and it will be accessible as long as the database is open. The passwords for administrators are stored in the dictionary as well.

When the database is closed, the data dictionary will be inaccessible. There needs to be a mechanism for administrators to login into the database even when it is closed because it is one of the administrator’s tasks to start up a down database. A password file is a separate operating system file that is stored on a disk outside of the database.

The username and password for the users who have SYSDBA or SYSOPER privileges are stored in it. Administrators who have those privileges are authenticated using this password file even when the database is down.

Q8. You want to find out how many users are defined in the password file and what privileges those users have. How would you accomplish this?

Ans. You need to query the “v$pwfile_users” view to get information about the existing users in the password file. Execute the SQL query below:
Sql>SELECT * FROM v$pwfile_users;
The query above will return four columns for each user in the password file. The column names are USERNAME, SYSDBA, SYSOPER, and SYSASM.

  1. The USERNAME column shows the username of the user in the password file.
  2. The SYSDBA column shows whether the user has SYSDBA privileges or not.
  3. The SYSOPER column shows whether the user has SYSOPER privileges or not.
  4. The SYSASM column shows whether the user has SYSASM privileges or not.


Q7. What would be the main responsibilities of an Oracle DBA in an organization?

Ans. The main duty of an Oracle DBA is to keep the Oracle Databases of the organization up and running. This may involve installing and configuring a database from scratch.
On a running system, the DBA will be the only privileged person who can shut down and startup the database.

The DBA will create new users and manage the privileges of each user.
He will take regular backups to ensure that data is safe. In case of a disaster, he will be responsible for restoring the database from backups. He will have to do monitor the space usage and do capacity planning for the database.

He will be responsible for enforcing security policies. He will have to monitor database activities. He will have to tune the database so that it works at an acceptable speed.
He is expected to follow the latest patches and apply them when applicable.

Q8. How does an Oracle DBA role differ from an Oracle Developer role in an organization? Are there any similarities between these two?

Ans. An Oracle developer is mainly responsible for developing backend applications. They do data modeling according to business rules. The design tables, create indexes and other types of constraints. They are expected to know SQL and PL/SQL. They develop procedures using this language.

However, the Oracle developers are not expected to administer the database software itself.
On the other side, an Oracle DBA’s main duty is to administer the database which involves tasks like doing maintenance to keep the databases up and running, taking backups, enforcing security policies, etc. DBAs are not primarily assigned to develop code.

DBAs are supposed to have a good knowledge of SQL and PL/SQL like a developer as these are also required for administering the database.
According to the structure of the organization, DBAs might also be assigned development tasks or at least assist the developers where necessary.

Q9. There are 10 identical servers and you want to install Oracle Database on each of them. What would you use to automate the installation process?

Ans. If you are going to do batch installations, it is best to do it with Oracle Universal Installer in silent mode. For single installations.it is best to start the installer in “interactive mode” and set installation options at each window.

However, in batch installations, this will take longer. You need to do the installations in “silent” mode with a “response file”. In a silent installation, you start the Oracle Universal Installer from a command prompt and specify the location of the “response file”.

The installation files and the response file can be shared among the servers via NFS so that you won’t have to copy the setup files to each server.

Q10. You want to create a response file to speed up the installation of databases. How would you prepare a response file?

Ans. A response file is a plain text file, where options to create a database are stored. It is possible to create it manually from scratch but that would take longer and would be erroneous.
Installation media comes with a template response file. It is rather easier to customize it manually. This file also contains notes about the parameters.

However, the easiest and most reliable way to create a response file is by using Oracle Universal Installer. If you start the installer in “record” mode, every option you choose at each step is automatically recorded in a response file in the correct format. After the installer completes in “record” mode, you’ll have a complete response file with all the options set in it.

Q1. What are the payment options?
A1. We have multiple payment options: 1) Book your course on our webiste by clicking on Buy this course button on top right of this course page 2) Pay via Invoice using any credit or debit card 3) Pay to our UK or India bank account 4) If your HR or employer is making the payment, then we can send them an invoice to pay.

Q2. Will I get certificate?
A2. Yes, you will receive course completion certificate from Uplatz confirming that you have completed this course with Uplatz. Once you complete your learning please submit this for to request for your certificate https://training.uplatz.com/certificate-request.php

Q3. How long is the course access?
A3. All our video courses comes with lifetime access. Once you purchase a video course with Uplatz you have lifetime access to the course i.e. forever. You can access your course any time via our website and/or mobile app and learn at your own convenience.

Q4. Are the videos downloadable?
A4. Video courses cannot be downloaded, but you have lifetime access to any video course you purchase on our website. You will be able to play the videos on our our website and mobile app.

Q5. Do you take exam? Do I need to pass exam? How to book exam?
A5. We do not take exam as part of the our training programs whether it is video course or live online class. These courses are professional courses and are offered to upskill and move on in the career ladder. However if there is an associated exam to the subject you are learning with us then you need to contact the relevant examination authority for booking your exam.

Q6. Can I get study material with the course?
A6. The study material might or might not be available for this course. Please note that though we strive to provide you the best materials but we cannot guarantee the exact study material that is mentioned anywhere within the lecture videos. Please submit study material request using the form https://training.uplatz.com/study-material-request.php

Q7. What is your refund policy?
A7. Please refer to our Refund policy mentioned on our website, here is the link to Uplatz refund policy https://training.uplatz.com/refund-and-cancellation-policy.php

Q8. Do you provide any discounts?
A8. We run promotions and discounts from time to time, we suggest you to register on our website so you can receive our emails related to promotions and offers.

Q9. What are overview courses?
A9. Overview courses are 1-2 hours short to help you decide if you want to go for the full course on that particular subject. Uplatz overview courses are either free or minimally charged such as GBP 1 / USD 2 / EUR 2 / INR 100

Q10. What are individual courses?
A10. Individual courses are simply our video courses available on Uplatz website and app across more than 300 technologies. Each course varies in duration from 5 hours uptop 150 hours. Check all our courses here https://training.uplatz.com/online-it-courses.php?search=individual

Q11. What are bundle courses?
A11. Bundle courses offered by Uplatz are combo of 2 or more video courses. We have Bundle up the similar technologies together in Bundles so offer you better value in pricing and give you an enhaced learning experience. Check all Bundle courses here https://training.uplatz.com/online-it-courses.php?search=bundle

Q12. What are Career Path programs?
A12. Career Path programs are our comprehensive learning package of video course. These are combined in a way by keeping in mind the career you would like to aim after doing career path program. Career path programs ranges from 100 hours to 600 hours and covers wide variety of courses for you to become an expert on those technologies. Check all Career Path Programs here https://training.uplatz.com/online-it-courses.php?career_path_courses=done

Q13. What are Learning Path programs?
A13. Learning Path programs are dedicated courses designed by SAP professionals to start and enhance their career in an SAP domain. It covers from basic to advance level of all courses across each business function. These programs are available across SAP finance, SAP Logistics, SAP HR, SAP succcessfactors, SAP Technical, SAP Sales, SAP S/4HANA and many more Check all Learning path here https://training.uplatz.com/online-it-courses.php?learning_path_courses=done

Q14. What are Premium Career tracks?
A14. Premium Career tracks are programs consisting of video courses that lead to skills required by C-suite executives such as CEO, CTO, CFO, and so on. These programs will help you gain knowledge and acumen to become a senior management executive.

Q15. How unlimited subscription works?
A15. Uplatz offers 2 types of unlimited subscription, Monthly and Yearly. Our monthly subscription give you unlimited access to our more than 300 video courses with 6000 hours of learning content. The plan renews each month. Minimum committment is for 1 year, you can cancel anytime after 1 year of enrolment. Our yearly subscription gives you unlimited access to our more than 300 video courses with 6000 hours of learning content. The plan renews every year. Minimum committment is for 1 year, you can cancel the plan anytime after 1 year. Check our monthly and yearly subscription here https://training.uplatz.com/online-it-courses.php?search=subscription

Q16. Do you provide software access with video course?
A16. Software access can be purchased seperately at an additional cost. The cost varies from course to course but is generally in between GBP 20 to GBP 40 per month.

Q17. Does your course guarantee a job?
A17. Our course is designed to provide you with a solid foundation in the subject and equip you with valuable skills. While the course is a significant step toward your career goals, its important to note that the job market can vary, and some positions might require additional certifications or experience. Remember that the job landscape is constantly evolving. We encourage you to continue learning and stay updated on industry trends even after completing the course. Many successful professionals combine formal education with ongoing self-improvement to excel in their careers. We are here to support you in your journey!

Q18. Do you provide placement services?
A18. While our course is designed to provide you with a comprehensive understanding of the subject, we currently do not offer placement services as part of the course package. Our main focus is on delivering high-quality education and equipping you with essential skills in this field. However, we understand that finding job opportunities is a crucial aspect of your career journey. We recommend exploring various avenues to enhance your job search:
a) Career Counseling: Seek guidance from career counselors who can provide personalized advice and help you tailor your job search strategy.
b) Networking: Attend industry events, workshops, and conferences to build connections with professionals in your field. Networking can often lead to job referrals and valuable insights.
c) Online Professional Network: Leverage platforms like LinkedIn, a reputable online professional network, to explore job opportunities that resonate with your skills and interests.
d) Online Job Platforms: Investigate prominent online job platforms in your region and submit applications for suitable positions considering both your prior experience and the newly acquired knowledge. e.g in UK the major job platforms are Reed, Indeed, CV library, Total Jobs, Linkedin.
While we may not offer placement services, we are here to support you in other ways. If you have any questions about the industry, job search strategies, or interview preparation, please dont hesitate to reach out. Remember that taking an active role in your job search process can lead to valuable experiences and opportunities.