单选题You executed the following PL/SQL block successfully：   VARIABLE tname VARCHAR2（20）  BEGIN dbms_addm.insert_finding_directive （NULL， DIR_NAME=>’Detail CPU Usage’， FINDING_NAME=>’CPU Usage’， MIN_ACTIVE_SESSIONS=>0， MIN_PERC_IMPACT=>90）；  ：tname ：= ’data

题目
单选题
You executed the following PL/SQL block successfully：   VARIABLE tname VARCHAR2（20）  BEGIN dbms_addm.insert_finding_directive （NULL， DIR_NAME=>’Detail CPU Usage’， FINDING_NAME=>’CPU Usage’， MIN_ACTIVE_SESSIONS=>0， MIN_PERC_IMPACT=>90）；  ：tname ：= ’database ADDM task4’； dbms_addm.analyze_db（：tname， 150， 162）；  END； /    Then you executed the following command：   SQL> SELECT dbms_addm.get_report（：tname） FROM DUAL；   The above command produces Automatic Database Diagnostic Monitor （ADDM） analysis（）
A

 with the CPU Usage finding if it is less than 90

B

 without the CPU Usage finding if it is less than 90

C

 with the CPU Usage finding for snapshots below 90

D

 with the CPU Usage finding for snapshots not between 150 and 162

相似考题

1.You executed the following PL／SQL block successfully:The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.()A. with the CPU Usage finding if it is less than 90B. without the CPU Usage finding if it is less than 90C. with the CPU Usage finding for snapshots below 90D. with the CPU Usage finding for snapshots not between 150 and 162

2.ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）A、vector B、database view C、database table D、transactional trigger E、PL/SQL table of records F、multi-dimensional array

3.When does a transaction complete?（）A、when a DELETE statement is executed B、when a ROLLBACK command is executed C、when a PL/SQL anonymous block is executed D、when a data definition language (DDL) statement is executed E、when a TRUNCATE statement is executed after the pending transact ion

4.Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:SQL> @utlrp.sqlWhat is the significance of executing this script?（）A. It performs parallel recompilation of only the stored PL/SQL code.B. It performs sequential recompilation of only the stored PL/SQL code.C. It performs parallel recompilation of any stored PL/SQL as well as Java code.D. It performs sequential recompilation of any stored PL/SQL as well as Java code.

