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

Question 96

Which three are true? (Choose three.)

A.Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

B.Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

C.Application-common TSDP policies are always container specific.

D.Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

E.Unified auditing can be automatically synchronized to all application PDBs in an application container.

F.Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

G.Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.

Question 97

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

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

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

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

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

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

Question 98

A database is configured in ARCHIVELOGmode.
A full RMAN backup exists but no control file backup to trace has been taken.
A media failure has occurred.
In which two scenarios is incomplete recovery required? (Choose two.)

A.after losing all members of an INACTIVE online redo log group

B.after losing all copies of the control file

C.after losing an UNDOtablespace that is in use

D.after losing all members of the CURRENTonline redo log group

E.after losing a SYSAUXtablespace data file

Question 99

A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)

A.PDB1 must be dropped from CDB1.

B.DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

C.PDB_FILE_NAME_CONVERT must be set before executing the command.

D./u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

E.PDB1 data files already exist in the correct location.

Question 100

Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?
(Choose three.)

A.They cannot create restore points.

B.They can drop any tablespace.

C.They can view data from any user-defined tables.

D.They can create any table.

E.They cannot drop tablespaces.

F.They can view data from any data dictionary view or dynamic performance view.

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

Latest Upload: 103OCEG.GRCP.v2025-09-11.q211; 102HP.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; 222CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 147Salesforce.Data-Architect.v2025-09-05.q216; 142Adobe.AD0-E605.v2025-09-05.q50

Question 96

Question 97

Question 98

Question 99

Question 100

Download PDF File