网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
- A、The online redo log files and online data files are opened.
- B、All the online data file headers are checked for consistency.
- C、Instance recovery is performed before opening the database.
- D、The path and existence of all the log file members are checked
参考答案
更多 “ After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL ALTER DATABASE OPEN； Which two statements are true（）A、The online redo log files and online data files are opened.B、All the online data file headers are checked for consistency.C、Instance recovery is performed before opening the database.D、The path and existence of all the log file members are checked” 相关考题
考题
After performing a copy backup of a file server, the archive bit on the backed up files will be which of the following?()
A. DeletedB. UnchangedC. SetD. Copied
考题
After performing the initial steps in installing the server OS from a DVD-ROM， the server reboots and goes back into the setup wizard. Which of the following is the MOST likely cause for this problem？（）A、The DVD-ROM drive has failed.B、An installation file copied from the DVD to the hard drive is corrupt.C、Faulty OS installation DVDD、Incorrect boot sequence in the BIOS
考题
You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
考题
You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option. What will NOT be the impact of using the RESETLOGS option？（）A、 The log sequence for the database will restart from 1.B、 The log sequence number will be written to the control file.C、 The log sequence number will be written to the datafile headers.D、 The log sequence number will be written to the initialization parameter file.
考题
Which of the following will corrupt the BIOS?（）A、Applying the BIOS settings in the incorrect orderB、Power being lost during the upgrade processC、Installing the OS before applying the BIOS upgradeD、Imaging the system after performing a BIOS upgrade
考题
After performing a copy backup of a file server， the archive bit on the backed up files will be which of the following？（）A、 DeletedB、 UnchangedC、 SetD、 Copied
考题
When is it advisable to dump the waste toner from a technicians service vacuum？（）A、When it is full.B、It is not recommended.C、Before performing preventative maintenance.D、After each call.
考题
An application fails to start after a Technology Level upgrade. The application vendor recommends that two filesets upgraded as part of the new Technology Level be rejected. What is the recommended method for performing this task?（）A、Run instfix -u to reject the filesets.B、Run installp -r to reject the filesets.C、Run installp -u to uninstall the filesets.D、Restore the system to previous state from the system backup.
考题
An administrator will be performing a PowerHA upgrade on a cluster from version 5.3 to version 5.5. Which ofthe following tasks will verify a successful migration？（）A、Use the clstat command and verify the cluster is in a stable stateB、After each node is upgraded， run a verification and synchronizationC、After all nodes are upgraded， run a verification and synchronizationD、Take a snapshot of each node and verify the configuration is the same
考题
After rebooting the machine, Companycom notices that the machine is not performing as well as before. The applications are running slower, and their CPU utilization has increased. How can the customer check to see if a CPU was deallocated?（）A、Run the vmstat commandB、Run the iostat commandC、Run the lparstat commandD、Check the logs in the /var/adm/ras directory
考题
A system administrator needs to replace a mirrored disk. After performing the proper removal process and replacing the disk, which of the following set of commands should be performed to bring the disk back into production?（）A、 reboot, mklvcopy, syncvg B、 cfgmgr -vl ssar, chvg -va, syncvg C、 cfgmgr, extendvg, syncvg D、 extendvg, mklvcopy, syncvg
考题
You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead， you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective？（）A、AFTER CREATEB、AFTER SUSPENDC、BEFORE CREATED、AFTER TRUNCATEE、BEFORE SUSPENDF、AFTER INSERT OR DELETE OR DELETEG、BEFORE INSERT OR DELETE OR DELETE
考题
The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command： RMANCONFIGURE MAXSETSIZE 10MB； What will be the impact of the above setting？（）A、 While performing the backup of the datafile，data1.dbf，one backup set is created.B、 While performing the backup of the datafile，data1.dbf，two backup sets are created.C、 While performing the backup of the datafile，data1.dbf，three backup sets are created.D、 While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.
考题
You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）A、 user managed complete recoveryB、 user managed incomplete recoveryC、 RMAN-based complete recoveryD、 RMAN-based incomplete recovery
考题
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? （）A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
考题
单选题The size of the largest datafile， data1.dbf， in your database is 30MB. You issued the following command： RMANCONFIGURE MAXSETSIZE 10MB； What will be the impact of the above setting？（）A
While performing the backup of the datafile，data1.dbf，one backup set is created.B
While performing the backup of the datafile，data1.dbf，two backup sets are created.C
While performing the backup of the datafile，data1.dbf，three backup sets are created.D
While performing the backup of the datafile，data1.dbf，the command for performing a backup of the datafile，data1.dbf，will fail.
考题
单选题After performing a modification on the /etc/ssh/sshd_config file the operator needs to reinitialize the secure shell daemon to enable the new settings. Which of the following is the correct way to achieve this?（）A
Use refresh -s sshdB
Use init.sshd /etc/rc.sshC
Use /usr/sbin/sshd -restartD
Use stopsrc -s sshd and then startsrc -s sshd
考题
单选题You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）A
user managed complete recoveryB
user managed incomplete recoveryC
RMAN-based complete recoveryD
RMAN-based incomplete recovery
考题
单选题You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option. What will NOT be the impact of using the RESETLOGS option？（）A
The log sequence for the database will restart from 1.B
The log sequence number will be written to the control file.C
The log sequence number will be written to the datafile headers.D
The log sequence number will be written to the initialization parameter file.
考题
单选题After performing the initial steps in installing the server OS from a DVD-ROM， the server reboots and goes back into the setup wizard. Which of the following is the MOST likely cause for this problem？（）A
The DVD-ROM drive has failed.B
An installation file copied from the DVD to the hard drive is corrupt.C
Faulty OS installation DVDD
Incorrect boot sequence in the BIOS
考题
单选题A system administrator needs to replace a mirrored disk. After performing the proper removal process and replacing the disk, which of the following set of commands should be performed to bring the disk back into production?（）A
reboot, mklvcopy, syncvg B
cfgmgr -vl ssar, chvg -va, syncvg C
cfgmgr, extendvg, syncvg D
extendvg, mklvcopy, syncvg
考题
单选题By saying “You have left the door wide open”, a speaker might be performing the three acts: locutionary, illocutionary and perlocutionary _____.A
at the same timeB
one after anotherC
two first and then the otherD
one first and then the other two
考题
多选题After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
考题
单选题Which of the following will corrupt the BIOS？（）A
Applying the BIOS settings in the incorrect orderB
Power being lost during the upgrade processC
Installing the OS before applying the BIOS upgradeD
Imaging the system after performing a BIOS upgrade
考题
单选题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? （）A
to minimize plan regression due to the use of a new optimizer versionB
to completely avoid the use of new plans generated by a new optimizer versionC
to prevent plan capturing when the SQL statement is executed after the database upgradeD
to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
考题
多选题After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
考题
单选题After performing a copy backup of a file server， the archive bit on the backed up files will be which of the following？（）A
DeletedB
UnchangedC
SetD
Copied
热门标签
最新试卷
