• Installing Oracle Software 

• Creating an Oracle Database Using DBCA

 • Managing Database instances and ASM instances 

• Managing and controlling database network environment 

• Define and devise transaction management, concurrency control, crash recovery components • Managing storage structures 

• Controlling user security 

• Designing Database backup and recovery procedures 

• Take Decisions related with Database Maintenance

 

·      Architecture

·      DBCA

·      Instance

·      Users

·      Tablespace and Storage

·      Temporaray Tablespace

·      Undo

·      Flashback Technology

·      Oracle Networking Environment

·      Oracle Locking

·      Oracle Auditing

·      EM and Data Pump

·      User Managed Backup

·      User Managed Recovery

·      RMAN - Backup

·      RMAN - Recovery

·      Oracle Database Migration to Cloud

This Oracle DBA training course will help the participant to master the Oracle certified Database Administrator. As a part of this Oracle DBA training, the participants will master the oracle database architecture, database processes, security and backup.

In Oracle DBA Course module, the participants can understand the capability to provide industry support for online backup and data recovery. In the Oracle DBA course, the participants will learn to deal with large amount of data without any failure.

Oracle DBA Certification is an important level in becoming a Database Administrator. As a part of the Oracle DBA course training, the Oracle Database administrator get trained in database overview, PL/SQL and SQL concepts, oracle network configuration. Oracle DBA tutorial helps the participants to fulfil the role of a database administrator.

The Oracle DBA certification exam validates that the participants possess the basic concepts and skills a Database administrator should require for daily operation management and maintenance. Oracle Certification exams verifies the participants capabilities using situation-based questions that can access the participants ability to perform. The process of becoming Oracle certified database administrator expands the participants knowledge and skills by getting exposed to key database features.

Uplatz online training ensures the participants to successfully go through the Oracle DBA certification provided by Oracle. Uplatz provides appropriate teaching and expertise training is provided to equip the participants for implementing the learnt concepts in an enterprise.

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

Below given are the Certification details of Oracle Database 12C Administration

·       Certification Level: Professional

·       Exam Name: Oracle Database 12C Administration

·       Exam Code: 1Z0-062

·       Exam Mode: Online

·       Total Number of Questions: 67

·       Pass Score: 64%

·       Time Duration: 120 Minutes

·       Exam Price: $330

The Oracle Database Administrator draws an average salary of $120,266 per year depending on the knowledge and hands-on experience. The Oracle Database Administrator job roles are in high demand and make a rewarding career.

The Oracle Database Administrators have major demand in global-based companies and MNCs. The adoption of the Oracle database concepts in global companies can open up a job opportunity. The Global companies hire Oracle Database Administrator considering the skill of Oracle DBA management and maintenance. The Learners earn the most beneficial Oracle Database Administrator course completion certification through our training and course curriculum.

The Oracle DBA Certification course is ideally designed for developers, database administrators and data center support engineers who wants to become an Oracle certified database administrator.

After pursuing Oracle DBA certification course the participants can pursue a wide range of career paths.

The following are the job titles:

·       Oracle DBA (Database Administrator)

·       Oracle 12C Administrator

·       Oracle Developer

·       Oracle DBA Associate

·       Database Engineer

 

Highly-skilled database professionals can manage any kind of critical systems. The Oracle certified Database Administrators are in high demand across the globe.

1) How many memory layers are in the shared pool? 

The shared pool portion of the SGA contains three major areas: library cache(contains parsed sql statements,cursor information,execution plans), dictionary cache (contains cache -user account information,priveleges information,datafile,segment and extent information), buffers for parallel execution messages, and control structure.

 

2) How do you find out from the RMAN catalog if a particular archive log has been backed-up? 

list archivelog all;

 

3) How can you tell how much space is left on a given file system and how much space each of the file system’s subdirectories take-up? 

df -kh and du-sh

 

4) Define the SGA and:

i)  How you would configure SGA for a mid-sized OLTP environment?

ii) What is involved in tuning the SGA? 

SGA: The System Global Area (SGA) is a group of shared memory areas that are dedicated to an Oracle “instance” (an instance is your database programs and RAM). All Oracle processes use the SGA to hold information. The SGA is used to store incoming data (the data buffers as defined by thedb_cache_size parameter), and internal control information that is needed by the database. You control the amount of memory to be allocated to the SGA by setting some of the Oracle “initialization parameters”.  These might include db_cache_size, shared_pool_size and log_buffer.

