Pass Your Oracle Database 19c 1Z0-083 Exam on Nov 21, 2022 with 279 Questions
1Z0-083 Free Exam Study Guide! (Updated 279 Questions)
Understanding functional and technical aspects of Oracle Database Administration II Exam Number: 1Z0-083
The following will be discussed in the ORACLE 1Z0-083 exam dumps:
- Configuring and Using RMAN
- Creating CDBs and Regular PDBs
- Upgrading and Transporting CDBs and Regular PDBs
- Recovery and Flashback
- Manage CDBs and PDBs
- Oracle Database: Managing Multitenant Architecture Ed 1
For more info read reference:
1Z0-083 Official Certification Site Oracle Cloud Learning Resources
NEW QUESTION 156
Examine this command for creating pluggable database PDB2 in container database CDB2 CREATE PLUGGABLE DATABASE pdb2 ADMIN USER pdb2_adrn IDENTIFIED BY 12 3pdb ROLES=(CONNECT) ; Select three options, any one of which is required for it to execute successfully.
- A. Enable only OMF.
- B. Set the pdb_file_name_convert parameter and enable OMF.
- C. Add the file_mame_comvert clause to the statement and enable Oracle Managed Files (OMF).
- D. Set only the pdb_file_name_convert parameter.
- E. Add the file_name_convert clause to the statement and set the pdb_file_name_convert parameter.
- F. Add only the create_file_dest clause to the statement.
Answer: B,C,E
NEW QUESTION 157
Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c? (Choose two.)
- A. The installer will prompt for the root or sudo password.
- B. Silent install always runs operating scripts automatically.
- C. The response file can specify the root or sudo password.
- D. The response file must contain the root or sudo password.
- E. The response file can specify the path of the sudo program.
Answer: D,E
NEW QUESTION 158
Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)
- A. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.
- B. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.
- C. The Data Recovery Advisor uses the ADR.
- D. Flashback commands help with repairing physical errors.
- E. RMAN can always repair corrupt blocks.
- F. The ADR can store metadata in an Oracle Database repository.
Answer: A,E,F
NEW QUESTION 159
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE; Which two statements are true about the execution of the duplicate command?
- A. The duplicate database is created without using RMAN backups and prod1 is allowed to remain open during duplication.
- B. The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
- C. The duplicate database has the same directory structure as the source database.
- D. The duplicate database is created by using the backups created during the execution of
- E. he duplicate command.
- F. All archive redo log files are automatically copied to the duplicate database.
Answer: A,C
NEW QUESTION 160
Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOTis an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully: Which two are true? (Choose two.)
- A. C##_APP_USER1 can be created in CDB1.
- B. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
- C. APP1_USER1can be created in PDB1.
- D. P1_USER1can be created in CDB1.
- E. C##_USER1will have the same privileges and roles granted in all PDBs in CDB1.
- F. APP1_USER1can be created in CDB1.
Answer: A,B
NEW QUESTION 161
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 PDB1 have been rolled back.
- B. CDB1 is in MOUNT state
- C. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
- D. PDB1 is closed.
- E. CDB1 is shut down.
Answer: A,D
NEW QUESTION 162
Which four are true about RMAN backup sets? (Choose four.)
- A. Blocks from multiple data files can be contained in one backup set,
- B. Blocks from multiple data files can be contained in one backup piece,
- C. A backup set must be written to media.
- D. A data file can be split into multiple sections stored in different backup sets.
- E. A data file canbe split into multiple sections stored in different backup pieces in the same backup set.
- F. A backup set can contain only one backup piece.
- G. A backup piece can belong to only one backup set.
- H. A backup set must be written to disk.
Answer: A,C,D,F
NEW QUESTION 163
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)
- A. creating the grid OS user
- B. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
- C. creating the OSDBA (dba) group
- D. creating the oracleOS user
- E. configuring the OS for Oracle Automatic Storage Management shared storage access
- F. creating thte oraInventory (oinstall) group
Answer: C,E,F
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN2932
NEW QUESTION 164
Which two are true about RMAN backups when using a media manager? (Choose two.)
- A. A media manager is required to create RMAN proxy copies.
- B. A media manager always writes RMAN requested backups to tape.
- C. A media manager is required to create RMAN image copies.
- D. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
- E. By default, a request for a proxy copy may result in a backup set being created.
Answer: B,C
NEW QUESTION 165
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)
- A. It can be used to provision middleware.
- B. It cannot be used to upgrade Oracle Database homes.
- C. It can be used to provision applications.
- D. It is an Oracle Database service
- E. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
Answer: A,C
NEW QUESTION 166
Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?
- A. six
- B. three
- C. seven
- D. five
- E. eight
Answer: C
NEW QUESTION 167
Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?
- A. Create an adaptive execution plan for each of the regressed statements
- B. Use the SQL Access Advisor for each of the regressed statements.
- C. Use The SQL Tuning Advisor for each of the regressed statements.
- D. Create SQL plan directives for each of the regressed statements.
Answer: C
NEW QUESTION 168
Which two are true about the character sets used in an Oracle database? (Choose two.)
- A. Multibyte character sets allow more efficient space utilization than single byte character sets.
- B. Single-byte character sets always use 7-bit encoding schemes.
- C. Single-byte character sets always use 8-bit encoding schemes.
- D. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).
- E. Unicode enables information from any language to be stored using a single character set.
- F. Single-byte character sets provide better performance than multibyte character sets.
Answer: E,F
Explanation:
Reference:
https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG166
NEW QUESTION 169
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_EVENT
- C. V$SESSION
- D. V$SESSION_WAIT_CLASS
- E. V$SESSION_WAIT
Answer: B
NEW QUESTION 170
Your sales_root application container has two application PDBs.
The sales_app application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:
Which two are true?
- A. A container map exists for the revenue table, but Is not enabled.
- B. The revenue table partitions are not pruned across the PDBs automatically.
- C. The maptable table is a metadata-linked table.
- D. The maptable table defines a logical partition key on a commonly used column for the revenue table.
- E. The containers clause cannot be used in queries on the revenue table.
- F. The revenue table must be a list-partitioned table.
Answer: A,C
NEW QUESTION 171
A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)
- A. after losing all copies of the control file
- B. after losing the SYSTEM tablespace
- C. after losing an archived log from before the most recent backup
- D. after losing an archived log from after the most recent backup
- E. when any archived log from, before, or after the most recent backup is corrupt.
Answer: B,C
NEW QUESTION 172
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. Redo logs are opened.
- B. PDB$SEED is in READ ONLY state.
- C. CDB$ROOT is in MOUNT state.
- D. PDB1 and PDB2 are in READ ONLY state.
- E. PDB1 and PDB2 are in MOUNT state.
Answer: A,B
NEW QUESTION 173
Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle
19c and later releases? (Choose three.)
- A. A PDB snapshot can be a sparse copy of a source PDB.
- B. A snapshot copy PDB can be a full copy of a source PDB.
- C. A PDB snapshot can be a full copy of a source PDB.
- D. A PDB snapshot depends on an existing storage snapshot of the source PDB.
- E. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
- F. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
- G. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
Answer: A,B,D
NEW QUESTION 174
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. If the password file location changes, then the new location is used automatically by the Oracle Server.
- B. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
- 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. All the Oracle-supplied accounts are Schema Only accounts.
- F. Schema Only accounts can be granted administrator privileges.
Answer: D,E,F
Explanation:
Reference:
https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/
NEW QUESTION 175
Choose three. Which three are true in Oracle 19c and later releases?
- A. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
- B. Tablespaces always remain in read/write mode during transportable tablespace operations.
- C. Tablespaces never remain in read/write mode during transportable tablespace operations.
- D. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.
- E. A transportable data pump import can leave a plugged-in tablespace in read/write mode.
- F. A transportable data pump import can leave a plugged-in tablespace in read-only mode.
Answer: A,C,E
NEW QUESTION 176
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
- A. It removes the AUDSYS schema and the AUDIT_ADMINand AUDIT_VIEWERroles
- B. It sets all user tablespaces to "read-only" before starting the upgrade.
- C. It increases tablespace size, if required, to meet upgrade requirements.
- D. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
- E. It recompiles all stored PL/SQLcode by using utlrp.sql.
- F. It empties the RECYCLE BIN.
Answer: C,D,E
Explanation:
Explanation/Reference: https://oracle-base.com/articles/12c/upgrading-to-12c
NEW QUESTION 177
Choose three. Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases?
- A. A PDB snapshot can be a sparse copy of a source PDB.
- B. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
- C. A snapshot copy PDB can be a full copy of a source PDB.
- D. A PDB snapshot can be a full copy of a source PDB.
- E. A PDB snapshot depends on an existing storage snapshot of the source PDB.
- F. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
- G. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
Answer: B,C,E
NEW QUESTION 178
Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)
- A. the Process Monitor Process (PMON)
- B. temporary tablespaces
- C. the log writer process (LGWR)
- D. SYSAUX tablespaces
- E. undo tablespaces
- F. the data dictionary in CDB$ROOT
Answer: A,B,F
NEW QUESTION 179
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 Access Advisor.
- C. Run the SQL Tunning Advisor.
- D. Run the Memory Advisor for the System Global Area.
- E. Run theMemory Advisor for the Program Global Area.
Answer: A
NEW QUESTION 180
Examine this configuration:
CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
PDB$SEED is open READ ONLY
PDB1 is open READ WRITE
PDB2 is MOUNTED.
ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:
For which databases will fixup scripts be created?
- A. CDB1, PDB$SEED, PDB1, and PDB2
- B. CDB1 and PDB$SEED only
- C. CDB1, PDB1, and PDB2 only
- D. PDB$SEED, PDB1, and PDB2 only
- E. CDB1, PDB$SEED, and PDB1 only
Answer: E
NEW QUESTION 181
......
1Z0-083 Dumps for Oracle Database 19c Certified Exam Questions and Answer: https://www.examcollectionpass.com/Oracle/1Z0-083-practice-exam-dumps.html
Realistic Verified 1Z0-083 exam dumps Q&As - 1Z0-083 Free Update: https://drive.google.com/open?id=1cF6pDm1ICiF763AODSjNqgTGSAr4Hjxg