Free Access Oracle.1Z0-083.v2024-08-30.q181 Practice Test (Page 25)

Question 116

Your sales_root application container has two application PDBs.
The sales_app application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true?

A.A container map exists for the revenue table, but Is not enabled.

B.The revenue table must be a list-partitioned table.

C.The maptable table is a metadata-linked table.

D.The containers clause cannot be used in queries on the revenue table.

E.The revenue table partitions are not pruned across the PDBs automatically.

F.The maptable table defines a logical partition key on a commonly used column for the revenue table.

Question 117

Choose two. You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2 . CDB1 user SYS executes these commands after connecting successfully to PDB2: SQL> ALTER SESSION SET CONTAINER=pdb1; Session altered. SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ; 1 row created. SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ; 1 row created. SQL> ALTER SESSION SET CONTAINER=pdb2; Session altered. SQL> INSERT INTO user2.dept VALUES(1, 'IT'); Which two are true? Which two are true? (Choose two.)

A.The insert on USER2.DEPT is uncommitted.

B.The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

C.The inserts on USER1.EMP were committed when the session inserted a row into USER2. DEPT.

D.The inserts on USER1.EMP were committed when the session connected to PDB2.

E.The insert on USER2.DEPT fails because of the active transaction in the parent container.

F.The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

G.The inserts on USER1.EMP were rolled back when the session connected to PDB2

Question 118

Which three are true in Oracle 19c and later releases? (Choose three.)

A.Tablespaces never remain in read/write mode during transportable tablespace operations.

B.A transportable data pump import can leave a plugged-in tablespace in read-only mode.

C.A transportable data pump import can leave a plugged-in tablespace in read/write mode.

D.Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

E.Tablespaces always remain in read/write mode during transportable tablespace operations.

F.An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Question 119

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

A.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

B.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

C.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

D.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

E.Automatic Memory Management must be used together with locking the System Global Area into physical memory.

F.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

Question 120

You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

A.Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

B.Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

C.Create the database by using the CREATE DATABASE . . . command and manually import data by using Data Pump.

D.Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

Other Version: 4244Oracle.1Z0-083.v2025-05-02.q283; 2448Oracle.1Z0-083.v2024-11-13.q152; 5912Oracle.1Z0-083.v2022-07-24.q137; 6009Oracle.1Z0-083.v2022-02-19.q163; 119Oracle.Examcollectionpass.1Z0-083.v2021-09-29.by.liz.149q.pdf

Latest Upload: 203PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 302Nokia.4A0-113.v2026-05-01.q69; 263EC-COUNCIL.312-49v11.v2026-04-30.q214; 230Microsoft.MB-820.v2026-04-30.q101; 212Salesforce.MC-202.v2026-04-30.q57; 207BICSI.INSTC_V8.v2026-04-29.q53; 336NMLS.MLO.v2026-04-28.q82; 245NCARB.Project-Management.v2026-04-28.q27; 466EMC.D-AV-DY-23.v2026-04-27.q184; 1125ServiceNow.CSA.v2026-04-27.q483

Question 116

Question 117

Question 118

Question 119

Question 120

Download PDF File