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  |
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;
|
|
|
|
|
|
| few OCP related questions (1) [related to Backup/Recovery] [message #336386 is a reply to message #335081] |
Sat, 26 July 2008 04:22  |
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;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Dec 27 22:52:10 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
