063_在线真题试卷与模拟练习_063

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

For your database, an incremental level 1 backup is taken every week day. On Tuesday,
Before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG ‘WEEKLY’
DATABASE;
Which statement is true about the execution of the command?

Your multitenant container database (CDB) cdb1 that is running in archivelog mode

Contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN

Is connected to the target databasepdb2_1.

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which statement is true about the execution of this command to back up the database?

You are connected to a pluggable database (PDB) as a common user with the sysdba

Privilege. The PDB is open and you issue the shutdown immediate command.

What is the outcome?

You create two Resource Manager plans, one for night time workloads, the other for day
Time. How would you make the plans switch automatically?

Which Oracle Database component is audited by default if the UnifiedAuditing option is
Enabled?

Examine the commands executed in CDB$ROOT of your multitenant container database
(CDB)that has multiple pluggable databases(PDB):
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER=ALL;
SQL> CREATE USER c##admin IDENTIFIED BYorcl123;
SQL> GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##role1 CONTAINER=ALL;
Which statement is true about granting the select privilege on the DBA_users view to the
C##ROLE1 role?

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the

RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema

Owned by the rc11 user.

Adatabase with DBID=1423241 is registered in the RCAT11 catalog. Both the recovery catalog

Databases are open.

In the CATDB12c database, you execute the commands:

RKAN> CONNECT CATALOG rc12c/pass12c@catdb12c

RKAN> IMPORT CATALOG rc11/pwdcat11@rcat11 DBID=1423241;

What is the outcome of the import?

Your database is running in archive log mode and a nightly backup of the database, along
With an auto backup of the control file, is taken by using RMAN. Because of a media failure,38 / 60
The SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1 Set DBID of the target database in RMAN.
2 Start the database instance by using the startup force nomount command in RMAN.
3 Restore the control files from the backup.
4 Mount the database.
5 Restore the SPFILE from the autobackup.
6 Create a PFILE from the recoveredSPFILE.
7 Restart the instance in nomount state.
Identify the required steps in the correct order.

You want to move your existing recovery catalog to another database. Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the create catalog command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import
Utility in the target database.
5) Import the source recovery catalog schema by using the import catalog command.
6) Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.

Your database supports an OLTP workload. Examine the output of the query:
SQL> SELECT target_mttr, estimated_mttr FROM v$instance_recovery
Target_mttr estimated_mttr
---------------------- ---------------------------
0 76
To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.
What is the effect of this setting on the database?

Examine the RMANcommand:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?

You notice a performance change in your production Oracle 12c database. You want to
39 / 6040 / 60
Know which change caused this performance difference.
Which method or feature should you use?

You created a database with DBCAby using one of the Oracle supplied templates. Which
Is the default permanent tablespace for all users except DBSNMP and OUTLN?

Examine these Data Pump commands to export and import objects from and to the same
Database.The dba has not yet created users hr1 and oe1.
$$expdp system/manager schemas = hr,oe directory = EXP_DIR dumpfile = export.dat include
= table
$$ impdp system/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat
Remap_schema=hr:hrl, oe:oe1
What will happen when running these commands?

You wish to enable an audit policy for all database users, except sys, system, and scott.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pending_area();
PL/SQL procedure successfully completed.
SQL> exec dbms_resource_manager.create_consumer_group (consumer_group => 'OLTP',
Comment => 'online user');
PL/SQL procedure successfully completed.
SQL> exec dbms_resource_manager.create_plan(plan=>'PRIUSER3',comment=>'dssprio');
SQL> exec dbms_resource_manager.create_plan_directive(plan=>'PRIUSER3',
Group_or_subplan =>' OLTP',comment=>'olinegrp',cpu_p1=>60);
PL/SQL procedure successfully completed.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager.validate_pending_area ();
What is the reason for the error?

You are administering a multitenant container database (CDB) cdb1 that is running in
Archivelog mode and contains pluggable databases (PDBs), pdb_1 and pdb_2.
While opening pdb_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-011S7: cannot identify/lock datafile11-see DBWR trace file
ORA-01110: data file 11:'/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf'
To repair the failure, you open an RMAN session for the target database CDB$ROOT. You
Execute the following as the first command:
RMAN>REPAIR FAILURE;
Which statement describes the consequence of the command?

You want to export the pluggable database (PDB) hr_pdb1 from the multitenant
Container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.
Examine the list of possible steps required to perform the task:
1 Create a PDB named emp_pdb1.
2 Export the hr_pdb1 PDB by using the fullclause.
3 Open the emp_pdb1 PDB.
4 Mount the emp_pdb1 PDB.
5 Synchronize the emp_pdb1 PDB in restrictedmode.
6 Copy the dump file to the Data Pump directory.
7 Create a Data Pump directory in the emp_pdb1PDB.
8 Import data into emp_pdb1 with the full and remap clauses.
9 Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Identify the required steps in the correct order.

Examine the following steps of privilege analysis for checking and revoking excessive,
Unused privileges granted to users:
1 Create a policy to capture the privileges used by a user for privilege analysis.
2 Generate a report with the data captured for a specified privilege capture.
3 Start analyzing the data captured by the policy.
4 Revoke the unusedprivileges.
5 Compare the used and unused privileges'lists.
6 Stop analyzing thedata.
Identify the correct sequence of steps.

You use RMAN with a recovery catalog to back up your database. The backups and
The archived redo log files are backed up to media daily.Because of a media failure, the
Entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1 Restore an auto backup of the server parameter file.
2 Restore the controlfile.
3 Start up the database instance in nomount state.
4 Mount the database.
5 Restore the data files.
6 Open the database with the resetlogsoption.
7 Recover the data files.
8 Set DBID for thedatabase.
Identify the required steps in the correct order.

1 2 3 4 5 6 17