For which two requirements can you use the user_tablespaces clause with the create pluggable database command?

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

Comment: *

Name: *

Email: *

Verification: *

Examine this output:

Which two are true? (Choose two.)

• A.PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
• B.PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
• C.PDB3 can use all available parallel execution processes at times.
• D.PDB1 is always limited to 40% of the available system resources regardless of demand.
• E.Any PDB not specified in the plan will be unable to execute statements in parallel.
• F.Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

• A.It runs automatically after each AWR snapshot.
• B.It analyzes a period of time corresponding to the 12 hours of activity.
• C.Results are written to the alert log.
• D.It analyzes a period of time corresponding to the last day of activity.
• E.A DBA can run it manually.

Comment: *

Name: *

Email: *

Verification: *

A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity.
Which view displays all waits waited on by a session at least once?

• A.VSSESSION_WAIT_CLASS
• B.VSSESSION
• C.VSSESSION_EVENT
• D.VSSESSTAT
• E.V$SESSION_WAIT

Comment: *

Name: *

Email: *

Verification: *

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

• A.Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
• B.A connection to an auxiliary instance is always required.
• C.A subset of the target database can be duplicated.
• D.A new DBID is always created for the duplicated database.
• E.A connection to the recovery catalog instance is always required.
• F.A backup of the target database is always required.
• G.Duplication can be done by having the target database instance push copies to the auxiliary database instance.
• H.A connection to the target database instance is always required.

Comment: *

Name: *

Email: *

Verification: *