[不定项选择题]Your CDB has two regular PDBs as well as one application container

With two application PDBs and an application seed.No changes have been

Made to the standard PDB$SEED.How many default temporary tablespaces

Can be assigned in the CDB?

A.

six

B.

seven

C.

five

D.

eight

E. three

[不定项选择题]Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. 

You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.

Which two are always true? (Choose two.)

A.

CDB1 and CDB2 must be in shared undo mode.

B.

A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C.

All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D.

Cloning HR_ROOT automatically clones HR_PDB1.

E.

The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.

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

1) CDB1 and CDB2 are two container databases.

2) PDB1 is a pluggable database in CDB1.

3) PDB1_C1_SRV is a service for PDB1.

4) CDB1_LINK is a database link in CDB2 referring to PDB1.

5) CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database

Default service.

You execute these commands successfully:

$ sqlplus sys/oracle_4U@cdb2 as sysdba

SQL> CREATE PLUGGABLE DATABASE PDB1

FROM PDB1@CDB1_LINK -

SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');

Which two are true? (Choose two.)

A. PDB1 will be created in CDB2 and automatically opened.
B. PDB1 will be created in CDB2 and left in MOUNT state.
C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
D. PDB1_C2_SRV will be created and started automatically.
E. PDB1_C2_SRV will be created but not started.

[不定项选择题]Application PDBs, SALES_APP1 and SALES_APP2, must be created and

They must access common tables of the SALES_APP application. Examine

These steps:

1) Install the SALES_APP application, including the common tables, in the

Application root.

2) Install the SALES_APP application in the application root and the common

Tables in both the CDB root and the application root.

3) Create an application seed.

4) Install the SALES_APP application in the application seed.

5) Create the SALES_APP1 and SALES_APP2 application PDBs.

6) Sync the SALES_APP1 and SALES_APP2 application PDBs with the

Application root.

7) Sync the SALES_APP1 and SALES_APP2 application PDBs with the

Application seed.

8) Sync the application seed with the application root.

Which are the minimum required steps in the correct sequence?

A.

3, 4, 1, 6, 8

B.

2, 5, 6

C.

1, 5, 6

D.

1, 3, 5, 6, 7

E. 1, 3, 5, 7

[不定项选择题]Aplication PDBs, SALES_APP1 and SALES_APP2, must be created and

They must access common tables of the SALES APP application. Examine

These steps:

1. Install the SALES_APP application, induding the common tables, in the

Application root.

2. Install the SALES_APP application in the application root and the common

Tables in both the CDB root and the application root.

3. Create an application seed.

4. Install the SALES_APP application in the application seed.

5. Create the SALES_APP1 and SALES_APP2 application PDBs.

6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application Root.

7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application Seed. 

8. Sync the application seed with the application root.

Which are the minimum required steps in the correct sequence?

A.

1,3,5,7

B.

2,5,6

C.

1,5,6

D.

3,4,1.6,8

E. 1,3,5,6,7

[不定项选择题]A container database (CDB) contains two pluggable databases PDB1

And PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in

The CDB. Data file 24 of PDB2 was deleted and you need to restore and

Recover it.

The only RMAN backup that exists was created with the BACKUP

DATABASE command while connected to CDB$ROOT. Which three are true?

(Choose three.)

A. Data file 24 can be recovered only while connected to PDB2.
B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
C. Data file 24 can be restored only while connected to CDB$ROOT.
D. Data file 24 can be restored only while connected to PDB2.
E. Data file 24 can be recovered while connected to PDB2.
F. Data file 24 can be recovered while connected to CDB$ROOT.

[不定项选择题]How do you configure a CDB for local undo mode?
A.

Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER

DATABASE LOCAL UNDO ON, and then restart the CDB instance.

B.

Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER

DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB,

Then restart the CDB instance.

C.

Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO

Tablespace. Execute

ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB

Instance.

D.

Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER

DATABASE LOCAL

UNDO ON, and then change the CDB to read/write mode.

E. Open the CDB instance in upgrade mode. In each PDB, execute ALTER
DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the
CDB instance.

[不定项选择题]Choose three.

Your container database, CDB1, is in local undo mode.

You successfully execute this command while connected to CDB1:

CREATE PLUGGABLE DATABASE pdb1

ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT)

CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ;

Which three are true about PDB1?

