[单选题] Which of the following sentences is right according to the passage？
A. Parents should like everything their children enjoy
B. In all families children can choose everything they like
C. Parents should try their best to understand their children better
D. Teenagers can only go to their friends for help

[单选题] Which of the following is different in the meaning from the sentence “some parents may even stop their children from meeting their good friends”？
A. Some parents may even not allow their children to meet their good friend.
B. Some parents may even ask their children not to meet their good friends.
C. Some parents may not even let their children meet their good friends.
D. Some parents may want their children to meet their good friends.

[不定项选择题]Choose three.

Which three are true about actions that can or cannot be performed by users

With the SYSBACKUP privilege?

A.

They can view data from any data dictionary view or dynamic performance

View.

B.

They can drop any tablespace.

C.

They can view data from any user-defined tables.

D.

They can create any table.

E.

They cannot create restore points.

F.

They cannot drop tablespaces.

[单选题]Among the following statements, ( ) is correct.
A. As WCDMA sysetms use 2.6 GHz band, the first Fresnel zone has no impact on their signal propagation.
B. The Doppler effect has more impact on narrowband wireless systems than wideband wirless systems.
C. The electric field probability density distribution functions of fast fading and slow fading fit the Rayleigh distribution.
D. None of the above statement is correct.

[不定项选择题]You execute the following piece of code with appropriate privileges:

