Verified 1Z0-083 dumps Q&As - 2024 Latest 1Z0-083 Download
Dumps Questions [2024] Pass for 1Z0-083 Exam
NEW QUESTION # 58
A database is configured in ARCHIVELOG mode.
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 an UNDO tablespace that is in use
- B. after losing all members of an INACTIVE online redo log group
- C. after losing a SYSAUX tablespace data file
- D. after losing all members of the CURRENT online redo log group
- E. after losing all copies of the control file
Answer: D,E
NEW QUESTION # 59
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?
- A. Reduced physical I/O
- B. Reduced virtual memory utilization
- C. Improved Serial Execution performance
- D. Reduced CPU utilization
- E. Reduced logical I/O
Answer: B,D
NEW QUESTION # 60
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 read I/O is a likely bottleneck.F
- B. If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.
- C. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
- D. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
- E. 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.
Answer: B,D,E
NEW QUESTION # 61
Choose two. Which two are true about memory advisors?
- A. If Automatic Memory Management is enabled, no memory advisors are available.
- B. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
- C. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.
- D. All memory advisors use data from Automatic Workload Repository.
- E. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
Answer: B,D
NEW QUESTION # 62
Choose two. Which two are true about Oracle Database Configuration Assistant (DBCA)?
- A. It can be launched from both the command line and the Universal Installer (OUI) interfaces.
- B. It can be used to create container databases and non-container databases.
- C. It can be used to change the character set of an existing database.
- D. It can be used to convert a non-container database to a container database.
- E. It can only be launched from the command line interface.
Answer: A,B
NEW QUESTION # 63
You plan to perform cross-platform PDB transport using XTTS.
Which two are true? (Choose two.)
- A. The source and target platforms must have the same endianness.
- B. The source PDB must not be an application root.
- C. The source PDB must be in MOUNT state.
- D. Automatic conversion of endianness occurs.
- E. A backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause.
- F. The source PDB can be in MOUNT or OPEN state.
Answer: A,F
NEW QUESTION # 64
Choose three. Which three are true about the FLASHBACK DATABASE feature?
- A. It always generates REDO and UNDO.
- B. A database can be flashed back using SQL*PLUS.
- C. FLASHBACK LOGS are archived after a log switch.
- D. FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
- E. It requires that the target database be in ARCHIVELOG mode.
- F. Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
Answer: A,B,E
NEW QUESTION # 65
Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 container database (CDB). 2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1. After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $ export ORACLE_SID=cdb1 $ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------------------------------------------------------------2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?
- A. It fails because PDB$SEED is in MIGRATE state.
- B. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
- C. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
- D. It fails because PDB2 is not in UPGRADE state.
- E. Only CDB$ROOT and PDB$SEED are upgraded.
- F. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
Answer: B
NEW QUESTION # 66
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
- A. relocating aremote container database in interactive mode
- B. relocating a remote container database in silent mode
- C. cloning a remote pluggable database in silent mode
- D. cloning a remote container database in silent mode
- E. relocating a remote pluggable database in interactive mode
- F. relocating a remote pluggable database in silent mode
- G. cloning a remote container database in interactive mode
Answer: D,E,F
NEW QUESTION # 67
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)
- A. The Statistics Advisor can help recommend the best way to gather statistics.
- B. Index balanced B*Tree height is considered when evaluating the cost of using an index.
- C. The Statistics Advisor generates actions for all recommendations.
- D. Statistics collected using DBMS_STATS always yield the best optimizer result.
- E. The number of table rows is considered when evaluating the cost of accessing a table using an index.
Answer: A,D
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statistics- advisor.html#GUID-D81A7708-FDA0-45BB-A6E2-103858B047AE
NEW QUESTION # 68
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:
Which table or set of tables will exist after the Flashback operation has completed?
- A. CDB1_TAB and APP_PDB1_TAB
- B. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
- C. CDB1_TAB and APP_ROOT_TAB
- D. none of the tables, because all three tables will be dropped
- E. CDB1_TAB only
Answer: B
NEW QUESTION # 69
The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3.
Which three are true? (Choose three.)
- A. PDB3's application root replica must exist in the local CDB.
- B. A proxy PDB must exist in the application root in the remote CDB.
- C. The HR_ROOT replica must exist in the remote CDB.
- D. A proxy PDB must exist in the application root in the local CDB.
- E. A database link must exist in the local CDB root referring to the remote CDB.
- F. A database link must exist in the remote CDB referring to the local CDB.
Answer: C,D,F
NEW QUESTION # 70
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. Privilege Analysisisincluded in Oracle Enterprise Edition and no longer requires Database Vault. E) Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
- B. All the Oracle-supplied accounts are Schema Only accounts.
- C. Schema Only accounts can be granted administrator privileges.
- 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,C
NEW QUESTION # 71
Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)
- A. It can be used to patch existing Oracle software installations.
- B. It can be used to deploy new homes without disrupting active databases.
- C. It can be used to create templates of Oracle homes as gold images of only Oracle databases.
- D. It can be used only on nodes with Oracle Grid Infrastructure installed.
- E. It can be used to upgrade only single-instance databases running on Oracle Restart.
- F. It can be used to create a single-instance Oracle Database in an already-installed Oracle home.
Answer: A,C,D
NEW QUESTION # 72
Choose the best answer. Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?
- A. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
- B. It is a set of recommendations by the optimizer to change the access methods used.
- C. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
- D. It is a set of recommendations by the optimizer to create new indexes.
- E. It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.
Answer: A
NEW QUESTION # 73
Examine this configuration:
1. CDB1is a container database.
2. PDB1 and PDB2are pluggable databases in CDB1.
3. PDB1 and PDB2are OPENin READ WRITEmode.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. Uncommitted transactions in CDB1and PDB1have been rolled back.
- B. Uncommitted transactions in PDB1have been rolled back.
- C. CDB1is in MOUNT state
- D. PDB1is closed.
- E. CDB1is shut down.
Answer: C,D
NEW QUESTION # 74
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 restored only 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 to PDB2.
- E. Data file 24 can be recovered while connected to CDB$ROOT.
- F. Data file 24 can be recovered only while connected to PDB2.
Answer: B,C,E
NEW QUESTION # 75
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
- A. Databases can be transported between systems with different endian formats.
- B. A new DBID is automatically created for the transported database.
- C. Data files can be converted on the source system.
- D. The password file is automatically converted by RMAN.
- E. Data files can be converted on the destination system.
- F. By default, the transported database will use Oracle Managed Files (OMF)
Answer: A,C,D
Explanation:
Explanation
Password file is automatically converted by RMAN.
NEW QUESTION # 76
Which two are true about flashback features in Oracle Database 19c and later releases?
- A. Flashback logs are monitored for being older than the retention period defined in db_flashback_retention_target and can be deleted by an administrator written event trigger.
- B. Flashback logs are monitored and proactively deleted when beyond the retention period definedin DB_flashback_retention_TARGET only after there is space pressure
- C. Flashback logs are automatically purged when db_flashback_retention_target is set lower than the time they have already been retained.
- D. Flashback logs are monitored and proactively deleted when beyond the retention period definedin db_flashback_retention_target before there is space pressure.
- E. Flashback logs are automatically purged whenever the value Of DB_FLASHBACK_RETENTION_TARGET is changed.
Answer: A,D
NEW QUESTION # 77
Which two are true about automatic block repair?
- A. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
- B. It is not possible for media corrupt blocks.
- C. Automatic block repair can repair blocks with no standby database if db_block_checking = TRUE.
- D. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
- E. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
Answer: A,B
NEW QUESTION # 78
Choose two. Which two are true about unplugging an application container from a container database and plugging it into a different container database?
- A. It requires only local UNDO mode in the database where the application container will be unplugged.
- B. It requires local UNDO mode in both container databases.
- C. The application root of an application container should be plugged into the other CDB before its application PDBs are plugged in.
- D. Plugging the application root into a different CDB plugs in all its application PDBs.
- E. Application PDBs in the application container must be unplugged before the application root is unplugged.
- F. Unplugging the application root from a CDB unplugs all its application PDBs.
Answer: C,E
NEW QUESTION # 79
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement is true about the result of this command?
- A. The statement is ignored because there is no SPFILE for a PDB.
- B. The statistics_level parameter is set to all when the root database is restarted.
- C. The statistics_level parameter is set to all only for PDB2 when it is reopened.
- D. The statistics_level parameter is set to all when any of the PDBs is reopened.
Answer: C
NEW QUESTION # 80
Choose three. Which three activities are possible for PDBs?
- A. copying an application container into another application container in the same CDB
- B. converting an application seed to an application PDB
- C. converting an application PDB to an application seed G) converting an application PDB to a regular PDB
- D. converting a regular PDB to an application PDB
- E. converting an application PDB to an application root
- F. copying an application container into another application container in a different CDB
Answer: B,C,F
NEW QUESTION # 81
In which two situations can you use Database Upgrade Assistant? (Choose two.)
- A. when the operating system (OS) needs to be changed as part of the upgrade
- B. when a character set conversion is required during the upgrade
- C. when multiple pluggable databases in a container database have to be upgraded in a specific sequence
- D. when the hardware platform needs to be changed as part of the upgrade
- E. when the target and source database are on the same platform
Answer: C,E
NEW QUESTION # 82
......
Updated Oracle Study Guide 1Z0-083 Dumps Questions: https://prep4sure.examtorrent.com/1Z0-083-exam-papers.html
