1Z0-083 Training & Certification Get Latest Oracle Database 19c Updated on Sep 05, 2021
Certification Training for 1Z0-083 Exam Dumps Test Engine
NEW QUESTION 65
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 the CDB is opened.
- B. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are 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 must be recovered while PDB2 is closed.
Answer: B,D
NEW QUESTION 66
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 container database in interactive mode
- C. cloning a remote container database in interactive mode
- D. cloning a remote container database in silent mode
- E. cloning a remote pluggable database in silent mode
- F. relocating a remote container database in silent mode
- G. relocating a remote pluggable database in silent mode
Answer: A,D,G
NEW QUESTION 67
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?
- A. Data file 24 can be restored only while connected to CDB$ROOT.
- B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
- C. Data file 24 can be recovered only while connected to PDB2.
- D. Data file 24 can be restored only while connected to PDB2.
- E. Data file 24 can be recovered while connected to PDB2.
- F. Data file 24 can be recovered while connected to CDB$ROOT.
Answer: A,C,E
NEW QUESTION 68
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 ARCHIVELOG 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. 1, 3, 4, 5
- B. 1, 2, 3, 4, 5, 6
- C. 2, 4, 5, 6
- D. 1, 2, 4, 5
- E. 2, 4, 5
Answer: E
NEW QUESTION 69
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)
- A. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
- B. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
- C. The Oracle Grid Infrastructure installation must be owned by the grid user.
- D. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
- E. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
- F. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
Answer: D,F
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/CWWIN/usrgrps.htm#CWWIN-GUID-6FD3C6AE-5A99-
4C6D-85D6-868CBA6F5DAE
NEW QUESTION 70
Which three are true about monitoring waits for sessions and services? (Choose three.)
- A. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
- B. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
- C. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
- D. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
- E. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
- F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
Answer: B,D,E
NEW QUESTION 71
Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)
- A. They are generated if STATISTICS_LEVEL is set to BASIC.
- B. They are generated if STATISTICS_LEVEL is set to TYPICAL.
- C. They are always created automatically.
- D. They are always created manually.
- E. They are generated if STATISTICS_LEVEL is set to ALL.
- F. They can be retained forever.
Answer: A,B,C
NEW QUESTION 72
Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?
- A. Run the SQL Tunning Advisor.
- B. Run the SQL Access Advisor.
- C. Run the Memory Advisor for the shared pool.
- D. Run the Memory Advisor for the Program Global Area.
- E. Run the Memory Advisor for the System Global Area.
Answer: C
NEW QUESTION 73
Which four are true about RMAN backup sets?
- A. A data file can be split into multiple sections stored in different backup pieces in the same backup set.
- B. Blocks from multiple data files can be contained in one backup set.
- C. A backup piece can belong to only one backup set.
- D. A backup set can contain only one backup piece.
- E. A backup set must be written to disk.
- F. Blocks from multiple data files can be contained in one backup piece.
- G. A data file can be split into multiple sections stored in different backup sets.
- H. A backup set must be written to media.
Answer: A,E,F,G
NEW QUESTION 74
Which three actions are performed by Database Upgrade Assistant (DBUA)?
- A. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
- B. It empties the recycle bin.
- C. It Increases tablespace size, if required, to meet upgrade requirements.
- D. It recompiles all stored pl/sql code by using utlrp.sql.
- 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: B,E,F
NEW QUESTION 75
Which two are true about Oracle instance recovery? (Choose three.)
- A. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
- B. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
- C. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
- D. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
- E. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
- F. Recovery begins from the beginning of the CURRENT redo log group.
Answer: A,D,E
NEW QUESTION 76
Which two are true about the Oracle dataabse methodology? (Choose two.)
- A. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
- B. Tuning activities should stop once the user is satisfied with performance.
- C. The database instance memory should always be tuned before tuning any file systems.
- D. Tuning activities should stop once agreed service levels for performance have been met.
- E. SQL statements should always be tuned before tuning any file systems.
- F. The alert log should be used to find the database and instance areas most in need of tuning.
Answer: D,F
Explanation:
Reference:
https://flylib.com/books/en/4.322.1.9/1/
NEW QUESTION 77
Which two are true about RMAN encryption? (Choose two.)
- A. RMAN can encrypt the Oracle Database password file.
- B. RMAN encryption keys are stored in a database keystore.
- C. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.
- D. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
- E. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.
Answer: C,D
Explanation:
Reference:
https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#BRADV89476
NEW QUESTION 78
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 READ ONLY state.
- B. PDB1 and PDB2 are in MOUNT 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 79
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
- A. ADDM can recommend extending the buffer cache.
- B. AWR snapshots must be deleted when no longer required by ADDM.
- C. ADDM performs its analysis only when a DBA requests it.
- D. ADDM can recommend shrinking the buffer cache.
- E. By default, MMON creates an AWR snapshot every 30 minutes.
- F. By default, AWR snapshots are automatically purged after eight days.
Answer: A,D,F
NEW QUESTION 80
Which two are true about server-generated alerts? (Choose two.)
- A. Stateful alerts must be created by a DBA after resolving the problem.
- B. Stateless alerts can be cleared manually.
- C. Stateful alerts are purged automatically from the alert history.
- D. Stateless alerts can be purged manually from the alert history.
- E. Stateless alerts are automatically cleared.
Answer: B,D
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 81
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. CDB1is shut down.
- B. Uncommitted transactions in PDB1have been rolled back.
- C. CDB1is in MOUNT state
- D. Uncommitted transactions in CDB1and PDB1have been rolled back.
- E. PDB1is closed.
Answer: C,E
NEW QUESTION 82
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
- A. Data files can be converted on the destination system.
- B. The password file is automatically converted by RMAN.
- C. By default, the transported database will use Oracle Managed Files (OMF)
- D. Databases can be transported between systems with different endian formats.
- E. A new DBID is automatically created for the transported database.
- F. Data files can be converted on the source system.
Answer: A,D,F
Explanation:
Password file is automatically converted by RMAN.
NEW QUESTION 83
Which three are true In Oracle 19c and later releases?
- A. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.
- B. Tablespaces always remain In read/write mode during transportable tablespace operations.
- C. A transportable data pump import can leave a plugged-in tablespace in read-only mode.
- D. Tablespaces never remain In read/write mode during transportable tablespace operations.
- E. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
- F. A transportable data pump import can leave a plugged-in tablespace In read/write mode.
Answer: B,C,E
NEW QUESTION 84
Which three are true about an application seed pluggable database (PDB)?
- A. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
- B. It is not required in an application container.
- C. A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
- D. It cannot be added to an application container after the application container has already been created.
- E. It is automatically synchronized with its application root PDB when an application is installed.
- F. It Is automatically synchronized with its application root PDB when an application is upgraded.
- G. It cannot be dropped from its application container.
Answer: A,C,D,E
NEW QUESTION 85
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. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
- B. Uncommitted transactions in PDB1 have been rolled back.
- C. CDB1 is shut down.
- D. PDB1 is closed.
- E. CDB1 is in MOUNT state
Answer: B,D
NEW QUESTION 86
Which two are true about RMAN Multisection backups when a very large data file is divided into four sections?
(Choose two.)
- A. The four sections must be image copies.
- B. The four sections can be created serially.
- C. The four sections must be contained in backup sets.
- D. The four sections can be created in parallel.
- E. Each of the file sections must be processed serially.
Answer: C,D
NEW QUESTION 87
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases?
- A. A Virtual Private Catalog used to register a container database can be created in a non-container database.
- B. It Is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
- C. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
- D. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
- E. A Virtual Private Catalog used to register a container database can be created in a pluggable database.
- F. It Is always possible for RMAN to connect to a pluggable database as a target.
Answer: A,B,E
NEW QUESTION 88
A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)
- A. PDB_FILE_NAME_CONVERT must be set before executing the command.
- B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
- C. PDB1 data files already exist in the correct location.
- D. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
- E. PDB1 must be dropped from CDB1.
Answer: C,E
NEW QUESTION 89
Examine this configuration:
1. The orcl database data files are in Automatic Storage Management (Oracle ASM) disk group +data.
2. orcl uses disk group +fra for the Fast Recovery Area.
3. listener is the listener for orcl.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:
$ srvctl start database -d ORCL
What is the outcome?
- A. The ORCL database, the Oracle ASM instances, the +data and +fra disk groups, and the listener are started.
- B. Only the orcl database instance is started.
- C. Only the orcl database and the ASM instances are started.
- D. Only the orcl database instance, the Oracle ASM instance, and the +data and +fra disk groups are started.
- E. Only the orcl database instance and the +data and +fra disk groups are started.
Answer: A
NEW QUESTION 90
......
Step by Step Guide to Prepare for 1Z0-083 Exam: https://www.exams4collection.com/1Z0-083-latest-braindumps.html
Oracle Database 19c 1Z0-083 Real Exam Questions and Answers FREE Updated: https://drive.google.com/open?id=1cU_IyJvtsJ5z3XpVR5Ntuj-6pmiUsu9D
