一起学OCP：oracle-082题库及解析(21-40)持续更新

更新已迁移到主号：点击这里

第21题

In your database,you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

A) Setting a metric threshold
B) Implementing Database Resource Manager
C) Enabling resumable timeout for user sessions
D) Decreasing the value of the IDLE_TIME resource limit in the default profile.
正确答案【B】

解析：题目的意思是你希望阻塞活动的空闲session在指定时间后自动终止，这个需求需要通过Resource Manager来实现。
相关知识点链接

第22题

Evaluate the following SQL statement:
SQL> select cust_id,cust_last_name “Last name” FROM customers WHERE country_id=10 UNION SELECT cust_id CUST_NO,cust_last_name FROM customers WHERE couontry_id=30

这里是引用
A) ORDER BY "Last name "
B) ORDER BY 2,cust_id
C) ORDER BY CUST_NO
D) ORDER BY 2,1
E) ORDER BY “CUST_NO”
正确答案【ABD】
解析：