Free Access Oracle.1z0-062.v2022-06-21.q305 Practice Test (Page 10)

Question 41

Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.)

A.To enable flashback database, the CDB must be mounted.

B.The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

C.Individual PDBs can be flashed back without flashing back the entire CDB.

D.The root container can be flashed back without flashing back the pluggable databases (PDBs).

E.A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Question 42

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions
The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result?

A.Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.

B.Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

C.Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.

D.Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.

E.Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.

F.Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

Question 43

Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:
$ make -fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME
Which two steps should you perform before executing this command? (Choose two.)

A.Ensure that the initialization parameter AUDIT_TRAIL is set to DB.

B.Drop any existing fine-grained audit (FGA) policies.

C.Stop the listener.

D.Shut down the database instance.

E.Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.

Question 44

You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems.
Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.)

A.The remote system must have a running Oracle Database instance and a scheduler agent installed.

B.The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.

C.The local database must be set up to run remote external jobs.

D.The remote system's scheduler agent must be registered with your database.

E.Database links to remote databases must be created.

Question 45

The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table.
Which statement is true?

A.The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS table is complete.

B.The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.

C.The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.

D.Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transactions on the DEPARTMENTS table is complete.

Other Version: 3595Oracle.1z0-062.v2022-12-05.q411; 37Oracle.Braindumpspass.1z0-062.v2021-09-25.by.hayden.259q.pdf

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; 220CFAInstitute.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; 183Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 41

Question 42

Question 43

Question 44

Question 45

Download PDF File