Pass 1Z1-083 Exam Latest Practice Questions Updated on Feb 17, 2024
Oracle 1Z1-083 Study Guide Archives
NEW QUESTION # 140
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
(Choose two.)
- A. The rootpassword cannot be specified in a response file.
- B. The sudopassword can be specified in a response file.
- C. root.shcan be executed automatically by the Database Installer only if it is provided with root credentials.
- D. The sudopassword must be specified in a response file.
- E. orainstRoot.shcan be executed automatically by the Database installer by using sudoor root credentials.
- F. root.shcan be executed automatically by the Database installer only by using sudocredentials.
Answer: A,E
Explanation:
Explanation
NEW QUESTION # 141
Choose two. Which two are true about RMAN backups when using a media manager?
- A. A media manager is required to create RMAN image copies.
- B. By default, a request for a proxy copy may result in a backup set being created.
- C. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
- D. A media manager is required to create RMAN proxy copies.
- E. A media manager always writes RMAN requested backups to tape.
Answer: B,E
NEW QUESTION # 142
Which two are true about the Oracle dataabse methodology? (Choose two.)
- A. The database instance memory should always be tuned before tuning any file systems.
- B. The alert log should be used to find the database and instance areas most in need of tuning.
- C. SQL statements should always be tuned before tuning any file systems.
- D. Tuning activities should stop once the user is satisfied with performance.
- E. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
- F. Tuning activities should stop once agreed service levels for performance have been met.
Answer: C,E
NEW QUESTION # 143
Which three are performed by Oracle Automatic Storage Management (ASM) instances? (Choose three.)
- A. managing extent allocation for Oracle database segments
- B. acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes
- C. managing Allocation Units (AUs) for disk group content
- D. managing space allocation for Oracle ASM files
- E. acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)
- F. mounting disk groups
Answer: C,D,F
NEW QUESTION # 144
Which three are true about SGA memory management in a multitenant database? (Choose three.)
- A. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
- B. SGA_MIN_SIZE cannot be set for a PDB.
- C. The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.
- D. The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.
- E. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.
- F. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
Answer: B,E,F
NEW QUESTION # 145
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$SESSION_WAIT_CLASS
- B. V$SESSION_EVENT
- C. V$SESSTAT
- D. V$SESSION_WAIT
- E. V$SESSION
Answer: A
NEW QUESTION # 146
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
- A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the databased be in the MOUNT state.
- B. Backing up a database in ARCHIVE LOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
- C. An Oracle database can be restored from backup files copied using O/S utilities.
- D. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
- E. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
- F. Backing up a database in ARCHIVE LOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.
- G. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
Answer: C,E,G
NEW QUESTION # 147
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:
What is the outcome?
- A. Only the ORCL database instance and the +DATA and +FRA disk groups are started.
- B. Only the ORCL database and the ASM instances are started.
- C. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
- D. Only the ORCL database instance is started.
- E. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
Answer: E
Explanation:
Explanation
https://docs.oracle.com/html/E25494_01/start001.htm
NEW QUESTION # 148
You have configured RMAN SBT channels to write backups to medi
a. You then take an RMAN backup by using this command: Which three are true? (Choose three.)
- A. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
- B. The restore point is a label for the system change number (SCN) before the archival backup was taken.
- C. All archive logs created after this backup are kept for two years.
- D. The control file is included in the self-contained archival backup.
- E. The SPFILE is included in the self-contaied archival backup.
- F. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
Answer: D,E,F
NEW QUESTION # 149
Examine the query and its output executed In an RDBMS Instance: Which three statements are true about the users (other than sys) in the output?
- A. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
- B. TheC# # B_ADMIN user can perform all back up and recovery operation susing RMAN only.
- C. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
- D. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
- E. The C # # A_ADMIN user can perform wallet operations.
Answer: A,C,D
NEW QUESTION # 150
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 shut down.
- C. CDB1 is in MOUNT state
- D. PDB1 is closed.
- E. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
Answer: A,D
NEW QUESTION # 151
Choose three. Which three are true about upgrading an application in an application container?
- A. An application name and version number must be specified to upgrade the application.
- B. After an application upgrade, the application container's PDBs remain synchronized with the existing application root.
- C. The upgrade must be performed when connected to CDB$ROOT.
- D. After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.
- E. An application root clone gets created automatically.
- F. The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.
Answer: A,D,E
NEW QUESTION # 152
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. the archived log deletion policy
- B. the DB_RECOVERY_FILE_DEST parameter setting
- C. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
- D. the backup retention policy
- E. the backup optimization policy
- F. using guaranteed UNDO retention
Answer: C,D
NEW QUESTION # 153
Choose two. Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
- A. ata Recovery Advisor can be used if a database is in the NOMOUNT state.
- B. Data Recovery Advisor can be used if a database is closed.
- C. Data Recovery Advisor can proactively check for failures.
- D. Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.
- E. A failure can be closed only if the database is in MOUNT state.
Answer: C,D
NEW QUESTION # 154
Which three are true about an application seed pluggable database (PDB)? (Choose three.)
- A. It is automatically synchronized with its application root PDB when an application is upgraded.
- B. It cannot be added to an application container after the application container has already been created.
- C. It is automatically synchronized with its application root PDB when an application is installed.
- D. A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
- E. It is not required in an application container.
- F. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
- G. It cannot be dropped from its application container.
Answer: C,D,E
NEW QUESTION # 155
Which two are true about memory advisors? (Choose two.)
- A. If Automatic Memory Management is enabled, no memory advisors are available.
- B. 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.
- C. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
- D. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
- E. All memory advisors use data from Automatic Workload Repository.
Answer: A,D
NEW QUESTION # 156
......
1Z1-083 Questions Prepare with Learning Information: https://www.practicematerial.com/1Z1-083-exam-materials.html
Download 1Z1-083 Mock Test Study Material: https://drive.google.com/open?id=1JRqD1tr3vwyF7lV60y6TqNH6Cl8DQKPI
