www_在线真题试卷与模拟练习_www_考试宝

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(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?

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?

Choose the best answer. Examine this configuration:
CDB1 is a container database.
APP_ROOT is an application root in CDB1.
APP_PDB1 is an application PDB in APP_ROOT.
FLASHBACK DATABASE is ON.
You execute these commands:
$$ sqlplus sys/orac1e_4U@localhost:1521/cdb1
SQL> SELECT current_scn FROM v$$database;
CURRENT_SCN
2074756
SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ;
Table created.
SQL> ALTER SESSION SET CONTAINER=app_root;
Session altered.
SQL> CREATE TABLE app_root_tab (c1 NUMBER) ;
Table created.
SQL> ALTER SESSION SET CONTAINER=app_pdb1;
Session altered.
SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ;
Table created.
SQL> conn / as sysdba
Connected.
SQL> ALTER PLUGGABLE DATABASE app_root CLOSE;
Pluggable database altered.
SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756;
Flashback complete.
Which table or set of tables will exist after the Flashback operation has completed?

Choose the best answer.
Examine this configuration:
CDB1 is a container database.
There are several pluggable databases (PDBs) in CDB1
Each PDB has several tables with referential integrity constraints.
FLASHBACK DATABASE is ON.
UNDO RETENTION GUARANTEE is enabled.
Multiple undesired multitable changes were made in all the PDBs.
Which method can be used to undo the changes using a single command?

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

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

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command:
SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin;
Which statement is true?

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands:
SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales;
SQL> AUDIT POLICY sales_pol; Which statement is true about SALES_POL?

Examine this configuration:

1The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA

2ORCL uses disk group +FRA for the Fast Recovery Area.

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

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 find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

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?

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

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

How are SGA and PGA memory managed by instance using these parameter settings?
Examine this extract from the show parameters command:

Choose the best answer.
SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases.
Which action could help in the performance management of these regressed SQL statements?

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

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

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?

Choose the best answer.
Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?