Free Access Oracle.1Z1-083.v2022-01-24.q140 Practice Test (Page 20)

Question 91

Which two are true about data movement between a non-CDB and a PDB using Data Pump?

A.Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

B.Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

C.Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.

D.Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB.

E.Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

F.A new PDB is automatically created when importing a non-CDB into a CDB.

Question 92

You are managing this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are two pluggable databases in CDB1.
* 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:

Which two are true? (Choose two.)

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

B.The insert on USER2.DEPT is uncommitted.

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

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

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

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

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

Question 93

Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?

A.six

B.three

C.eight

D.five

E.seven

Question 94

Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

A.The Data Warehouse template is most suitable when transaction response time is the key criterion.

B.Oracle DBCA templates can be used to create new databases and duplicate existing databases.

C.Oracle DBCA templates can store only logical structure and not database files.

D.The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

E.New templates can only be created by modifying an existing user-created template.

Question 95

Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

A.It always generates REDO and UNDO.

B.It requires that the target database be in ARCHIVELOG mode.

C.A database can be flashed back using SQL*PLUS.

D.FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

E.Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.

F.FLASHBACK LOGS are archived after a log switch.

Other Version: 1005Oracle.1Z1-083.v2024-01-08.q225; 2877Oracle.1Z1-083.v2022-11-09.q168; 4618Oracle.1Z1-083.v2022-05-30.q253; 86Oracle.Examboosts.1Z1-083.v2021-11-12.by.lance.121q.pdf

Latest Upload: 105OCEG.GRCP.v2025-09-11.q211; 104HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 151Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 165TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 170PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 150Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 91

Question 92

Question 93

Question 94

Question 95

Download PDF File