Oracle OCP 1Z0-050（101-110题）解析
OCP 1Z0-050（101-110题）解析
101:
View the for some of the .
You start a and issue the :
SQL> INDEX ON emp(ename)
users ;
What is the of the above ?
A. The index is used by the only if a hint is in the query and is DML .
B. The index is not used by the but is DML .
C. The index is not used by the and is not DML .
D. The index is used by the only if a hint is in the query but is not DML .
: B
解析：
参考官方文档：
#
or the use of .
:
102:
You the :
SQL> ALTER SET = false;
SQL> .('SH', '',
'','false');
SQL> .('SH', '');
Which is the above on the SH. table in the above ?
A. The are in the table in the data .
B. The are as the by the for the only.
C. The are as the by the for all .
D. The are and used by the for all until this .
: A
解析：
参考官方文档：
#
#
or not the uses when SQL .
指定在SQL语句编译时是否使用未决定（）的统计信息。
with 11g 2 (11.2), you have the when :
the new as you to the new and them only if they are .
To check the will be as soon as they are , use the as :
.('') FROM DUAL;
The query TRUE or FALSE. TRUE that the will be as and when they are , while FALSE that the will be kept .
Note:
The in data views such as and . The in views such as TS and TS.
You can the at the or the table level. For , to the for the table in the SH , the :
EXEC .('SH', '', '', 'false');
, when you on the table, the will not be when the job . , the the newly in the TS table.
By , the uses the in the data views. If you want the to use the newly , then set the to TRUE (the value is FALSE), and run a the table or :
ALTER SET = TRUE;
The will use the of the when SQL . If the are valid, then you can make them by the :
EXEC .S(null, null);
You can also the for a . For , by using the :
EXEC .S('SH','');
If you do not want to the , them by the :
EXEC .('SH','');
You can using . . to a test you to run a full the new .
103:
You plan to set up the (AWR) for a . Which would you take
A. Take an AWR .
B. the size for the .
C. the time for the .
D. the .
: D
解析：
参考官方文档：
#
A to all AWR data that the AWR . This is when using the can use AWR data in the AWR to .
a - . The size for the - is the AWR , which by is 8 days. If you are to use , using a —such as 30 days—to . You can the by the of days in the to a value that is equal to or less than the of days in the AWR . , to the size of a , you must first the AWR .
104:
You are the as a DBA. You plan to this in the same with the name DUPDB.
You the RMAN to a :
RMAN> sys/sys@
RMAN> TO dupdb FROM
'///prod/',
'////dupdb/'
SPILE
ERT '///prod/',
'////dupdb/'
SET = '300M'
SET = '250M'
SET T '///prod/redo/',
'////dupdb/redo/';
Which three are the for the of the above ?
( three.)
A. RMAN be to both the as .
B. The be to the .
C. The file must exist for the and have the same SYS user as the .
D. The be in mode if it is open.
E. The be open.
: A,C,D
解析：
参考官方文档：
#
根据题目的描述需要使用 a 技术创建一个名字为DUPDB的数据库。使用RMAN可以完成这个操作。RMAN支持两种基本类型的操作： 和-based 。
RMAN can -based with or of the :
A to both is for .
24-1
In , RMAN as to the and as to the . RMAN the live over the to the , the . No of the are . 24-2 .
-Based
In -based , RMAN the by using pre- RMAN and . This of uses one of the :
24-3 -based a . RMAN to a and the . The host must have to the RMAN to the .
24-4 -based to the or to the . RMAN to the of the on the host. A disk all the or for must be to the host.
24-4 -Based a or
24-5 -based with a . RMAN to the and the . , RMAN can to a (not shown in the ). The host must have to the RMAN to the .
24-5 -Based with a
of
A is for a of , most of which . You can the tasks in a :
For , you can the on host1 to host2, and then use the on host2 to and this while the on host1 as usual.
If you copy a with of the , then the DBID of the the same as the . To the copy in the same with the , you must the DBID with the (see ). In , the the a DBID so that it can be in the same as the .
The can a fully copy of your or a , which a very . A is a copy of the that you with log files from the . If the is , then you can fail over to the , which the new . A copy, , be used in this way: it is not for and does not the and .
Basic Steps of
This the basic steps of . the link in each step for .
To a :
for .Start RMAN and to the .Place the in the state (if ). RMAN (if ). the .
to a
the , you must how to the and then the , the .
To for :
A. a .
While an Real ( RAC) , set the on the to FALSE. This can be reset to TRUE after the .
B. a for the files.
C. For a -based , make the to the ; , skip this step.
D. to .
E. the .
105:
You the RMAN with the KEEP . Which two are true this ? ( two.)
A. The data files, the file, and the file even if the file is .
B. The KEEP the .
C. The only data files and redo log files.
D. The KEEP is an of an piece.
: A,B
解析：
参考官方文档：
RMAN does not with the KEEP when the . If , RMAN uses these for , but their is to a of the that can be on for or usage.
When with KEEP, RMAN only KEEP with the same tag. Thus, when using with , RMAN only skips a if it finds the of KEEP with the same tag. Other are not .
the as an , which is a self- that is from the .
An is self- is all files to the and it to a state. If the is open the , then RMAN and backs up the redo log files to make the (see 2-26).
RMAN does not with the KEEP when the . If , RMAN uses these for , but their is to a of the that can be on for or usage.
Note: You use KEEP to the for files in the fast area. If you KEEP when up to the area, then RMAN an error.
When KEEP is , RMAN sets. RMAN backs up data files, redo log files, the file, and the file with the in the first . Since a of the file is , an of the file is not . RMAN uses the , POOL, and TAG for all the . For this , the must allow for the of . %U is the way to meet this .
See Also: and and User's Guide to learn more about of the file.
When KEEP is with LEVEL, the must be a KEEP and have the same TAG . both these are met, the be . that meet these do not with other or tasks.
Note: A is only for KEEP . No other KEEP a .
106:
You set the in the file and the :
=0
=500M
=90M
=270M
Which two are true these after the is ? ( two.)
A. The lower of and are set to 90 MB and 270 MB, .
B. The value of the zero till it is .
C. The is set to 500 MB.
D. The and are set to zero.
: A,C
解析：
参考官方文档：
#
the value to which a DBA can set the . See the of for more about how the of and each other.
= [K | M | G]
0 to the size to the
#
the total size of all SGA . If is , then the pools are sized:
If these tuned pools are set to , then those are used as by . You would set if an needs a of to .
The pools are sized and are not by :
The to these pools is from the total for when the of the tuned pools.
In the value field, mode are to avoid ORA-04031 . The and modes are in the of the V$ view.
If is ( is set to a value) and is also set to a value, the value acts as the value for the size of the SGA.
#
the PGA to all to the .
to a value has the of the to AUTO. This means that SQL areas used by - SQL (such as sort, group-by, hash-join, merge, and ) will be sized. A value for this is the since, you , sets it to 20% of the SGA or 10 MB, is .
to 0 sets the to . This means that SQL are sized using the * .
to keep the of below the by this by the size of the work areas to . When the value of this , you the to work areas. , more - are able to run fully in and less will work their way over to disk.
If is ( is set to a value) and is also set to a value, the value acts as the value for the size of the PGA.
107:
You are an 11g . You want to take a on tape of the USERS that has a data file of 900 MB. You have tape of 300 MB each. To the , you the RMAN
:
RMAN> SIZE 300M users;
What be to and by using the above ?
A. The SBT must be , with the for the SBT set to 1.
B. The for the must be set to at least 10.0.
C. The SBT must be , with the for the SBT set to 3.
D. The SBT must be , with the set to 300 MB.
: C
108:
:
View the to the error while the in an RMAN .
What is the for this error?
A. is .
B. The ID has not been in the for data file 5.
C. There are new in the (ADR).
D. The has not been the .
: A
109:
To the of a when it is bad from a , you set the as :
SQL> ALTER SET =
Drop,10;
What is the of this ?
A. It the after a bad and the can to the same after 10 .
B. It the after 10 bad but the can still , and the same again.
C. It the after 10 bad and the to the same .
D. It the 10 after a bad and the to the same .
: B
解析：参考官方文档：
#
the of a when bad from a .
:
The . The may be to a of (DoS) if bad to be sent by a .
The a delay of the the next from the same . are from of while a in but can to .
The the after bad . The at the of the (for , a may be lost). The may and the same .
110:
You want to a SQL Set (STS) using SQL in a test . Which two are true the the test of SQLs in a SQL Set? ( two.)
A. The plan and are for each SQL in the STS.
B. The of DDL and DML are to the plan and .
C. Every SQL in the STS is only once for .
D. The SQL in the STS are to the plan and .
: A,C
解析：
SQL 翻译成中文就是SQL性能分析器，它与数据库重演特性一起构成提供的Total 特性，能测试重大系统更改的影响，如测试数据库升级的SQL工作负荷响应时间。SQL性能分析器分析比较系统更改前后的SQL性能，提出阻止性能退化的建议。可以在数据库、应用、操作系统或硬件升级等系统更改之后，或者在初始化参数设置更改、SQL调优活动和统计数据收集与模式更改等之后，用SQL性能分析器来分析可能的SQL性能变化。
SQL性能分析器是 11g的一个组成部分，它可以充分利用SQL 等工具以及SQL Plan 等特性来很好地调优数据库性能。
具体内容，参考官方文档：
#
#
SQL you to the of any in to SQL plans and . of for which you can use SQL :
You can run SQL on a or a test that the 。 a on a will the 's SQL must the SQL that you are 。 Any made on the to test the may also other users of the 。 If the does not many or SQL , then SQL on the may be 。
, for —such as a —using a is not 。 , SQL on a test so that you can test the of the the 。 Using a test also that other on the will not the by SQL 。 SQL on a test is the and the here。 If you to run the SQL on the , then the for the test where 。
the SQL of using SQL the steps, as in 2-1:
2-1 SQL
You can use the APIs to an STS:
The the of SQL (such as or OTHER) in an STS by STS name and SQL ID.
The the of the full by the SQL area over a . This more than using the and to the SQL area over an . This the , as to the AWR—which only the of high-load SQL —or the , which the data only once.
The adds a new to an STS to its use by a . The the of the added . The NCE an STS to it is no used by the .
#
A SQL Set (STS) is a that one or more SQL along with their and , and could a user . The SQL can be into a SQL Set from SQL , such as the , the cache, or SQL by the user. An STS :
SQL can be using the name and , or any of the . In , the SQL can be based on any of .
A SQL Set can be used as input to the SQL , which of the SQL based on other input by the user. SQL Sets are and can be from one to , for the of SQL for and . When SQL are on a , it may not be for to their and on the . This the DBA to the SQL to a test where the can and tune them. To SQL Sets, use the .
