063_在线真题试卷与模拟练习_063_考试宝

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

You are administering a multitenant container database(CDB.CBD1 with two pluggable databases(PDBs), PDB1 and PDB2.
You execute the following commands on CBD$ROOT as the SYS user: SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO C##SCOTT user?
Which statement is true about the C##SCOTT user?

You are administering a multitenant container database(CDB.that contains multiple pluggable database(PDBs).RMAN is connected to CDB$ROOT.
Examine the command:
RMAN>LIST FAILURES;
Which statement is true about this command?

You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database use 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?

Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?

You execute the commands to configure settings in RMAN:
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Then, you issue the following command to take a backup:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of these commands?

You execute the command to recover your database:RMAN> RUN (SET UNTIL TIME ‘2015-02-28:16:45:00’; RESTORE DATABASE;RECOVER DATABASE;)Which statement is true?

In CDB$ROOT of your multitenant container database (CDB., you create a common user, C##A_ADMIN, and the execute the command:
SQL> GRANT create tablespace to C##A_ADMIN:
Which statement is true?

RMAN is connected to a target database instance and an auxiliary instance. You execute thecommand:
RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G;
What is the outcome?

A database instance uses an spfile examine the parameter NAME TYPE VALUE
------------------- ------------ --------------------------------------
Control_files string /u01/app/oracle/oradata/cdb1/disk1/control01.ctl,
/u01/app/oracle/oradata/cdb1/disk2/control02.ctl You plan to multiplex the control file to a new location,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl Examine the possible steps that are in random order:
1/Shutdown the database instance.
2/Issue ALTER SYSTEM SET CONTROL_FILES= '/u01/app/oracle/oradata/cdb1/disk1/control01.ctl‘, ‘/u01/app/oracle/oradata/cdb1/disk2/control02.ctl’ ’/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’ scope=spfile;
3/Issue ALTER SYSTEM SET CONTROL_FILES= '/u01/app/oracle/oradata/cdb1/disk1/control01.ctl’, ‘/u01/app/oracle/oradata/cdb1/disk2/control02.ctl’ ‘/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’; 4/Copy the control file from the existing location to
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl 5/Mount the database
6/Open the database
Identify the required steps in the correct order to accomplish the task.

You are administering a multitenant container database(CDB. that has no startup triggers and contains three pluggable databases(PDBs).
You execute the command to start up the CDB:
SQL> STARTUP
Which statement is true?

Your database is running on the host ouserver,You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host , ouserver1,with the same directory structure, So, you copy the backups to the new host.
What must you do to make the database operational in ouserver1?

Examine the list of possible steps to transport a tablespaces across platforms that have the same compatibility level,character sets,and endian format:
1/Make the tablespaces read-only at the source database. 2/Export metadata from the source database.
3/Import metadata into the target database.
4/Transfer the dump file and data files to the target machine.
5/Convert data files by using Recovery Manager(RMAN).
6/Make the tablespaces read-write at the target database. Identify the required steps in the correct order.

You want to migrate your Oracle 11g database as a pluggable database (PDB. In a multitenant container database (CDB..

Examine the steps required to perform the migration:

1/Use Data Pump export to perform a full transportable export on the source database with the export parameter version=12.

2/Place all tablespaces in read-only mode on the sourcedatabase.

3/Upgrade the source database to Oracle Database 12c.

4/Copy the dump file and data files to the desired location in the target database.

5/Create a new PDB In the target CDB.

6/Synchronize the PDB on the target CDB.

7/Use Data Pump import on the new PDB by using the full transportable import options. Identify the required steps in the correct order.

Examine these actions:
1/Log in to CDB$ROOT as a user with the SYSDBA privilege.
2/Log in to the PDB as a user with the SYSKM privilege.
3/Ensure that the CDB keystore is open.
4/Ensure that the CDB keystore is closed.
5/Export the PDB key information.
6/Export the CDB key information.
7/Shut down the CDB.
8/Shut down the PDB.
9/Unplug the PDB.
Which of these are required to unplug an encrypted PDB?

One of your production databases is in ARCHIVELOG mode.
You use RMAN with a recovery catalog to back up this database to media and the database is defined in the recovery catalog.You want to create a test database by duplicating the production database while it remains open.You restore production database backups to a new host with the same directory structure as on the original host.The same recovery catalog must be used for any new backups created after the test database is successfully restored to the new host.
How would you achieve this?

You are required to migrate your 11.2.0.3 database to an Oracle 12c database. Examine the list of steps that might be used to accomplish this task:
1\Place all user-defined tablespaces in read-only mode on the source database.
2\Use the RMAN CONVERT command to convert data files to the target platform's endian format, if required.
3\Perform a full transportable export on the source database with the parameters VERSION=12, TRANSPORTABLE=ALWAYS, and FULL=y.
4\Transport the data files for all the user-defined tablespaces.
5\Transport the export dump file to the target database.
6\Perform an import on the target database by using the FULL, NETWORK_LINK, and TRANSPORT_DATAFILES parameters.
7\Perform an import on the target database by using the FULL and TRANSPORT_DATAFILES parameters.
Identify the minimum required steps in the correct order.

Your database is running in ARCHIVELOG mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted. Examine the steps to recover the online redo log group and move it to a new location.
1/Restore the corrupted redo log group.
2/Restore the database from the most recent database backup.
3/Perform an incomplete recovery.
4/Relocate the member of the damaged online redo log group to a new location.
5/Open the database with the RESETLOGS option.
6/Issue a checkpoint and clear the log.
Identify the required steps in the correct order .

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?

One of your database runs in ARCHIVELOG mode. Examine these initialization parameter settings:
LOG_ARCHIVE_DEST_1 = ‘LOCATION=/disk1/arch’ LOG_ARCHIVE_DEST_2 = ‘LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = ‘LOCATION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY’ LOG_ARCHIVE_MIN_SUCCEED_DEST = 2
Which statement is true based on these settings?

One of your database suffered an instance failure.At the next startup, from which point in the redo logs does instance recovery begin?