최신Oracle Database 11g Certified Master Upgrade - 11gocmu무료샘플문제
문제1
Which of the following are prerequisite steps to transport a database? (Choose all that apply.)
Which of the following are prerequisite steps to transport a database? (Choose all that apply.)
정답: B,C,E
문제2
When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?
When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?
정답: B
문제3
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.
On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.
So you decided to perform incomplete recovery until 11:00
AM. All the archive logs needed to perform recovery are intact.
In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup.
Then you mounted the database. Identify the next set of commands that are required to accomplish the task?
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.
On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.
So you decided to perform incomplete recovery until 11:00
AM. All the archive logs needed to perform recovery are intact.
In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup.
Then you mounted the database. Identify the next set of commands that are required to accomplish the task?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제4
Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?
Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?
정답: D
문제5
You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message: SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORA' Using RMAN, how would you respond to this error?
You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message: SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORA' Using RMAN, how would you respond to this error?
정답: C
문제6
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
1.Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2.Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
1.Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2.Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
정답: D
문제7
Exhibit:
View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.
Which statement is true about the block corruption detected by the command?
Exhibit:
View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.
Which statement is true about the block corruption detected by the command?
정답: C
문제8
Which two statements about the SQL Management Base (SMB) are true? (Choose two.)
Which two statements about the SQL Management Base (SMB) are true? (Choose two.)
정답: A,D
문제9
You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed. What would be the appropriate order of operations to correct the situation?
a.Mount the database with the startup mount command.
b.Take the SYSTEM datafile offline with the alter database command.
c.Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.
d.Restore all SYSTEM tablespace-related datafiles from backup media.
e.Issue the recover tablespace SYSTEM command.
f.Issue the recover datafile SYSTEM_01.dbf command.
g.Open the database with the alter database open command.
h.Open the database with the alter database open resetlogs command.
You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed. What would be the appropriate order of operations to correct the situation?
a.Mount the database with the startup mount command.
b.Take the SYSTEM datafile offline with the alter database command.
c.Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.
d.Restore all SYSTEM tablespace-related datafiles from backup media.
e.Issue the recover tablespace SYSTEM command.
f.Issue the recover datafile SYSTEM_01.dbf command.
g.Open the database with the alter database open command.
h.Open the database with the alter database open resetlogs command.
정답: A
문제10
How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed?
How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed?
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제11
Which command would you use to determine what database backups are currently available for restore?
Which command would you use to determine what database backups are currently available for restore?
정답: A
문제12
What is the correct order of steps to perform an online database backup?
a.alter database begin backup;
b.alter database end backup;
c.Back up the database datafiles.
d.Back up the archive log files.
e.alter system switch logfile;
What is the correct order of steps to perform an online database backup?
a.alter database begin backup;
b.alter database end backup;
c.Back up the database datafiles.
d.Back up the archive log files.
e.alter system switch logfile;
정답: D
문제13
Which backup option defines a user-defined name for a backup?
Which backup option defines a user-defined name for a backup?
정답: C
문제14
Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?
Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)