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

Question 66

In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to
20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?

A.Taking the target tablespace offline after the segments are moved

B.The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used

C.The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

D.The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

E.Setting the target tablespace to read-only after the segments are moved

Question 67

Your database is running in ARCHIVELOGmode. Examine the initialization parameters you plan to set for your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.

A.These settings work only if LOG__ARCHIVE_MIN_SUCCEED_DESTis set to a value of 4.

B.An online redo log file is not allowed to be overwritten if the archived log file cannot be created in the location specified for LOG_ARCHIVE_DEST_4.

C.An online redo log file is not allowed to be overwritten if the archived log file cannot be created in any of the LOG_ARCHIVE_DEST_.ndestinations.

D.Optional destinations cannot use the fast recovery area.

Question 68

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute
the command to create a common user:
SQL> CREATE USER c##a_admin
IDENTIFIED BY password
DEFAULT TABLESPACE users
QUOTA 100M ON users
TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

A.The command gives an error because the CONTAINER=ALLclause is missing.

B.The command succeeds and sets the default permanent tablespace of a PDB as the default
tablespace for the C##A_ADMINuser if the USERStablespace does not exist in that PDB.

C.The command succeeds only if all the PDBs have the USERS and TEMPtablespaces.

D.The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces
of the CDB to store schema objects.

Question 69

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length, consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group;

Which two statements are true?

A.An attempt to start a new session by a user belonging to OTHE_GROUPS fails withan error.

B.The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.

C.A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

D.An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

E.The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

Question 70

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command? (Choose two.)

A.It succeeds with default settings if the employees table exists in the hr schema.

B.It fails because no SQL*Loader control file location is specified.

C.It fails if the hr user does not have the create any directory privilege.

D.It succeeds and creates the employees table in the HR schema.

E.It fails because no SQL*Loader data file location is specified.

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

Latest Upload: 101OCEG.GRCP.v2025-09-11.q211; 101HP.HPE0-V27.v2025-09-11.q78; 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; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 156PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 146Salesforce.Data-Architect.v2025-09-05.q216; 139Adobe.AD0-E605.v2025-09-05.q50

Question 66

Question 67

Question 68

Question 69

Question 70

Download PDF File