Genpact Oracle Database Administrator Interview Questions and Answers for Experienced

CKPT stands for Checkpoint. It is a background process in Oracle database that ensures data integrity and recovery.

• CKPT is responsible for writing dirty buffers from the database buffer cache to the data files

• It updates the control file and data file headers to record the most recent checkpoint

• CKPT is triggered by various events like log switch, manual checkpoint, or when the dirty buffers reach a certain threshold

• It h...read more

Redo log is a set of files that records all changes made to a database and is used for recovery and replication.

• Redo log is a crucial component of Oracle database architecture.

• It consists of two or more pre-allocated files that store all changes made to the database.

• Redo log files are used for recovery in case of a system failure or crash.

• They are also used for replication to maintain consistency across multiple databa...read more

To select a particular row from a table, use the SELECT statement with a WHERE clause specifying the desired criteria.

• Use the SELECT statement to query the table

• Add a WHERE clause to specify the criteria for selecting the row

• The WHERE clause can include conditions based on column values

• Example: SELECT * FROM table_name WHERE column_name = 'desired_value'

My father retired voluntarily to spend more time with his family and pursue his hobbies.

• He wanted to focus on spending quality time with his family after years of working

• He had interests and hobbies he wanted to pursue in his retirement

• He felt it was the right time in his life to step back from work and enjoy his free time