Excellent 1Z0-083 Updated 2021 Dumps With 100% Exam Passing Guarantee
Best way to practice test for Oracle 1Z0-083
NEW QUESTION 67
Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)
- A. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.
- B. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.
- C. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.
- D. It can be used for applications and middleware.
- E. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.
Answer: B,C
Explanation:
Explanation
Reference https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwadd/rapid-homeprovisioning.
html#GUID-CCEC5960-EDA4-4A3F-9643-0CA308EA49AA
NEW QUESTION 68
Which two are true about the Optimizer Statistics Advisor?
- A. It can be run only manually.
- B. It can recommend changes to improve the statistics gathering process.
- C. It runs automatically every night by default.
- D. It can be run only automatically.
- E. It always analyzes all schemas in the database.
Answer: B,D
NEW QUESTION 69
Which two are true about server-generated alerts? (Choose two.)
- A. Stateful alerts must be created by a DBA after resolving the problem.
- B. Stateless alerts can be cleared manually.
- C. Stateful alerts are purged automatically from the alert history.
- D. Stateless alerts can be purged manually from the alert history.
- E. Stateless alerts are automatically cleared.
Answer: B,D
Explanation:
Explanation
Except for the tablespace space usage metric, which is database related, the other metrics are instance related.
Threshold alerts are also referred to as stateful alerts which are automatically cleared when an alert condition clears. Stateful alert appears in DBA_OUTSTANDING_ALERTS and when cleared go to DBA_ALERT_HISTORY. Other server-generated alerts correspond to specific database events such as ORA-* errors, "Snapshot too old" errors, Recovery Area Low on Free Space, Resumable Session Suspended.
These are non threshold based alerts, also referred to as stateless alerts. Stateless alerts go directly to the History table. +++ Most alerts (such as "Out of Space") are cleared automatically when the cause of the problem disappears. However, other alerts (such as generic alert log errors) are sent to you for notification and must be acknowledged by you. After taking the corrective measures, you acknowledge an alert by clearing or purging it. Clearing an alert sends the alert to the Alert History which is accessible from Monitoring sub menu.
Purging an alert removes it from the Alert History.
NEW QUESTION 70
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
- A. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- B. Oracle DBCA templates can store only logical structure and not database files.
- C. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
- D. The Data Warehouse template is most suitable when transaction response time is the key criterion.
- E. New templates can only be created by modifying an existing user-created template.
Answer: A,C
Explanation:
Reference:
https://docs.oracle.com/database/121/ADMQS/GUID-2B8A3B5E-D319-4377-8B22- 8BB67DCC9885.htm#ADMQS0235
NEW QUESTION 71
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? (Choose two.)
- A. after losing an UNDO tablespace that is in use
- B. after losing all copies of the control file
- C. after losing all members of the CURRENT online redo log group
- D. after losing all members of an INACTIVE online redo log group
- E. after losing a SYSAUX tablespace data file
Answer: B,C
NEW QUESTION 72
Which two are true about the character sets used in an Oracle database? (Choose two.)
- A. Single-byte character sets provide better performance than multibyte character sets.
- B. Unicode enables information from any language to be stored using a single character set.
- C. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).
- D. Single-byte character sets always use 7-bit encoding schemes.
- E. Single-byte character sets always use 8-bit encoding schemes.
- F. Multibyte character sets allow more efficient space utilization than single byte character sets.
Answer: A,B
Explanation:
Reference:
https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG166
NEW QUESTION 73
Examine this configuration:
1. CDB1 is an Oracle Database 12c Release 2 container database (CDB).
2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.
After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:
What is the outcome?
- A. It fails because PDB$SEED is in MIGRATE state.
- B. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
- C. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
- D. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
- E. It fails because PDB2 is not in UPGRADE state.
- F. Only CDB$ROOT and PDB$SEED are upgraded.
Answer: F
NEW QUESTION 74
The users tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace?
- A. The database must be registered in an RMAN catalog.
- B. Backups must be done incrementally.
- C. Backups must be contained in backup sets.
- D. Backups can be taken only if the database is in archivelog mode.
- E. Only consistent backups can be created.
- F. Backups can be done incrementally.
Answer: D,F
NEW QUESTION 75
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 all members of the current online redo log group
- B. after losing an undo tablespace that is in use
- C. after losing all copies of the control file
- D. after losing a sysaux tablespace data file
- E. after losing all members of an inactive online redo log group
Answer: C,D
NEW QUESTION 76
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
- A. It recompiles all stored PL/SQL code by using utlrp.sql.
- B. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
- C. It empties the RECYCLE BIN.
- D. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
- E. It increases tablespace size, if required, to meet upgrade requirements.
- F. It sets all user tablespaces to "read-only" before starting the upgrade.
Answer: A,B,E
NEW QUESTION 77
Which two are true about gathering optimizer statistics? (Choose two.)
- A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
- B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
- C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
- D. System statistics can be gathered only while connected to CDB$ROOT.
- E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
Answer: B,C
Explanation:
Explanation
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%2
NEW QUESTION 78
Which three are true about managing memory components in an Oracle database instance? (Choose three.)
- A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
- B. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
- C. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
- D. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
- E. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
- F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
Answer: A,C,F
NEW QUESTION 79
Which two are true about Oracle instance recovery? (Choose three.)
- A. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
- B. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
- C. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
- D. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
- E. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
- F. Recovery begins from the beginning of the CURRENT redo log group.
Answer: A,D,E
NEW QUESTION 80
Examine these queries and their output:
After a system crash, an instance restart and an attempted opening of the PDBs result in:
Which two are true?
- A. Data file 24 must be recovered while the CDB is opened.
- B. Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
- C. Data file 24 cannot be recovered while the CDB is opened.
- D. Data file 24 can be recovered while PDB2 is opened.
- E. Data file 24 must be recovered while PDB2 is closed.
Answer: B,D
NEW QUESTION 81
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 82
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It can recommend changes to improve the statistics gathering process.
- B. It runs automatically every night by default.
- C. It is part of the DBMS_STATS package.
- D. It is part of the DBMS_ADVISOR package.
- E. It always analyzes all schemas in the database.
- F. It can be run only manually.
Answer: A,C,F
Explanation:
https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf Reference:
https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2
NEW QUESTION 83
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)
- A. using Database Replay
- B. using operating system file copy utilities
- C. using Oracle Data Pump
- D. using the CREATE TABLE AS SELECT SQL statement
- E. using Database Upgrade Assistant
- F. using SQL Developer
Answer: C,D,F
Explanation:
Explanation
https://www.oracle.com/a/tech/docs/twp-upgrade-oracle-database-19c.pdf
NEW QUESTION 84
Which two are true about Oracle Flashback features?
- A. flashback query can retrieve redo records from online and archived redo log files.
- B. flashback drop can undrop an index when undropping a table.
- C. flashback version query can retrieve redo records from online and archived redo log files.
- D. flashback table can undrop a column.
- E. After a database is restored from flashback logs using the flashback database command, it is sometimes rolled forward using redo logs.
Answer: A,D
NEW QUESTION 85
Which two are true about creating RMAN backups for an Oracle container database?
- A. spfile backups can be created while connected to an application root PDB.
- B. The backup pluggable database command can be used to back up cdb$root.
- C. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
- D. The backup database command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
- E. The backup database plus archivelog command will back up archive logs when RMAN is connected to a PDB.
Answer: D,E
NEW QUESTION 86
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 is required to create RMAN image copies.
- C. By default, a request for a proxy copy may result in a backup set being created.
- D. A media manager always writes RMAN requested backups to tape.
- E. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
Answer: B,D
NEW QUESTION 87
......
Oracle Database Administration II Certification Sample Questions and Practice Exam: https://www.itpass4sure.com/1Z0-083-practice-exam.html
Real Exam Questions & Answers - Oracle 1Z0-083 Dump is Ready: https://drive.google.com/open?id=15xYhH2j36KyvfMJ6L8eytT90W8iWmpj0
