Why F?
you can drop datafiles of tablespace where are INDEXes only, then restart DB. It will fail as datafiles cannot be found so make them offline drop and open DB. From dictionary view extract DDLs to create indexes and save it in your notepad. Drop tablespace including contents. Create tablespace with the same name. Use DDLs to re-create indexes from your notepad.
Done. Tested in practice minutes ago.
A. CORRECT. SQL> create spfile from memory;
C. CORRECT drop the temporary tablespace and then create a new one and assign new one to the database users.
D. CORRECT. use orapwd to recreate
C is wrong. It is talking about datafile, not tablespace. If you delete a TEMP datafile, Oracle will recreate it autoamtically before opening the database.
C - is wrong, tempfile can be recreated automatically since 10g:
https://oracle-help.com/backup-and-recovery/recovery-recover-loss-temporary-tablespace/
F is correct i think (lost datafiles can be offline dropped and recreated, index can be rebuild without need of recovery)
So, my opinion: A, D, F
My opinion, A C and D
A. CORRECT. SQL> create spfile from memory;
B. WRONG. Not possible.
C. CORRECT. No harm to DB, only warning. Drop and recreate
D. CORRECT. use orapwd to recreate
E. WRONG. PFILE is just text file no need SQLPLUS. Just copy paste content of pararamterfrom alert_SID.log. save it as $ORACLE_HOME/dbs/initSID.ora via text editor or vi.
F. WRONG. Recovery needed
I think A - D - E.
A- create spfile from memory
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-SPFILE.html#GUID-D3E295B7-A3A4-43D3-8BBD-5CBE171A2E52
D- create password file using orapwd
https://www.thegeekdiary.com/how-to-create-the-oracle-password-file-using-orapwd-command/
E- create pfile from log
https://docs.oracle.com/en/database/oracle/oracle-database/18/tutorial-recover-a-lost-or-damaged-server-parameter-file/index.html#CreateSPFILE
E- is Incorrect
U can't create pfile from log only with sqlplus. You must use text editor for that.
"Locate the alert_ORCLCDB.log file, which you need to use to extract the initialization parameters and their values."
It will probably be because of my low level of English, but I don't understand the meaning of option E (A lost PFILE can be re-created alert.log using SQL * PLUS). Lost PFILE can be recreated from the alert.log and It can also be created using SQL*PLUS, but I don't understand both in that sentence...
I think there is a missing word:
"E : A lost PFILE can be re-created with alert.log using SQL*PLUS."
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RinD
Highly Voted 3 years, 2 months agoObserverPL
Highly Voted 3 years, 2 months agoflaviogcmelo
Most Recent 11 months agoKuraudio
6 months, 1 week ago_gio_
1 year, 1 month agoScottL
1 year, 3 months agohilaire
1 year, 7 months agoFranta1
1 year, 9 months agoleader79
2 years, 10 months agoarpz
2 years, 11 months agoNeil107
2 years, 12 months agoEric_F
2 years, 2 months agoEric_F
2 years, 2 months agoMarco_M
3 years, 2 months agoAldrid
3 years, 2 months agossseee
3 years, 2 months agoRogazan
3 years, 2 months agovkra
1 year, 5 months ago