Free Access Oracle.1Z1-083.v2022-11-09.q168 Practice Test (Page 25)

Question 116

Which two statements are true when row archival management is enabled?

A.The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.

B.The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.

C.The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active. Correct

D.The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.

E.The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

Question 117

Which three are true about an application seed pluggable database (PDB)? (Choose three.)

A.A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.

B.It is not required in an application container.

C.A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

D.It is automatically synchronized with its application root PDB when an application is upgraded. B)It cannot be added to an application container after the application container has already been created.

E.It cannot be dropped from its application container.

F.It is automatically synchronized with its application root PDB when an application is installed.

Question 118

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADATA.
3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands: $ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type --------------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?

A.SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.

B.It will return an error because the SYNC operation is not allowed when constraints are added to common objects.

C.It will return an error because EMP is not empty in APP_ROOT.

D.SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

E.It will return an error because EMP.SAL is empty in APP_ROOT.

Question 119

Choose two. Which two are true about server-generated alerts?

A.Stateless alerts can be purged manually from the alert history.

B.Stateful alerts are purged automatically from the alert history after one day.

C.Stateless alerts can be cleared manually.

D.Stateless alerts are automatically cleared after one day.

E.Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.

Question 120

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

A.A PDB snapshot is always a full copy of the source PDB.

B.A PDB snapshot is always a sparse copy of the source PDB.

C.A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

D.A PDB snapshot depends on a storage snapshot which can be stored on any file system.

E.A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

F.A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

G.A snapshot copy PDB can be created from a stand-alone clone PDB.

Other Version: 1005Oracle.1Z1-083.v2024-01-08.q225; 4609Oracle.1Z1-083.v2022-05-30.q253; 3046Oracle.1Z1-083.v2022-01-24.q140; 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; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 164TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 150Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 116

Question 117

Question 118

Question 119

Question 120

Download PDF File