[不定项选择题]What is the effect of specifying the "ENABLE PLUGGABLE DATABASE"

Clause in a "CREATE DATABASE" statement? choose one

A.

It will create a multitenant container database (CDB) with only the root Opened.

B.

It will create a CDB with root opened and seed read only.

C.

It will create a CDB with root and seed opened and one PDB mounted.

D.

It will create a CDB that must be plugged into an existing CDB.

E. It will create a CDB with root opened and seed mounted.

[不定项选择题]其他列车系指：
A.回空列车
B.工程列车
C.救援列车
D.内燃机车单机
E.轨道车单机
F.调试列车

[不定项选择题]运营事故主要包括：
A.生产安全事故
B.消防安全事故
C.特种设备安全事故
D.道路交通安全事故
E.行车指挥事故
F.网络安全事件

[不定项选择题]什么是安全操作四会
A.会报警
B.会使用消防器材
C.会补救初起火灾
D.会组织人员疏散

[不定项选择题]You must transport the UNIVERSITY tablespace from one database to

Another.

The UNIVERSITY tablespace is currently open read/write.

The source and destination platforms have different endian formats.

Examine this list of actions:

1-Make the UNIVERSITY tablespace read-only on the source system.

2-Export the UNIVERSITY tablespace metadata using EXPDP.

3-Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the source system.

4-Copy the UNIVERSITY tablespace data files to the destination system.

5-Copy the Data Pump dump set to the destination system.

6-Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

7-Import the UNIVERSITY tablespace metadata using IMPDP.

8-Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

A.

1, 2, 4, 5, 7, 8

B.

1, 2, 4, 6, 7, 8

C.

1, 2, 3, 4, 5, 7, 8

D.

1, 2, 3, 4, 5, 6, 7, 8

E. 2, 4, 5, 6, 7

[不定项选择题]Automatic Shared Memory Management is disabled for one of your

Database instances. Some SQL statements perform poorly due to excessive

Hard parse activity, thereby degrading performance. 

What would be your Next step?  one

A.

Run the SQL Access Advisor.

B.

Run the Memory Advisor for the shared pool.

C.

Run the SQL Tuning Advisor.

D.

Run the Memory Advisor for the Program Global Area.

E.

Run the Memory Advisor for the System Global Area.

[不定项选择题]Examine the statements that use flashback technologies:

1-FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');

2-SELECT * FROM customers AS OF SCN 123456;

3-FLASHBACK TABLE customers TO BEFORE DROP;

4-FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');

5-SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;

6-ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the Undo tablespace?

A.

1,3,6

B.

1,2,5

C.

3,4,5

D.

2,3,5,6

[不定项选择题]Which two are prerequisites for performing Flashback Transaction?
A.

Fast Recovery Area must be enabled for the database.

B.

The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK

Package.

C.

Undo retention guarantee must be configured for the database.

D.

A supplemental log must be enabled for the primary key.

E.

Row movement must be enabled.

[不定项选择题]In a recent Automatic Workload Repository (AWR) report for your

Database, you notice a high number of buffer busy waits. The database

Consists of locally managed tablespaces with free list managed segments.

On further investigation, you f ind that buffer busy waits is caused by

Contention on data blocks.

Which option would you consider first to decrease the wait event

Immediately?

A.

Decreasing PCTUSED

B.

Decreasing PCTFREE

C.

Increasing the number of DBWN process

D.

Using Automatic Segment Space Management (ASSM)

E. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE
Recommendation

[不定项选择题]Examine the command for creating pluggable database PDB2 in

Container database CDB2.

Select three options, any one of which is required for it to execute

Successfully. (Choose three.)

A. Add the FILE_NAME_CONVERT clause to the statement and set the
PDB_FILE_NAME_CONVERT
Parameter.
B. Add only the CREATE_FILE_DEST clause to the statement.
C. Set only the PDB_FILE_NAME_CONVERT parameter.
D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
E. Enable only OMF.
F. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle
Managed Files (OMF)

[不定项选择题]choose one
You enable Flashback Data Archive for a table for which you
Want to track and save all transactions for four years. After some time, the
Requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;
What is the outcome?
A. All historical data older than two years, if any, is purged from the flashback
Archive FDA1.
B. An error is returned because the retention period cannot be reduced.
C. All the flashback data archives are purged and the subsequently created
Flashback archives are maintained for two years.
D. All historical data older than two years, if any, is archived to flashback logs and
The flashback archive is set to new retention time.

[不定项选择题]工会的职责
A.负责协调伤亡员工与运营分公司的关系，并维护员工的合法利益
B.负责内部各中心、部门间的协调配合，并做好伤亡员工探视及慰问，妥善处理家属接待、安抚工作
C.负责组织相关中心、部门与当事人及其家属对员工伤亡事故处理中的纠纷、争议进行商谈，结果及时报分公司研究处理
D.负责参与和监督员工伤亡事故调查

[不定项选择题]列车类型可分为()。
A.头码车
B.人工车
C.计划车
D.非计划车

[不定项选择题]消防巡查员职责()。
A.定期巡查管辖区内道路（通道）、水源、消防设备设施和周边建筑物及道路等情况，及时报告周围情况的变化
B.及时拨打火警电话
C.根据职责分工，完成初期火灾扑救和应急救援任务
D.负责现场人员疏散指挥工作

[不定项选择题]惩处实施主体分为（）。
A.集团公司级
B.分公司级
C.中心（部门）
D.分部级

[不定项选择题]运营事故责任判定的原则：
A.以法律为依据
B.以事实为依据
C.以规章为准绳
D.坚持四不放过

[不定项选择题]起重指挥信号应（ ）。
A.简明
B.统一
C.畅通
D.分工明确

[不定项选择题]以下说法正确的是（)
A.起重机械必须具有产品合格证和安全使用、维护、保养说明书
B.其生产厂家必须具有政府主管部门颁发的相关资质，其安全、防护装置必须齐全、完备
C.改造后的起重装备，应取得当地政府相关部门颁发的使用许可证后，方可使用
D.安装后的起重装备，应取得当地政府相关部门颁发的使用许可证后，方可使用

[不定项选择题]下列说法正确的是()
A.在用火前应清除现场一切可燃物并准备好消防器材
B.用火期间距用火点30m内严禁排放各类可燃气体
C.用火期间15m内严禁排放各类可燃液体
D.用火期间10m范围内及用火点下方不应同时进行可燃溶剂清洗和喷漆等交叉施工