Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); Which three statements are true about the effect of this command?

• A.Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
• B.Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
• C.Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
• D.Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
• E.Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about using flashback database in a multitenant container database (CDB)?
(Choose three.) (Choose three.)

• A.The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
• B.The root container can be flashed back without flashing back the pluggable databases (PDBs).
• C.Individual PDBs can be flashed back without flashing back the entire CDB.
• D.To enable flashback database, the CDB must be mounted.
• E.A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

• A.A DBA can check specific tables with the DMU
• B.The database to be migrated must be opened read-only.
• C.The release of the database to be converted can be any release since 9.2.0.8.
• D.The DMU can report columns that are too long in the converted characterset.
• E.The DMU can report columns that are not represented in the converted characterset.

Comment: *

Name: *

Email: *

Verification: *

You executed this command to create a password file:
$ orapwd file = orapworcl entries = 10 ignorecase = N
Which two statements are true about the password file? (Choose two.)

• A.It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
• B.It contains username and passwords of database users who are members of the OSOPER operating system group.
• C.It contains usernames and passwords of database users who are members of the OSDBA operating system group.
• D.It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
• E.It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

Comment: *

Name: *

Email: *

Verification: *

Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

• A.All database operations performed by the impdp command are logged.
• B.Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
• C.Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
• D.None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

Comment: *

Name: *

Email: *

Verification: *