Oracle 1z0-034 問題集

質問 1：
Given below is a list of scenarios:
1) A user terminates his session abnormally.
2) The connection between the server and the client application terminates because of a
network failure.
3) A schema is accidentally dropped.
4) The tablespace is accidentally dropped from the database.
5) The hard disk gets corrupted and the data files in the disk are lost.
6) The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
A. 3, 4, and 5
B. 1, 3, and 6
C. 1, 2, and 6
D. 4, 5, and 6
正解：A

質問 2：
The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations.
How would you achieve this?
A. Implement a Database Resource Manager plan.
B. Set the threshold for the undo tablespace.
C. Implement a profile for the users.
D. Implement external roles for the users.
正解：D

質問 3：
The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?
A. Password file
B. Archived log files required to perform recovery
C. Control files
D. Newly created tablespace which is not backed up
E. Inactive online redo log file
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?
A. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
B. ALTER DATABASE FLASHBACK ON;
C. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
D. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
E. GRANT SELECT ANY TRANSACTION TO scott;
F. GRANT EXECUTE ON dbms_flashback TO scott;
正解：A,C,E,F

質問 5：
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)
A. It contains file systems that have been mounted by the kernel NFS system.
B. Its entries are specific to a single database.
C. It is globally available to all Oracle 11g databases on the machine.
D. It contains file systems that have been mounted by Direct NFS.
正解：A,C

質問 6：
View the Exhibit to examine the replay settings for replay parameters.
What is the implication for setting the values for replay parameters? (Choose all that apply.)
Exhibit:

A. The COMMIT order in the captured workload is preserved during replay.
B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.
C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.
D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.
E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
正解：A,D,E

質問 7：
Examine the following command for RMAN backup:
RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP
INCREMENTAL LEVEL = 0
(DATAFILE 1,4,5 CHANNEL c1)
(DATAFILE 2,3,9 CHANNEL c2)
(DATAFILE 6,7,8 CHANNEL c3);
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
Which statement is true regarding the approach in the command?
A. It is a case of parallelization of the backup set.
B. The RMAN multiplexing level is 4.
C. It is the use of asynchronous I/O by RMAN.
D. It is an implementation of a multi section backup.
正解：A

質問 8：
Your database is open and running in ARCHIVELOG mode.
You take RMAN full backups every Sunday night.
On Monday morning, while querying the user1.emoloyees table, you receive the following error message:
01578: ORACLE data block corrupted (file # 5, block # 51) ORA-0lll0: data file 5: '/u01/app/oracle/oradata/orcl/exanple0l.dbf*
You need to recover from this while ensuring that:
1.The data file remains online.
2.Mean Time To Recover (MTTR) is minimized as much as possible
You have no backup control file, but all the archived logs are accessible. Which method will best satisfy the requirements?
A. flash back the corrupted blocks
B. perform a table point in time recovery with datapump export and import
C. use the RMAN BLCCKRECOVER command
D. use the DBMS_REPAIR package
E. use RMAN tablespace point in time recovery
正解：C