Oracle 1Z0-050 問題集

質問 1：
Which three are the valid statements in relation to SQL plan baselines? (Choose three.)
A. The plans can be manually loaded to the SQL plan baseline.
B. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
C. The plans generated for every SQL statement are stored in the SQL plan baseline by default.
D. The plan baselines are stored temporarily in the memory as long as the database instance is running.
E. The plans in the SQL plan baseline are verified and accepted plans.
正解：A,B,E

質問 2：
What are the recommendations for Oracle Database 11 g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)
A. Flash recovery area and data file location should be created under Oracle base in a
non-Automatic Storage Management (ASM) setup.
B. ORACLE_BASE should be set explicitly.
C. An Oracle base should have only one Oracle home created in it.
D. Flash recovery area and data file location should be on separate disks.
正解：A,B,D

質問 3：
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?
A. Specify undo retention guarantee for the database.
B. Enable Flashback Data Archive for the tables.
C. Create Flashback Data Archive on the tablespace on which the tables are stored.
D. Enable supplemental logging for the database.
E. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.
正解：B

質問 4：
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)
A. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
B. The optimizer selects the new plan for the execution of the SQL statement.
C. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
D. The optimizer adds the new plan to the plan history.
E. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
正解：A,D

質問 5：
Examine the following command:
ALTER DISKGROUP data MOUNT FORCE;
In which scenario can you use the above command to mount the disk group?
A. when one or more ASM files are dropped
B. when ASM disk goes offline
C. when some disks in a failure group for a disk group are rebalancing
D. when some disks in a disk group are offline
正解：D

質問 6：
You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT DELETE ROWS
TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)
A. It can be a default or nondefault temporary tablespace for the database.
B. It must be the default temporary tablespace of the user who issues the command.
C. It stores only the temporary table but not its indexes.
D. It stores both the temporary table as well as its indexes.
E. It must be a nondefault temporary tablespace for the database.
正解：A,D

質問 7：
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?
A. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
B. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
D. The tuned plan is not added to the SQL plan baseline.
正解：C

質問 8：
You are managing an Oracle 11 g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE .ASM attribute is set to 11.1.
Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)
A. The ASM disk is dropped immediately from a disk group when it becomes unavailable.
B. The ASM-preferred mirror read feature is enabled.
C. The ASM supports variable sizes for extents of 1. 8. and 64 allocation units.
D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
正解：B,C