Infinite Computer Solutions Database Admin Interview Questions and Answers

Q1. How to sync primary and standby?
Ans. 
Primary and standby databases can be synced using Data Guard in Oracle.
• Configure Data Guard on primary and standby databases

• Enable redo transport services

• Monitor and resolve any synchronization issues

• Perform switchover or failover when necessary
Answered by AI
Add your answer
Q2. Performance tuning?
Add your answer

Q1. Why you want to change the job?
Ans. 
Seeking new challenges and growth opportunities in a dynamic environment.
• Looking for new challenges to enhance my skills and knowledge

• Seeking growth opportunities for career advancement

• Interested in working in a more dynamic and innovative environment
Answered by AI
Add your answer
Q2. Expected salary.
Add your answer

Query writing , famous query of db

Q1. Tell me about your roles and responsibilities
Add your answer
Q2. How to add diskgroup in disks
Ans. 
To add a diskgroup in disks, use the CREATE DISKGROUP command in Oracle ASM.
• Ensure that the disks are initialized and partitioned

• Use the ASMCA (ASM Configuration Assistant) or ASMCMD (ASM Command-Line Utility) to create the diskgroup

• Specify the diskgroup name, redundancy level, and the disks to be included in the diskgroup

• Example: CREATE DISKGROUP dg1 NORMAL REDUNDANCY DISK '/dev/sdb1', '/dev/sdc1'
Answered by AI
Add your answer
Q3. What will do in Real application cluater
Ans. 
Real Application Cluster (RAC) is a cluster database with shared disk architecture.
• RAC allows multiple instances to access a single database simultaneously.

• It provides high availability and scalability.

• RAC uses Oracle Clusterware to manage the cluster.

• Load balancing and failover are automatic in RAC.

• RAC requires additional hardware and software licenses.
Answered by AI
Add your answer

Q1. Difference between index and statistics
Ans. 
Index is used to speed up data retrieval while statistics are used by the query optimizer to create an efficient query plan.
• Indexes are created on columns to speed up data retrieval

• Statistics are used by the query optimizer to create an efficient query plan

• Indexes are used to enforce uniqueness and primary key constraints

• Statistics are used to estimate the number of rows returned by a query

• Indexes can be clustered or n...read more
Answered by AI
Add your answer