网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
While performing monitoring and tuning the database, you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts?()
A
General
B
High Availability
C
Space Usage
D
Diagnostic Summary
参考答案
参考解析
解析:
暂无解析
更多 “单选题While performing monitoring and tuning the database, you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts?()A GeneralB High AvailabilityC Space UsageD Diagnostic Summary” 相关考题
考题
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()
A. The backup as copy can only be taken to diskB. The backup as copy can only be taken to tapeC. Backup can be performed only when the instance is shutdownD. Backup will constitute all used and unused blocks in the database
考题
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 using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task.()A、 Reregistering the target database in recovery catalogB、 Transporting the new tablespaces to the recovery catalog databaseC、 Syncronizing the recovery catalog with the target database control fileD、 Performing a fresh backup of the target database to include the new data files in the catalog database
考题
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 maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A、 redo log filesB、 password fileC、 control fileD、 change tracking file
考题
To view the results of the most recent Automatic SQL Tuning Advisor task,which sequence should you follow?() A、 EM Database home page,Software and Support,SQL Advisors,Automatic SQL Tuning AdvisorB、 EM Database home page,Software and Support,Advisor Central,SQL Advisors,Automatic SQL Tuning AdvisorC、 EM Database home page,Software and Support,Support Workbench,Advisor Central,SQL Advisors,Automatic SQL Tuning AdvisorD、 Either B or CE、 All of the above
考题
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. ()(Choose two.)A、Reregistering the target database in recovery catalogB、Transporting the new tablespaces to the recovery catalog databaseC、Syncronizing the recovery catalog with the target database control fileD、Performing a fresh backup of the target database to include the new data files in the catalog database
考题
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 want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()A、The backup as copy can only be taken to diskB、The backup as copy can only be taken to tapeC、Backup can be performed only when the instance is shutdownD、Backup will constitute all used and unused blocks in the database
考题
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company. You find a problem that there are three reports which are running slowly. And through detailed analysis, you conclude that no error messages are generated from these reports. Not only the indexing strategy but also the status of the current indexes is tested by you. You confirm that the slow performance of the financial reports is not caused by it. Since you are the technical support, you are required to find out which statement is causing the slow performance. Which action should be performed first?()A、SQL Server Profiler should be run with the Lock:Deadlock event class.B、The Database Engine Tuning Advisor (DTA) f should be run or at least one hour.C、SQL Server Profiler should be run with the TSQL_Duration template.D、The Database Engine Tuning Advisor (DTA) should be run with the default options.
考题
单选题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 want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()AThe backup as copy can only be taken to diskBThe backup as copy can only be taken to tapeCBackup can be performed only when the instance is shutdownDBackup will constitute all used and unused blocks in the database
考题
单选题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
考题
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?()A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database,the database will not be opened.
考题
单选题While performing monitoring and tuning the database, you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warning and critical level alerts?()A
GeneralB
High AvailabilityC
Space UsageD
Diagnostic Summary
考题
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?()A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database, the database will not be opened.
考题
单选题You observe that database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to, in order to determine the required size of the database buffer cache?()A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor (ADDM)
考题
单选题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
考题
单选题You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A
redo log filesB
password fileC
control fileD
change tracking file
考题
单选题You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to, in order to determine that required size of the database buffer cache? ()A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor (ADDM)
考题
单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?()A
Open the database in NORMAL modeB
Open the database in read-only modeC
Open the database in RESTRICTED modeD
Open the database with the RESETLOGS option
考题
单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?()A
You must have change tracking enabled in your databaseB
Your database must be running in NOARCHIVELOG modeC
To back up a tablespace, it must be in backup modeD
To back up a tablespace, it must first be taken offline
考题
单选题To view the results of the most recent Automatic SQL Tuning Advisor task,which sequence should you follow?()A
EM Database home page,Software and Support,SQL Advisors,Automatic SQL Tuning AdvisorB
EM Database home page,Software and Support,Advisor Central,SQL Advisors,Automatic SQL Tuning AdvisorC
EM Database home page,Software and Support,Support Workbench,Advisor Central,SQL Advisors,Automatic SQL Tuning AdvisorD
Either B or CE
All of the above
考题
单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?()A
You must have change tracking enabled in your databaseB
Your database must be running in NOARCHIVELOG modeC
To back up a tablespace,it must be in backup modeD
To back up a tablespace,it must first be taken offline
考题
单选题You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance. What action must you take to achieve this?()A
Run Segment AdvisorB
Run the SQL Tuning Advisor (STA)C
Run the Automatic Workload Repository (AWR) reportD
Run the SQL Access Advisor with a hypothetical workload
热门标签
最新试卷