1Z0-053章节练习(2019.04.21)

多项选择题
You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation？（）
A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager
单项选择题
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?（）
A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
D. If you restart the database, the database will not be opened.
单项选择题
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？（）
A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
B. If the function execution results in an unhandled exception，the exception result is also stored in the cache.
C. Each time the function is invoked in a different session，the current result in the result cache gets overwritten.
D. If the function is invoked with a different parameter value，the existing result in the result cache gets overwritten by the latest value.
多项选择题
Which statements about the MEMORY_TARGET initialization parameter are true？（）
A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if MEMORY_MAX_TARGET is set to a value greater than zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
多项选择题
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？（）
A. Only data files and the control file are backed up.
B. Archived redo logs are backed up only if the database is open during the backup.
C. The backup is deleted after one day，regardless of the default retention policy settings.
D. The backup becomes obsolete after one day，regardless of the default retention policy settings.
多项选择题
Which three components does the Scheduler use for managing tasks within the Oracle environment? （）(Choose three.)
A. a job
B. a program
C. a schedule
D. a PL/SQL procedure
单项选择题
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 file3) Start the target database instance4) Mount the database5) Restore the data files6) Open the database with RESETLOGS option7) Recover the data files8) Set DBID for the target databaseWhich option illustrates the correct sequence that you must use?（）
A.8，1，3，2，4，5，7，6
B.1，8，3，4，2，5，7，6
C.1，3，4，2，8，5，6，7
D.1，3，2，4，6，5，7，8
单项选择题
When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）
A. log_file_name_convert
B. convert_log_file_name
C. file_name_convert_log
D. redo_log_file_name_convert
E. logfile_convert_directory
单项选择题
Which of the following advisors is run in every maintenance window by the auto-task system?（）
A. The Memory Advisor
B. The SQL Tuning Advisor
C. The Undo Advisor
D. The SQL Access Advisor