1Z1-083 Exam Practice Questions prepared by Oracle Professionals [Q141-Q159]

1Z1-083 Exam Practice Questions prepared by Oracle Professionals

Use Valid New 1Z1-083 Questions - Top choice Help You Gain Success

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

• A. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
• B. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
• C. A PDB snapshot is always a sparse copy of the source PDB.
• D. A PDB snapshot is always a full copy of the source PDB.
• E. A snapshot copy PDB can be created from a stand-alone clone PDB.
• F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
• G. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

Answer: E,G

Explanation:
G:
https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/cloning-a-pdb.html#GUID- F26C8A55-2465-475A-905A-83BD2E68AE6E and then create a SNAPSHOT COPY PDB from the standalone PDB.
C:
Storage requirements depend on the setting of the CLONEDB initialization parameter:
CLONEDB=FALSE
The underlying file system for the source PDB files must support storage snapshots. Such file systems include Oracle Automatic Storage Management Cluster File System (Oracle ACFS) and Direct NFS Client storage. Oracle Exadata supports snapshot copy functionality on ASM configured with sparse ASM grid disks.
CLONEDB=TRUE
The underlying file system for the source PDB files can be any local file system, network file system (NFS), or clustered file system that has Direct NFS enabled and supports sparse files.
Most UNIX systems meet these requirements, including Oracle ACFS and ZFS. However, when CLONEDB=TRUE, the source PDB must remain in open read-only mode when clones exist.

NEW QUESTION # 142
Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)

• A. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
• B. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
• C. A snapshot copy PDB can be a full copy of a source PDB.
• D. A PDB snapshot can be a full copy of a source PDB.
• E. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
• F. A PDB snapshot depends on an existing storage snapshot of the source PDB.
• G. A PDB snapshot can be a sparse copy of a source PDB.

Answer: D,E,G

Explanation:
A, E sparse / full depending on storage
D - no configuration required:
https://docs.oracle.com/en/database/oracle/oracle-database/19/duplicate-cdbs-using-dbca-silent- mode/index.html

NEW QUESTION # 143
Which two are true about the Oracle dataabse methodology? (Choose two.)

• A. Tuning activities should stop once the user is satisfied with performance.
• B. Tuning activities should stop once agreed service levels for performance have been met.
• C. The alert log should be used to find the database and instance areas most in need of tuning.
• D. SQL statements should always be tuned before tuning any file systems.
• E. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• F. The database instance memory should always be tuned before tuning any file systems.

Answer: B,C

Explanation:
Reference:
https://flylib.com/books/en/4.322.1.9/1/

NEW QUESTION # 144
Which two statements are true about the Oracle Database server during and immediately after SHUTDOWN IMMEDIATE?

• A. Uncommitted transactions are rolled back automatically.
• B. New connection requests made to the database instance are refused.
• C. All existing connections to the database instance remain connected until all transactions either roll back or commit.
• D. Uncommitted transactions are allowed to continue to the next COMMIT.
• E. All existing transactions are aborted immediately.

Answer: A,B

NEW QUESTION # 145
Which operating system group is NOT needed to perform an Oracle Database installation?

• A. OSOPER
• B. OSKMDBA
• C. OSDBA
• D. OSRACDBA
• E. OSASM

Answer: A

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/creating-operating-system-privileges-groups.html#GUID-164A7218-166D-4B58-9A86-88149E8FCB83

NEW QUESTION # 146
Choose two. Which two statements are true when row-archival management is enabled?

• A. The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.
• B. The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.
• C. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.
• D. The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query
• E. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.

Answer: D,E

NEW QUESTION # 147
Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

• A. It is used to change failure priority only for HIGH or LOW priorities.
• B. It is used to change failure priority only for the CRITICAL priority.
• C. It is used to inform the database about the repair after the repair script executes.
• D. It is used to execute the advised repair script.
• E. It is used to explicitly close the open failures.

Answer: A,E

NEW QUESTION # 148
Choose three. Which three activities are possible for PDBs?

• A. converting an application PDB to an application seed G) converting an application PDB to a regular PDB
• B. copying an application container into another application container in a different CDB
• C. converting a regular PDB to an application PDB
• D. converting an application PDB to an application root
• E. converting an application seed to an application PDB
• F. copying an application container into another application container in the same CDB

Answer: A,B,E

NEW QUESTION # 149
Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

• A. Use the SQL Access Advisor for each of the regressed statements.
• B. Use The SQL Tuning Advisor for each of the regressed statements.
• C. Create an adaptive execution plan for each of the regressed statements
• D. Create SQL plan directives for each of the regressed statements.

