Free Access Oracle.1Z1-060.v2022-03-23.q171 Practice Test (Page 34)

Question 161

You plan to drop the column of a table that has Flashback Archiving enabled.
You want to ensure minimal service disruption.
How would you do this in your Oracle 12c Database?

A.Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.

B.Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.

C.Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.

D.Drop the column using the ALTER TABLE statement.

E.Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.

Question 162

You connect to the root container of a multitenant container database (CDB) with SYSDBA privileges by using SQL*Plus.
The CDB has several pluggable databases (PDBs) open in read/write mode.
There are ongoing transactions in both the CDB and the PDBs.
What happens after issuing the SHUTDOWN TRANSACTIONAL statement?

A.The statement results in an error because there are open PDBs.

B.The shutdown proceeds immediately

C.The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

D.The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled back.

Question 163

You upgrade your Oracle database in a multiprocessor environment. As a recommended best practice, you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)

A.Parallel compilation of only the stored PL/SQL code

B.Sequential recompilation of only the stored PL/SQL code

C.Parallel recompilation of any stored PL/SQL code

D.Sequential recompilation of any stored PL/SQL code

E.Parallel recompilation of Java code

F.Sequential recompilation of Java code

Question 164

What is the result of executing a TRUNCATE TABLE command on a table that hasFlashback Archivingenabled?

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

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

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

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

Question 165

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

Which two statements are true?

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

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

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

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

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

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; 162TheSecOpsGroup.CNSP.v2025-09-08.q20; 221CFAInstitute.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; 184Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 161

Question 162

Question 163

Question 164

Question 165

Download PDF File