Get 100% Passing Success With True 1Z0-083 Exam! [Jun-2024]
Oracle 1Z0-083 PDF Questions - Exceptional Practice To Oracle Database Administration II
NEW QUESTION # 120
Which two are true about server-generated alerts? (Choose two.)
- A. Stateless alerts can be purged manually from the alert history.
- B. Stateful alerts are purged automatically from the alert history.
- C. Stateless alerts can be cleared manually.
- D. Stateful alerts must be created by a DBA after resolving the problem.
- E. Stateless alerts are automatically cleared.
Answer: C,D
Explanation:
Explanation/Reference: https://jameshuangsj.wordpress.com/2019/12/01/clears-stateless-alerts-in-oem-by-using-emcli/
NEW QUESTION # 121
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. A transportable data pump import can leave a plugged-in tablespace in read-only mode.
- B. Tablespaces never remain in read/write mode during transportable tablespace operations.
- C. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.
- D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
- E. A transportable data pump import can leave a plugged-in tablespace in read/write mode.
- F. Tablespaces always remain in read/write mode during transportable tablespace operations.
Answer: D,E,F
NEW QUESTION # 122
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. Undo tablespaces existing in PDBs must be dropped before the change.
- F. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
Answer: B,D
NEW QUESTION # 123
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?
- A. Settingthetargettablespacetoread-only
- B. Setting the target tablespace offline
- C. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
- D. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct
- E. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
Answer: A,E
NEW QUESTION # 124
Choose four. Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?
- A. It can be used to recover a truncated table.
- B. It can be performed using an auxiliary instance managed by a DBA.
- C. 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.
- 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: A,D
Explanation:
tablespace.
NEW QUESTION # 125
Choose two. Which two statements are true when row-archival management is enabled?
- A. The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the column select list of a query
- B. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job based on activity tracking.
- C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.
- D. The ORA_ARCHIVE_STATE column may only be queried by users with the DBA role set.
- E. The ORA_ARCHIVE_STATE column may only be updated by users with the DBA role set.
Answer: A,C
NEW QUESTION # 126
On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days.
Level 0 backups are taken on the 10th, 17th, and 24th of August.
Differential level 1 incremental backups are taken daily between the level 0 backups.
Today is the 26th of August.
Which backups will be obsolete?
- A. all backups prior to 10th of August
- B. all backups prior to 22nd of August
- C. all backups prior to 20th of August
- D. all backups prior to 17th of August
- E. all backups prior to 24th of August
Answer: E
NEW QUESTION # 127
Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?
- A. 2,4,5
- B. 1,2,4,5
- C. 2,4,5,6
- D. 1,2,3,4,5,6
- E. 1,3,4,5
Answer: A
NEW QUESTION # 128
A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?
- A. V$SESSTAT
- B. V$SESSION_WAIT_CLASS
- C. V$SESSION_WAIT
- D. V$SESSION
- E. V$SESSION_EVENT
Answer: E
NEW QUESTION # 129
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. cloning a remote pluggable database in silent mode
- C. relocating a remote pluggable database in silent mode
- D. relocating a remote container database in silent mode
- E. cloning a remote container database in interactive mode
- F. cloning a remote container database in silent mode
- G. relocating a remote pluggable database in interactive mode
Answer: C,F,G
NEW QUESTION # 130
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)
- A. It predicts the impact of system changes on SQL workload response time.
- B. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
- C. It provides before and after execution statistics for each SQL statement in the analysis task
- D. SQL statements that were originally run concurrently are run concurrently by SPA.
- E. It is integrated with the SQL Access Advisor.
Answer: A,C
Explanation:
SQL Performance Analyzer measures the impact of system changes both on the overall execution time of the SQL workload and on the response time of every individual SQL statement in the workload. By default, SQL Performance Analyzer uses elapsed time as a metric for comparison.
NEW QUESTION # 131
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?
- A. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
- B. by running ADDM in diagnostic mode
- C. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
- D. by using Active Session History (ASH) data and performing hang analysis
Answer: C
NEW QUESTION # 132
Choose three. Which three are true about Recovery Manager (RMAN) active database duplication?
- A. No connection to the recovery catalog is required for active database duplication.
- B. Pre-existing backups of the database to be duplicated are always used if they exist.
- C. Image copies can be used to duplicate the active database.
- D. Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.
- E. Backup sets can be used to duplicate the active database.
- F. Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.
- G. The active database must be duplicated while in OPEN state.
Answer: A,C,E
NEW QUESTION # 133
Choose two. Which two are true about Oracle Database Configuration Assistant (DBCA)?
- A. It can be used to create container databases and non-container databases.
- B. It can be used to change the character set of an existing database.
- C. It can only be launched from the command line interface.
- D. It can be used to convert a non-container database to a container database.
- E. It can be launched from both the command line and the Universal Installer (OUI) interfaces.
Answer: A,E
NEW QUESTION # 134
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. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
- E. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
- F. The Oracle Grid Infrastructure installation must be owned by the grid user.
Answer: B,D
NEW QUESTION # 135
Automatic Shared Memory Management is disabled for one of your database instances.
SomeSQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?
- A. Run the Memory Advisor for the shared pool.
- B. Run the SQL Tunning Advisor.
- C. Run theMemory Advisor for the Program Global Area.
- D. Run the Memory Advisor for the System Global Area.
- E. Run the SQL Access Advisor.
Answer: A
NEW QUESTION # 136
RMAN has just been connected to a target database and the recovery catalog database.
In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog? (Choose two.)
- A. when a new tablespace is added to a registered target database
- B. when the target is first registered
- C. when a backup of the current control file is created
- D. when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
- E. when control file metadata for archive log backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
Answer: C,D
NEW QUESTION # 137
Which two are true about Oracle Flashback features? (Choose two.)
- A. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
- B. After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.
- C. FLASHBACK TABLE can undrop a column.
- D. FLASHBACK DROP can undrop an index when undropping a table.
- E. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
Answer: A,E
NEW QUESTION # 138
......
1Z0-083 dumps - Free4Torrent - 100% Passing Guarantee: https://pass4sures.free4torrent.com/1Z0-083-valid-dumps-torrent.html