While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identi

题目

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)

  • A、An entry is created in the alert log file and the database instance continues to function normally
  • B、The log switch hangs occur for transactions until free space is available in the flash recovery area
  • C、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
  • D、The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
相似考题

1.【程序说明】 下列输出乘法口诀的程序，要求输出的格式如下，其中数字之间有3个空格。* 1 2 3 4 5 6 7 8 91 12 2 43 3 6 94 4 8 12 165 5 10 15 20 256 6 12 18 24 30 367 7 14 21 28 35 42 478 8 16 24 32 40 48 56 649 9 18 27 36 45 54 63 72 81【程序】CLEARSET TALK OFF(5)A＝1DO WHILE A＜=9?? STR(A，4)A＝A+1ENDDOA= (6)DO WHILE A＜=9? STR(A，4)B＝1DO WHILE B＜＝AP= (7)?? STR(P，4)B=B+1ENDDOA= (8)ENDDOSET TALK ONRETURN(5)A．?“*”B．? SPACE(3) +“*”C．? SPACE (3)+*D．SPACE(3) +“*”

2.When monitoring a system using /usr/bin/vmstat with an interval， the metrics under page pi and page po represent which of the following phrases？（）A、 The pages to and from paging space per secondB、 The page intervals and page operations per secondC、 The page interrupts and page operations per secondD、 The page segments transferred between pi and po devices per second

3.While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）A、 It would result in an error because the warning threshold cannot be more than the critical threshold.B、 The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.C、 The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.D、 Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.

4.三次动态地从右向左显示变量S内容的字幕程序:CLEARS-SPACE(80)+“热烈庆祝北京审半2008年奥运会成功!热烈呼唤!!”+SPACE(60)N-O【 】I=1DO WHILE 1<160@20,0 SAY SUBSTR(S,I,80)H=INKEY(0,1，”H”)I=1+2【 】【 】ENDDO

