PDF Download Free of 1Z0-083 Valid Practice Test Questions
1Z0-083 Test Engine files, 1Z0-083 Dumps PDF
Oracle 1Z0-083 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
Understanding functional and technical aspects of Oracle Database Administration II Exam Number: 1Z0-083
The following will be discussed in the ORACLE 1Z0-083 dumps:
- Restore and Recovery Concepts - Oracle Database: Backup and Recovery Workshop
- Configuring and using RMAN - Oracle Database: Backup and Recovery Workshop
- Duplicate Databases
- Configure and using an RMAN recovery catalog
- Diagnosing Database Issues
- Using Flashback Technologies - Oracle Database: Backup and Recovery Workshop
- Configure your Database to support Flashback
- Diagnosing Failures - Oracle Database: Backup and Recovery Workshop
- Employ the best Oracle Database recovery technology for your failure situation
NEW QUESTION 93
You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:
Which three are true? (Choose three.)
- A. The restore point is a label for the system change number (SCN) before the archival backup was taken.
- B. The SPFILE is included in the self-contaied archival backup.
- C. The control file is included in the self-contained archival backup.
- D. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
- E. All archive logs created after this backup are kept for two years.
- F. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
Answer: B,C,E
NEW QUESTION 94
Which two are true about gathering optimizer statistics?
- A. Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open PDBs except pdb$seed.
- B. Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open pluggable databases (PDBs).
- C. Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics only in cdbSroot.
- D. System statistics can be gathered only while connected to cdb$root.
- E. Executing dbms_stats.gather_database_stats while connected to a PDBopened in read/write mode gathers object statistics for that PDB.
Answer: B,C
NEW QUESTION 95
Which three methods can be used for heap table data migration after upgrading a database?
- A. using operating system file copy utilities
- B. using Database Replay
- C. using the create table AS select SQL statement
- D. using Database Upgrade Assistant
- E. using SQL Developer
- F. using Oracle Data Pump
Answer: B,D,E
NEW QUESTION 96
Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)
- A. The ADR can store metadata in an Oracle Database repository.
- B. RMAN can always repair corrupt blocks.
- C. The Data Recovery Advisor uses the ADR.
- D. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.
- E. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.
- F. Flashback commands help with repairing physical errors.
Answer: A,B,E
NEW QUESTION 97
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 recovered while connected to PDB2.
- B. Data file 24 can be restored only 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 restored and recovered while connected to CDB$ROOT.
- F. Data file 24 can be recovered while connected to CDB$ROOT.
Answer: A,B,C
NEW QUESTION 98
Which operating system group is NOT needed to perform an Oracle Database installation?
- A. OSDBA
- B. OSASM
- C. OSOPER
- D. OSKMDBA
- E. OSRACDBA
Answer: E
NEW QUESTION 99
Which two are true about memory advisors? (Choose two.)
- A. 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.
- B. All memory advisors use data from Automatic Workload Repository.
- C. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
- D. If Automatic Memory Management is enabled, no memory advisors are available.
- E. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
Answer: D,E
NEW QUESTION 100
Examine this configuration:
1. The ORCLdatabase data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2. ORCLuses disk group +FRAfor 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:
What is the outcome?
- A. Only the ORCL database instance is started.
- B. Only the ORCLdatabase instance, the Oracle ASM instance, and the +DATAand +FRAdisk groups are started.
- C. Only the ORCLdatabase and the ASM instances are started.
- D. The ORCL database, the Oracle ASM instances, the +DATAand +FRAdisk groups, and the LISTENER are started.
- E. Only the ORCLdatabase instance and the +DATAand +FRAdisk groups are started.
Answer: B
NEW QUESTION 101
Which two are true about Oracle instance recovery? (Choose three.)
- A. Recovery reads redo until the end of the redo thread. SMON rollsback any dead transactions, and then the datanase is opened.
- B. 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.
- C. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
- D. Recovery begins from the beginning of the CURRENT redo log group.
- E. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
- F. Recovery begins from the last checkpoint position that wascalculated by the Database Writer before instance failure.
Answer: A,C,F
NEW QUESTION 102
Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)
- A. It can be used to convert a non-container database to a container database.
- B. It can be launched from both the command line and the Universal Installer (OUI) interfaces.
- C. It can be used to create container databases and non-container databases.
- D. It can be used to change the character set of an existing database.
- E. It can only be launched from the command line interface.
Answer: D,E
NEW QUESTION 103
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$SESSION_WAIT
- B. V$SESSION
- C. V$SESSION_EVENT
- D. V$SESSION_WAIT_CLASS
- E. V$SESSTAT
Answer: C
Explanation:
Reference:
https://docs.oracle.com/cd/E29597_01/server.1111/e16638/instance_tune.htm
NEW QUESTION 104
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
- A. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
- B. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
- C. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
- D. Undo tablespaces existing in PDBs must be dropped before the change.
- E. After the change, only one undo tablespace can exist in CDB$ROOT.
- F. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
Answer: C,E
Explanation:
Explanation
You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB property. When the database property LOCAL_UNDO_ENABLE is FALSE, which is the default, there is only one UNDO tablespace that is created in the CDB root, and that is shared by all containers. When LOCAL_UNDO_ENABLE is TRUE, every container in the CDB uses local undo and each PDB must have its own local UNDO tablespace. To maintain ease of management and provisioning, UNDO tablespace creation happens automatically and does not require any action from the user. When a PDB is opened and an UNDO tablespace is not available, its automatically created.
NEW QUESTION 105
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:
What is the outcome?
- A. Only the ORCL database instance and the +DATA and +FRA disk groups are started.
- B. Only the ORCL database instance is started.
- C. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
- D. Only the ORCL database and the ASM instances are started.
- E. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
Answer: E
Explanation:
Explanation
https://docs.oracle.com/html/E25494_01/start001.htm
NEW QUESTION 106
Which two are true about server-generated alerts? (Choose two.)
- A. Stateless alerts are automatically cleared.
- 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 can be purged manually from the alert history.
Answer: C,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 107
Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)
- A. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
- B. A table's constraints must be disabled before issuing the flashback.
- C. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
- D. Row Movement must be enabled on the table being flashed back.
- E. A table's indexes must be set to unusable before issuing the flashback.
Answer: A,C
NEW QUESTION 108
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
- A. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
- B. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
- C. Existing Oracle Database instances must be shut down before starting the upgrade.
- D. An existing Oracle base can be used.
- E. Only the grid user can perform the upgrade.
- F. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
Answer: A,C,E
Explanation:
Reference:
https://docs.oracle.com/database/121/CWLIN/procstop.htm#CEGEDCDB
NEW QUESTION 109
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 read-only Oracle home
- B. to switch back to the previous Oracle home as part of a rollback operation
- C. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
- D. to switch to a patched Oracle Database home
- E. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
Answer: B,D
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 110
A container database called CDB1is OMF-enabled.
PDB_FILE_NAME_CONVERTis not configured in CDB1.
PDB1was unplugged from CDB1earlier 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. PDB1 must be dropped from CDB1.
- B. PDB1 data files already exist in the correct location.
- C. DBMS_PDB.CHECK_PLUG_COMPATIBILITYmust be run in CDB1before executing the command.
- D. /u01/app/oracle/oradata/pdb1.xmldoes not contain the current locations of data files for PDB1.
- E. PDB_FILE_NAME_CONVERTmust be set before executing the command.
Answer: D,E
Explanation:
Explanation/Reference: http://anjaniappsdba.blogspot.com/2016/09/oracle-database-12102c-hot-cloning-of.html
NEW QUESTION 111
You must transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
1.Make the UNIVERSITY tablespace read-only on the source system.
2.Export the UNIVERSITY tablespace metadata using EXPDP.
3.Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4.Copy the UNIVERSITY tablespace data files to the destination system.
5.Copy the Data Pump dump set to the destination system.
6.Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7.Import the UNIVERSITY tablespace metadata using IMPDP.
8.Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?
- A. 1, 2, 3, 4, 5, 6, 7, 8
- B. 1, 2, 4, 6, 7, 8
- C. 1, 2, 3, 4, 5, 7, 8
- D. 2, 4, 5, 6, 7
- E. 1, 2, 4, 5, 7, 8
Answer: C
NEW QUESTION 112
You want to transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have the same endian format.
Examine this list of steps:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause.
4. Copy the cross-platform backup sets to the destination system.
5. Copy the Data Pump dump set from the source to the destination system.
6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?
- A. 1, 2, 3, 4, 5, 6, 7, 8
- B. 3, 4, 6
- C. 2, 3, 4, 5, 6, 7
- D. 1, 3, 4, 6, 8
Answer: D
NEW QUESTION 113
......
Pass Your Oracle Database 19c 1Z0-083 Exam on Dec 17, 2021 with 160 Questions: https://www.actual4dump.com/Oracle/1Z0-083-actualtests-dumps.html
Latest Oracle 1Z0-083 PDF and Dumps (2021) Free Exam Questions Answers: https://drive.google.com/open?id=1hpBiG8tlj7W3CP6ImXBKkbDBcTkFThai