You want to determine if any of your data files are OMFs.
Which two methods could you use to determine you have any OMFs? (Choose two.)
A. Review the alert log for the instance.
B. Query the FILE_ID column of the DBA_DATA_FILES static view.
C. Query the FILE_NAME column of the DBA_DATA_FILES static view.
D. Review the INIT.ORA or SPFILE used to start the instance to see if the
DB_CREATE_FILE_DEST parameter is set.
E. Review the INIT.ORA file or SPFILE used to start the instance to see if the
DB_CREATE_FILE_DEST parameter and the DB_CREATE_ONLINE_LOG_DEST_n
parameter are set.
F. Review the INIT.ORA file or SPFILE used to start the instance to determine the data file
location for OMFs. Then, review these locations looking for data files whose name matches
the standard for OMFs.
答案是 AD
可是我覺得是AE , 各位認為呢。?
both D and E are correct in a sense.according to ILT, they are two different ways of allocating OMF's.
i want to say the answer is A and C, according to ILT 13-7.
btw, where do you see this question?
well, technically you can still "review" spfile by quering v$spparameter view, e.g.
select * from v$spparameter where name like 'db_create%';
but i agree AC are more likely to be correct.
it seems to me now questions are in 9i can be very tricky
最初由 oramind 发布
[B]well, technically you can still "review" spfile by quering v$spparameter view, e.g.
select * from v$spparameter where name like 'db_create%';
[/B]
没想到这一点,谢谢 oramind提醒!
最初由 oramind 发布
[B]well, technically you can still "review" spfile by quering v$spparameter view, e.g.
select * from v$spparameter where name like 'db_create%';
but i agree AC are more likely to be correct.
it seems to me now questions are in 9i can be very tricky