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

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Automatic Shared Memory Management (ASMM)is enabled for your database instance,
But parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

A database is running in archivelog mode. You want to back up a 10 TB data file
Belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?

Which parameter must be set to which value to implement automatic PGAmemory
Management?

Your multitenant container database (CDB) cdb1 that is running in archivelog mode
Contains two pluggable databases (PDBs), pdb2_1 andpdb2_2.
RMAN is connected to the target database pdb2_1. Examine the command executed to back
Uppdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?

What can be automatically implemented after the SQL Tuning Advisoris run as part of the
Automated Maintenance Task?

In your multitenant container database (CDB)that contains pluggable databases (PDBs),
The hr user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (
V_emp_id NUMBER,
V_ename VARCHA R2,
V_SALARY NUMBER,
V_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure from
Inserting values into tables on which they do not have any privileges?

The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1 Set the evolve task parameters.
2 Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3 Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4 Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5 Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps.

In the SPFILE, UNDO_TABLESPACE is Set toUNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?

You are administering a database that supports a data warehousing workload and is
Running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and
Level 1 incremental backups on all the other days of the week. One of the data files is
Corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?

Your database is running in archivelog mode. You are taking a backup of your database
By using RMAN with a recovery catalog. Because of a media failure, one of the data files and
All the control files are lost.
Examine the steps to recover the database:
1 Restore the control files by using the RMAN restore controlfile command.
2 Mount the database.
3 Restore the data files by using the RMAN restore database command.
4 Open the database with the resetlogsoption.
5 Recover the data files by using the RMAN recover using backup controlfile command.
6 Start the database instance in nomount state.
7 Connect to the target database by using a recovery catalog.
8 Open the database.
9 Restore the data file.
10 Recover the data file.
Identify the required steps in the correct order.

You want RMAN to make duplicate copies of data files when using the backup command.

What must you set using the RMAN configure command to achieve this?

Your database is running in archivelog mode.
Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l='LOCATION=/disk1/archMANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'
LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'
LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1
Parameter is not available. All redo log groups have been used.
What happens at the next log switch?

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors:
SQL> startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal
Settings,see alertlog for more information
Why did the instance fail to start?

You notice performance degradation in your production Oracle 12c database. Youwant to

Know what caused this performancedifference.

Which method or feature should you use?

You execute the commands on a multitenant container database CDB1 that has multiple

Pluggable databases: $$ . oraenv

ORACLE_SID = [oracle] ? cdb1

The oracle base for ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is

/u01/app/oracle

54 / 60$$ rman target /

Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013 Coppyright

Connected to target database:CDB1 (DBID=782249327)

RMAN>SELECT name FROM v$tablespace;

Which statement is true about the execution of the last command?

You notice that the performance of your production 24/7 Oracle 12c database has

Significantly degraded. Sometimes you are not able to connect to the instance because

It hangs. You do not wantto restart the databaseinstance.

How can you detect the cause of the degraded performance?

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

The following are the possible steps to accomplish this task:

1 Place all the user-defined tablespace in read-only mode on the source database.

2 Upgrade the source database to a 12cversion.

3 Create a new PDB in the target containerdatabase.

4 Perform a full transportable export on the source database with the VERSIONparameter set to 12 using the expdp utility.

5 Copy the associated data files and export the dump file to the desired location in the target database.

6 Invoke the Data Pump import utility on the new PDB database as a user with the DATA PUMP_IMP_FULL_DATABASE role and specify the full transportable import options.

7 Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the requiredsteps.

After implementing full Oracle Data Redaction, you change the default value for the
Number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL;
NUMBER_VALUE
-------------------------
0
SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full;
NUMBER VALUE
------------------------
-1
After changing the value, you notice that FULL redaction continues to redact numeric data
With a zero. What must you do to activate the new default value for numeric full redaction?

Examine the commands:
SQL> ALTER SESSION SET RECYCLBIN = ON;
Session altered.
SQL> DROP TABLE emp; -- (First EMP table) Total dropped.
SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name
VARCHAR2 (15), salary NUMBER (7,2) );
Table created.
You then execute multiple INSERT statements to insert rows into EMP table and drop the
Table again:
SQL> DROP TABLE emp; -- (Second EMPtable)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?

1 2 3 4 5 6 17