违法和不良信息举报 联系客服
免费注册 登录

When an UNDO segment is created manually by you, its availab

题目
单选题
When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）
A

Online 

B

Pending online 

C

Offline 

D

Stale

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

For anyinformation system to serve its purpose ，the ihformation must be（ ）when it ìs needed.

A.integralB.availab1eC.irreplaceableD.confidential


正确答案：B

第2题：

In which two conditions are resumable statements suspended？（）

  • A、 when a user exceeds the space quota
  • B、 when a user session is terminated
  • C、 when a table that is being accessed by the current transaction is not found
  • D、 when a user manually suspends the statement
  • E、 when the maximum extents of a segment is reached

正确答案:A,E

第3题：

Which describes the default behavior when you create a table? ()

A. The table is accessible to all users.

B. Tables are created in the public schema.

C. Tables are created in your schema.

D. Tables are created in the DBA schema.

E. You must specify the schema when the table is created.


参考答案：C

第4题：

While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

  • A、 Memory Advisor
  • B、 Segment Advisor
  • C、 Undo Advisor
  • D、 SQL Tuning Advisor

正确答案:C

第5题：

When recovering from a disaster, the backup and restore operation you use is similar to the export/import configuration procedure, with one additional step. Which additional step must you take when recovering from a disaster?（）

  • A、A new WebSphere profile is required to restore the configuration.
  • B、The restored system requires the IBM Tivoli Access Manager for e-business （TAMeb） JRTE to be manually configured against the WebSphere’s Java Runtime to allow the IBM Tivoli Federated Identity Manager （ITFIM） Runtime to function properly.
  • C、The ITFIM Domain needs to be created manually within the Integrated Solution Console.
  • D、The ITFIM Runtime instance needs to be re-registered with the TAMeb policy server by running the SvrSslCfg command.

正确答案:C

第6题：

For anyinformation system to serve its purpose ，the ihformation must be( )when it ìs needed.

A.integral
B.availab1e
C.irreplaceable
D.confidential

答案：B
解析：

第7题：

When using the Call Subflow step, can variables be shared between the parent (calling) flow and the subflow?（）

  • A、No.  
  • B、Yes.  
  • C、Yes, but they must be manually passed via input and output mapping.  
  • D、Yes, but they must be manually created in both flows and have the same name. 

正确答案:C

第8题：

Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)

A. Database must be running in archivelog mode.

B. Automatic undo management must be enabled.

C. Undo retention guarantee must be enabled.

D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).


参考答案：B, D

第9题：

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

  • A、 The database will not start.
  • B、 The database will start but will not retain the undo data in the undo segment.
  • C、 The database will start， and the undo segment will contain the undo data for at least one hour.
  • D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.

正确答案:D

第10题：

Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)

  • A、Flash recovery area must be defined
  • B、Undo retention guarantee must be enabled.
  • C、Database must be running in archivelog mode.
  • D、Automatic undo management must be enabled.
  • E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

正确答案:D,E

更多相关问题
相关内容