1Z0-082 practice question 7 of 25
In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent…
Full set: 142 questionsThe command ALTER TABLESPACE salesq1 ADD DATAFILE; relies on Oracle Managed Files (OMF) to determine the location and name of the new datafile. For this command to succeed as written, the DBCREATEFILEDEST parameter must be set to a valid directory with sufficient space (C). By default, OMF creates a 100MB autoextensible datafile, so at least 100MB must be available. Alternatively, one could modify the command to explicitly specify the datafile path and name (B), which overrides the need for DBCREATEFILEDEST and will succeed if the specified location has enough space.
A. Ensure that DBRECOVERYFILEDEST and DBCREATEFILEDEST each specify with at least 50 Mb of available space: Incorrect. DBRECOVERYFILEDEST is for the FRA, not standard datafiles. Also, the default OMF datafile size is 100MB, so 50MB is insufficient.
D. Add the AUTOEXTEND ON clause with NEXT set to 100M: Incorrect. AUTOEXTEND concerns future growth of the file after it has been created. It does not help with the initial file creation itself.
E. Ensure that DBRECOVERYFILEDEST and DBCREATEFILEDEST each specify locations with at least 50 Mb of available space: Incorrect. This is a duplicate of the flawed logic in option A, concerning the wrong parameter and an insufficient amount of space.
1. Oracle Database 19c
Administrator's Guide
Chapter 13
"Using Oracle Managed Files"
Section "Creating Oracle Managed Files". It states: "When you issue an ALTER TABLESPACE ... ADD DATAFILE statement without a file name
a 100 MB OMF datafile is created in the default file system directory..."
2. Oracle Database 19c
Administrator's Guide
Chapter 2
"Creating and Configuring an Oracle Database"
Section "Specifying Initialization Parameters". It specifies that DBCREATEFILEDEST defines the location for OMF datafiles and tempfiles.
3. Oracle Database 19c
SQL Language Reference
"ALTER TABLESPACE". The syntax shows that the datafiletempfilespec clause is optional if OMF is enabled
but can be used to provide an explicit file specification.
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 10Which three statements are true about the Oracle Data Dictionary? (Choose three.)