i) 40% of RAM can be used for sizing SGA rest is reserved for OS and others in 64 bit machine and in 32 bit machine max SGA configured can be 1.5GB only.

ii) Check the statspack report. Check hit ratio of Data buffer. If it is less than 90%, then we need to increase the Data buffer. Check hit ratio of Shared pool. If it is less than 95%, then we need to increase the Shared pool. Check log buffer. If redo buffer allocation retries/redo entries is greater than 1%, then we need to increase log_buffer.

 

5) What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it? 

Buffer cache hit ratio: It calculates how often a requested block has been found in the buffer cache without requiring disk access. This ratio is computed using data selected from the dynamic performance view V$SYSSTAT. The buffer cache hit ratio can be used to verify the physical I/O as predicted by V$DB_CACHE_ADVICE.

sql> select name, value From v$sysstat Where name in (‘db block gets’, ‘consistent gets’, ‘physical reads’);

The cache-hit ratio can be calculated as follows: Hit ratio = 1 – (physical reads / (db block gets + consistent gets)) If the cache-hit ratio goes below 90% then:  increase the initialisation parameter DB_CACHE_SIZE.

Library cache hit ratio: It calculates how often the parsed representation of the statement can be reused. It also known as soft parse.

sql>  select namespace, pins, pinhits, reloads, invalidations from v$librarycache order by namespace;

Library Cache Hit Ratio = sum(pinhits) / sum(pins)

Dictionary cache hit ratio:It is a measure of the proportion of requests for information from the data dictionary, the collection of database tables and views containing reference information about the database, its structures, and its users. On instance startup, the data dictionary cache contains no data, so any SQL statement issued is likely to result in cache misses. As more data is read into the cache, the likelihood of cache misses should decrease. Eventually the database should reach a "steady state" in which the most frequently used dictionary data is in the cache.

 

6) Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database? 

Daily Monitoring activities and check different logs for any sort of errors.

 

7) How do you tell what your machine name is and what is its IP address?

hostname, uname -n and ifconfig

 

8) How would you go about verifying the network name that the local_listener is currently using?

lsnrctl stat or ps-eaf|grep tns

 

9) You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance? 

SQL> oradebug setmypid

SQL> oradebug ipc

SQL>oradebug tracfile_name

Also you can check the spfile. The parameters will start with instance_name. parameter_name naming.

 

10) What view(s) do you use to associate a user’s SQLPLUS session with his o/s process? 

v$process and v$session

sql> select a.spid from v$process a, v$session b where a.addr = b.addr and b.audsid=userenv(‘sessionid’);

 

11) What is the recommended interval at which to run statspack snapshots, and why? 

Should be in minutes (15-20 mins approx)  because where the time between the two snapshots is measured in hours, the events that caused serious performance issues for 20 minutes during peak processing don’t look so bad when they’re spread out over an 8-hour window. It’s also true with STATSPACK that measuring things over too long of a period tends to level them off over time. Nothing will stand out and strike you as being wrong.

 

12) What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly? 

OPTIMIZER_INDEX_COST_ADJ= FORCE

 

13) Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM. 

dbms_job.submit(:jobno,'statspack.snap;',trunc(sysdate)+9/24,'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);

 

14) How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM? 

00 02 * * * /test/test.sh

 

15) In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

SQL> SELECT MVIEW_NAME,LAST_REFRESH_DATE from USER_MVIEWS;

 

16) How would you best determine why your MVIEW couldn’t FAST REFRESH? 

Possibly by checking the MVIEW LOG for errors.

 

17) How would you begin to troubleshoot an ORA-3113 error? 

End of File Communication Error. Check Alert Logfile. CheckNetwrok Latency. Check sqlnet.ora file has expire_time = 0, delete unwanted files and check the swap and temp spaces.

 

18) Which dictionary tables and/or views would you look at to diagnose a locking issue?

v$lock, v$session, v$process

 

19) An automatic job running via DBMS_JOB has failed. Knowing only that “it’s failed”, how do you approach troubleshooting this issue? 

Check the log and possible reason for the JOB failed.

 

20) How would you extract DDL of a table without using a GUI tool? 

select dbms_metadata.get_ddl('OBJECT','OBJECT_NAME') from dual;

 

21) You’re getting high “busy buffer waits” - how can you find what’s causing it? 

Buffer busy wait means that the queries are waiting for the blocks to be read into the db cache.There could be the reason when the block may be busy in the cache and session is waiting for it. It could be undo, data block or segment header wait.

Run the following query to find out the p1,p2 and p3 of a session causing buffer busy wait

