In which mode Oracle Database performs full redo logging for instance – McqOptions

MCQOPTIONS

1.	In which mode Oracle Database performs full redo logging for instance and media recovery. If the database is in ARCHIVELOG mode, then you can archive redo logs to tape. If the database is in NOARCHIVELOG mode, then you can recover instance crashes but not disk failures?
A.	Direct-path INSERT without Logging
B.	Direct-Path INSERT with Logging
C.	Both A & B
D.	None of the above
Answer» C. Both A & B

Discussion

No Comment Found

Related MCQs

Which type of table is a group of tables that share the same data blocks because they share common columns and are often used together?
Which privileges are required for directory objects containing bad, log, or discard files for external tables?
In which mode Oracle Database performs full redo logging for instance and media recovery. If the database is in ARCHIVELOG mode, then you can archive redo logs to tape. If the database is in NOARCHIVELOG mode, then you can recover instance crashes but not disk failures?
In the error Logging Table format, which set of columns contain data from the row that caused the error and the column names match the column names from the table being inserted into (the "DML table")?
Which method enables you to add rows to a table, either by specifying the column values or by specifying a subquery that selects data from another existing table?
Which INSERT operation does the database reuses free space in the table, interleaving newly inserted data with the existing data and during such operations, the database also maintains referential integrity constraints?
In Viewing and querying Objects in the recycle bin which view gives administrators visibility to all dropped objects in the recycle bin?
Which tables in the Tables schema cannot be redefined?