|
Home > Archive > Oracle certifications > November 2001 > 8i backup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I found these questions on a chinese guide!
Enjoy! Discussion! Thanks!
1 The alert log will never contain information about which database activity?
A. Placing tablespace in end backup mode
B. Altering the database to take a data file offline
C. Performing operating system restore of the database files
D. Changing the database mode from NOARCHIVELOG to ARCHIVELOG
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 What are two causes of a user process failure?
A. A table is accidentally truncated
B. The user issues an abnormal interrupt
C. There is a logic error in the application
D. The application program receives an addressing exception
E. There is a head crash on the disk containing a database file
4 What are two benefits of making recovery operations parallel?
A. Minimizing downtime
B. Recovering more than one data file
C. Recovering by using all redo-log files at once
D. Improving the chances of database consistency
E. Making better use of available system resources
5 You perform an incomplete recovery using RMAN. You write the following script:
RUN{
SET UNTIL TIME = 'yyyy-nm-dd:hh:mi:ss';
RESTORE DATABASE;
RECOVER DATABASE;
SQL "alter database open resetlogs";}
Which command is missing?
A. RESYNC CATALOG;
B. RELEASE CHANNEL;
C. ALLOCATE CHANNEL cname TYPE DISK;
D. SET LIMIT CHANNEL cname KBYTESS 4194304
6 A media management layer is always used when Recovery Manager...
A. reads or writes to tapes
B. performs media recovery
C. reads or writes to disk files
D. reads or writes through a channel
7 Which two records does the Recovery Manager RESYC CATALOG command update? (Choose two)
A. alert log records
B. log switch records
C. rollback segment records
D. archived log copy records
8 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_SARCHIVE_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
9 What must a DBA do after using NOLOGGING operations on a primary database?
A. switch log files on the primary database
B. copy all affected data files to the standby server
C. manually reapply the changes to the standby database
D. make sure the database is the only primary database in the current configuration | |
|
| I'm an 8i MASTER
I know everything about 8i
100.000% correct answers here:
1-B
2-A B=confusion, no... A
3-AB
4-AB
5-C
6-A
7-BD
8-AB
9-B | |
|
| I think those questions are from STS |
|
|
|
|