Oracle認證考試章節(jié)練習(2019.12.31)

來源：考試資料網(wǎng)

1 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？（）

點擊查看答案

2 用（）語句修改表的一行或多行數(shù)據(jù)。

點擊查看答案&解析

3 Which three functions are performed by the SQL Tuning Advisor?（）

點擊查看答案

4 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（）

點擊查看答案

5 In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）

點擊查看答案

6 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?（）

點擊查看答案

7 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？（）

點擊查看答案

8 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？（）

點擊查看答案

9 Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)

點擊查看答案

10 Evaluate the SQL statement:
1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal
2 FROM employees a,
3 (SELECT dept_id, MAX(sal) maxsal
4. FROM employees
5 GROUP BY dept_id) b
6 WHERE a.dept_id = b.dept_id
7 AND a. asl < b. maxsal;
What is the result of the statement? （）

點擊查看答案

广告位招租联系QQ:5245112（WX同号）