Technical Interview Questions
The ROWS option indicates whether the table rows should be imported. In Oracle, the ROWS option in the IMP (Import) command is used to specify the number of rows to import. This option allows you to control the import process by specifying a limit on the number of rows that should be imported from the … Read more
GRANT is used to import object grants. It seems there might be a confusion in your question. The IMP command in Oracle is typically used for importing data into the database, and it doesn’t have a GRANT option. The GRANT command in Oracle is used to provide specific privileges to a user or a role … Read more
The main limitation of CHECK constraint is that the condition must be a Boolean expression evaluated using the values in the row being inserted or updated and can’t contain sub queries. In Oracle, CHECK constraints have certain limitations. Some of the notable limitations include: Complex Conditions: CHECK constraints can become complex and may be challenging … Read more
The number of times a dictionary table is repeatedly called by various processes is known as recursive hint. Recursive hint is occurred because of the small size of data dictionary cache. In Oracle, the term “recursive hints” usually refers to hints used in SQL statements to influence the behavior of recursive SQL statements generated by … Read more
Mirroring is a process of having a copy of Redo log files. It is done by creating group of log files together. This ensures that LGWR automatically writes them to all the members of the current on-line redo log group. If the group fails, the database automatically switches over to the next group. It diminishes … Read more