[单选]
Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every
Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows：
SQL> DROP TABLE cust_ord PURGE；
Table dropped.
Client B executes a query at 9：00 a.m. on the same table as follows：
SQL> SELECT * FROM cust_ord；
SELECT * FROM cust_ord
*ERROR at line 1：ORA-00942： table or view does not exist
Client B needs the dropped table and reports the problem to you.With reference to this scenario， which action should you take？（）

A . retrieve the table by using the flashback feature
B . restore all the data files from last Sunday’s backup and then perform a time-based recovery
C . restore all the data files from last Sunday’s backup and then perform a log sequence recovery
D . restore all the data files from last Sunday’s backup and then perform a cancel-based recovery
E . restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored and then perform a complete recovery

广州公共汽车561路“柯子岭――车陂”，始末站为“柯子岭”和“车陂”，安排两个站长（基层调度员）分别负责这两个始末站的调度组织工作。设该线路17：00~18：00为高峰期，行车作业方案为高峰期单程运行时间40min，平峰期为35min。某天编号为001的车辆在线运行片段如下：第3车次在18：40从“柯子岭”发车开出，发车间距为5分钟，车辆在19：20到达终点站“火车站”，运行是否正点？ You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（） Increase the size of redo log files。 Increase the size of redo log buffer。 Increase the number of redo log files。 Place the redo log files on a separate disk。 Decrease the number of redo log groups to two。 Increate the number Log Writer （LGWR） proce。 Which code， inserted at line 16， correctly retrieves a local instance of a Point object？（） Point p = Line.getPoint（）；。 Line.Point p = Line.getPoint（）；。 Point p = （new Line（））.getPoint（）；。 Line.Point p = （new Line（））.getPoint（）；。室内机背部靠墙，需做好防震加固，室内机安装应考虑（）美观。整洁。隐秘。利于冷凝水的排放。最初提出“师夷长技以制夷”主张的人是（）。郑关应。冯桂芬。薛福成。魏源。

Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every
Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows：
SQL> DROP TABLE cust_ord PURGE；
Table dropped.
Client B executes a query at 9：00 a.m. on the same table as follows：
SQL> SELECT * FROM cust_ord；
SELECT * FROM cust_ord
*ERROR at line 1：ORA-00942： table or view does not exist
Client B needs the dropped table and reports the problem to you.With reference to this scenario， which action should you take？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1z0-043题库

相关题目: