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?

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?

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 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 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?

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 files 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?

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

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

A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity.
Which view displays all waits waited on by a session at least once?

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 one 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?

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- PDB1 is open READ WRITE
4- PDB2 is MOUNTED.
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:
$$ . oraenv ORACLE SID = [ cdbl] ? cdb1
The oracle base remains unchanged with value /u01/app/oracle
Ş ŞORACLE_HOME/jdk/bin/java -jar preupgrade. jar TERMINAL TEXT For which databases will fixup scripts be created?

Your production database is running in archivelog mode. You use RMAN with a recovery catalog toback 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- CDB1 is a container database running in ARCHIVELOG mode.
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 OFF
4-. 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/cdb1/CDB1/controlfile02. ctl' is accidentally deleted.
To recover from this critical failure, you execute these commands: S 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'; What will be the outcome?

Examine these actions:

1- Create a new database for a recovery catalog.

2-Create a tablespace with sufficient space in the catalog database for the recovery catalog.

3- Configure ARCHIVE LOG mode for the catalog database.

4- Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.

5- Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.

6- Grant the SYSBACKUP privilege to the recovery catalog schema owner.

Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

You plan to create a database by using the Database Configuration Assistant (DBCA., with the following specifications: Applications will connect to the database via a middle tier.
The number of concurrent user connections will be high.
The database will have mixed workload, with the execution of complex Bl queries scheduled at night.
Which DBCA option must you choose to create the database?

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:
$ srvctl start database -d ORCL What is the outcome?

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?

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?

Examine the RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?