1Z0-053章節(jié)練習(xí)(2019.04.21)

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:
ALTER TABLESPACE data1 BEGIN BACKUP;
While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）

Evaluate the following function code：  
CREATE FUNCTION get_dept_avg（dept_id NUMBER） RETURN NUMBER RESULT_CACHE RELIES_ON （EMPLOYEES） IS avgsal NUMBER（6）； BEGIN 
SELECT AVG（SALARY）INTO avgsal FROM EMPLOYEES  
WHERE DEPARTMENT_ID = dept_id； RETURN avgsal； END get_dept_avg；  
Which statement is true regarding the above function？（）

Examine the following RMAN command：  
BACKUP DATABASE TAG TESTDB 
KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06；  
Which two statements are true regarding the backup taken by using the above RMAN command？（）  

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis.
Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:
1) Restore an autobackup of the server parameter file.
2) Restore the control file
3) Start the target database instance
4) Mount the database
5) Restore the data files
6) Open the database with RESETLOGS option
7) Recover the data files
8) Set DBID for the target database
Which option illustrates the correct sequence that you must use?（）