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?

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 up pdb2_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.

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.

Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' 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. You want to know what caused this performance difference.
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
$$ rman target /
Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013 Coppyright
(C. 1982, 2013, oracle and/or its affiliates. All rights reserved. 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 want to restart the database instance.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 VERSION parameter 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?

In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup controlfile.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database. Which step should you perform next to start the upgrade of the database?

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

1 2 3 4 5 6 17