Oracle 1Z0-083 Exam Prep Guide: Prep guide for the 1Z0-083 Exam
2024 New Preparation Guide of Oracle 1Z0-083 Exam
How to book the Oracle Database Administration II Exam Number: 1Z0-083
You can schedule the exam anytime at Pearson VUE. You can pay directly from a credit card or redeem a voucher purchased from Oracle.
NEW QUESTION # 106
In which two situations can you use Database Upgrade Assistant? (Choose two.)
- A. when a character set conversion is required during the upgrade
- B. when the target and source database are on the same platform
- C. when the operating system (OS) needs to be changed as part of the upgrade
- D. when the hardware platform needs to be changed as part of the upgrade
- E. when multiple pluggable databases in a container database have to be upgraded in a specific sequence
Answer: B,E
NEW QUESTION # 107
Examine the command for creating pluggable database PDB2 in container database CDB2.
Select three options, any one of which is required for it to execute successfully. (Choose three.)
- A. Addonly the CREATE_FILE_DEST clause to the statement.
- B. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
- C. Set only the PDB_FILE_NAME_CONVERT parameter.
- D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
- E. Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)
- F. Enable only OMF.
Answer: A,D,F
NEW QUESTION # 108
Which two are true about unplugging an application container from a container database and plugging it into a different container database?
- A. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.
- B. It requires only local undo mode in the database where the application container will be unplugged.
- C. Unplugging the application root from a CDB unplugs all its application PDBs.
- D. It requires local undo mode in both container databases.
- E. Application PDBs In the application container must be unplugged before the application root Is unplugged.
- F. Plugging the application root into a different CDB plugs In all its application PDBs.
Answer: C,E
NEW QUESTION # 109
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
- A. A new DBID is automatically created for the transported database.
- B. Data files can be converted on the destination system.
- C. By default, the transported database will use Oracle Managed Files (OMF)
- D. The password file is automatically converted by RMAN.
- E. Databases can be transported between systems with different endian formats.
- F. Data files can be converted on the source system.
Answer: B,C,F
Explanation:
Explanation
A: If you do not provide a destination, then the DB_FILE_CREATE_DEST initialization parameter must be set in the target platform. RMAN restores the data files to the location specified by this parameter using new Oracle Managed File (OMF) names. BC: While creating the cross-platform backup to transport a database, you can convert the database either on the source database or the destination database. The benefit of performing the conversion on the destination database is that the processing overhead of the convert operation is offloaded from the source to the destination database.
NEW QUESTION # 110
Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?
- A. control files
- B. all data dictionary metadata
- C. mandatory Oracle-supplied PL/SQL packages
- D. temporary tablespaces
- E. user-defined PL/SQL packages
- F. undo tablespaces
- G. redo logs
Answer: A,B,G
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. 2,4,5,6,7
- D. 1,2,3,4,5,7,8
- E. 1,2,4,5,7,8
Answer: D
NEW QUESTION # 112
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
- A. By default, AWR snapshots are taken every 60 minutes.
- B. AWR data is stored in the SYSTEM tablespace.
- C. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
- D. By default, AWR snapshots are retained for 7 days.
- E. The taking of AWR snapshots can be disabled.
Answer: A,C,E
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
NEW QUESTION # 113
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 SPFILE is included in the self-contaied archival backup.
- B. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
- C. All archive logs created after this backup are kept for two years.
- D. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
- E. The control file is included in the self-contained archival backup.
- F. The restore point is a label for the system change number (SCN) before the archival backup was taken.
Answer: A,C,E
NEW QUESTION # 114
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. All the Oracle-supplied accounts are Schema Only accounts.
- B. If the password file location changes, then the new location is used automatically by the Oracle Server.
- C. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
- D. Privilege Analysis is included 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.
- F. Schema Only accounts can be granted administrator privileges.
Answer: A,D,F
Explanation:
Explanation
Explanation/Reference: https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/
NEW QUESTION # 115
Choose two. Which two are true about RMAN Multisection backups when a very large data file is divided into four sections?
- A. The four sections must be image copies.
- B. The four sections can be created serially.
- C. Each of the file sections must be processed serially.
- D. The four sections must be contained in backup sets.
- E. The four sections can be created in parallel.
Answer: D,E
NEW QUESTION # 116
You execute this command successfully:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
What is the outcome?
- A. It creates a file that contains RMAN scripts to create a duplicate database.
- B. It creates a file that contains SQL statements to re-create the control file.
- C. It creates a copy of the control file in the fast recovery area (FRA).
- D. It updates the alert log with the location and contents of the control file
- E. It creates a binary backup of the control file.
Answer: B
NEW QUESTION # 117
Which two are true about Optimizer Statistics? (Choose two.)
- A. They are gathered by the SQL Tuning Advisor.
- B. By default, they are automatically gathered by a maintenance job.
- C. They provide real-time data about schema objects.
- D. They are ignored by Optimizer if they are stale.
- E. They can be gathered by the DBMS_STATS package.
Answer: B,E
NEW QUESTION # 118
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
- A. By default, AWR snapshots are taken every 60 minutes.
- B. AWR data is stored in the SYSTEMtablespace.
- C. Its collection level is determined by the value of the STATISTICS_LEVELdatabase parameter.
- D. By default, AWR snapshots are retained for 7 days.
- E. The taking of AWR snapshots can be disabled.
Answer: A,C,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
NEW QUESTION # 119
Which four are true about RMAN backup sets?
- A. A backup set must be written to disk.
- B. Blocks from multiple data files can be contained in one backup set.
- C. A data file can be split into multiple sections stored in different backup sets.
- D. A data file can be split into multiple sections stored in different backup pieces in the same backup set.
- E. A backup set must be written to media.
- F. A backup piece can belong to only one backup set.
- G. A backup set can contain only one backup piece.
- H. Blocks from multiple data files can be contained in one backup piece.
Answer: A,C,F,H
NEW QUESTION # 120
Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command:
SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?
- A. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.
- B. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.
- C. It fails because the command does notspecify when the unified audit policy should be enforced.
- D. It fails because system privileges cannot be granted with roles in the same audit policy.
Answer: B
NEW QUESTION # 121
......
Latest Questions 1Z0-083 Guide to Prepare Free Practice Tests: https://www.actual4dump.com/Oracle/1Z0-083-actualtests-dumps.html
1Z0-083 Practice Exam - 283 Unique Questions: https://drive.google.com/open?id=1cDFOQHc4YWXKhij1fN5U5XUq_4I_9hUd