Wipro Database Administrator DBA Interview Questions, Process, and Tips

Answering questions on RAC architecture, startup and shutdown process, spfile and ASM migration

• RAC architecture involves multiple nodes sharing a common storage and network infrastructure

• Startup process involves starting the Oracle Clusterware stack, starting the database instances, and mounting the database

• Shutdown process involves dismounting the database, stopping the database instances, and stopping the Oracle Clus...read more

Data Guard steps in RAC

• Configure primary and standby databases

• Enable archive log mode on primary database

• Create standby control file on standby database

• Start the Data Guard broker

• Start the redo apply process on standby database

ORA-00600 is an internal error code that indicates a software bug or corrupted data.

• ORA-00600 is a generic error message that indicates an internal error has occurred.

• It is caused by a software bug or corrupted data.

• It is a critical error that requires immediate attention from the DBA.

• The error message includes a code that identifies the specific error.

• The error can be resolved by applying a patch or contacting Oracle ...read more

ORA-600 is an internal error code in Oracle database.

• It is a generic error that indicates that something unexpected has occurred within the database.

• It is usually accompanied by a detailed error message that provides more information about the cause of the error.

• It can be caused by a variety of factors, including software bugs, hardware failures, and data corruption.

• It is important to diagnose and resolve ORA-600 error...read more

Cloning high level steps involve creating a copy of an existing database or server.

• Identify the source database or server to be cloned

• Create a backup of the source database or server

• Restore the backup to a new location or server

• Modify the cloned database or server as needed

• Test the cloned database or server to ensure it functions properly

To add a datafile in a database, use the ALTER TABLESPACE statement.

• Connect to the database as a user with the necessary privileges.

• Identify the tablespace where you want to add the datafile.

• Use the ALTER TABLESPACE statement with the ADD DATAFILE clause to add the datafile.

• Specify the file name, size, and other attributes of the datafile.

• Example: ALTER TABLESPACE users ADD DATAFILE '/path/to/datafile.dbf' SIZE 100M;

My typing speed is around 70 words per minute.

• My typing speed is measured at around 70 words per minute.

• I have experience typing for extended periods of time without fatigue.

• I am comfortable using a variety of keyboard layouts and typing software.

• I prioritize accuracy over speed when typing important documents.

• I am always looking for ways to improve my typing speed and efficiency.