sql> select p1 "File #",p2 "Block #",p3 "Reason Code" from v$session_wait where event = 'buffer busy waits';

After that running the following query to find the  segment causing buffer busy wait:-

sql> select owner,segment_name,segment_type from dba_extents where file_id = &P1 and &P2 between block_id and block_id + blocks -1;

 

22) What query tells you how much space a tablespace named “test” is taking up, and how much space is remaining? 

SET SERVEROUTPUT ON

SET LINESIZE 1000

SET FEEDBACK OFF

rem column dummy noprintcolumn  pct_used format 999.9       heading "%|Used"

column  name    format a25      heading "Tablespace Name"

column  Kbytes   format 999,999,999    heading "MBytes"

column  used    format 999,999,999   heading "Used(MB)"

column  free    format 999,999,999  heading "Free(MB)"

column  largest    format 999,999,999  heading "Largest"

break   on report

compute sum of kbytes on report

compute sum of free on report

compute sum of used on report

set pagesize 100

select nvl(b.tablespace_name,

nvl(a.tablespace_name,'UNKOWN')) name,(kbytes_alloc/1024) kbytes,

((kbytes_alloc-nvl(kbytes_free,0))/1024) used,(nvl(kbytes_free,0)/1024) free,

((kbytes_alloc-nvl(kbytes_free,0))/kbytes_alloc)*100 "%used",

nvl(largest,0)/1024  largest

from ( select sum(bytes)/1024 Kbytes_free,

max(bytes)/1024 largest,              tablespace_name

from  sys.dba_free_space       group by tablespace_name ) a,

( select sum(bytes)/1024 Kbytes_alloc,              tablespace_name

from sys.dba_data_files       group by tablespace_name )b

where a.tablespace_name (+) = b.tablespace_name

order by 1

/

 

23) Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session is able to connect. 

Log into the system and find whether there are any deadlocks in the system using the following query.

select    'SID ' || l1.sid ||' is blocking  ' || l2.sid blocking

from    v$lock l1, v$lock l2

where    l1.block =1 and l2.request > 0

and    l1.id1=l2.id1

and    l1.id2=l2.id2

/

If so kill the processes caught in deadlock

alter system kill session 'SID,SERIAL#' immediate;

Also find out which wait events exist in the system using following commands and go in detail as to what events are causing these waits and take appropriate actions.

select event,count(*) from v$session group by event

/

select u.sid,u.serial#, u.username,p.spid,to_char(u.logon_time,'DD-MON-YYYY:HH24:MI:SS')  from v$session u, v$session w,v$process p where u.sid = w.sid and w.event like '%&a%' and u.paddr = p.addr

/

 

24) Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle’s. What database recovery options are available? Database is in archive log mode.

First of all secure all the archives and all the backups you have on the tape or other system. Then run fschk to check the filesystem. If the corruption is detected at the filesystem level and is not recoverable by fschk format the file system and restore the database through RMAN.

 

25) How do you increase the OS limitation for open files (LINUX and/or Solaris)?

Set the file-max parameter is /etc/sysctl.conf to the number you want.Save the file and execute it by using command /etc/sysctl.conf-p

 

26) Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

export ORACLE_BASE=/oracle

export ORACLE_HOME=/oracle/ora10g

export ORACLE_SID=ora10g

export path=$ORACLE_HOME/lib

sqlplus sys as sysdba << EOF

@/oracle/date.sql

exit;

Now the contents of /oracle/date.sql

select SYSDATE from dual;

select to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss') from dual;

drop table tablename cascade constraints;

select to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss') from dual;

 

27) Explain how you would restore a database using RMAN to Point in Time?

restore database

until time "to_date('Aug 27 2001 02:00:00','Mon DD YYYY HH24:MI:SS')";

recover database

 

28) How does Oracle guarantee data integrity of data changes?

It enables you to define and enforce data integrity constraints like PRIMARY KEY CONSTRAINTS, FOREIGN KEY CONSTRAINTS and UNIQUE CONSTRAINTS.

 

29) Which environment variables are absolutely critical in order to run the OUI?

ORACLE_BASE, ORACLE_HOME, ORACLE_SID,path and library path

 

30) What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

select count(1) from v$session where USERNAME='username';

 

31) TABLESPACE is not specified for a user?

a. TEMP

b. DATA

c. SYSTEM

d. ROLLBACK

Answer: c

 

32) User SCOTT creates an index with this statement: CREATE INDEX emp_indx on employee (empno). In which tablespace would be the index created?

