[不定项选择题]choose one You want to create a test database as a replica of your

Production database with minimum intervention from a DBA. Which method

Would you use?

A.

Use DBCA to create a template from the existing database to contain the

Database structure with data files and then use the same template to create the

Database in the new location.

B.

Use Database Configuration Assistant (DBCA) to create a template from the

Existing database to contain the database structure.

C.

Use DBCA to create a template from the existing database to contain the

Database structure and then manually copy the data by using Oracle Data Pump.

D.

Create the database by using the CREATE DATABASE . . . command and

Manually import data by using Data Pump.

[不定项选择题]Choose the best answer
You want to create a duplicate database
DUP_DB from your production database PROD on the same host. The PROD
Database uses Automatic Storage Management (ASM) for storage.
Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE
DATABASE;
What is a prerequisite for the successful execution of this command
A. RMAN must be connected to the target database instance and the auxiliary
Instance.
B. A most recent backup set of the PROD database must exist.
C. Flashback must be enabled for the PROD database.
D. The target database must be in MOUNT state.

[不定项选择题]Which three actions are performed by Database Upgrade Assistant

(DBUA)? (Choose three.)

A.

It recompiles all stored PL/SQL code by using utlrp.sql.

B.

It empties the RECYCLE BIN.

C.

It performs prerequisite checks to verify if the Oracle database is ready for

Upgrade.

D.

It sets all user tablespaces to 'read-only' before starting the upgrade.

E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER
Roles
F. It increases tablespace size, if required, to meet upgrade requirements.

[不定项选择题]Examine this configuration:

1The ORCL database data files are in Automatic Storage Management

(Oracle ASM) disk group +DATA.

2ORCL uses disk group +FRA for the Fast Recovery Area.

3LISTENER is the listener for ORCL.

4The database, listener, ASM instance, and ASM disk groups are managed

By Oracle Restart.

5All components are currently shut down.

You execute this command:

What is the outcome?

A.

The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk

Groups, and the

LISTENER are started.

B.

Only the ORCL database instance is started.

C.

Only the ORCL database and the ASM instances are started.

D.

Only the ORCL database instance, the Oracle ASM instance, and the +DATA

And +FRA disk groups

Are started.

E. Only the ORCL database instance and the +DATA and +FRA disk groups are
Started.

[不定项选择题]Which three can be done using Oracle Database Configuration Assistant

(DBCA) starting from Oracle Database 19c? (Choose three.)

A. cloning a remote container database in interactive mode
B. cloning a remote pluggable database in silent mode
C. relocating a remote pluggable database in interactive mode
D. relocating a remote container database in silent mode
E. cloning a remote container database in silent mode
F. relocating a remote pluggable database in silent mode
G. relocating a remote container database in interactive mode

[不定项选择题]choose three
You want to duplicate one of your databases when
Connected to the target database and to the recovery catalog.
Which three are true about this type of database duplication?
A.) The duplication process can create backup sets or image copies.
B.) The target database must be open.
C.) The duplication process can use existing backup sets or image copies.
D.) The target database must be in mount state.
E.) The duplication process pushes backup sets to the auxiliary instance.
F.) The duplication process pushes image copies to the auxiliary instance.

[不定项选择题]Examine these actions:

1-Create a new database for a recovery catalog.

2-Create a tablespace with sufficient space in the catalog database for the recovery catalog.

3-Configure ARCHIVE LOG mode for the catalog database.

4-Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.

5-Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.

6-Grant the SYSBACKUP privilege to the recovery catalog schema owner.

Which are the minimum actions that must be performed before executing

The CREATE CATALOG command?

A.

2, 4, 5, 6

B.

1, 2, 3, 4, 5, 6

C.

1, 2, 4, 5

D.

2, 4, 5

E. 1, 3, 4, 5

[不定项选择题]In one of your databases, unified auditing is enabled and an SH.SALES

Table exists.

