Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

• A.temporary tablespaces
• B.undo tablespaces
• C.the log writer process (LGWR)
• D.the Process Monitor Process (PMON)
• E.the data dictionary in CDB$ROOT
• F.SYSAUX tablespaces

Comment: *

Name: *

Email: *

Verification: *

choose four Which four are true about performance-related Oracle tools?

• A.Database Replay always uses one replay client for all the original database sessions.
• B.SQL Performance Analyzer can identify regressed SQL statements.
• C.SQL Performance Analyzer can suggest schema changes.
• D.Database Replay always uses one replay client for each original database session.
• E.The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two non-consecutive periods.
• F.The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.
• G.The Active Session History (ASH) report is based on wait event samples.

Comment: *

Name: *

Email: *

Verification: *

Which three are true in Oracle 19c and later releases? (Choose three.)

• A.Unified Auditing can be configured to audit only events that are issued directly by an audited user.
• B.Privilege Analysisisincluded in Oracle Enterprise Edition and no longer requires Database Vault. E) Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
• C.If the password file location changes, then the new location is used automatically by the Oracle Server.
• D.Schema Only accounts can be granted administrator privileges.
• E.All the Oracle-supplied accounts are Schema Only accounts.

Comment: *

Name: *

Email: *

Verification: *

Examine the statements that use flashback technologies:
FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM-DD HH:MI:SS'); SELECT * FROM customers AS OF SCN 123456; FLASHBACK TABLE customers TO BEFORE DROP; FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS'); SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999; ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of relevant undo data in the undo tablespace?

• A.3,4,5
• B.1,3,6
• C.1,2,5
• D.2,3,5,6

Comment: *

Name: *

Email: *

Verification: *

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

• A.to specify the list of user tablespaces to include when moving a non-CDB to a PDB
• B.to specify the list oftablespaces to include when creating a PDB from the CDB seed
• C.to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
• D.to exclude all tablespaces except SYSTEM, SYSAUX, and TEMPwhen plugging in a PDB
• E.to include specific user tablespaces only when relocating a PDB
• F.to exclude a temp tablespace when plugging in a PDB

Comment: *

Name: *

Email: *

Verification: *