083_在线真题试卷与模拟练习_083

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

choose one You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?

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?

Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

Choose the best answer. Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

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 notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

Examine this configuration:

1.CDBi is a container database running in ARCHIVELOGmod

2.Controlfiles of cDB1 are multiplexed in

/u01/app/oracle/oradata/CDB1/controlfile/controlfile01.ctl'and/u02/app/oracle/fast recover_area/cdb1/CDB1/controlfile02.ctl

3. The only backup of cDB1 was taken when CONTROLFILE AUTOBACK was OFF4.SNAPSHOT CONTROLFILE NAME IS'/u01/app/oracle/product/12.2.0.1/db 1/dbs/snapcf cdb1.f'.

While CDB1 is open, "u02/app/oracle/fast recover area/cdb 1/CDB1/ controlfile02.ctl' is accidentally deletedS rman target sys/oracle 4u@localhost:1521/cdb1

RMAN> SHUTDOWN ABORT

Oracle instance shut down

RMAN> STARTUP NOMOUNT

RMAN RESTORE CONTROLFILE FROM/u01/app/oracle/oradata/CDB1/controlfile/controlfile01.ctl';

To recover from this critical failure, you execute these commands: What will be the outcome?

Choose the best answer. A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?

Examine this configuration: 1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. 2. ORCL uses disk group +FRA for the Fast Recovery Area. 3. LISTENER is the listener for ORCL. 4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5. All components are currently shut down. You execute this command: What is the outcome?

Which is true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have different endian formats. Examine this list of actions: 1. Make the UNIVERSITY tablespace read-only on the source system.

2.Export the UNIVERSITY tablespace metadata using EXPDP.

3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.

4. Copy the UNIVERSITY tablespace data files to the destination system.

5. Copy the Data Pump dump set to the destination system.

6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

7. Import the UNIVERSITY tablespace metadata using IMPDP.

8. Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

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?

Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

Choose the best answer. Which operating system group is NOT needed to perform an Oracle Database installation?

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$$SEED, PDB1, and PDB2. 2. PDB$$SEED is open READ ONLY 3. 3. PDB1 is open READ WRITE 4. 4. PDB2 is MOUNTED. 5. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release:

S.oraenv

ORACLE SID =[cdb1] ? cdb1

The Oracle base remains unchanged with value /u01/app/oracle

S SORACLE HOME/jdk/bin/java -jar preupgrade.jar TERMINAL TEXTFor which databases will fixup scripts be created?

How are SGA and PGA memory managed by instance using these parameter settings?

Examine this extract from the show parameters command:

Examine the statements that use flashback technologies: 1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY□MM- DD HH:MI:SS'); 2. SELECT * FROM customers AS OF SCN 123456; 3. FLASHBACK TABLE customers TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS'); 5. SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999; 6. ALTER TABLE customers FLASHBACK ARCHIVE; Which set of statements depends on the availability of relevant undo data in the undo tablespace?

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

1 2 3 4 5 6 15

更多题库