Oracle认证考试章节练习(2019.12.31)

多项选择题
Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode？（）
A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover
B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
单项选择题
用（）语句修改表的一行或多行数据。
A.Update
B.set
C.Select
D.Where
多项选择题
Which three functions are performed by the SQL Tuning Advisor?（）
A. Building and implementing SQL profiles
B. Recommending the optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending the restructuring of SQL queries that are using bad plans
单项选择题
To make audit information more productive， the DBA executes the following command before starting an auditoperation：SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）
A.It contains only the plan for the SQL statement executed by the user.
B.It contains the SQL text executed by the user and the bind variables used with it.
C.It contains the plan and statistics associated with the SQL statement executed by the user.
D.It contains the plan for the SQL statement executed by the user and the bind variables used with it
多项选择题
In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）
A.After the COPY command.
B.After adding a data file in the target database.
C.After adding a tablespace in the target database.
D.After adding a tablespace in the catalog database.
E.After dropping a data file in the catalog database.
F.After running SQL Loader to load a large amount of data.
单项选择题
You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.How would you accomplish this task?（）
A. Set metric threshold
B. Implement Database Resource Manager
C. Enable resumable timeout for user sessions
D. Add directives to Automatic Database Diagnostic Monitor (ADDM)
单项选择题
In a database with the database character set of US7ASCII and a national character set of UTF-8， which datatypes would be capable of storing Unicode data by default？（）
A. VARCHAR2
B. CHAR
C. NVARCHAR2
D. CLOB
E. LONG
多项选择题
Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）
A. increase the number of checkpoint processes
B. define the POWER option while adding or removing the disks
C. increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
D. increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
E. increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal
多项选择题
Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)
A. The user has dropped an important table that needs to be recovered.
B. The database files are corrupted when the database is open.
C. You are not able to start up the database instance because the required database files are missing.
D. The archived log files are missing for which backup is not available.
单项选择题
Evaluate the SQL statement:1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal2 FROM employees a,3 (SELECT dept_id, MAX(sal) maxsal4. FROM employees5 GROUP BY dept_id) b6 WHERE a.dept_id = b.dept_id7 AND a. asl < b. maxsal;What is the result of the statement? （）
A. The statement produces an error at line 1.
B. The statement produces an error at line 3.
C. The statement produces an error at line 6.
D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.
E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.