test_在线真题试卷与模拟练习_test_考试宝

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

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

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

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?

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?

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?

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 BI queries scheduled at night.Which DBCA option must you choose to create the database?

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

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?

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_REDACTION_VALUES(-1..;
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 zero.（您注意到 FULL 编校继续以零编校数值数据.也就是上面的修改还没有生效，该命令是把 number 的数据类型编辑以后默认值为－1.。
What must you do to activate the new default value for numeric full redaction?

You are administering a multitenant container database (COB. that contains two pluggable databases (PDBs., pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.
The statistics_level parameter is PDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?

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

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

choose one You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

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

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

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

更多题库