Oracle Database 19c Certification 1Z0-083 Sample Questions Reliable
Prepare for the Actual Oracle Database 19c 1Z0-083 Exam Practice Materials Collection
How much Oracle Database Administration II Exam Number: 1Z0-083 costs
- Types of questions: Performance Based Questions
- Length of Exam: 150 min
- Examination Fees: $250 USD
NEW QUESTION 148
Which three statements are true about Flashback Data Archive?
- A. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database
- B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
- C. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.
- D. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.
- E. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.
Answer: B,C,E
NEW QUESTION 149
choose three Which three are true about unified auditing in full mode?
- A. Audit records are created for SYS.
- B. Audit records are created for non-sys users.
- C. The unified audit trail is written to a read-only table.
- D. Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.
- E. The unified audit trail is written to a read-only external file.
Answer: A,B,C
NEW QUESTION 150
Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)
- A. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
- B. SBT tape compression can be used even if no RMAN compression is configured.
- C. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
- D. The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.
- E. SBT tape compression and RMAN backup compression should be used in parallel.
Answer: D,E
NEW QUESTION 151
While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)
- A. Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.
- B. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
- C. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.
- D. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
- E. If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.
- F. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
- G. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/
Answer: A,C,E
NEW QUESTION 152
Examine this configuration:
CDB1 is a container database.
PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. PDB1 and PDB2 are in MOUNT state.
- B. PDB1 and PDB2 are in READ ONLY state.
- C. CDB$ROOT is in MOUNT state.
- D. PDB$SEED is in READ ONLY state.
- E. Redo logs are opened.
Answer: D,E
NEW QUESTION 153
Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?
(Choose three.)
- A. Some messages in the error stack are not errors.
- B. If an RMAN command fails, the output will identify the channel ID where the failure occurred.
- C. Media Management errors appear as a line with "sbtio" and a number.
- D. Media Management errors appear as a line with "sbtio".
- E. If an RMAN command fails, the output will only identify the command that failed.
- F. Media Management errors appear as a line with "Additional information" and a number.
Answer: B,D,F
NEW QUESTION 154
Choose two. Which two are true about PDB archive files?
- A. They contain all the data files only in uncompressed form for a PDB.
- B. They contain all the data files only in compressed form for a PDB.
- C. They must be created using the DBMS_PDB package.
- D. They contain a PDB manifest file and all the data files in uncompressed form for a PDB.
- E. They contain a PDB manifest file and all the data files in compressed form for a PDB.
- F. DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.
Answer: E,F
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. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
- C. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
- D. It is not possible for media corrupt blocks.
- E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
Answer: D,E
NEW QUESTION 156
Which three are true about requirements for various flashback operations?
- A. flashback data archive requires undo to store all versions of all rows of a table being tracked.
- B. flashback transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- C. flashback drop requires undo to retrieve all versions of a row that existed between two points in time.
- D. flashback version query requires undo to retrieve all versions of a row that existed between two points in time.
- E. flashback version query requires that the recyclebin parameter be set to on.
- F. flashback drop requires that the recyclebin parameter be set to on.
Answer: A,B,E
NEW QUESTION 157
Choose three. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?
- A. creating a database link from CDB$ROOT in the remote database to the PDB in the local database
- B. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
- C. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
- D. automatically dropping the database link to the remote database if it already exists
- E. opening the cloned PDB
- F. creating a new empty PDB in the local database from PDB$SEED
- G. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
Answer: A,C,D
NEW QUESTION 158
Which three are true about opatchauto? (Choose three.)
- A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
- B. It applies patches in nonrolling mode by default.
- C. Patches are applied via opatchauto.
- D. Users must always input patch plans to opatchauto.
- E. It must be invoked by a user with root user privileges.
- F. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
- G. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
Answer: A,E,G
NEW QUESTION 159
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It always analyzes all schemas in the database.
- B. It is part of the DBMS_STATS package.
- C. It is part of the DBMS_ADVISOR package.
- D. It runs automatically every night by default.
- E. It can be run only manually.
- F. It can recommend changes to improve the statistics gathering process.
Answer: B,D,F
NEW QUESTION 160
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It always analyzes all schemas in the database.
- B. It is part of the DBMS_STATS package.
- C. It is part of the DBMS_ADVISOR package.
- D. It runs automatically every night by default.
- E. It can be run only manually.
- F. It can recommend changes to improve the statistics gathering process.
Answer: B,D,F
Explanation:
Explanation
https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf
NEW QUESTION 161
How do you configure a CDB for local undo mode?
- A. Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.
- B. Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
- C. Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.
- D. Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.
- E. Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
Answer: C
NEW QUESTION 162
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
- A. An existing Oracle base can be used.
- B. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
- C. Only the grid user can perform the upgrade.
- D. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
- E. Existing Oracle Database instances must be shut down before starting the upgrade.
- F. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
Answer: A,C,D
NEW QUESTION 163
Examine the command for creating pluggable database PDB2 in container database CDB2.
Select three options, any one of which is required for it to execute successfully. (Choose three.)
- A. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
- B. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
- C. Set only the PDB_FILE_NAME_CONVERT parameter.
- D. Add only the CREATE_FILE_DEST clause to the statement.
- E. Enable only OMF.
- F. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
Answer: A,D,E
NEW QUESTION 164
Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?
- A. It has the same common users defined as does CDB1.
- B. It has no local users.
- C. It has the same number of roles as CDB1.
- D. It is in mount state after creation.
- E. It has only local roles.
- F. Service PDB1 is created for remote logins to PDB1.
Answer: A,D,F
NEW QUESTION 165
choose one You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?
- A. All historical data older than two years, if any, is purged from the flashback archive FDA1.
- B. An error is returned because the retention period cannot be reduced.
- C. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.
- D. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years
Answer: A
NEW QUESTION 166
Which three are true about block media recovery? (Choose three.)
- A. The target database for which one or more blocks are to be recovered must be in the OPEN state.
- B. To use it, Flashback Database must be enabled.
- C. It cannot repair logical corruption.
- D. A block being recovered is not accessible.
- E. It can be performed on noncorrupt blocks.
- F. The data file containing the block being recovered remains online.
Answer: A,B,F
NEW QUESTION 167
The users tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace?
- A. The database must be registered in an RMAN catalog.
- B. Backups can be done incrementally.
- C. Backups must be done incrementally.
- D. Backups must be contained in backup sets.
- E. Only consistent backups can be created.
- F. Backups can be taken only if the database is in archivelog mode.
Answer: B,F
NEW QUESTION 168
Which two are true about the SQL Tuning Advisor?
- A. It can recommend semantic changes to SQL statements.
- B. It only recommends syntactic changes to SQL statements.
- C. It considers all SQL statements being analyzed by the advisor task as a group.
- D. It prevents performance regressions for SQL statements when changes are made.
- E. It checks each query being analyzed for missing or stale statistics.
Answer: A,B
NEW QUESTION 169
Choose three. Which three actions will add a resource to an Oracle Restart configuration?
- A. creating a database service using Oracle Database Configuration Assistant (DBCA)
- B. creating a database using the CREATE DATABASE SQL statement
- C. creating a disk group using the CREATE DISKGROUP SQL statement
- D. creating a database service using DBMS_SERVICE.CREATE_SERVICE
- E. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)
- F. creating an Oracle Database service by modifying the SERVICE_NAMES parameter
Answer: A,C,E
NEW QUESTION 170
Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)
- A. It can only be launched from the command line interface.
- B. It can be launched from both the command line and the Universal Installer (OUI) interfaces.
- C. It can be used to create container databases and non-container databases.
- D. It can be used to change the character set of an existing database.
- E. It can be used to convert a non-container database to a container database.
Answer: A,D
NEW QUESTION 171
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)
- A. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
- B. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
- C. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
- D. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
- E. The Oracle Grid Infrastructure installation must be owned by the grid user.
- F. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
Answer: A,C
NEW QUESTION 172
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
- A. It increases tablespace size, if required, to meet upgrade requirements.
- B. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
- C. It recompiles all stored PL/SQL code by using utlrp.sql.
- D. It empties the RECYCLE BIN.
- E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
- F. It sets all user tablespaces to "read-only" before starting the upgrade.
Answer: A,B,C
NEW QUESTION 173
......
What is Oracle Database Administration II Exam Number: 1Z0-083 Certification Exam and Retake policy
Oracle Cloud Certification credentials are only valid for a period of 18 months from the date you earn the credential. The certification will become inactive at the end of 18 months. However, for Oracle candidates, it is necessary to hold an active certification in order to have access to various certification benefits including, using Oracle certification logos, certificates, scoring reports, digital badges, and certification verification.
To stay current, candidates have to re-certify themselves with the latest version of the exam. Oracle Cloud Certifications include various titles with levels that are Oracle Certified Associate, Specialist, and Professional. Moreover, the Oracle Cloud Certifications are updated continuously throughout the year for keeping current with major product and service releases and re-released on an annual basis with a new title.
Ace Oracle 1Z0-083 Certification with Actual Questions Aug 02, 2022 Updated: https://gocertify.actual4labs.com/Oracle/1Z0-083-actual-exam-dumps.html