Home » Other » Training & Certification » few OCP related questions (1) [related to Backup/Recovery] (Merged)
few OCP related questions (1) [related to Backup/Recovery] (Merged) [message #335081] Sun, 20 July 2008 21:31 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
Plz. help me in the answers to below :

QUESTION NO: 114
When importing a table into a database, the import process performs these tasks:
1. Triggers are imported.
2. Data is imported.
3. New tables are created.
4. Indexes are built.
5. Any bitmap, functional, and/or domain indexes are built.
6. Integrity constraints are enabled on the new tables.
Which option shows the tasks in the order in which they are performed?
A. 2, 3, 4, 1, 6, 5 B. 3, 2, 4, 1, 6, 5 C. 3, 2, 6, 4, 1, 5 D. 4, 2, 3, 1, 5, 6



QUESTION NO: 117
You configured automatic archive logging for the database. On the next startup the
database runs for a while, but then hangs. After checking the alert log, you determine
that all the online redo logs need archiving.
Which step was skipped when you set up automatic archive log?
A. LOG_ARCHIVE_DEST was not set in the parameter file.
B. LOG_ARCHIVE_START was not set in the parameter file.
C. alter database archivelog; was not executed in MOUNT mode.
D. LOG_ARCHIVE_MAX processes were not set in the parameter file.



QUESTION NO: 139
Examine the RMAN command:
SWITCH DATAFILE ‘/DISK3/user_data01.dbf’;
Which command do you need to issue before you issue the above command, so that
RMAN finds the file in the restored location of ‘DISK2/user_data01.dbf’?
A. RESTORE DATAFILE ‘/DISK2/user_data01.dbf’
B. RESTORE DATAFILE ‘/DISK3/user_data01.dbf’
C. SET NEWNAME FOR ‘/DISK3/user_data01.dbf’ TO ‘/DISK2/user_data01.dbf’
D. SET NEWNAME FOR ‘/DISK2/user_data01.dbf’ TO ‘/DISK3/user_data01.dbf’


QUESTION NO: 154
Management has decided that the database must be available 24 hours a day, 7 days a
week. Given this requirement, which type of backup is required?
A. user-managed backups. B. partial database backups.
C. consistent database backups. D. inconsistent database backups.
Answer: C
Explanation:
Consistent database backups are required for the database available 24 hours a day, 7 days a
week.
Incorrect Answers
A: User-managed backups will not provide 24 hours a day, 7 days a week database
availability.
B: Database backup should be consistent, not partial.
D: Database backup should be consistent.



QUESTION NO: 156
Your database runs in ARCHIVELOG mode, and is backed up every Sunday night
using RMAN scripts. On Friday your database crashes. Now you want to use the
backups from last Sunday night to restore your database. How can you do this?
A. You need to perform the restore manually, because your database was running in
ARCHIVELOG mode.
B. Issue the RECOVER command from within RMAN.
RMAN determines which data files to restore, and which archive logs to use.
C. Issue the RESTORE and RECOVER commands from within RMAN.
RMAN determines which data files to restore, and which archive logs to use.
D. Issue the RESTORE DATAFILES, RESTORE ARCHIVELOGS, and RECOVER
commands from within RMAN.
RMAN determines which data files to restore, and which archive logs to use.



QUESTION NO: 178
Assume your situation can be described as follows:
• A full backup taken using RMAN is available on disk.
• The current control files were NOT damaged and do not need to be restored.
• All data files are damaged or lost.
• The database is in NOARCHIVELOG mode.
Which RMAN command would be most appropriate to use in line 3 of the following
RMAN command set to restore and fully recover your database ?
1. RMAN> STARTUP MOUNT
2. RMAN> RESTORE DATABASE;
3. RMAN> _________
4. RMAN> ALTER DATABASE OPEN;
A. RECOVER DATABASE;
B. SWITCH DATAFILE ALL;
C. RESTORE CONTROL FILE;
D. RECOVER DATABASE USING BACKUP CONTROL FILE;
Re: few ocp questions (1) [related to B&R] [message #335114 is a reply to message #335081] Mon, 21 July 2008 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Backup and Recovery Basics
Backup and Recovery Advanced User's Guide
Backup and Recovery Reference

Then what is your opinion about the answers? Why?

Regards
Michel

few OCP related questions (1) [related to Backup/Recovery] [message #336386 is a reply to message #335081] Sat, 26 July 2008 04:22 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
Plz. help me in the answers to below :

QUESTION NO: 114
When importing a table into a database, the import process performs these tasks:
1. Triggers are imported.
2. Data is imported.
3. New tables are created.
4. Indexes are built.
5. Any bitmap, functional, and/or domain indexes are built.
6. Integrity constraints are enabled on the new tables.
Which option shows the tasks in the order in which they are performed?
A. 2, 3, 4, 1, 6, 5 B. 3, 2, 4, 1, 6, 5 C. 3, 2, 6, 4, 1, 5 D. 4, 2, 3, 1, 5, 6



QUESTION NO: 117
You configured automatic archive logging for the database. On the next startup the
database runs for a while, but then hangs. After checking the alert log, you determine
that all the online redo logs need archiving.
Which step was skipped when you set up automatic archive log?
A. LOG_ARCHIVE_DEST was not set in the parameter file.
B. LOG_ARCHIVE_START was not set in the parameter file.
C. alter database archivelog; was not executed in MOUNT mode.
D. LOG_ARCHIVE_MAX processes were not set in the parameter file.



QUESTION NO: 139
Examine the RMAN command:
SWITCH DATAFILE ‘/DISK3/user_data01.dbf’;
Which command do you need to issue before you issue the above command, so that
RMAN finds the file in the restored location of ‘DISK2/user_data01.dbf’?
A. RESTORE DATAFILE ‘/DISK2/user_data01.dbf’
B. RESTORE DATAFILE ‘/DISK3/user_data01.dbf’
C. SET NEWNAME FOR ‘/DISK3/user_data01.dbf’ TO ‘/DISK2/user_data01.dbf’
D. SET NEWNAME FOR ‘/DISK2/user_data01.dbf’ TO ‘/DISK3/user_data01.dbf’


QUESTION NO: 154
Management has decided that the database must be available 24 hours a day, 7 days a
week. Given this requirement, which type of backup is required?
A. user-managed backups. B. partial database backups.
C. consistent database backups. D. inconsistent database backups.
Answer: C
Explanation:
Consistent database backups are required for the database available 24 hours a day, 7 days a
week.
Incorrect Answers
A: User-managed backups will not provide 24 hours a day, 7 days a week database
availability.
B: Database backup should be consistent, not partial.
D: Database backup should be consistent.



QUESTION NO: 156
Your database runs in ARCHIVELOG mode, and is backed up every Sunday night
using RMAN scripts. On Friday your database crashes. Now you want to use the
backups from last Sunday night to restore your database. How can you do this?
A. You need to perform the restore manually, because your database was running in
ARCHIVELOG mode.
B. Issue the RECOVER command from within RMAN.
RMAN determines which data files to restore, and which archive logs to use.
C. Issue the RESTORE and RECOVER commands from within RMAN.
RMAN determines which data files to restore, and which archive logs to use.
D. Issue the RESTORE DATAFILES, RESTORE ARCHIVELOGS, and RECOVER
commands from within RMAN.
RMAN determines which data files to restore, and which archive logs to use.



QUESTION NO: 178
Assume your situation can be described as follows:
• A full backup taken using RMAN is available on disk.
• The current control files were NOT damaged and do not need to be restored.
• All data files are damaged or lost.
• The database is in NOARCHIVELOG mode.
Which RMAN command would be most appropriate to use in line 3 of the following
RMAN command set to restore and fully recover your database ?
1. RMAN> STARTUP MOUNT
2. RMAN> RESTORE DATABASE;
3. RMAN> _________
4. RMAN> ALTER DATABASE OPEN;
A. RECOVER DATABASE;
B. SWITCH DATAFILE ALL;
C. RESTORE CONTROL FILE;
D. RECOVER DATABASE USING BACKUP CONTROL FILE;
Re: few OCP related questions (1) [related to Backup/Recovery] [message #336420 is a reply to message #336386] Sat, 26 July 2008 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do YOU think it is and why?

Regards
Michel
Re: few OCP related questions (1) [related to Backup/Recovery] [message #336426 is a reply to message #336386] Sat, 26 July 2008 12:43 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Why repost the same message within a week?

Just to get the same answer from Michel?
Put some effort into this before asking us to do so.
Re: few OCP related questions (1) [related to Backup/Recovery] [message #336427 is a reply to message #336426] Sat, 26 July 2008 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing

I didn't remember this post but it seems I'm quite consistent in my answers. Smile

Regards
Michel
icon8.gif  Re: few OCP related questions (1) [related to Backup/Recovery] (Merged) [message #336500 is a reply to message #335081] Sun, 27 July 2008 22:35 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
i must say orafaqs have become pretty pathetic, in terms of helping out.

instead now moderators seem to be doing merging into the right (or should i saw the wrong forum) ; where no-one will help out.

instead will land up giving replies like
"What do YOU think it is and why?"


I put this in Backup/Recovery forum cause most questions are related to them.


and also fyi: Instead of answering 2 doubts, you ask me back again the answers. huh. if that was the case why would i post it ?

ppl. like Michel give me some links to docs. << DO YOU THINK I DONT KNOW THOSE DOCS.
Re: few OCP related questions (1) [related to Backup/Recovery] (Merged) [message #336501 is a reply to message #335081] Sun, 27 July 2008 22:48 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>DO YOU THINK I DONT KNOW THOSE DOCS.
I think you are incapable or unwilling to RTFM.

Nobody here owes you any answer.

If you are ever dissatisfied with time, tenor, tone or quality of any response, you are entitled to a full & complete refund.
Submit your refund request to /dev/null & await delivery.
Re: few OCP related questions (1) [related to Backup/Recovery] (Merged) [message #336577 is a reply to message #335081] Mon, 28 July 2008 04:07 Go to previous message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
i am not even interested Laughing
Previous Topic: snapshot too old error
Next Topic: OCP 10g
Goto Forum:
  


Current Time: Thu Mar 28 17:26:33 CDT 2024