In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
To ensure the command executes successfully, you can specify a path in the DATAFILE clause of the command where there is sufficient space available. This ensures the location has at least 100MB of available space to accommodate the new datafile. Alternatively, you can ensure that the DB_CREATE_FILE_DEST parameter specifies a location with at least 100MB of available space, as Oracle Managed Files (OMF) will handle the rest of the details for creating the datafile in that location. These actions ensure that the tablespace SALES_Q1 can successfully add a datafile without running into space issues.
BC are the correct one https://oracle-base.com/articles/9i/oracle-managed-files - Files typically have a default size of 100M - if OMF is used you do not need to specify a path for the new created datafile BUT we have to "ensure that the command executes successfully" so we need a location with at least 100 MB free space and we can ensure that with B or C
really? if my database using OMF i should not add a path for the datafile. The Database will do that for me !
yes, db does that for you, but if you want to specify the path, it also fine.
This B,C because the question says either one of the solution should work. Ina situation where there isn't enough space in the "db_create_file_dest" location, you either make sure to have enough space in "db_create_file_dest" or you can override by providing the path where there is enough space
i agree
Correct answers are B,C Answers A and E are false as OMF defaults to a file size of at least 100MB As for answer D, you can omit the AUTOEXTEND clause, the database will use the default value of AUTOEXTEND UNLIMITED instead. Using AUTOEXTEND ON won't ensure that the command executes successfully, as the file will be autoextensible either way. So the only possible answers left are B and C.
Well, first of all OMF is in use so no Need to specify a path for the new created datafile. Correct answers must be C, D https://oracle-base.com/articles/9i/oracle-managed-files
Oracle Managed Files (OMF) is used, so no need to specify a datafile location.
A - false; without specifying SIZE, a new OMF datafile is created with size of 100 MB in DB_CREATE_FILE_DEST, therefore 50 MB space is not enough B - true; when using ALTER TABLESPACE sales_q1 ADD DATAFILE '<filename>'; command, <filename> can specify path of location. When the location contains at least 100 MB of available space, a new OMF datafile can be created. C - true; DB_CREATE_FILE dest is a default directory where new OMF datafiles are created with default size 100 MB D - false; AUTOEXTEND ON does not cause there is enough space for a new datafile E - false; it is the same as aswer A - same words
it is c and d. c is correct because of omf and make sure we have 100m space coz it is the default size d is correct because even though autoextend and next have default values, it is no harm to statement execution.
good choice
Here the evidence that D is correct Very unfortunately, the default AUTOEXTEND ON NEXT size is 1 Database block (based on the blocksize of the tablespace). But if you create your Tablespace using OMF (i.e. where "db_create_file_dest" is configured), then Oracle defaults the initial size to 100MB and *also* defaults the AUTOEXTEND to ON with a of 100MB !
I think what you just quoted actually disproves D: if the autoextend is already automatically set ON with a next extent of 100M, then giving the exact same option wouldn't change anything and especially wouldn't help ensuring that the statement completes correctly.
BC is correct
BD is correct because in this case the database has both OMF and unmanaged files. with add data file clause, the path must be added