Free Access Oracle.1z0-063.v2022-04-21.q171 Practice Test (Page 9)

Question 36

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?

A.Database Resident Connection Pooling

B.Nondefaultblocksizetablespaces

C.Oracle Suggested Backup Strategy

D.Database Vault in ORACLE_HOME

E.Configure Label Security

Question 37

You are connected to a pluggable database (PDB) as a common user with the SYSDBA privilege. The PDB is open and you issue the SHUTDOWN IMMEDIATE command.
What is the outcome?

A.The command results in an error because the PDB can be shut down only by a local user.

B.The PDB is closed and left in the mount state.

C.The PDB is closed and left in the unmount state.

D.The command executes only if the common user is granted the SET CONTAINER privilege for the PDB.

Question 38

You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true?

A.The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

B.The pga_aggregate_target and sga_target parameters are automatically set to zero.

C.The memory_max_target parameter is automatically set to 500 MB.

D.The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

E.The value of the memory_max_target parameter remains zero for the database instance.

Question 39

Which two are prerequisites for creating a backup-based duplicate database? (Choose two.)

A.connecting to the target database and a recovery catalog to execute the duplicate command

B.creating a password file for an auxiliary instance

C.connecting to an auxiliary instance

D.matching the database identifier (DBID) of the source database and the duplicate database

E.creating an SPFILE for the target database

Question 40

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcll;
SQL> GRANT CREATE SESSION TO c##scott user?
Which statement is true about the c##scott user?

A.It is created in all the PDBs with the CREATE SESSION privilege.

B.It is created only in CDB$ROOT and has the CREATE SESSION privilege.

C.It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.

D.It is created and has the CREATE SESSION privilege only in a PDB that is open.

Other Version: 2134Oracle.1z0-063.v2022-10-18.q151

Latest Upload: 107Oracle.1Z0-1057-23.v2025-09-10.q47; 146Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 155TheSecOpsGroup.CNSP.v2025-09-08.q20; 204CFAInstitute.ESG-Investing.v2025-09-08.q173; 152PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 140Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 176Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 36

Question 37

Question 38

Question 39

Question 40

Download PDF File