Online Access Free 1Z1-083 Practice Test

Examine this configuration:
1. CDB1is a container database.
2. PDB1 and PDB2are pluggable databases in CDB1.
3. PDB1 and PDB2are OPENin READ WRITEmode.
You execute these commands successfully:

Which two are true? (Choose two.)

• A.PDB1 is closed.
• B.CDB1 is shut down.
• C.Uncommitted transactions in PDB1 have been rolled back.
• D.Uncommitted transactions in CDB1 and PDB1 have been rolled back.
• E.CDB1 is in MOUNT state

Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)

• A.The entire PGA is located in the System Global Area (SGA) when using shared servers.
• B.The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
• C.PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
• D.Sorts and Hash Joins use PGA memory.
• E.The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.

Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c? (Choose two.)

• A.The response file must contain the root or sudo password.
• B.Silent install always runs operating scripts automatically.
• C.The response file can specify the root or sudo password.
• D.The response file can specify the path of the sudo program.
• E.The installer will prompt for the root or sudo password.

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 the target database instance is always required.
• C.A subset of the target database can be duplicated.
• D.A backup of the target database is always required.
• E.A new DBID is always created for the duplicated database.
• F.Duplication can be done by having the target database instance push copies to the auxiliary database instance.
• G.A connection to an auxiliary instance is always required.
• H.A connection to the recovery catalog instance is always required.

Which two are true about memory advisors? (Choose two.)

• A.If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.
• B.If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
• C.All memory advisors use data from Automatic Workload Repository.
• D.If Automatic Memory Management is enabled, no memory advisors are available.
• E.If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.