[不定项选择题]中共十七大对走中国特色社会主义道路提出了四点根本要求,下列属于四点根本要求的是( )
A.继续解放思想
B.坚持改革开放
C.落实科学发展
D.转变发展方式

[不定项选择题]The persistent configuration settings for RMAN have default for all

Parameters. 

Identify four RMAN commands that produce a multi-section Backup.

A.

BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

B.

BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

C.

BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

D.

BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION
SIZE 100M;
F. BACKUP SPFILE SECTION SIZE 1M;
G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

[不定项选择题]Which statement describes the significance of the CHANGE FAILURE

Command in RMAN? (Choose all that apply.) choose two

A.

It is used to change failure priority only for HIGH or LOW priorities.

B.

It is used to execute the advised repair script.

C.

It is used to change failure priority only for the CRITICAL priority.

D.

It is used to explicitly close the open failures.

E. It is used to inform the database about the repair after the repair script
Executes.

[不定项选择题]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?

A.

Decreasing PCTUSED

B.

Decreasing PCTFREE

C.

Increasing the number of DBWN process

D.

Using Automatic Segment Space Management (ASSM)

E. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE
Recommendation

[不定项选择题]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?

A.

1, 2, 4, 5, 7, 8

B.

1, 2, 4, 6, 7, 8

C.

1, 2, 3, 4, 5, 7, 8

D.

1, 2, 3, 4, 5, 6, 7, 8

E. 2, 4, 5, 6, 7

[不定项选择题]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?

A.

Re-enable redaction policies that use FULL data redaction.

B.

Re-create redaction policies that use FULL data redaction.

C.

Re-connect the sessions that access objects with redaction policies defined on

Them.

D.

Flush t he shared pool.

E. Restart the database instance.

[不定项选择题]Examine the command for creating pluggable database PDB2 in

Container database CDB2.

Select three options, any one of which is required for it to execute

Successfully. (Choose three.)

A. Add the FILE_NAME_CONVERT clause to the statement and set the
PDB_FILE_NAME_CONVERT
Parameter.
B. Add only the CREATE_FILE_DEST clause to the statement.
C. Set only the PDB_FILE_NAME_CONVERT parameter.
D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
E. Enable only OMF.
F. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle
Managed Files (OMF)

[不定项选择题]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?
A. All historical data older than two years, if any, is purged from the flashback
Archive FDA1.
B. An error is returned because the retention period cannot be reduced.
C. All the flashback data archives are purged and the subsequently created
Flashback archives are maintained for two years.
D. All historical data older than two years, if any, is archived to flashback logs and
The flashback archive is set to new retention time.

[不定项选择题]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?

A.

Database Replay

B.

Automatic Database Diagnostic Monitor (ADDM) Compare Period report

C.

Active Session History (ASH) report

D.

SQL Performance Analyzer

[不定项选择题]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?

A.

The statistics_level parameter is set to all when any of the PDBs is reopened.

B.

The statistics_level parameter is set to all only for PDB2 when it is reopened.

C.

The statistics_level parameter is set to all when the root database is restarted.

D.

The statement is ignored because there is no SPFILE for a PDB.

[不定项选择题]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?  one

A.

Run the SQL Access Advisor.

B.

Run the Memory Advisor for the shared pool.

C.

Run the SQL Tuning Advisor.

D.

Run the Memory Advisor for the Program Global Area.

E.

Run the Memory Advisor for the System Global Area.

[不定项选择题]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?

A.

1,3,6

B.

1,2,5

C.

3,4,5

D.

2,3,5,6

[不定项选择题]Which two are prerequisites for performing Flashback Transaction?
A.

Fast Recovery Area must be enabled for the database.

B.

The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK

Package.

C.

Undo retention guarantee must be configured for the database.

D.

A supplemental log must be enabled for the primary key.

E.

Row movement must be enabled.

[不定项选择题]安全标志分为()。
A.禁止标志
B.警告标志
C.提示标志
D.指示标志
E.以上都对

[不定项选择题]电脑软件包括（）。
A.应用软件
B.操作系统
C.基本输入输出系统
D.主板
E.驱动

[不定项选择题]车载设备包括()。
A.VOBC机柜
B.MMI显示屏
C.速度传感器,雷达，应答器
D.鱼鳍天线，平板天线
E.驾驶台开关及指示灯

[不定项选择题]谐波的危害是（ ）
A.增大设备损耗，降低系统容量，如变压器、断路器、电缆等；
B.加速设备老化，缩短设备使用寿命，甚至损坏设备；
C. 造成保护误动或者拒动，危害生产安全与稳定；
D.对邻近的通信信号等弱电系统产生干扰，轻者减低通信质量，重者导致信息丢失，系统无法正常工作。

[不定项选择题]以下哪项不是地铁火灾的特点（）。
A.影响范围广
B.疏散困难
C.救护难度大
D.通信系统容易瘫痪
E.以上都对

[不定项选择题]下面说法不正确的一项是()。
A.“全面深化改革”中,经济体制改革始终是改革重点,经济体制改革对其他的改革起着一个牵引的作用
B.“四个全面”每个要素之间是完全处在等同和并列地位的
C.“四个全面”有机联系、缺一不可,相互之间谁也离不开谁
D.“全面深化改革”“全面依法治国”“全面从严治党”支撑着“全面建成小康社会”目标实现

[不定项选择题]Which three are true about Automatic Workload Repository (AWR)?

(Choose three.)

A. By default, AWR snapshots are taken every 60 minutes.
B. Its collection level is determined by the value of the STATISTICS_LEVEL
Database parameter.
C. By default, AWR snapshots are retained for 7 days.
D. The taking of AWR snapshots can be disabled.
E. AWR data is stored in the SYSTEM tablespace.