A. It has the same common users defined as does CDB1.
B. It has only local roles.
C. It has the same number of roles as CDB1.
D. Service PDB1 is created for remote logins to PDB1.
E. It is in mount state after creation.
F. It has no local users.

[不定项选择题]Choose two.

Examine this configuration:

1CDB1 and CDB2 are two container databases.

2 PDB1 is a pluggable database in CDB1.

3 PDB1_C1_SRV is a service for PDB1.

4CDB1_LINK is a database link in CDB2 referring to PDB1.

5 CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database

Default service.

You execute these commands successfully:

$ sqlplus sys/oracle_4U@cdb2 as sysdba

SQL> CREATE PLUGGABLE DATABASE PDB1

FROM PDB1@CDB1_LINK

SERVICE_NAME_CONVERT=('PDB1_C1_SRV', 'PDB1_C2_SRV') ;

Which two are true?

A. PDB1_C2_SRV will be created but not started.
B. PDB1 will be created in CDB2 and automatically opened.
C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
D. PDB1 will be created in CDB2 and left in MOUNT state.
E. PDB1_C2_SRV will be created and started automatically.

[不定项选择题]A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1.
PDB1 was unplugged from CDB1 earlier in the week.
Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING ‘/u01/app/oracle/oradata/pdb1.xml’
SOURCE_FILE_NAME_CONVERT =
(‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);
Which two are true? (Choose two.)
A. PDB1 data files already exist in the correct location.
B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before
Executing the command.
C. PDB_FILE_NAME_CONVERT must be set before executing the command.
D. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of
Data files for PDB1.
E. PDB1 must be dropped from CDB1.

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

1) CDB1 is a container database running in ARCHIVELOG mode.

2) Multiple uncommitted transactions are running in CDB1.

3) Redo log groups 1 and 2 are INACTIVE.

4) Redo log group 3 is the CURRENT group.

All members of redo log group 3 are lost before it is archived.

Examine these possible steps:

1) SHUTDOWN ABORT

2) STARTUP NOMOUNT

3) STARTUP MOUNT

4) ALTER DATABASE MOUNT

5) RESTORE DATABSE

6) RECOVER DATABASE NOREDO

7) RECOVER DATABASE UNTIL AVAILABLE

8) RESTORE ARCHIVELOG ALL

9) ALTER DATABSE OPEN

10)ALTER DATABASE OPEB RESETLOGS

Choose the minimum required steps in the correct order to recover the

Database.

A.

1, 3, 5, 8, 6, 10

B.

1, 3, 5, 6, 10

C.

1, 3, 5, 7, 10

D.

1, 2, 5, 7, 4, 10

E. 1, 3, 5, 6, 9

[不定项选择题]Choose three. You must migrate a non-CDB Oracle 11g Database to a

CDB without first performing an upgrade to the non-CDB.

User-defined objects are stored in several tablespaces in the non-CDB.

Which three methods can you use?

A.

Data Pump full database export and import

B.

cloning the non-CDB as a PDB

C.

replication using GoldenGate

D.

Data Pump transportable tablespaces

E. Data Pump full transportable database
F. the DBMS_PDB package

[不定项选择题]Choose three.

A container database, CDB1, contains a pluggable database PDB1.

Another container database is called CDB2.

You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time.

Which three are required?

A.

CDB1 must be in archivelog mode.

B.

CDB2 must be in shared UNDO mode only.

C.

CDB1 and CDB2 must be in shared UNDO mode.

D.

CDB2 must be in archivelog mode.

E.

CDB1 and CDB2 must both be in local UNDO mode.

F. CDB1 must be in shared UNDO mode only.

[不定项选择题]Choose two.

RMAN has just been connected to a target database and the recovery

Catalog database. In which two cases would an automatic full

Resynchronization occur between this target database's control file and the

RMAN recovery catalog?

A. when control file metadata for archive log backups or image copies has been
Overwritten in the target database's control file due to being older than
CONTROL_FILE_RECORD_KEEP_TIME
B. when a new tablespace is added to a registered target database
C. when a backup of the current control file is created
D. when control file metadata for data file backups or image copies has been
Overwritten in the target database's control file due to being older than
CONTROL_FILE_RECORD_KEEP_TIME
E. when the target is first registered

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

[不定项选择题]什么是劳动能力鉴定
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.会组织人员疏散

[不定项选择题]什么是安全三懂
A.懂得本单位火灾危险性
B.懂得预防火灾的措施
C.懂得补救初起火灾的方法