| swordfish_70 2002-07-18, 9:26 pm |
| Hi everyone,
I very badly need Answers for few questions,I have consulted my instructor & my collegues,all of different opinions,
trust me I have the test tommorrow,I need the answers for these questions ASAP.
thanks & regards.
QUESTIONS:
1. What is the difference between using NOLOGGING operations in a single database environment and a standby database environment?
A. NOLOGGING operations are not allowed when using a standby database.
B. The affected data file needs to be copied from the primary to the standby server.
C. NOLOGGING operations can be used on the standby database, but not on the primary database.
D. The standby database becomes unavailable after a NOLOGGING operation has been used on the primary database.
2. When using the DBVERIFY tool to detect corruption in an Oracle data block, which statement is true?
A. The utility can verify data files for a database with any DB_BLOCK_SIZE
B. The utility cannot verify data files for a database with any DB_BLOCK_SIZE greater than 2K bytes
C. The utility cannot verify data files for a database with any DB_BLOCK_SIZE less than or equal to 4K bytes
D. The utility cannot verify data files for a database with any DB_BLOCK_SIZE less than or equal to 8K bytes
3. In order to keep a standby database up-to-date, archived redo-log files need to be transferred from the primary to the standby server. What are two ways to do this? (Choose two)
A. Use operating system commands to transfer the files
B. Specify LOG_ARCHIVE_DEST_n on the standby database
C. Set the STANDBY_ARCHIVE_DEST parameter on the standby database
D. Specify the service name in LOG_ARCHIVE_DEST_n of the primary database
E. Issue the command RECOVER MANAGED STANDBY DATABASE on the standby database
4. If a DBA restores a read-only tablespace from a backup taken before the tablespace was made read-only, what must the DBA do next?
A. Recreate the control file.
B. Complete media recovery.
C. Make the tablespace locally-managed.
D. After the tablespace to become read-only.
 |
