Oracle database 10g:new features for Oracle8i ocps - 1Z0-045무료 덤프문제 풀어보기
You want an ASM instance to manage the files of your production database. To achieve this objective, you specify the following parameters in the parameter file.
INSTANCE_TYPE = RDBMS LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA
Which parameter would be ignored while starting up the instance of the production database?
INSTANCE_TYPE = RDBMS LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA
Which parameter would be ignored while starting up the instance of the production database?
정답: E
You want to retain the job entries for the last five days and purge all job entries from the job log that are older than five days. Select the command that will enable you to do the job.
정답: C
The Oracle 10g LogMiner needs a data dictionary copy to display the object names. From which three locations can LogMiner retrieve the data dictionary information? (Choose three.)
정답: B,C,D
Consider the following command to add a new disk group called "tdgroupA" with two failover groups:
CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK
'/devices/A1',
'/devices/A2',
'/devices/A3'
FAILOVERGROUP control02 DISK
'/devices/B1',
'/devices/B2',
'/devices/B3';
The disk "/devices/A1" is currently a member disk of a disk group by name "tdgroup1".
Which task would be accomplished by the command?
CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK
'/devices/A1',
'/devices/A2',
'/devices/A3'
FAILOVERGROUP control02 DISK
'/devices/B1',
'/devices/B2',
'/devices/B3';
The disk "/devices/A1" is currently a member disk of a disk group by name "tdgroup1".
Which task would be accomplished by the command?
정답: C
View the Exhibit and examine the Data Pump architecture.
Identify the numbered components.
Identify the numbered components.
정답: E
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)
정답: B,E
View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.
The graph recommends that the size of undo tablespace should be set to _____.
The graph recommends that the size of undo tablespace should be set to _____.
정답: D
Identify four uses of the Oracle Scheduler. (Choose four.)
정답: B,C,D,E
What does the Character Set Scanner command line utility do?
정답: C
Which three parameters are ignored when creating an automatic space management segment? (Choose three.)
정답: B,C,D