[Feb-2024] Check your preparation for Oracle 1Z0-083 On-Demand Exam
Practice Exam 1Z0-083 Realistic Dumps Verified Questions
NEW QUESTION # 131
You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)
- A. Flashback logs are maintained in redo log files.
- B. Flashback logs are not archived.
- C. Flashback logs are used to maintain Flashback Database related errors.
- D. Flashback logs are maintained in the Flash Recovery Area.
- E. Flashback logs need to be cleared manually after you disable Flashback Database.
Answer: B,D
NEW QUESTION # 132
Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?
- A. The Oracle Application Express configuration should be updated after upgrading Oracle Database.
- B. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.
- C. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.
- D. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.
- E. The new extended data type capability must be enabled by running the utlrp.sql script
Answer: A,C,E
NEW QUESTION # 133
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?
- A. Decreasing PCTUSED
- B. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation
- C. Increasing the number of DBWN process
- D. Decreasing PCTFREE
- E. Using Automatic Segment Space Management (ASSM)
Answer: E
NEW QUESTION # 134
Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)
- A. A DBA can run it manually.
- B. It analyzes a period of time corresponding to the 12 hours of activity.
- C. It runs automatically after each AWR snapshot.
- D. It analyzes a period of time corresponding to the last day of activity.
- E. Results are written to the alert log.
Answer: A,C
NEW QUESTION # 135
Choose two. When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?
- A. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
- B. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
- C. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.F
- D. 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.
- E. If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.
Answer: B,D,E
NEW QUESTION # 136
choose two Which two are true about RMAN image copies?
- A. They can be used as a level 1 incremental backup.
- B. They can only be written to disk.
- C. They can be encrypted using Transparent Data Encryption (TDE).
- D. They are the only backup option available for databases in NOARCHIVELOG mode.
- E. They can be used as a level 0 incremental backup.
Answer: B,E
NEW QUESTION # 137
Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE; What is a prerequisite for the successful execution of this command
- A. RMAN must be connected to the target database instance and the auxiliary instance.
- B. The target database must be in MOUNT state.
- C. Flashback must be enabled for the PROD database.
- D. A most recent backup set of the PROD database must exist.
Answer: A
NEW QUESTION # 138
Examine this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are pluggable databases in CDB1.
* PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. CDB1 is in MOUNT state
- B. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
- C. PDB1 is closed.
- D. Uncommitted transactions in PDB1 have been rolled back.
- E. CDB1 is shut down.
Answer: C,D
NEW QUESTION # 139
Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?
- A. The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.
- B. The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
- C. The target PDB must be registered in a base catalog.
- D. The target PDB must be registered in a Virtual Private Catalog.
- E. The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.
- F. The base catalog must be enabled for Virtual Private Catalog use.
Answer: A,E,F
NEW QUESTION # 140
Examine these queries and their output:
After a system crash, an instance restart and an attempted opening of the PDBs result in:
Which two are true?
- A. Data file 24 must be recovered while PDB2 is closed.
- B. Data file 24 must be recovered while the CDB is opened.
- C. Data file 24 cannot be recovered while the CDB is opened.
- D. Data file 24 can be recovered while PDB2 is opened.
- E. Data file 24 can be recovered while CDB$ROOTand PDB$SEED are opened.
Answer: B,D
NEW QUESTION # 141
our SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: Which two are true? (Choose two.)
- A. A container map exists for the REVENUE table, but is not enabled.
- B. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
- C. The REVENUE table partitions are not pruned across the PDBs automatically.
- D. The REVENUE table must be a list-partitioned table.
- E. The CONTAINERS clause cannot be used in queries on the REVENUE table.
- F. The MAPTABLE table is a metadata-linked table.
Answer: B,C
NEW QUESTION # 142
Which three are true about Oracle Grid Infrastructure for a Standalone Server?
- A. Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.
- B. It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.
- C. It creates one disk group during installation.
- D. It requires the operating system oracle_base environment variable to be predefined before installation.
- E. It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks
- F. It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.
Answer: C,E,F
NEW QUESTION # 143
Which two are true in Oracle 19c and later releases?
- A. Schema Only accounts can be granted administrator privileges.
- B. All the Oracle-supplied accounts are Schema Only accounts.
- C. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
- D. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
- E. If the password file location changes, then the new location is used automatically by the Oracle Server.
Answer: A,E
NEW QUESTION # 144
Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment?
- A. defining primary keys for all tables to speed up all queries
- B. defining foreign keys for all tables to speed up joins
- C. the configuration of storage arrays
- D. using check constraints to speed up updates
- E. the physical data model
Answer: B,C
NEW QUESTION # 145
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
- A. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
- B. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
- C. After the change, only one undo tablespace can exist in CDB$ROOT.
- D. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
- E. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
- F. Undo tablespaces existing in PDBs must be dropped before the change.
Answer: A,D
NEW QUESTION # 146
Choose the best answer. Which operating system group is NOT needed to perform an Oracle Database installation?
- A. OSKMDBA
- B. OSASM
- C. OSOPER
- D. OSDBA
- E. OSRACDBA
Answer: E
NEW QUESTION # 147
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. Schema Only accounts can be granted administrator privileges.
- B. If the password file location changes, then the new location is used automatically by the Oracle Server.
- C. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
- D. All the Oracle-supplied accounts are Schema Only accounts.
- E. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
- F. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
Answer: A,D,F
NEW QUESTION # 148
Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)
- A. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
- B. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
- C. Tablespaces are automatically created as need while importing full exports in either a non-CDB or a PDB.
- D. A new PDB is automatically created when importing a non-CDB into a CDB.
- E. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
- F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
Answer: A,B
NEW QUESTION # 149
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
- A. relocating a remote pluggable database in interactive mode
- B. relocating a remote pluggable database in silent mode
- C. cloning a remote pluggable database in silent mode
- D. relocating aremote container database in interactive mode
- E. relocating a remote container database in silent mode
- F. cloning a remote container database in silent mode
- G. cloning a remote container database in interactive mode
Answer: A,B,F
NEW QUESTION # 150
Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?
- A. It requires the use of fast recovery area (FRA).
- B. The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.
- C. The control file is backed up automatically each time the SPFILE is backed up manually.
- D. The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.
- E. The control file is backed up whenever a new table is created.
- F. The control file is backed up whenever a new tablespace is created.
Answer: B,C,F
NEW QUESTION # 151
Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)
- A. to switch to a patched Oracle Database home
- B. to switch to a read-only Oracle home
- C. to switch back to the previous Oracle home as part of a rollback operation
- D. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
- E. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
Answer: A,C
Explanation:
You can use rhpctl move gihome command with the same syntax to switch from the current Oracle Grid Infrastructure home to a patched home. The rhpctl command enables you to switch from your current Oracle Grid Infrastructure or Oracle Database home to patched Oracle home so that you can provision the new Oracle home as gold image. You can also use the rhpctl command to switch back to the old Oracle home, if you want to roll back the operation.
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/18/cwadd/rapid-home- provisioning.html#GUID-856C7378-2510-4B3E-8BE1-B4D79DF4FE8B
NEW QUESTION # 152
......
Valid 1Z0-083 Dumps for Helping Passing Oracle Exam: https://www.actual4exams.com/1Z0-083-valid-dump.html
Download Free Oracle 1Z0-083 Exam Questions & Answer: https://drive.google.com/open?id=1DF1HOoVviHjnVZvMBYXikIvFaAArMFe_