Exam 1z0-082 topic 1 question 58 discussion

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

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

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.

BC is correct

good choice

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

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.

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 !

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