CMS专题

多选题You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time 

题目
多选题
You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）
A

Increase the size of redo log files

B

Increase the size of redo log buffer

C

Increase the number of redo log files

D

Place the redo log files on a separate disk

E

Decrease the number of redo log groups to two

F

Increate the number Log Writer （LGWR） process

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）

  • A、Memory Advisors
  • B、Segment Advisors
  • C、SQL Tuning and Access Advisors
  • D、Automated Workload Repository （AWR）
  • E、Automatic Database Diagnostic Monitor （ADDM）

正确答案:C

第2题：

You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）

  • A、All control files are opened
  • B、All redo files are opened
  • C、The password file is opened
  • D、The parameter file is opened
  • E、All online data files are opened

正确答案:B,E

第3题：

You work as a database administrator for Certkiller .com. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）

  • A、Enable instance failover
  • B、Configure shared server
  • C、Enable database failover
  • D、Enable connect-time failover
  • E、Enable Transparent Application Failover （TAF）

正确答案:D

第4题：

You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

  • A、Database Control
  • B、Management Server
  • C、Management Repository
  • D、Application Server Control
  • E、Oracle Management Agent

正确答案:E

第5题：

You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR：  ORA-12154：TNS：couldnot resolve service name  Which network configuration files would you look into to resolve this error？（）

  • A、snmp.ora
  • B、names.ora
  • C、spfile.ora
  • D、sqlnet.ora
  • E、listener.ora
  • F、tnsnames.ora

正确答案:D,F

第6题：

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

  • A、The DBMS_JOB package
  • B、The BACKUP_JOB package
  • C、The DBMS_BACKUP_RESTORE package
  • D、The calendar tool in the Operating System （OS）
  • E、The backup scheduler in Enterprise Manager （EM）
  • F、The DBMS_BACKUP_SCHEDULER packager inline mode

正确答案:E

第7题：

You work as a database administrator for Certkiller .com. In your organization， you have four databases， Certkiller DB01， Certkiller DB02， Certkiller DB03， and Certkiller DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）.  You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）

  • A、Control file
  • B、Password file
  • C、Parameter file
  • D、Online redo log file
  • E、Listener controller file
  • F、Server parameter file

正确答案:B

第8题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

  • A、Hot backup
  • B、Online backup
  • C、consistent backup
  • D、incremental backup
  • E、inconsistent backup

正确答案:C

第9题：

You work as a database administrator for Certkiller .com. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

  • A、The trace file
  • B、The fixed views
  • C、The data dictionary views
  • D、The operating system log fields
  • E、The dynamic performance views.

正确答案:E

第10题：

单选题
You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file？（）
A

USER_DUMP_DEST

B

CORE_DUMP_DEST

C

ALERT_LOG_DEST

D

ALERT_DUMP_DEST

E

TRACE_DUMP_DEST

F

BACKGROUND_DUMP_DEST


正确答案： D
解析： 暂无解析

更多相关问题
相关内容