Best Quality 1Z0-083 Exam Questions Oracle Test To Gain Brilliante Result!
Preparations of 1Z0-083 Exam 2021 Oracle Database 19c Unlimited 160 Questions
NEW QUESTION 67
Which two are true about data movement between a non-CDB and a PDB using Data Pump?
- A. Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB.
- B. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
- C. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
- D. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
- E. A new PDB is automatically created when importing a non-CDB into a CDB.
- F. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
Answer: A,E
NEW QUESTION 68
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
- A. Databases can be transported between systems with different endian formats.
- B. Data files can be converted on the destination system.
- C. The password file is automatically converted by RMAN.
- D. A new DBID is automatically created for the transported database.
- E. By default, the transported database will use Oracle Managed Files (OMF)
- F. Data files can be converted on the source system.
Answer: B,E,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 69
Which three actions are performed by Database Upgrade Assistant (DBUA)?
- A. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
- B. It empties the recycle bin.
- C. It Increases tablespace size, if required, to meet upgrade requirements.
- D. It recompiles all stored pl/sql code by using utlrp.sql.
- E. It removes the audsys schema and the audit_admin and audit_viewer roles.
- F. It sets all user tablespaces to "read-only" before starting the upgrade.
Answer: B,E,F
NEW QUESTION 70
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 remote CDB referring to the local CDB.
- B. PDB3's application root replica must exist in the local CDB.
- C. The HR_ROOT replica must exist in the remote CDB.
- D. A proxy PDB must exist in the application root in the local CDB.
- E. A proxy PDB must exist in the application root in the remote CDB.
- F. A database link must exist in the local CDB root referring to the remote CDB.
Answer: A,C,D
NEW QUESTION 71
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)?
- A. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
- B. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
- C. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
- D. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
- E. The Oracle Grid Infrastructure Installation must be owned by the grid user.
- F. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
Answer: E,F
NEW QUESTION 72
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)
- A. A PDB snapshot is always a sparse copy of the source PDB.
- B. A snapshot copy PDB can be created from a stand-alone clone PDB.
- C. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
- D. A PDB snapshot is always a full copy of the source PDB.
- E. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
- F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
- G. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
Answer: D,G
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-pdb- snapshots.html#GUID-35B03C37-00BA-4945-BF20-9A7C4C541955
NEW QUESTION 73
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)
- A. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
- B. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
- C. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
- D. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- E. These backups can be written to disk or SBT.
Answer: D,E
Explanation:
Explanation
https://blog.toadworld.com/rman_-_using_the_flash_recovery_area
NEW QUESTION 74
Which three are true about Database Point-in-Time Recovery?
- A. The database must be open resetlogs after Database Point-in-Time Recovery.
- B. The database must be in archivelog mode.
- C. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
- D. The target point for the recovery must be specified as a time or System Change Number (SCN).
- E. The database must be in mount state when performing Database Point-in-Time Recovery.
- F. The database must have flashback database on to perform Database Point-in-Time Recovery.
Answer: A,B,D
NEW QUESTION 75
Which three methods can be used for heap table data migration after upgrading a database?
- A. using operating system file copy utilities
- B. using Oracle Data Pump
- C. using Database Upgrade Assistant
- D. using the create table AS select SQL statement
- E. using Database Replay
- F. using SQL Developer
Answer: C,E,F
NEW QUESTION 76
Which three are true about Automatic Workload Repository (AWR)?
- A. Its collection level is determined by the value of the statistics_level database parameter.
- B. By default, AWR snapshots are retained for 7 days.
- C. The taking of AWR snapshots can be disabled.
- D. By default, AWR snapshots are taken every 60 minutes.
- E. AWR data is stored in the system tablespace.
Answer: A,C,D
NEW QUESTION 77
A database is configured in archivelog mode.
A full RMAN backup exists but no control file backup to trace has been taken.
A media failure has occurred.
In which two scenarios is incomplete recovery required?
- A. after losing an undo tablespace that is in use
- B. after losing all members of an inactive online redo log group
- C. after losing all members of the current online redo log group
- D. after losing all copies of the control file
- E. after losing a sysaux tablespace data file
Answer: B,C
NEW QUESTION 78
You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)
- A. All files in any previous FRA that have been backed up already, are backed up.
- B. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
- C. All files in the current FRA that have been backed up already, are backed up.
- D. All files in any previous FRA that have not yet been backed up, are backed up.
- E. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.
- F. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
- G. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.
Answer: A,E,G
NEW QUESTION 79
Which three are true about requirements for various flashback operations?
- A. flashback version query requires that the recyclebin parameter be set to on.
- B. flashback transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- C. flashback drop requires undo to retrieve all versions of a row that existed between two points in time.
- D. flashback data archive requires undo to store all versions of all rows of a table being tracked.
- E. flashback drop requires that the recyclebin parameter be set to on.
- F. flashback version query requires undo to retrieve all versions of a row that existed between two points in time.
Answer: C,D,F
NEW QUESTION 80
Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)
- A. the configuration of storage arrays
- B. defining primary keys for all tables to speed up all queries
- C. using check constraints to speed up updates
- D. the physical data model
- E. defining foreign keys for all tables to speed up joins
Answer: A,B
NEW QUESTION 81
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 will be an owner of the Oracle Inventory.
- B. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
- C. oracle must be the owner of every Oracle Database installation.
- 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 82
Which three are true about the SQL Tuning Advisor? (Choose three.)
- A. It checks each query being analyzed for missing statistics.
- B. It can recommend semantic changes to SQL statements.
- C. It considers all SQL statements being analyzed by the advisor task as a group.
- D. It checks each query being analyzed for stale statistics.
- E. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.
- F. It only recommends syntactic changes to SQL statements.
Answer: A,D,E
Explanation:
Reference:
https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL540
NEW QUESTION 83
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
- A. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
- B. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
- C. The RMAN SHOW ALL command displays only settings with nondefault values.
- D. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
- E. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
- F. A target database's persistent RMAN configuration settings are always stored in the target's control file
- G. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
Answer: B,D,F
NEW QUESTION 84
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
- A. ADDM can recommend extending the buffer cache.
- B. ADDM performs its analysis only when a DBA requests it.
- C. ADDM can recommend shrinking the buffer cache.
- D. By default, MMON creates an AWR snapshot every 30 minutes.
- E. By default, AWR snapshots are automatically purged after eight days.
- F. AWR snapshots must be deleted when no longer required by ADDM.
Answer: C,E,F
NEW QUESTION 85
Which two are true about the Oracle dataabsemethodology? (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 the user is satisfied with performance.
- C. The database instance memory should always be tuned before tuning any file systems.
- D. Tuning activities should stop onceagreed service levels for performance have been met.
- 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: D,F
NEW QUESTION 86
Which two are true about memory advisors? (Choose two.)
- A. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
- B. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
- C. 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.
- D. If Automatic Memory Management is enabled, no memory advisors are available.
- E. All memory advisors use data from Automatic Workload Repository.
Answer: A,D
NEW QUESTION 87
......
Focus on 1Z0-083 All-in-One Exam Guide For Quick Preparation: https://www.testinsides.top/1Z0-083-dumps-review.html
1Z0-083 All-in-One Exam Guide For Quick Preparation: https://drive.google.com/open?id=1qViErD_Qa8fAT_9UiDNezyX0D9h9jpcZ