Oracle 1z0-034 問題集

質問 1：
Examine the following command that is used to duplicate a database on the same host:
RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; }
Which two statements describe the effect after the database is duplicated successfully? (Choose two)
A. The data files of the read-only tablespaces in the target database are not duplicated
B. The read-only tablespaces in the target database are still defined in new the database
C. The read-only tablespaces in the target database are not defined in the new database
D. The read-only tablespaces in the target database are changed to online after duplication
E. The data files of the read-only tablespaces in the target database get duplicated
正解：A,B

質問 2：
You created a database with the Database Configuration Assistant (DBCA) by using one of the default templates.
Which tablespace will be the default permanent tablespace for non-system users, excluding DBSNMP and OUTLN?
A. SYSAUX
B. SAMPLE
C. EXAMPLE
D. SYSTEM
E. USERS
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)
A. It bypasses the OS file system cache.
B. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
C. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
D. It uses the operating system kernel NFS layer for user tasks and network communication modules.
E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)
A. direct path load of data from external files
B. all DDL statements having bind variables
C. flashback query
D. distributed transactions
E. logging in and logging out of sessions
正解：B,E

質問 5：
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?
A. external tables
B. views
C. Index-Organized Tables (IOTs)
D. fixed tables
E. heap tables
F. temporary tables
正解：C,E

質問 6：
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 メンバーにのみ表示されます)

質問 7：
Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?
A. the default permanent tablespace for the non-SYSTEM users
B. an offline tablespace
C. the SYSTEM tablespace
D. a temporary tablespace
E. a read-only tablespace
F. an undo tablespace
正解：A,D,E,F

質問 8：
What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?
A. The number of ASMB processes increases
B. The number of DBWR_TO_SLAVES increases
C. The number of DBWR processes increases
D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/Ooverhead
正解：D