You successfully execute these commands: SQL> CREATE

AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY

Sales_pol; Which statement is true about SALES_POL?

A.

It is enabled for all users having SELECT privilege on SH.SALES.

B.

Only successful queries of SH.SALES are written to the audit trail.

C.

It is only enabled for user SH.

D.

Audit records are always stored in an external audit file.

[不定项选择题]choose one Examine the RMAN commands:

RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";

RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";

RMAN> DUPLICATE TARGET DATABASE TO dup_db

FROM ACTIVE DATABASE

PASSWORD FILE

SECTION SIZE 400M;

Which statement is true about the DUPLICATE command?

A.

It succeeds and creates multisection backup sets that are used for active

Database duplication.

B.

It fails because there is no connection to a recovery catalog.

C.

It succeeds only if the target database is in MOUNT state.

D.

It fails because no parallel channels are allocated for the auxiliary database.

[不定项选择题]choose one. 

You take regular backups of one of your production databases by using RMAN with a recovery catalog. 

You have added two new tablespaces to this database which must be included in future backups.

Which process occurs which allows the new backups to contain the new datafiles?

A.

The target database control file is synchronized from the recovery catalog with

A partial resync at the next backup.

B.

The recovery catalog is synchronized from the target database control file with

A full resync at the next backup.

C.

The target database control file is synchronized from the recovery catalog with

A full resync at the next backup.

D.

The recovery catalog is synchronized from the target database control file with

A partial resync at the next backup.

[不定项选择题]Choose two.

You want to install Oracle Grid Infrastructure for a Standalone Server using

Oracle Universal Installer (OUI).

There is no existing Oracle installation on the server.

Which two are prerequisites?

A.

an operating system user to own this installation

B.

the Oracle Inventory group oinstall

C.

an operating system account called grid

D.

a group called dba

E.

the installation of Oracle ASMLIB

[不定项选择题]Choose the best answer. You want to transport the UNIVERSITY

Tablespace from one database to another. The UNIVERSITY tablespace is

Currently open read/write. The source and destination platforms have the

Same endian Examine this list of steps:. 

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

2. Export the UNIVERSITY tablespace metadata using EXPDP. 

3. Create a cross-platform backup set from the UNIVERSITY

Source system, using an RMAN command that includes the DATAPUMP clause. 

4. Copy the cross-platform backup sets to the destination system. 

5. Copy the Data Pump dump set from the source to the destination system. 

6. Restore the cross-platform backup set on the destination system using an

RMAN command that includes the DATAPUMP clause. 

7. Import the UNIVERSITY tablespace metadata using IMPDP. 

8. Make the UNIVERSITY Tablespace read/write on the destination system. 

Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY Tablespace?

A.

3,4,6

B.

2,3,4,5,6,7

C.

1,3,4,6,8

D.

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

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

[不定项选择题]什么是工亡待遇
A.员工因工死亡，其近亲属按照下列规定从工伤保险基金领取丧葬补助金、供养亲属抚恤金和一次性工亡补助金。
B.伤残员工在停工留薪期内因工伤导致死亡的，其近亲属享工亡待遇

[不定项选择题]运营事故报告分为：
A.初报
B.电话报送
C.续报
D.书面报送

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

[不定项选择题]什么是劳动能力鉴定
A.员工发生工伤，经治疗伤情相对稳定后存在残疾、影响劳动能力的，应当进行劳动能力鉴定。
B.劳动能力鉴定标准由国务院劳动保障行政部门会同国务院卫生行政部门等部门制定
C.西安市劳动能力鉴定委员会的劳动能力鉴定材料受理时间为每周二、周四上午9:00-11:30，下午13:30-16:30

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

[不定项选择题]运输收入分为（ ）
A.票款收入、运费收入、铁路建设基金、代收款
B.客运收入、货运收入
C.客运收入、货运收入、铁路建设基金、代收款
D.票款收入、运费收入、杂费收入

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