Answer: B

NEW QUESTION # 150
Which three are true about monitoring waits for sessions and services? (Choose three.)

• A. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
• B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
• C. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
• D. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
• E. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
• F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

Answer: A,B,F

Explanation:
A, E - False : V$SESSION_EVENT displays information on waits for an event by a session.
V$SESSION_WAIT_HISTORY displays the last 10 wait events for each active session.
B - V$SERVICE_EVENT displays aggregated wait counts and wait times for each wait statistic.
C - False : V$SESSION_WAIT_CLASS displays the time spent in various wait event operations on a per-session basis.
D, F - True : V$SESSION_WAIT displays the current or last wait for each session.
V$SESSION.EVENT If the session is currently waiting, then the resource or event for which the session is waiting. If the session is not in a wait, then the resource or event for which the session most recently waited.
Resource :
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-
SESSION_EVENT.html#GUID-5723D404-83F7-4C8D-8BF2-031B3FFEAAA8

NEW QUESTION # 151
Which two are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases?

• A. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
• B. A PDB snapshot must be a full copy of a source PDB.
• C. A CDB can be duplicated only by using the Database Configuration Assistant (DBCA).
• D. A PDB snapshot can be a sparse copy of a source PDB.
• E. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode.

Answer: D,E

NEW QUESTION # 152
Oracle Data Redaction is active on the SCOTT.EMPtable.
You queried the table twice.
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

Which is guaranteed to be true concerning the redaction policy?

• A. PARTIAL redaction is active on the MGR column.
• B. RANDOM redaction is active on the MGR column
• C. RANDOM redaction is active on the HIREDATE column
• D. FULL redaction is active on the SAL column
• E. PARTIAL redaction is active of the HIREDATE column.

Answer: C

NEW QUESTION # 153
Which three are true about Transparent Data Encryption (TDE)?

• A. Master encryption keys are managed by Oracle Database Vault.
• B. It encrypts only data on the client.
• C. It replaces secure application roles.
• D. It stores the current and all past master keys in the keystore.
• E. It uses a single master key for a database.
• F. It can encrypt data at the column level.

Answer: A,D,F

NEW QUESTION # 154
Your container database, CDB1 has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT Which two are always true?

• A. A common user must exist in CDB2 with the create pluggable database privilege.
• B. Cloning HR_ROOT automatically clones HR_PDB1.
• C. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.
• D. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
• E. CDB1 and CDB2 must be In shared undo mode.

Answer: A,B

NEW QUESTION # 155
Which two are true about automatic block repair? (Choose two.)

• A. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
• B. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
• C. It is not possible for media corrupt blocks.
• D. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
• E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Answer: A,E

Explanation:
You can use an Oracle Active Data Guard standby database for automatic repair of data corruptions detected by the primary database. Additionally if the corruption is discovered on an Active Data Guard physical standby database the corruption will be automatically repaired with a good block from the Primary.

NEW QUESTION # 156
Choose four. Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

• A. It can be performed repeatedly until the correct time is found without using an RMAN catalog. E)RMAN always includes tablespaces containing UNDO segments in the recovery set.
• B. It can be used to recover a truncated table.
• C. It can be performed using an auxiliary instance managed by a DBA.
• D. It can be performed using an auxiliary instance managed by RMAN.
• E. RMAN automatically adds any required tablespaces to the recovery set to make it selfcontained. G) FLASHBACK DATABASE must be enabled for it to work. H) It can be used to recover a dropped

Answer: B,D

Explanation:
tablespace.

NEW QUESTION # 157
Which two are true about Oracle instance recovery? (Choose three.)

• A. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
• B. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
• C. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
• D. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
• E. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
• F. Recovery begins from the beginning of the CURRENT redo log group.

Answer: B,E

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

• A. They can view data from any user-defined tables.
• B. They can view data from any data dictionary view or dynamic performance view.
• C. They can drop any tablespace.
• D. They cannot drop tablespaces.
• E. They cannot create restore points.
• F. They can create any table.

Answer: D,F

NEW QUESTION # 159
......

1Z1-083 Exam Practice Materials Collection: https://www.dumpsquestion.com/1Z1-083-exam-dumps-collection.html

Get Latest and 100% Accurate 1Z1-083 Exam Questions: https://drive.google.com/open?id=11S1gEwoJlyimhoztzNFlLvW0ZnXW8PKn