Quality 1Z1-083 PDF Dumps - 1Z1-083 Exam Questions [Q10-Q28]

Share

Quality 1Z1-083 PDF Dumps - 1Z1-083 Exam Questions

Most UptoDate Oracle 1Z1-083 Exam Dumps PDF 2023

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

  • A. It is not possible for media corrupt blocks.
  • B. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
  • C. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
  • 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 that physical standby database.

Answer: A,C


NEW QUESTION # 11
Which three actions will add a resource to an Oracle Restart configuration? (Choose three.)

  • A. creating a database service using Oracle Database Configuration Assistant (DBCA)
  • B. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)
  • C. creating an Oracle Database service by modifying the SERVICE_NAMES parameter
  • D. creating a disk group using the CREATE DISKGROUP SQL statement
  • E. creating a database using the CREATE DATABASE SQL statement
  • F. creating a database service using DBMS_SERVICE.CREATE_SERVICE

Answer: A,E,F


NEW QUESTION # 12
Which two are true about server-generated alerts? (Choose two.)

  • A. Stateless alerts can be cleared manually.
  • B. Stateful alerts must be created by a DBA after resolving the problem.
  • C. Stateless alerts are automatically cleared.
  • D. Stateful alerts are purged automatically from the alert history.
  • E. Stateless alerts can be purged manually from the alert history.

Answer: A,E

Explanation:
Except for the tablespace space usage metric, which is database related, the other metrics are instance related. Threshold alerts are also referred to as stateful alerts which are automatically cleared when an alert condition clears. Stateful alert appears in DBA_OUTSTANDING_ALERTS and when cleared go to DBA_ALERT_HISTORY. Other server-generated alerts correspond to specific database events such as ORA-* errors, "Snapshot too old" errors, Recovery Area Low on Free Space, Resumable Session Suspended. These are non threshold based alerts, also referred to as stateless alerts. Stateless alerts go directly to the History table. +++ Most alerts (such as "Out of Space") are cleared automatically when the cause of the problem disappears. However, other alerts (such as generic alert log errors) are sent to you for notification and must be acknowledged by you. After taking the corrective measures, you acknowledge an alert by clearing or purging it. Clearing an alert sends the alert to the Alert History which is accessible from Monitoring sub menu. Purging an alert removes it from the Alert History.
Reference:
https://jameshuangsj.wordpress.com/2019/12/01/clears-stateless-alerts-in-oem-by-using-emcli/


NEW QUESTION # 13
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 must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.
  • B. The target PDB must be registered in a Virtual Private Catalog.
  • C. The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
  • D. The base catalog must be enabled for Virtual Private Catalog use.
  • E. The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.
  • F. The target PDB must be registered in a base catalog.

Answer: A,D,E


NEW QUESTION # 14
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)

  • A. Data file 24 can be recovered while connected to PDB2.
  • B. Data file 24 can be recovered while connected to CDB$ROOT.
  • C. Data file 24 can be restored and recovered while connected to CDB$ROOT.
  • D. Data file 24 can be restored only while connected toCDB$ROOT.
  • E. Data file 24 can be restored only while connected to PDB2.
  • F. Data file 24 can be recovered only while connected to PDB2.

Answer: B,C,E


NEW QUESTION # 15
Which three are true about performing an Oracle Database install on Linux? (Choose three.)

  • A. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group
  • B. It can be done before installing Grid Infrastructure for a Standalone Server
  • C. The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.
  • D. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group
  • E. It allows you to select the languages supported by the Oracle database server.
  • F. The runfixup.sh script can install missing RPMs.
  • G. It can be done after installing Grid Infrastructure for a Standalone Server.

Answer: B,D,G


NEW QUESTION # 16
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 snapshot copy PDB can be created from a stand-alone clone PDB.
  • C. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
  • D. A PDB snapshot is always a sparse copy of the source PDB.
  • E. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
  • F. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
  • G. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

Answer: A,G

Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-pdb- snapshots.html#GUID-35B03C37-00BA-4945-BF20-9A7C4C541955


NEW QUESTION # 17
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? (Choose two.)

  • A. Backups can be taken only if the database is in ARCHIVE LOG mode.
  • B. Backups must be contained in backup sets.
  • C. Backups can be done incrementally.
  • D. The database must be registered in an RMAN catalog.
  • E. Backups must be done incrementally.
  • F. Only consistent backups can be created.

