Online Access Free Oracle.1Z1-060.v2021-08-31.q180 Practice Test (Page 7)

1Z1-060 Exam Question 26

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit

Character Set: AL32UTF8

National Character Set: AL16UTF16

O/S: Oracle Linux 6 64-bit

The characteristics of the CDB are as follows:
Version: Oracle Database 12c Release 1 64-bit

Character Set: AL32UTF8

National Character Set: AL16UTF16

O/S: Oracle Linux 6 64-bit

Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A.Transportable database

B.Transportable tablespace

C.Data Pump full export/import

D.The DBMS_PDB package

E.RMAN

1Z1-060 Exam Question 27

Examine the commands executed to monitor database operations:
$ > conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid:= DBMS_SQL_MONITOR.BEGIN_OPERATION ('batch_job',
FORCED_TRACKING => 'Y');
Which two statements are true? (Choose two.)

A.Database operations will be monitored only when they consume a significant amount of resources.

B.Database operations for all sessions will be monitored.

C.Database operations will be monitored only if the STATISTICS_LEVELparameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESSis set to DIAGNISTIC + TUNING.

D.Only DML and DDL statements will be monitored for the session.

E.All subsequent statements in the session will be treated as one database operation and will be monitored.

1Z1-060 Exam Question 28

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true? (Choose two.)

A.Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

B.The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

C.The command will, create a common user whose description is contained in the root and each PDB.

D.The schema for the common user C # # A_ADMIN can be different in each container.

E.The command will create a user in the root container only because the container clause is not used.

1Z1-060 Exam Question 29

Examine the current values for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

A.It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.

B.It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.

C.It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

D.It succeeds only if memory is available from the autotuned components of SGA.

1Z1-060 Exam Question 30

What is the result of executing a TRUNCATE TABLEcommand on a table, in a non-CDB database, that has Flashback Archiving enabled?

A.It fails with the ORA-665610 Invalid DDLstatement on history-tracked message

B.The rows in the table and the archive are truncated, and flashback archiving is disabled.

C.The rows in the table are truncated without being archived.

D.The rows in the table are archived, and then truncated.

E.The rows in both the table and the archive are truncated.

Other Version: 68Oracle.Latestcram.1Z1-060.v2022-05-23.by.verna.110q.pdf; 2126Oracle.1Z1-060.v2022-04-28.q110; 115Oracle.Pass4training.1Z1-060.v2021-08-16.by.jennifer.153q.pdf

Latest Upload: 165ACSM.020-222.v2025-09-11.q48; 156VMware.5V0-31.23.v2025-09-10.q73; 130Oracle.1z0-915-1.v2025-09-10.q24; 159Citrix.1Y0-231.v2025-09-10.q87; 134SAP.C-THR85-2505.v2025-09-09.q29; 164Adobe.AD0-E727.v2025-09-09.q76; 129Oracle.1Z0-1123-25.v2025-09-09.q20; 134SAP.C_SIGPM_2403.v2025-09-08.q20; 253EXIN.ITIL.v2025-09-08.q161; 169BCS.PC-BA-FBA-20.v2025-09-08.q45

1Z1-060 Exam Question 26

1Z1-060 Exam Question 27

1Z1-060 Exam Question 28

1Z1-060 Exam Question 29

1Z1-060 Exam Question 30

Download PDF File