BEGIN DBMS_REDACT.ADD_POLICY ( END; object_schema object_name

Column_name policy_name function_type expression => 'SCOTT', => 'EMP',

=> 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT

(''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); END; 

BEGIN DBMS_REDACT.ADD_POLICY ( object_schema object_name column_name

Policy_name function_type expression => 'SCOTT', => 'EMP_VW', => 'SAL',

=> 'SCOTT_EMP_VW', => DBMS_REDACT.NONE, => 'SYS_CONTEXT

(''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); 

User SCOTT has been granted the CREATE SESSION privilege and the MGR role. 

Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A.

DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheM

GR role set.

B.

DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.

C.

Data is never redacted for the EMP_VW.SAL column.

D.

Data is redacted for the EMP_V.SAL column only if the SCOTT session has the

MGR role set.

E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not
Have the MGR role set. Correct

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

[单选题]Hold the card in your right hand and swipe it here. 此句应用于（ ）场景下。
A.A.刷卡进站
B.B.售票充值
C.C.进站安检
D.D.退票

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

[不定项选择题]Which three are true about monitoring waits for sessions and services?

(Choose three.)

A.

V$SESSION_EVENT displays all waits for all past and existing sessions if the

Wait has occurred at least once for a session.

B.

V$SERVICE_EVENT displays all waits for all services if the wait has occurred at

Least once for a service.

C.

V$SESSION_WAIT _CLASS displays waits broken down by wait class only for

Waiting sessions.

D.

V$SESSION_WAIT and V$SESSION both contain details of the event on which

A non-waiting session last waited.

E. V$SESSION_EVENT displays all waits for all past sessions if the wait has
Occurred at least once for a session.
F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a
Session is currently waiting.

[不定项选择题]Which two are true about Oracle Optimizer Statistics, their use, and

Their collection? (Choose two.)

A. The number of table rows is considered when evaluating the cost of accessing
A table using an index.
B. Index balanced B*Tree height is considered when evaluating the cost of using
An index.
C. The Statistics Advisor can help recommend the best way to gather statistics.
D. Statistics collected using DBMS_STATS always yield the best optimizer result.
E. The Statistics Advisor generates actions for all recommendations.

[不定项选择题]Identify three scenarios in which RMAN will use backup sets to perform

Active database duplication.

A. when the duplicate ... from active database command contains the section size
Clause
B. when you perform active database duplication on a database with flashback
Disabled
C. when you specify set encryption before the duplicate ... from active database
Command
D. when the number of auxiliary channels allocated is equal to or greater than
The number of target channels
E. when you perform active database duplication on a database that has
Readonly tablespaces

[不定项选择题]Which two are true about flashback features in Oracle Database 19c and

Later releases? (Choose two.)

A.Flashback logs are automatically purged when
DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have
Already been retained.
B. Flashback logs are monitored and proactively deleted when beyond the
Retention period defined in DB_FLASHBACK_RETENTION_TARGET only after
There is space pressure.
C. Flashback logs are monitored and proactively deleted when beyond the
Retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is
Space pressure.
D. Flashback logs are monitored for being older than the retention period
Defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an
Administrator written event trigger.
E. Flashback logs are automatically purged whenever the value of
DB_FLASHBACK_RETENTION_TARGET is changed.

[不定项选择题]Which three are true? ()
A.

Virtual Private Database (VPD) policies on objects in an application root are

Automatically synchronized with all application PDBs contained in the application

Container.

B.

Application-common TSDP policies are always container specific.

C.

Application-common Transparent Security Data Protection (TSDP) policies can

Be created only within an application install/patch BEGIN-END block.

D.

Application-common Oracle Label Security (OLS) policies cannot be created in

An application root outside an install/patch BEGIN-END block.

E. Fine-grained auditing (FGA) policies in an application root are automatically
Synchronized to all application PDBs contained in the application container.
F. Application-common OLS policies can be created in an application root inside
An install/patch BEGINEND block.
G. Unified auditing can be automatically synchronized to all application PDBs in
An application container.

[不定项选择题]Which two are true about duplicating pluggable databases (PDBs) with

RMAN? (Choose two.)

A.

Two or more PDBs can be duplicated with the same RMAN DUPLICATE

Command.

B.

All tablespaces belonging to a PDB must be duplicated when duplicating the

PDB.

C.

The auxiliary instance is automatically created with

ENABLE_PLUGGABLE_DATABASE = TRUE.

D.

A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB

To duplicate it.

E. CDB$ROOT and PDB$SEED are automatically duplicated.

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

[不定项选择题]Which three tasks can be automatically performed by the Automatic
Data Optimization feature of Information lifecycle Management (ILM)?
A. Tracking the most recent read time for a table segment in a user tablespace
B. Tracking the most recent write time for a table segment in a user tablespace
C. Tracking insert time by row for table rows
D. Tracking the most recent write time for a table block
E. Tracking the most recent read time for a table segment in t he SYSTEM
Tablespace
F. Tracking the most recent write time for a table segment in t he SYSAUX
Tablespace

[不定项选择题]Which three are true about an application seed pluggable database

(PDB)? (Choose three.)

A.

It is automatically synchronized with its application root PDB when an

Application is upgraded.

B.

It cannot be added to an application container after the application container

Has already been created.

C.

A new application PDB created by cloning an application seed PDB can have

An old version of the application installed after cloning completes.

D.

It is automatically synchronized with its application root PDB when an

Application is installed.

E. It cannot be dropped from its application container.
F. A new application PDB created by cloning an application seed PDB can have
An up-to-date version of the application installed after cloning completes.
G. It is not required in an application container.

[不定项选择题]Which three are true about upgrading Oracle Grid Infrastructure?

(Choose three.)

A.

A direct upgrade can be performed only from the immediately preceding

Oracle Grid Infrastructure version.

B.

The newer version is installed in a separate Oracle Grid Infrastructure home on

The same server as the existing version.

C.

An existing Oracle base can be used.

D.

The upgrade process will automatically install all mandatory patches for the

Current version of Oracle Grid Infrastructure.

E. Existing Oracle Database instances must be shut down before starting the
Upgrade.
F. Only the grid user can perform the upgrade.

[不定项选择题]Which two are true about creating pluggable databases (PDBs) using

Snapshots in Oracle 19c and later releases? (Choose two.)

A.

A PDB snapshot is always a full copy of the source PDB.

B.

A PDB snapshot is always a sparse copy of the source PDB.

C.

A snapshot copy PDB depends on a storage snapshot which can only be

Stored on specific file systems.

D.

A PDB snapshot depends on a storage snapshot which can be stored on any

File system.

E.

A PDB snapshot depends on a storage snapshot which can only be stored on

Specific file systems.

F. A snapshot copy PDB depends on a storage snapshot which can be stored on
Any file system.
G. A snapshot copy PDB can be created from a stand-alone clone PDB.

[不定项选择题]Which three are true about Recovery Manager (RMAN) in Oracle Database

19c and later releases? (Choose three.)

A. It is only possible for RMAN to connect to a pluggable database as a target if
An RMAN Virtual Private Catalog is used.
B. It is always possible for RMAN to connect to a pluggable database as a target
If any RMAN Catalog is used.
C. A Virtual Private Catalog used to register a container database must be
Created in a pluggable database.
D. A Virtual Private Catalog used to register a container database can be created
In a pluggable database.
E. It is always possible for RMAN to connect to a pluggable database as a target.
F. A Virtual Private Catalog used to register a container database can be created
In a non-container database.