Oracle 1z0-083 Exam Practice Questions (P. 1)
- Full Access (181 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #1
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
- AAll metrics are instance related.
- BCleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.Most Voted
- CA space usage management alert is automatically cleared after the underlying problem is resolved.Most Voted
- DThey are generated by SMON when a tablespace is 97% full.
- EMetrics are statistical counts for a specific unit.Most Voted
- FSTATISTICS_LEVEL must be set to ALL to generate alerts.
Correct Answer:
CEF
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 https://blogs.oracle.com/oem/how-to-clear-an-alert-v2
CEF
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 https://blogs.oracle.com/oem/how-to-clear-an-alert-v2
send
light_mode
delete
Question #2
While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)
- AIncrease the size of tape I/O buffers.
- BDisable FORCE LOGGING for the database.
- CIncrease the size of the database buffer cache.
- DEnable asynchronous disk I/O.Most Voted
- EIncrease the level of RMAN multiplexing.Most Voted
Correct Answer:
CE
CE

Boosting read performance during the RMAN backup's read phase can effectively be achieved by enabling asynchronous disk I/O and enhancing RMAN’s multiplexing level. Asynchronous I/O allows multiple read operations to occur simultaneously, reducing wait times and speeding up the overall process. Additionally, increasing RMAN multiplexing enables concurrent processing of multiple streams of backup data, further enhancing read performance and expediting the backup process. These two adjustments work together to optimize the efficiency of your backup operations under a compressed RMAN environment.
send
light_mode
delete
Question #3
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
- Ato specify a default tablespace in a PDB cloned from another PDB in the same CDB.
- Bto exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDBMost Voted
- Cto include specific user tablespaces only when relocating a PDB
- Dto specify the list of user tablespaces to include when moving a non-CDB to a PDBMost Voted
- Eto exclude a temp tablespace when plugging in a PDB
- Fto specify the list of tablespaces to include when creating a PDB from the CDB seed
Correct Answer:
EF
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/creating-and-removing-pdbs-with-sql-plus.html#GUID-1C47D543-8376-48AE-
A1AE-632316731D59
EF
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/creating-and-removing-pdbs-with-sql-plus.html#GUID-1C47D543-8376-48AE-
A1AE-632316731D59
send
light_mode
delete
Question #4
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
- AFLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- BFLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.Most Voted
- CFLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
- DFLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.Most Voted
- EFLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
- FFLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.Most Voted
Correct Answer:
ABC
Reference:
https://books.google.com.pk/books?id=0iwrL9P25Z0C&pg=PA35&lpg=PA35&dq=FLASHBACK+transaction+query+requires+undo+to+retrieve+all+versions+of+a
+row+that+existed+between+two+points+in+time&source=bl&ots=MJnYl5CZ1u&sig=ACfU3U0dWP-NPd-
U8uu3zbaoi3YZzT0FTQ&hl=en&sa=X&ved=2ahUKEwigi5_Jl9joAhXzUBUIHUh4DksQ6AEwAnoECAsQJg#v=onepage&q=FLASHBACK%20transaction%20query
%20requires%20undo%20to%20retrieve%20all%20versions%20of%20a%20row%20that%20existed%20between%20two%20points%20in%20time&f=false https://docs.oracle.com/cd/E18283_01/server.112/e17120/tables011.htm
ABC
Reference:
https://books.google.com.pk/books?id=0iwrL9P25Z0C&pg=PA35&lpg=PA35&dq=FLASHBACK+transaction+query+requires+undo+to+retrieve+all+versions+of+a
+row+that+existed+between+two+points+in+time&source=bl&ots=MJnYl5CZ1u&sig=ACfU3U0dWP-NPd-
U8uu3zbaoi3YZzT0FTQ&hl=en&sa=X&ved=2ahUKEwigi5_Jl9joAhXzUBUIHUh4DksQ6AEwAnoECAsQJg#v=onepage&q=FLASHBACK%20transaction%20query
%20requires%20undo%20to%20retrieve%20all%20versions%20of%20a%20row%20that%20existed%20between%20two%20points%20in%20time&f=false https://docs.oracle.com/cd/E18283_01/server.112/e17120/tables011.htm
send
light_mode
delete
Question #5
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx-preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)
- Aperforming checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
- Bcreating the oracle OS userMost Voted
- Ccreating the OSDBA (dba) groupMost Voted
- Dcreating the oraInventory (oinstall) groupMost Voted
- Ecreating the grid OS user
- Fconfiguring the OS for Oracle Automatic Storage Management shared storage access
Correct Answer:
CDF
Reference:
https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN2932
CDF
Reference:
https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN2932
send
light_mode
delete
All Pages