Interview :: oracle
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 the performance.
What is the meaning of recursive hints in Oracle?
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.
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.
GRANT is used to import object grants.
The ROWS option indicates whether the table rows should be imported.
The INDEXES option is used to determine whether indexes are imported.
The IGNORE option is used to specify how object creation errors should be handled.
The SHOW option specifies when the value of show=y, the DDL within the export file is displayed.
FILE param is used to specify the name of the export file to import. Multiple files can be listed, separated by commas.
The to_char() function is used to convert date to character. You can also specify the format in which you want output.
Or,