Try 100% Updated 1Z1-083 Exam Questions [2021]
Pass 1Z1-083 Exam - Real Questions & Answers
Exam Topic for Oracle Database Administration II Exam Number: 1Z0-083
The following will be discussed in ORACLE 1Z0-083 exam dumps:
- Recovery and Flashback
- Backup Strategies and Terminology
- Creating CDBs and Regular PDBs
- Duplicating a Database
- Transporting Data
- Diagnosing Failures
- Manage Application PDBs
- Restore and Recovery Concepts
- Install Grid Infrastructure and Oracle Database
- Backup and Duplicate
- Using Flashback Technologies
For more info read reference:
1Z0-083 Official Certification Site Oracle Cloud Learning Resources
NEW QUESTION 31
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. Tablespaces never remain in read/write mode during transportable tablespace operations.
- B. A transportable data pump import can leave a plugged-in tablespace in read/write mode.
- C. A transportable data pump import can leave a plugged-in tablespace in read-only mode.
- D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
- E. Tablespaces always remain in read/write mode during transportable tablespace operations.
- F. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.
Answer: B,D,E
NEW QUESTION 32
Which two are true about RMAN duplexed backup sets?
- A. A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.
- B. A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.
- C. A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.
- D. A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.
- E. A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.
- F. A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.
Answer: B,F
NEW QUESTION 33
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? (Choose three.)
- A. Data file 24 can be restored only while connected to CDB$ROOT.
- B. Data file 24 can be restored only while connected to PDB2.
- C. Data file 24 can be restored and recovered while connected to CDB$ROOT.
- D. Data file 24 can be recovered while connected to PDB2.
- E. Data file 24 can be recovered only while connected to PDB2.
- F. Data file 24 can be recovered while connected to CDB$ROOT.
Answer: A,C,F
NEW QUESTION 34
HR_ROOT is an application container with the HR_APP application installed.
No application PDBs and no application seed have yet been created in HR_ROOT.
An application PDB, PDB1, must be created so that the HR_APP application's common objects are accessible to it.
Which two methods can be used? (Choose two.)
- A. Create the PBD1 application PDB and synchronize it with PDB$SEED.
- B. Create an application seed, synchronize it with HR_ROOT, and then create the PDB1 application PDB.
- C. Create the PBD1 application PDB and synchronize it with HR_ROOT.
- D. Create an application seed, and install HR_APP in it.
- E. Create the PDB1 application PDB and install HR_APP in it.
Answer: B,D
NEW QUESTION 35
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 agreed service levels for performance have been met.
- C. The database instance memory should always be tuned before tuning any file systems.
- D. Tuning activities should stop once the user is satisfied with performance.
- 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: B,F
NEW QUESTION 36
Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)
- A. the Process Monitor Process (PMON)
- B. the data dictionary in CDB$ROOT
- C. undo tablespaces
- D. temporary tablespaces
- E. the log writer process (LGWR)
- F. SYSAUX tablespaces
Answer: A,B,D
NEW QUESTION 37
Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)
- A. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
- B. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
- C. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
- D. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
- E. CDB$ROOT and PDB$SEED are automatically duplicated.
Answer: A,C
Explanation:
Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV430
NEW QUESTION 38
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It is part of the DBMS_ADVISOR package.
- B. It is part of the DBMS_STATS package.
- C. It can recommend changes to improve the statistics gathering process.
- D. It can be run only manually.
- E. It runs automatically every night by default.
- F. It always analyzes all schemas in the database.
Answer: B,C,F
NEW QUESTION 39
Examine this output:
Which two are true? (Choose two.)
- A. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
- B. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
- C. PDB1 is always limited to 40% of the available system resources regardless of demand.
- D. Any PDB not specified in the plan will be unable to execute statements in parallel.
- E. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
- F. PDB3 can use all available parallel execution processes at times.
Answer: B,D
NEW QUESTION 40
Which two are true about data movement between a non-CDB and a PDB using Data Pump?
- A. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
- B. A new PDB is automatically created when importing a non-CDB into a CDB.
- C. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
- D. Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB.
- E. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
- F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
Answer: B,D
NEW QUESTION 41
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. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.
- C. RMAN can always repair corrupt blocks.
- D. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.
- E. The Data Recovery Advisor uses the ADR.
- F. Flashback commands help with repairing physical errors.
Answer: A,B,C
NEW QUESTION 42
You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:
Which two are true? (Choose two.)
- A. oracle must be the owner of every Oracle Database installation.
- B. oracle will be an owner of the Oracle Inventory.
- C. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
- D. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.
- E. oracle will be granted the SYSASM privilege when installing the Oracle Database software.
Answer: D,E
NEW QUESTION 43
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)
- A. Index balanced B*Tree height is considered when evaluating the cost of using an index.
- B. The Statistics Advisor can help recommend the best way to gather statistics.
- C. The Statistics Advisor generates actions for all recommendations.
- D. Statistics collected using DBMS_STATS always yield the best optimizer result.
- E. The number of table rows is considered when evaluating the cost of accessing a table using an index.
Answer: B,D
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statistics- advisor.html#GUID-D81A7708-FDA0-45BB-A6E2-103858B047AE
NEW QUESTION 44
You are managing this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are two pluggable databases in CDB1.
* USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:
Which two are true? (Choose two.)
- A. The insert on USER2.DEPT is uncommitted.
- B. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
- C. The insert on USER2.DEPT fails because of the active transaction in the parent container.
- D. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
- E. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
- F. The inserts on USER1.EMP were committed when the session connected to PDB2.
- G. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
Answer: A,F
NEW QUESTION 45
Which two are true about duplicating pluggable databases (PDBs) with RMAN?
- A. cdb$root and pdbSseed are automatically duplicated.
- B. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
- C. The auxiliary Instance is automatically created with enable_pluggable_database = true.
- D. Two or more PDBs can be duplicated with the same rmak duplicate command.
- E. A user with sysdba or sysbkup must be logged in with RMAN to the PDB to duplicate it.
Answer: B,D
NEW QUESTION 46
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases?
- A. It Is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
- B. A Virtual Private Catalog used to register a container database can be created in a non-container database.
- C. A Virtual Private Catalog used to register a container database can be created in a pluggable database.
- D. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
- E. It Is always possible for RMAN to connect to a pluggable database as a target.
- F. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
Answer: A,B,C
NEW QUESTION 47
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
- A. New templates can only be created by modifying an existing user-created template.
- B. Oracle DBCAtemplates can be used to create new databases and duplicate existing databases.
- C. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- D. Oracle DBCA templates can store only logical structure and not database files.
- E. The Data Warehouse template is most suitable when transaction response time is the key criterion.
Answer: B,C
NEW QUESTION 48
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 and the +data and +fra disk groups are 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 is started.
Answer: A
NEW QUESTION 49
Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)
- A. Row Movement must be enabled on the table being flashed back.
- B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
- C. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
- D. A table's indexes must be set to unusable before issuing the flashback.
- E. A table's constraints must be disabled before issuing the flashback.
Answer: B,C
NEW QUESTION 50
......
1Z1-083 Exam Questions Get Updated [2021] with Correct Answers: https://www.guidetorrent.com/1Z1-083-pdf-free-download.html
Free Oracle 1Z1-083 Test Practice Test Questions Exam Dumps: https://drive.google.com/open?id=14qOfZs8eKFGF88LGeA-wC3H-KIQnhA71