更多“You executed the following PL/SQL block successfully：   VARI”相关问题

  • 第1题：

    You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）

    • A、 .SQL 
    • B、 .PLL 
    • C、 .PLD
    • D、 .PRT

    正确答案:B

  • 第2题：

    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）

    • A、 functions
    • B、 package
    • C、 procedure
    • D、 database trigger
    • E、 anonymous PL/SQL block

    正确答案:D

  • 第3题：

    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

    • A、Library cache 
    • B、Row cache
    • C、Dictionary cache 
    • D、Large area 
    • E、Buffer cache

    正确答案:B

  • 第4题：

    You issued the following block of code：        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL>/   Which option is NOT a result of executing the above code？（）  

    • A、 The switch privilege is granted to the PROG_ROLE role.
    • B、 The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
    • C、 The users cannot grant the switch privilege to other users.
    • D、 The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

    正确答案:D

  • 第5题：

    Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   Which statement describes the effect of the execution of the above PL/SQL block？（）  

    • A、 The plan baselines are verified with the SQL profiles.
    • B、 All fixed plan baselines are converted into nonfixed plan baselines.
    • C、 All the nonaccepted SQL profiles are accepted into the plan baseline.
    • D、 The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

    正确答案:D

  • 第6题：

    单选题
    Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）
    A

     The statement will be executed successfully， and a new time zone will be set for the database.

    B

     The statement will be executed successfully， but a new time zone will not be set for the database.

    C

     The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.

    D

     The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.


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

  • 第7题：

    多选题
    When does a transaction complete?（）
    A

    when a DELETE statement is executed

    B

    when a ROLLBACK command is executed

    C

    when a PL/SQL anonymous block is executed

    D

    when a data definition language (DDL) statement is executed

    E

    when a TRUNCATE statement is executed after the pending transact ion


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

  • 第8题：

    单选题
    You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL> SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）
    A

    Because 4194304 is the granule size

    B

    Because 4194304 is the standard block size

    C

    Because 4194304 is the largest nonstandard block size defined in the database

    D

    Because 4194304 is the total size of data already available in the database buffer cache


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

  • 第9题：

    单选题
    You issued the following block of code：        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL>/   Which option is NOT a result of executing the above code？（）
    A

     The switch privilege is granted to the PROG_ROLE role.

    B

     The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.

    C

     The users cannot grant the switch privilege to other users.

    D

     The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.


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

  • 第10题：

    单选题
    Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script：   SQL> @utlrp.sql   What is the significance of executing this script？（）
    A

     It performs parallel recompilation of only the stored PL/SQL code.

    B

     It performs sequential recompilation of only the stored PL/SQL code.

    C

     It performs parallel recompilation of any stored PL/SQL as well as Java code.

    D

     It performs sequential recompilation of any stored PL/SQL as well as Java code.


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

  • 第11题：

    单选题
    You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）
    A

     The code will be executed successfully.

    B

     The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.

    C

     The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.

    D

     The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.


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

  • 第12题：

    单选题
    You executed the following PL/SQL block successfully：   VARIABLE tname VARCHAR2（20）  BEGIN dbms_addm.insert_finding_directive （NULL， DIR_NAME=>’Detail CPU Usage’， FINDING_NAME=>’CPU Usage’， MIN_ACTIVE_SESSIONS=>0， MIN_PERC_IMPACT=>90）；  ：tname ：= ’database ADDM task4’； dbms_addm.analyze_db（：tname， 150， 162）；  END； /    Then you executed the following command：   SQL> SELECT dbms_addm.get_report（：tname） FROM DUAL；   The above command produces Automatic Database Diagnostic Monitor （ADDM） analysis（）
    A

     with the CPU Usage finding if it is less than 90

    B

     without the CPU Usage finding if it is less than 90

    C

     with the CPU Usage finding for snapshots below 90

    D

     with the CPU Usage finding for snapshots not between 150 and 162


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

  • 第13题：

    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）

    • A、function
    • B、package
    • C、procedure
    • D、database trigger
    • E、anonymous PL/SQL block

    正确答案:D

  • 第14题：

    Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script：   SQL> @utlrp.sql   What is the significance of executing this script？（）  

    • A、 It performs parallel recompilation of only the stored PL/SQL code.
    • B、 It performs sequential recompilation of only the stored PL/SQL code.
    • C、 It performs parallel recompilation of any stored PL/SQL as well as Java code.
    • D、 It performs sequential recompilation of any stored PL/SQL as well as Java code.

    正确答案:C

  • 第15题：

    You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）  

    • A、 The code will be executed successfully.
    • B、 The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.
    • C、 The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
    • D、 The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.

    正确答案:C

  • 第16题：

    You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

    • A、 by using the DBMS_REPAIR package
    • B、 by using the DBVERIFY utility
    • C、 by using Block Media Recovery
    • D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

    正确答案:C

  • 第17题：

    单选题
    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）
    A

    function

    B

    package

    C

    procedure

    D

    database trigger

    E

    anonymous PL/SQL block


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

  • 第18题：

    单选题
    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）
    A

    Library cache 

    B

    Row cache

    C

    Dictionary cache 

    D

    Large area 

    E

    Buffer cache


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

  • 第19题：

    单选题
    You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）
    A

    functions

    B

    packages

    C

    procedures

    D

    database triggers

    E

    anonymous PL/SQL block


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

  • 第20题：

    单选题
    You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered.  To verify the change in size， you executed this command： SQL> SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE  ------------------- ----------- ------------------  db_cache_size big integer 4194304  （4M）  Why is the value set to 4194304 and not to 2516582（）
    A

    because 4194304 is the granule size

    B

    because 4194304 is the standard block size

    C

    because 4194304 is the largest nonstandard block size defined in the database

    D

    because 4194304 is the total size of data already available in the database buffer cache


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

  • 第21题：

    单选题
    Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
    A

    FORMS_DDL 

    B

    DO_SQL 

    C

    FORM_SUCCESS 

    D

    FORM_NOT_SUCCESS

    E

    DBMS.ERROR_CODE


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

  • 第22题：

    单选题
    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）
    A

     functions

    B

     package

    C

     procedure

    D

     database trigger

    E

     anonymous PL/SQL block


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

  • 第23题：

    单选题
    You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）
    A

     The statement will fail.

    B

     The statement will be executed successfully， and the new time zone will be set for the database.

    C

     The statement will be executed successfully， but the new time zone will be set for the current session.

    D

    The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.


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

  • 第24题：

    单选题
    Examine the following PL/SQL block：   SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob；  BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END；   Which statement describes the effect of the execution of the above PL/SQL block？（）
    A

     The plan baselines are verified with the SQL profiles.

    B

     All fixed plan baselines are converted into nonfixed plan baselines.

    C

     All the nonaccepted SQL profiles are accepted into the plan baseline.

    D

     The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.


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

相关内容