Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

Question:When the database was created, UNDO_MANAGEMENT was set to AUTO in the parameter file, a directory was specified for the parameter DB_CREATE_FILE_DEST. An UNDO TABLESPACE named UNDOTBS1 is being created without using a data file subclause. Which statement will hold true?

a.        The creation of UNDOTBS1 fails
b.        Oracle places the file in $ORACLE_HOME/oradata/ directory
c.        Oracle creates a data file and placed it in $ORACLE_HOME/data directory
d.        Oracle creates a data file in the directory specified in DB_CREATE_FILE_DEST

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Related Hot Questions

Government Jobs Opening