a. SYSTEM tablespace

b. SCOTTS default tablespace

c. Tablespace with rollback segments

d. Same tablespace as the EMPLOYEE table.

Answer: b

 

33) Which data dictionary view shows the available free space in a certain tablespace? 

A. DBA_EXTENTS

B. V$FREESPACE

C. DBA_FREE_SPACE

D. DBA_TABLESPACE

E. DBA_FREE_EXTENTS

Answer: C

 

34) Which method increase the size of a tablespace?

A. Add a datafile to a tablespace.

B. Use the ALTER TABLESPACE command to increase the MINEXTENTS for the tablespace.

C. Use the ALTER TABLESPACE command to increase the MAXEXTENTS for the tablespace.

D. Use the ALTER TABLESPACE command to increase the MINIMUM EXTENT for the tablespace.

Answer: A

 

35) What does the command ALTER DATABASE . . . RENAME DATAFILE do?

A. It copies a data file.

B. It updates the control file.

C. It copies a data file and updates the control file.

D. It copies a data file, deletes the obsolete file, and updates the control file.

Answer: B

 

36) Can you drop objects from a read-only tablespace?

A. No

B. Yes

C. Only when using the DBA role

D. Only when the tablespace is online

Answer: B

 

37) SYSTEM TABLESPACE can be made off-line.

a) Yes

b) No

Answer: b

 

38) Datadictionary can span across multiple Tablespaces.

a) TRUE

b) FALSE

Answer: b

 

39) Multiple Tablespaces can share a single datafile.

a) TRUE

b) FALSE

Answer: b

 

40) All datafiles related to a Tablespace are removed when the Tablespace is dropped?

a) TRUE

b) FALSE

Answer: b

 

41) In which situation would you need to create a new control file for an existing database?

A. When all redo-log files are lost.

B. When MAXLOGMEMBERS needs to be changed.

C. When RECOVERY_PARALLELISM needs to be changed.

D. When the name of the parameter file needs to be changed

Answer: B

 

42) When configuring a database for ARCHIVELOG mode, you use an initialisation parameter to specify which action?

A. The size of archived log files.

B. How frequently log files will be archived.

C. That the database is in ARCHIVELOG mode.

d. To Store Archive log Files

Answer: d

 

43) Which command creates a text backup of the control file?

A. ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

B. ALTER DATABASE BACKUP CONTROLFILE TO BACKUP;

C. ALTER DATABASE BACKUP CONTROLFILE TO filename;

D. ALTER DATABASE BACKUP CONTROLFILE TO TEXT filename;

Answer: A

 

44) You are configuring a database for ARCHIVELOG mode. Which initialization parameter should you use?

A. LOG_ARCHIVE_SIZE

B. ARCHIVELOG_MODE

C. LOG_ARCHIVE_DEST

Answer: C

 

45) How does a DBA specify multiple control files?

A. With the ADD CONTROLFILE command.

B. By using the files in the STARTUP command.

C. With the MULTIPLEX control file command.

D. By listing the files in the CONTROL_FILES parameter.

Answer: D

 

46) Which dynamic view should a DBA query to obtain information about the different sections of the control file? 

A. V$CONTROLFILE

B. DBA_CONTROLFILE

C. V$CONTROLFILE_RECORD_SECTION

D. DBA_CONRTOLFILE_RECORD_SECTION

Answer: C

 

47) Which statements about online redo log members in a group are true?

A. All files in all groups are the same size.

B. All members in a group are the same size.

C. The rollback segment size determines the member size.

D. Differently size of transactions requires that the DBA should differently sized members.

Answer: B

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.

Q19. How do I enrol in Uplatz video courses?
A19. To enroll, click on "Buy This Course," You will see this option at the top of the page.
a) Choose your payment method.
b) Stripe for any Credit or debit card from anywhere in the world.
c) PayPal for payments via PayPal account.
d) Choose PayUmoney if you are based in India.
e) Start learning: After payment, your course will be added to your profile in the student dashboard under "Video Courses".

Q20. How do I access my course after payment?
A20. Once you have made the payment on our website, you can access your course by clicking on the "My Courses" option in the main menu or by navigating to your profile, then the student dashboard, and finally selecting "Video Courses".

Q21. Can I get help from a tutor if I have doubts while learning from a video course?
A21. Tutor support is not available for our video course. If you believe you require assistance from a tutor, we recommend considering our live class option. Please contact our team for the most up-to-date availability. The pricing for live classes typically begins at USD 999 and may vary.