更多“While Monitoring the space usag”相关问题

  • 第1题：

    Network management saves time and money by automating which two tasks? （）

    • A、Configuring changes to hardware and software
    • B、Monitoring online purchasing
    • C、Monitoring user access to storage files
    • D、Monitoring and troubleshooting network devices

    正确答案:A,D

  • 第2题：

    An administrator is getting reports that a file server is responding slowly. Which of the following steps should the administrator take FIRST？（）

    • A、Remove unnecessary files on the server to free up hard disk space.
    • B、Defragment the server’s hard disks.
    • C、Compare monitoring results with the server baseline.
    • D、Add additional memory to reduce paging.

    正确答案:C

  • 第3题：

    While monitoring a system using vmstat， which of the following options most likely indicates that the system is CPU bound？（）

    • A、 r is greater than 40
    • B、 id is greater than 50
    • C、 sum of id and wa equals 50
    • D、 sum of us and sy equals 100

    正确答案:D

  • 第4题：

    单选题
    While monitoring a system that is CPU bound， which of the following output is most likely to occur？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第5题：

    单选题
    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


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

  • 第6题：

    单选题
    While monitoring a system using vmstat， which of the following options most likely indicates that the system is CPU bound？（）
    A

     r is greater than 40

    B

     id is greater than 50

    C

     sum of id and wa equals 50

    D

     sum of us and sy equals 100


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

  • 第7题：

    多选题
    While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed   that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.  Identify the two events that can occur in the event of a log switch？（）
    A

    An entry is created in the alert log file and the database instance continues to function normally

    B

    The log switch hangs occur for transactions until free space is available in the flash recovery area

    C

    The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area

    D

    The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented


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

  • 第8题：

    单选题
    While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）
    A

    It would result in an error because the warning threshold cannot be more than the critical threshold.

    B

    The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.

    C

    The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.

    D

    Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.


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

  • 第9题：

    单选题
    When monitoring a system using vmstat with an interval， the metrics under page po represent which of the following phrases？（）
    A

     The number pages over the limit

    B

     The pages to paging space per second

    C

     The number of page operations per second

    D

     The number of processes waiting for page out


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

  • 第10题：

    单选题
    How did the researchers do the experiment?
    A

    By inviting the volunteers to have a long class.

    B

    By asking the volunteers to pay attention to a clock.

    C

    By monitoring brain activity while volunteers are watching a picture.


    正确答案： B
    解析：
    细节理解题。根据文章第三段可知：研究人员通过观察12个志愿在看一幅画时的大脑活动来做研究。故选C项。

  • 第11题：

    多选题
    You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk. Proactively, which two options could you use to make more space available in the flash recovery？（）
    A

    Change the RMAN archived log deletion policy

    B

    Use the RMAN CROSSCHECK command to reclaim the archived log space

    C

    Change the RMAN retention policy to retain backups for a shorter period of time

    D

    Use OS command to move files from the flash recovery area to some other location


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

  • 第12题：

    A user is reporting that access to a file server is much slower than it has been. The system administrator completes a test of the server using a system monitoring tool and compares it to the previously taken baseline. The comparison shows that there are no significant changes in the use ofsystem resources.  Which of the following actions should be taken to resolve this users problem？（）

    • A、 Add additional RAM to the users PC
    • B、 Troubleshoot the users PC
    • C、 Add additional RAM to the server
    • D、 Add additional hard drive space to the server

    正确答案:B

  • 第13题：

    When monitoring a system using vmstat with an interval， the metrics under page po represent which of the following phrases？（） 

    • A、 The number pages over the limit
    • B、 The pages to paging space per second
    • C、 The number of page operations per second
    • D、 The number of processes waiting for page out

    正确答案:B

  • 第14题：

    You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.  The data should be spread across two data files.  A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）

    • A、set PCTFREE and PCTUSED to 50
    • B、specify extent allocation as Uniform
    • C、specify extent allocation as Automatic
    • D、create the tablespace as bigfile tablespace
    • E、create the tablespace as smallfile tablespace
    • F、set segment space management to Automatic
    • G、use the RESIZE clause while creating the tablespace

    正确答案:B,E,F

  • 第15题：

    单选题
    What’s the _____ of having a public open space where you can’t eat, drink or even simply hang out for a while?
    A

    sense

    B

    matter

    C

    case

    D

    opinion


    正确答案： A
    解析：
    句意为：你对一个你在那儿既不让吃也不让喝连简单的出去溜达一会儿都不行的一个公共露天场所有何看法？

  • 第16题：

    单选题
    When monitoring a system using /usr/bin/vmstat with an interval， the metrics under page pi and page po represent which of the following phrases？（）
    A

     The pages to and from paging space per second

    B

     The page intervals and page operations per second

    C

     The page interrupts and page operations per second

    D

     The page segments transferred between pi and po devices per second


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

  • 第17题：

    多选题
    Evaluate the following command and its output: Which two statements correctly interpret the output?（）
    A

    FREE_SPACE indicates only the space that is currently unallocated.

    B

    ALLOCATED_SPACE indicates only the space currently allocated and in use.

    C

    FREE_SPACE indicates only the space that is currently allocated and available for reuse.

    D

    ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.

    E

    FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.


    正确答案： E,B
    解析： 暂无解析

  • 第18题：

    多选题
    Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：  ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）
    A

    Drop and re-create the inbox.

    B

    Coalesce the ORDERS_IND index.

    C

    Coalesce the INDEXES tablespace.

    D

    Drop and re-create the ORDERS table.

    E

    Rebuild the index online and move it to another tablespace.


    正确答案： C,A
    解析： 暂无解析

  • 第19题：

    单选题
    You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）
    A

    DBMS_STATS 

    B

    DBMS_ALERT 

    C

    DBMS_SPACE 

    D

    DBMS_MONITOR 

    E

    DBMS_SERVER_ALERT

    F

    DBMS_SPACE_ADMIN


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

  • 第20题：

    单选题
    You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）
    A

    enable index monitoring and query the DBA_OBJECTS view

    B

    enable index monitoring and query the DBA_INDEXES view

    C

    enable index monitoring and query the V$OBJECT_USAGE view

    D

    enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view


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

  • 第21题：

    多选题
    Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES  While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available.  Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）
    A

    drop and re-create the index

    B

    coalesce the ORDERS_IND index

    C

    coalesce the INDEXES tablespace

    D

    drop and re-create the ORDERS table

    E

    rebuild the index online and move it to another tablespace


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

相关内容