Fractal Analytics Database Analyst Interview Questions and Answers

Q1. Backup and recovery for rac db instances
Ans. 
Backup and recovery for RAC DB instances involves using RMAN for backups and restoring from backups in case of failures.
• Use RMAN for taking backups of RAC DB instances

• Implement a backup strategy that includes full, incremental, and archive log backups

• Test the backups regularly to ensure they can be restored successfully

• In case of failures, restore the database using RMAN backups
Answered by AI
Add your answer
Q2. Sql db running slow
Add your answer
Q3. Dataguard sync issue
Add your answer

Q1. Why Standby Redo logfiles are required. How to troubleshoot node-eviction in RAC. RTO and RPO. Extended RAC. Managed Database.
Ans. 
Standby Redo logfiles are required for data protection and disaster recovery in Oracle databases.
• Standby Redo logfiles are essential for maintaining a standby database in Oracle Data Guard for disaster recovery purposes.

• They contain a record of changes made to the primary database, which can be applied to the standby database to keep it synchronized.

• In case of a primary database failure, the standby database can be act...read more
Answered by AI
Add your answer

Basic coding question with u can find on the oracle website

Q1. Mostly the question are from the engineering subjects
Add your answer
Q2. Cs fundametals , oops concept and dbms
Add your answer

Basic coding question which u can find on the oracle website

Q1. Technical question is mostly based on the cs fundamental
Add your answer

Q1. How many nodes can we implement in rac
Ans. 
Up to 60 nodes can be implemented in RAC.
• RAC stands for Real Application Clusters

• The number of nodes depends on the version of Oracle Database being used

• Oracle Database 12c supports up to 60 nodes in RAC
Answered by AI
View 1 more amswer

Q1. What is the difference between 11i and R12
Ans. 
11i and R12 are two different versions of Oracle E-Business Suite.
• 11i is the older version, released in 2000, while R12 was released in 2007.

• R12 has a more modern architecture and improved features, such as online patching and subledger accounting.

• Upgrading from 11i to R12 requires careful planning and testing.

• Both versions are still in use, but Oracle has announced that support for 11i will end in 2020.
Answered by AI
Add your answer

Q1. How. Many years of experience do you have
Add your answer

Q1. What is ur salary expectations
Add your answer

Q1. What about your self introduction
Add your answer
Q2. Tell obout your hobbies
Add your answer
Q3. Tell obout your techincal skills
Add your answer
Q4. This job which can be useful for you
Add your answer
Q5. Tells about what about your skills
Add your answer
Q6. You can reach a goal
Add your answer

Q1. What about your self introduction
Add your answer
Q2. Tell obout your hobbies
Add your answer
Q3. Tell obout your techincal skills
Add your answer
Q4. This job which can be useful for you
Add your answer
Q5. Tells about what about your skills
Add your answer
Q6. You can reach a goal
Add your answer

Q1. What is two node rac with two node Dataguard
Ans. 
Two node RAC with two node DataGuard is a high availability solution for Oracle databases.
• Two node RAC provides high availability by allowing multiple instances to access a single database simultaneously.

• Two node DataGuard provides disaster recovery by maintaining a standby database that can take over in case of a primary database failure.

• Combining the two creates a highly available and disaster-resistant solution for ...read more
Answered by AI
Add your answer