[单选题]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.

[不定项选择题]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 three statements are true about Automatic Workload

Repository (AWR)?

A.

All AWR tables belong to the SYSTEM schema.

B.

The AWR data is stored in memory and in the database.

C.

The snapshots collected by AWR are used by the self-tuning components in the database

D.

AWR computes time model statistics based on time usage for activities, which

Are displayed in t he v$SYS time model and V$SESS_TIME_MODEL views.

E. AWR contains system wide tracing and logging information.

[不定项选择题]Which three statements are true about the keystore storage framework

For transparent data encryption?

A. It facilitates and helps to enforce keystore backup requirements.
B. It handles encrypted data without modifying applications.
C. It enables a keystore to be stored only in a file on a file system.
D. It enables separation of duties between the database administrator and the
Security administrator.
E. It transparently decrypts data for the database users and applications that
Access this data.
F. It helps to track encryption keys and implement requirements such as keystore
Password rotation and master encryption key reset or re-key operations.

[不定项选择题]Which two statements are true about recovering logically corrupted

Tables or table partitions from an RMAN backup?

A. Tables or table partitions can be recovered by using an auxiliary instance only.
B. Tables or table partitions with a foreign key cannot be recovered.
C. Tables or table partitions can be recovered only when the database is in
Mount state.
D. Tables or table partitions from the system and sysaux tablespaces cannot be
Recovered.
E. Tables with not null constraints cannot be recovered.

[不定项选择题]Which three statements are true about Flashback Data Archive?
A. To use Flashback Data Archive, users must have unlimited quota on the
Flashback Data Archive tablespace.
B. To enable Flashback Data Archive for a table, it is mandatory to have a default
Flashback Data Archive for a database.
C. While enabling Flashback Data Archive for a table, if no name is provided for
Flashback Data Archive, it is enabled using the default Flashback Data Archive.
D. A table enabled for Flashback Data Archive cannot be dropped unless
Flashback Data Archive is disabled or disassociated first.
E. Flashback Data Archive prevents flashback queries from getting a
Snapshot-too-old error.

[不定项选择题]Which two statements are true about Resource Manager plans for

Individual pluggable databases (PDB plans) in a multitenant container

Database (CDB)?

A. If no PDB plan is enabled for a pluggable database, then all sessions for that
PDB are treated to an equal degree of the resource share of that PDB.
B. In a PDB plan, subplans may be used with up to eight consumer groups.
C. If a PDB plan is enabled for a pluggable database, then resources are allocated
To consumer groups across all PDBs in the CDB.
D. If no PDB plan is enabled for a pluggable database, then the PDB share in the
CDB plan is dynamically calculated.
E. If a PDB plan is enabled for a pluggable database, then resources are allocated
To consumer groups based on the shares provided to the PDB in the CDB plan
And the shares provided to the consumer groups in the PDB plan.

[不定项选择题]choose two Which two statements are true about encrypted backups

Performed by using RMAN?

A. Transparent encryption of backups uses an encryption wallet.
B. Image copy backups can be created by using password encryption.
C. A password encryption of backups uses the password while creating and
Restoring backups.
D. Encrypted backups can only be written to disk.
E. A database uses the same encryption key for every encrypted backup.

[不定项选择题]Which two statements are true when row archival management is
Enabled?
A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW
ARCHIVAL VISIBILITY session parameter.
B. The ORA_ARCHIVE_STATE column is updated manually or by a program that
Could reference activity tracking columns, to indicate that a row is no longer
Considered active.
C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
D. The ORA_ARCHIVE_STATE column is visible if referenced in t he select list of a
Query.
E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle
Server based on activity tracking columns, to Indicate that a row is no longer
Considered active.

[不定项选择题]Which two statements are true about RMAN duplexed backups?
A. It is not supported for image copies.
B. It is only supported for backups to tape via the media management interface.
C. Duplex backups can be performed on either disk or media, but cannot be
Performed on media and disk simultaneously.
D. Duplex backups can contain only data files and control files.
E. For performing duplexed backups, the parallelism for the device must be set
Equal to the number of copies.

[不定项选择题]Which two statements are true about the Database Configuration

Assistant (DBCA)?

A. It can configure Automatic Storage Management (ASM) diskgroups.
B. It can be used to copy an existing Oracle database to a new host and apply
Any patches necessary in the new host.
C. It can be used to add a new tablespace.
D. It can be used to create a database template from an existing database.
E. It can generate SQL database creation scripts.

[不定项选择题]Choose two.

Which two statements are true when row-archival management is enabled?

A.

The ORA_ARCHIVE_STATE column may only be queried by users with the DBA

Role set.

B.

The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the

Column select list of a query

C.

The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.

D.

The ORA_ARCHIVE_STATE column may only be updated by users with the

DBA role set.

E. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job
Based on activity tracking.

[单选题] Among the habits which children should _____ are slovenliness, rudeness, laziness, lying, stealing and slandering.
A. shake
B. shrink
C. shatter
D. shun

[单选题] 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.

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

[单选题]She made a speech to __________ smoking among teenagers.
A.discouraged
B. discourage
C. encouraged
D. encourage