OCP 11G認證考試章節(jié)練習(2018.08.01)

A.Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. 
B.Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. 
C.Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D.Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. 

A.The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. 
B.The backup set has one or more invalid blocks in it and is not usable for recovery. 
C.The backup set contains one or more tablespaces no longer in the database.  
D.The backup set contains one or more missing backup set pieces.
E.The backup set is from a previous version of RMAN and was not upgraded. 

A.field names in the SELECT statement 
B.the FROM clause in the SELECT statement 
C.the HAVING clause in the SELECT statement
D.the GROUP BY clause in the SELECT statement 
E.the WHERE clause in only the SELECT statement 
F.the WHERE clause in SELECT as well as all DML statements

A.7 
B.1 
C.10 
D.11 
E.21

A.RMAN will attempt to make the backup run as fast as possible without any IO limitations. 
B.RMAN will automatically restrict the number of channels in use to one. 
C.RMAN will spread the backup IO over the total duration stated in the backup command.
D.RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up. 
E.Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first. 

A.The LIKE operator cannot be used with single-row subqueries 
B.The NOT IN operator is equivalent to IS NULL with single-row subqueries 
C.=ANY and =ALL operators have the same functionality in multiple-row subqueries 
D.The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries 

A.alter database controlfile autobacku on
B.alter system controlfile autobackup on 
C.configure controlfile autobackup on 
D.enable controlfile autobackup

A.A subquery that defines a view cannot include the GROUP BY clause 
B.A view that is created with the subquery having the DISTINCT keyword can be updated 
C.A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
D.A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

A. TIMESTAMP
B. DATE
C. TIMESTAMP WITH TIME ZONE
D. TIMESTAMP WITH LOCAL TIME ZONE
E. DATETIME

A. WINDOW_PRIORITY
B. PRIORITY
C. PRIORITY_LEVEL
D. WINDOW_PRIORITY_LEVEL
E. OVERLAP_RULE