Oracle 1z0-067 問題集

質問 1：
You install Oracle Grid Infrastructure for a standalone server and issue this command:
crsctl start has
Which two components get automatically added to the Oracle Restart configuration the first time this command is issued?
Choose two.
A. Oracle Healthcheck services
B. A database that already exists prior to the Grid Infrastructure installation
C. Oracle Notification services
D. An Oracle Net Listener that already exists prior to the Grid Infrastructure installation
E. Oracle CSSD services
正解：A,E

質問 2：
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv
ORACLE*_SID = [oracle] ? cdb1
The oracle base for ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle
$ rman target /
Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?
A. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
B. It fails and returns an error because a connection is not made by using the sysdba privilege.
C. It succeeds and displays all the tablespaces that belong to the root database.
D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
正解：A

質問 3：
For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY
DATABASE;
Which statement is true about the execution of the command?
A. It performs a backup as a backup set of all data files including those that belong to the new tablespace.
B. It returns an error because there is no level 0 backup available for new data files.
C. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
D. It performs a level-0 backup of all data files including those that belong to the new tablespace.
E. It performs an image copy backup of all data files including those that belong to the new tablespace.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this?
A. ALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;
B. ALTER TA3LESPACE adtbs ADD DATAFILE;
C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
D. ALTER TA3LESPACE adtbs RESI2E 20G;
E. ALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You set the following parameters in the parameter file and restart the database instance:
MEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true?
A. The value of the memory_max_target parameter remains zero for the database instance.
B. The pga_aggregate_target and sga_target parameters are automatically set to zero.
C. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
D. The memory_max_target parameter is automatically set to 500 MB.
E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.
正解：C,D

質問 6：
You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?
A. The t:kid_statistics parameter is set to false.
B. Enterprise Manager was not used.
C. The statistics_level parameter is set to basic.
D. The event parameter was not set.
E. The sql_trace parameter is set to false.
正解：C
解説: (Topexam メンバーにのみ表示されます)