Oracle Database 12c: RAC Administration — Question 51

A directory +DATA/ORCL/DATAFILE/USERS exists in ASM.
USERS is a user created directory; ORCL and DATAFILE are system generated directories.
Which two statements are true about user-created directories?

Answer options

• A. You can create subdirectories under the USERS directory.
• B. You cannot rename a user-created subdirectory.
• C. You cannot drop a directory containing aliases unless you delete the aliases first.
• D. You cannot create a user-defined directory at the root (+) level.
• E. You cannot create a nested subdirectory /USERS/2014 under USERS with a single CREATE DIRETORY command even if directory USER1 doesn’t exist.

Correct answer: D, E

Explanation

Option D is correct because user-defined directories cannot be created directly at the root level in ASM. Option E is also correct since the creation of nested subdirectories requires separate CREATE DIRECTORY commands, regardless of the existence of other directories.