Answer: A,C


NEW QUESTION # 18
Which two are prerequisites for performing Flashback Transaction?

  • A. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
  • B. A supplemental log must be enabled for the primary key.
  • C. Fast Recovery Area must be enabled for the database
  • D. A supplemental log must be enabled for the primary key.
  • E. Undo retention guarantee must be configured for the database.

Answer: A,B


NEW QUESTION # 19
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 back to the previous Oracle home as part of a rollback operation
  • B. to switch to a patched Oracle Database home
  • C. to switch to a read-only Oracle home
  • D. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
  • E. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server

Answer: A,B

Explanation:
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.


NEW QUESTION # 20
Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?

  • A. when a resumable statement is suspended
  • B. when free space in a dictionary managed tablespace falls below a specified percentage
  • C. when the total number of logons exceeds a specific value
  • D. when the total number of locked user account exceeds a specific value
  • E. when free space in a locally managed tablespace falls below a specified percentage
  • F. when the number of logons per second exceeds a specific value

Answer: D,E,F


NEW QUESTION # 21
Choose two. Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?

  • A. Space is only reclaimed when there is space pressure in the Fast Recovery Area (FRA).
  • B. Space might be reclaimed proactively before space pressure occurs.
  • C. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
  • D. Space is always reclaimed proactively before space pressure occurs.
  • E. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

Answer: A,B


NEW QUESTION # 22
A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)

  • A. when any archived log from, before, or after the most recent backup is corrupt.
  • B. after losing the SYSTEM tablespace
  • C. after losing all copies of the control file
  • D. after losing an archived log from before the most recent backup
  • E. after losing an archived log from after the most recent backup

Answer: A,D


NEW QUESTION # 23
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

  • A. A connection to the recovery catalog instance is always required.
  • B. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
  • C. A connection to the target database instance is always required.
  • D. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.
  • E. A connection to an auxiliary instance is always required.
  • F. A subset of the target database can be duplicated.
  • G. A backup of the target database is always required.
  • H. A new DBID is always created for the duplicated database.

Answer: B,D,E,F


NEW QUESTION # 24
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

  • A. AWR snapshots must be deleted when no longer required by ADDM.
  • B. By default, AWR snapshots are automatically purged after eight days.
  • C. ADDM can recommend shrinking the buffer cache.
  • D. ADDM performs its analysis only when a DBA requests it.
  • E. By default, MMON creates an AWR snapshot every 30 minutes.
  • F. ADDM can recommend extending the buffer cache.

Answer: B,C,F


NEW QUESTION # 25
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN -----------------------2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?

  • A. CDB1_TAB and APP_ROOT_TAB
  • B. none of the tables, because all three tables will be dropped
  • C. CDB1_TAB and APP_PDB1_TAB
  • D. CDB1_TAB only
  • E. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

Answer: C


NEW QUESTION # 26
Which three are true about upgrading Oracle Grid Infrastructure?

  • A. Existing Oracle Database instances must be shut down before starting the upgrade.
  • B. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
  • C. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
  • D. Only the grid user can perform the upgrade.
  • E. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
  • F. An existing Oracle base can be used.

Answer: A,B,E


NEW QUESTION # 27
Choose two. Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area?

  • A. the archived log deletion policy
  • B. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
  • C. the backup retention policy
  • D. the DB_RECOVERY_FILE_DEST parameter setting
  • E. the backup optimization policy
  • F. using guaranteed UNDO retention

Answer: A,C


NEW QUESTION # 28
......


Oracle 1Z1-083 (Oracle Database Administration II) Certification Exam is designed to test the knowledge and skills of database administrators who are responsible for managing and maintaining Oracle databases. 1Z1-083 exam is intended for professionals who have experience working with Oracle databases and are looking to advance their career by becoming certified in database administration. 1Z1-083 exam covers a wide range of topics related to database administration, including database architecture, performance tuning, backup and recovery, security, and troubleshooting.

 

100% Free Oracle Database 19c 1Z1-083 Dumps PDF Demo Cert Guide Cover: https://www.actualcollection.com/1Z1-083-exam-questions.html