-
Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member. When you attempt to start the database, you receive the following errors:()
A . ALTER DATABASE DROP LOGFILE GROUP 1
B . ALTER DATABASE CLEAR LOGFILE GROUP 1
C . ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
D . ALTER DATABASE DROP LOGFILE MEMBER ’D:\REDO01.LOG&rsquo
-
In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?()
A . import the database from the last export
B . restore all the members in the group from the last backup
C . drop the lost member from the database and then add a new member to the group
D . restore all the database files from the backup and then perform a complete recovery
E . restore all the database files from the backup and then perform an incomplete recovery
-
The configuration of the online redo log files is as follows:
https://assets.asklib.com/images/image2/2018080117374454032.jpg
Based on this configuration, which statement is true?()
A . The LGWR process concurrently writes the redo log entries to both the members of a group.
B . When a member of a group becomes corrupt, the database crashes.
C . The sizes of the redo01a.log and redo01b.log online redo log members of group Group1 can be different.
D . When redo02a.log and redo02b.log files become corrupt, then the database operations will proceed as normal.
-
In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure. How would you recover the lost redo log member?()
A . import the database from the last export
B . restore all the members in the group from the last backup
C . drop the lost member from the database, and then add a new member to the group
D . restore all the database files from the backup, and then perform a complete recovery
E . restore all the database files from the backup, and then perform an incomplete recovery
-
Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end?()
A . current redo log and inactive redo log
B . checkpoint position to end of redo log
C . beginning of redo log to end of redo log
D . all redo logs before the point of last commit
E . beginning of redo log to checkpoint positio
-
Which of the following dynamic view would you query to identify the online CURRENT redo log group?()
A . V$LOG
B . V$LOFHIST
C . V$LOGFILE
D . V$LOG_HISTORY
-
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()
A . Shared pool
B . Control file
C . SGA
D . PGA
-
As a result of a media failure, the current online redo log group is corrupted. The database crashes, as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform? ()
A . Cancel-based
B . Recovery using a backup control file
C . Time-based
D . Change-based
-
During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information?()
A . V$LOGFILE
B . V$RECOVER_LOG
C . V$RECOVER_DATABASE
D . V$LOG_RECOVER
E . V$LOG
-
Which log includes a statement of the conduct,ability,and character of each crew member on the completion of a voyage().
A . Official Logbook
B . Department Logbook
C . Crew Logbook
D . Smooth Logbook
-
Which statement about recovering from the loss of a redo log group is true?()
A . If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
B . If the lost redo log group is CURRENT, you must clear the log file.
C . If the lost redo log group is ACTIVE, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.
D . If the lost redo log group is CURRENT, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.
-
You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?()
A . log01.log
B . logORCL01.log
C . 1_2.logALTER ROLLBACK SEGMENT
D . ora_1_asdf1234.log
-
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true? ()
A . Transactions are rolled back using redo log files.
B . Transactions are rolled forward using redo log files.
C . Transactions are rolled back using redo log files and archived log files.
D . Transactions are rolled forward using redo log files and rolled back using redo log files.
-
Which of the following parameters defines the location where Oracle should create archived redo logs?()
A . LOG_ARCHIVE_1
B . LOG_DESTINATION_1
C . LOG_ARCHIVED_DESTINATION_1
D . LOG_ARCHIVE_DEST_1
E . LOG_ARCHIVE_SOURCE_1
-
You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?()
A . ALTER DATABASE
B . ALTER SYSTEM
C . ALTER USER
D . ALTER REDO LOG
-
Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end? ()
A . current redo log and inactive redo log
B . checkpoint position to end of redo log
C . beginning of redo log to end of redo log
D . all redo logs before the point of last commit
E . beginning of redo log to checkpoint positio
-
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()
A . Writes buffers to disk
B . Writes current redo log number to datafile headers
C . Writes redo log information to disk
D . Reads information into memory for user
-
In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()
A . The database instance aborts.
B . The database operation temporarily halts till the member becomes available.
C . Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D . The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E . The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
-
Archived redo logs can be copied to more than one destination by Oracle.()
A . True
B . False
-
The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery()
A . Inactive and current redo log files are required to accomplish recovery.
B . Online and archived redo log files are required to accomplish instance recovery.
C . All redo log entries after the last checkpoint are applied from redo log files to data files.
D . All redo log entries recorded in the current redo log file until the checkpoint position are applied to data file
-
In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?()
A . Nothing happens
B . Oracle will automatically switch redo logs when detected
C . Oracle eventually won't allow new records to be added to the database
D . The instance crashe
-
Berkeley is one of the 14 founding members of the Association of American Universities.
-
He is not one of those_____members of the stff who red ’The.Times’nd tken interestHe is not one of those_____members of the stff who red ’The.Times’nd tken interest inrtnd philosophy.proficient B.
A.proficient
B.submissive
C.intellectual
D.structural
-
You are the network administrator for The network consists of a single Active Directory domain named All servers run Windows Server 2003.A member server named TestKing3 hosts files and folders. On TestKing3, you configure a normal backup to run every night. The backup data will be saved to magnetic tape, and a detailed log file will be generated. The backup job will use an account named BackupUser, which is a member of the Backup Operators group.One week later, you use your Administrator account credentials to log on to TestKing3. You start the Backup utility. However, no backup logs are available.You need to verify that the backup jobs are completing successfully.What should you do?()
A.Use a text editor to open C:\windows\security\logs\Backup.log. Search for the dates when backups were scheduled.
B. Start the Backup utility by using the Run As option. Provide the account credentials of BackupUser. From the Tools menu, select Report, and then select the most recent report.
C. Open the Removable Storage snap-in. Examine the properties of the most recently completed Work Queue object.
D. Open the Removable Storage snap-in, and then open the properties of the Operator Requests object. On the General tab, clear the Automatically delete completed requests option