Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,155,653 members, 7,827,414 topics. Date: Tuesday, 14 May 2024 at 11:37 AM

Oracle RAC Interview Questions And Answers - Education - Nairaland

Nairaland Forum / Nairaland / General / Education / Oracle RAC Interview Questions And Answers (320 Views)

Oracle DBA Rac 12c Training / National Common Entrance Examination [NCEE] Past Questions And Answers / UNIZIK POST UTME PAST QUESTIONS AND ANSWERS 2020 (2) (3) (4)

(1) (Reply)

Oracle RAC Interview Questions And Answers by Lianamelissa: 10:04am On Aug 31, 2018
Q) What are the differences between Oracle RAC and Oracle Grid ?
Oracle RAC Vs Oracle Grid
RAC GRID
Single system image avaiable No single system image
Proprietary interoperability with VIA No standards available
Single ownership Multiple Ownerships
Disciverable membership services Central Index and decentral information to discover
Moderate throughput Either too high or too low throughput
Guarantees capacity High capacty, varies sometimes
Most number of commodity computers Commodity and High-end computers
Centralised user management Distributed user management
Centralised resource management Distributed resource management
Central allocation and scheduling DecentraliDistributed allocation and scheduling
Q1) What is cache fusion?

In a RAC environment, it is the combining of data blocks, which are shipped across the interconnect from remote database caches (SGA) to the local node, in order to fulfill the requirements for a transaction (DML, Query of Data Dictionary).

Q2) What is split brain?

When database nodes in a cluster are unable to communicate with each other, they may continue to process and modify the data blocks independently. If the
same block is modified by more than one instance, synchronization/locking of the data blocks does not take place and blocks may be overwritten by others in the cluster. This state is called split brain.

Q3) What is the difference between Crash recovery and Instance recovery?

When an instance crashes in a single node database on startup a crash recovery takes place. In a RAC enviornment the same recovery for an instance is performed by the surviving nodes called Instance recovery.

Q4) What is the interconnect used for?

It is a private network which is used to ship data blocks from one instance to another for cache fusion. The physical data blocks as well as data dictionary blocks are shared across this interconnect.

Q5) How do you determine what protocol is being used for Interconnect traffic?

One of the ways is to look at the database alert log for the time period when the database was started up.

Want To Get RAC Training From Experts? Enroll Now For Free Demo On Oracle RAC Training.
Q6) What methods are available to keep the time synchronized on all nodes in the cluster?

Either the Network Time Protocol(NTP) can be configured or in 11gr2, Cluster Time Synchronization Service (CTSS) can be used.

Q7) What files components in RAC must reside on shared storage?

Spfiles, ControlFiles, Datafiles and Redolog files should be created on shared storage.

Q8) Where does the Clusterware write when there is a network or Storage missed heartbeat?

The network ping failure is written in $CRS_HOME/log

Q9) How do you find out what OCR backups are available?

The ocrconfig -showbackup can be run to find out the automatic and manually run backups.

Q10) If your OCR is corrupted what options do have to resolve this?

You can use either the logical or the physical OCR backup copy to restore the Repository.

For more information visit Mindmajix
Re: Oracle RAC Interview Questions And Answers by kbstraining(m): 7:21am On Feb 19, 2022
Hey Thanks For Sharing This Help So Much For Beginners
https://www.kbstraining.com/

(1) (Reply)

"Nigeria Can Potentially Take Global Lead In Food Production" - Prof Alonge / Ibadan Secondary School Students Use Tramadol To Study For Exams --research Says / Google Says See-ya To College Term Paper Writing Companies

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 15
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.