单选题Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）A V$LOGB V$LOFHISTC V$LOGFILED V$LOG_HISTORY

第1题：

第2题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）

• A、Use the DESCRIBE command in the EMP_DEPT VU view.
• B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
• C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
• D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

第3题：

第4题：

Which three statements about dynamic filtering are true? （）

• A、Dynamic filtering creates a query statement.
• B、Dynamic filtering has an option to save query.
• C、Dynamic filtering can select any log field to filter.
• D、Dynamic filtering permanently removes other log entries.
• E、Dynamic filtering redraws the log when you select a variable link.

第5题：

Which of the following devices would allow a technician using a packet sniffer to view all the dataon a network?（）

• A、GBIC
• B、Hub
• C、Bridge
• D、Modem

第6题：

Which of the following statements best describes Flashback Versions Query？（）  

• A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
• B、 Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.
• C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
• D、 Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.

第7题：

Which command would you configure globally on a Cisco router that would allow you to view directly connected Cisco devices?（）

• A、enable cdp
• B、cdp enable
• C、cdp run
• D、run cdp

第8题：

第9题：

Which version of a view would you use if you just want a quick， easy view within your XPage？（）

• A、Data Table Control
• B、View Control
• C、Repeat Control
• D、Filter by category View Control

第10题：

Examine the parameter for your database instance: You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan: Identify the reason why the optimizer chose different execution plans.（）

• A、The optimizer used a dynamic plan for the query.
• B、The optimizer chose different plans because automatic dynamic sampling was enabled.
• C、The optimizer used re-optimization cardinality feedback for the query.
• D、The optimizer chose different plan because extended statistics were created for the columns used.