[Aug-2024] Oracle 1Z0-083 DUMPS WITH REAL EXAM QUESTIONS
2024 New ExamTorrent 1Z0-083 PDF Recently Updated Questions
Who should take the Oracle Database Administration II Exam Number: 1Z0-083
Oracle Database Administration II Exam Number: 1Z0-083 has is ideal for:
- DB designers and analysts
- DB Architects
- Development DBAs
- Production Database Administrators (DBAs)
NEW QUESTION # 84
The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3.
Which three are true? (Choose three.)
- A. A database link must exist in the local CDB root referring to the remote CDB.
- B. A database link must exist in the remote CDB referring to the local CDB.
- C. A proxy PDB must exist in the application root in the local CDB.
- D. PDB3's application root replica must exist in the local CDB.
- E. A proxy PDB must exist in the application root in the remote CDB.
- F. The HR_ROOT replica must exist in the remote CDB.
Answer: A,C,F
Explanation:
Database link must be created in master application root (local CDB) referring to replica application root (remote CDB). Option B Proxy PDB must be created in master application root (local CDB) using this database link.
Option F
Replica application root must exist in remote CDB (created or upgraded using SYNC in local Proxy PDB). Option E With this, we can make a SELECT that will show data from local and remote PDB applications (Query in local master application root using CONTAINERS clause).
https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-application- containers-sql-plus.html#GUID-B96087B5-678C-4781-9464-42FC468B1FCC
NEW QUESTION # 85
Examine these queries and their output:
An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.
How do you achieve this?
- A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
- B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
- C. This cannot be done due to the lack of a clean restore point.
- D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
- E. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.
Answer: E
NEW QUESTION # 86
Your database is in ARCHIVELOG mode and you plan to use Flashback Database.
Which two features or parameters manage space availability in the fast recovery area? (Choose two.)
- A. using guaranteed UNDO retention
- B. the archived log deletion policy
- C. the DB_RECOVERY_FILE_DEST parameter setting
- D. the backup optimization policy
- E. the backup retention policy
- F. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
Answer: B,E
Explanation:
RMAN automatically manages files in the fast recovery area by deleting obsolete backups and archiving files no longer required for recovery.
https://docs.oracle.com/en/database/oracle/oracle-database/18/ssdbi/about-the-fast-recovery- area-and-the-fast-recovery-area-disk-group.html#GUID-05343E2B-24CF-427E-A068-
9AC2104BEF81
NEW QUESTION # 87
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 duplicate database has the same directory structure as the source database.
- C. All archive redo log files are automatically copied to the duplicate database.
- D. The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
- E. he duplicate command.
- F. The duplicate database is created by using the backups created during the execution of
Answer: A,B
NEW QUESTION # 88
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)
- A. using Database Replay
- B. using Oracle Data Pump
- C. using SQL Developer
- D. using operating system file copy utilities
- E. using Database Upgrade Assistant
- F. using the CREATE TABLE AS SELECT SQL statement
Answer: D,E,F
NEW QUESTION # 89
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
- A. relocating a remote container database in silent mode
- B. cloning a remote container database in interactive mode
- C. relocating a remote container database in interactive mode
- D. relocating a remote pluggable database in silent mode
- E. relocating a remote pluggable database in interactive mode
- F. cloning a remote container database in silent mode
- G. cloning a remote pluggable database in silent mode
Answer: D,F,G
Explanation:
$ORACLE_HOME/bin/dbca -silent \
-createDuplicateDB -gdbName CDB1 -sid CDB1B \
-createAsStandby -dbUniqueName CDB1B -sysPassword oracle \
-primaryDBConnectionString $(hostname):1521/CDB1A \
-datafileDestination /u01/oradata -useOMF true -storageType FS \
-recoveryAreaDestination /u01/fast_recovery_area \
-recoveryAreaSize 10240 -enableArchive true \
-createListener LISTENER1B:1522
NEW QUESTION # 90
Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)
- A. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
- B. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
- C. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
- D. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
- E. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
- F. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
- G. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
- H. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
Answer: B,D,F,H
Explanation:
Reference:
http://oradb-srv.wlv.ac.uk/ora12c/RCMRF/rcmsynta020.htm
NEW QUESTION # 91
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
- A. STATISTICS_LEVEL must be set to ALL to generate alerts.
- B. They are generated by SMON when a tablespace is 97% full.
- C. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
- D. All metrics are instance related.
- E. Metrics are statistical counts for a specific unit.
- F. A space usage management alert is automatically cleared after the underlying problem is resolved.
Answer: C,E,F
NEW QUESTION # 92
A database is configured in archivelog mode.
Full RMAN backups are taken daily and no backup to trace has been taken of the control file.
A media failure has occurred.
In which two scenarios are complete recovery possible?
- A. after losing an archived log from before the most recent backup
- B. when any archived log from, before, or after the most recent backup is corrupt
- C. after losing an archived log from after the most recent backup
- D. after losing all copies of the control file
- E. after losing the system tablespace
Answer: A,D
NEW QUESTION # 93
Choose three. Which three are true about Recovery Manager (RMAN) active database duplication?
- A. Pre-existing backups of the database to be duplicated are always used if they exist.
- B. The active database must be duplicated while in OPEN state.
- C. No connection to the recovery catalog is required for active database duplication.
- D. Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.
- E. Image copies can be used to duplicate the active database.
- F. Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.
- G. Backup sets can be used to duplicate the active database.
Answer: C,E,G
NEW QUESTION # 94
Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)
- A. The CSS daemon runs from the Grid Infrastructure home.
- B. It can manage database resources on the server where it is installed or on a different server.
- C. It supports volume management, file system, and automatic restart capabilities.
- D. It must be installed before the Oracle database software is installed.
- E. It requires Oracle Automatic Storage Management (ASM) components to be installed separately.
Answer: A,C
Explanation:
Oracle Grid Infrastructure for a standalone server includes Oracle Restart and Oracle Automatic Storage Management.
If you install Oracle Grid Infrastructure for a standalone server and then create your database, then the database is automatically added to the Oracle Restart configuration. Oracle Restart automatically restarts the database when required.
If you install Oracle Grid Infrastructure for a standalone server on a host computer on which a database already exists, then you must manually add the database, the listener, the Oracle ASM instance, and other components to the Oracle Restart configuration before you are able to configure automatic database restarts.
NEW QUESTION # 95
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 # 96
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?
- A. Tracking the most recent write time for a table segment in a user tablespace
- B. Tracking the most recent read time for a table segment in a user tablespace
- C. Tracking the most recent write time for a table block
- D. Tracking insert time by row for table rows
- E. Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct
- F. Tracking the most recent read time for a table segment in the SYSTEM tablespace
Answer: A,B,D
NEW QUESTION # 97
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)
- A. A Virtual Private Catalog used to register a container database can be created in a non-container database.
- B. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
- C. It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
- D. A Virtual Private Catalog used to register a container database can 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,D,E
Explanation:
Explanation/Reference:
NEW QUESTION # 98
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADATA.
3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands: $ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type --------------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?
- A. It will return an error because EMP is not empty in APP_ROOT.
- B. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.
- C. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.
- D. It will return an error because the SYNC operation is not allowed when constraints are added to common objects.
- E. It will return an error because EMP.SAL is empty in APP_ROOT.
Answer: A
NEW QUESTION # 99
......
Latest 1Z0-083 Pass Guaranteed Exam Dumps Certification Sample Questions: https://pass4sure.examtorrent.com/1Z0-083-prep4sure-dumps.html
