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

Question 146

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating
a multitenant container database (CDB) plan using Oracle Database Resource Manager? (Choose two.)

A.maximum number of sessions for a PDB

B.maximum undo per consumer group

C.CPU

D.maximum idle time for a session in a PDB

E.parallel server limit

Question 147

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

A.If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

B.In a PDB plan, subplans may be used with up to eight consumer groups.

C.If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

D.If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

E.If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Question 148

Which three statements are true about Oracle Restart? (Choose three.)

A.It can be configured to automatically attempt to restart various components after a hardware or
software failure.

B.While starting any components, it automatically attempts to start all dependencies first and in proper
order.

C.It can be configured to automatically restart a database in case of normal shutdown of the database
instance.

D.It can be used to only start Oracle components.

E.It runs periodic check operations to monitor the health of Oracle components.

Question 149

You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAME TYPE VALUE
- ----------------------------------------------------------------------
db_create_file_dest string
db_file_name_convert string
db_files integer 200
You verify that sufficient disk space is available and that no file currently exists in the '/u0l/app/oracle/
oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSER salesadm IDENTIFIED BY password;
ROLES=(dba)
DEFAULTTABLESPACE sales
DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01.dbf'SIZE 250M
AUTOEXTEND ON
FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdbseed/',
' /u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE2G)
PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';
Which statement is true?

A.PDB creation fails because the db_file_name_convert parameter is not set in the CDB.

B.SALESPDB is created and is in read/write mode.

C.SALESPDB is created and is in mount state.

D.PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

Question 150

You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
create table employees
( empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A.The valid time columns employee_time_start and employee_time_end are automatically created.

B.The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

C.The valid time columns are not populated by the Oracle Server automatically.

D.The valid time columns are visible by default when the table is described.

E.Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

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

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

Question 146

Question 147

Question 148

Question 149

Question 150

Download PDF File