单选题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 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
单选题
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
参考解析
解析：
暂无解析
相关考题：
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
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.
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
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
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、 .PLDD、 .PRT
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、functionB、packageC、procedureD、database triggerE、anonymous PL/SQL block
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、 functionsB、 packageC、 procedureD、 database triggerE、 anonymous PL/SQL block
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.
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 cacheC、Dictionary cache D、Large area E、Buffer cache
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.
You issued the following block of code： SQLBEGIN 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.
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 packageB、 by using the DBVERIFY utilityC、 by using Block Media RecoveryD、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
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.
单选题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？ （）AfunctionBpackageCprocedureDdatabase triggerEanonymous PL/SQL block
单选题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.
单选题You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）ALibrary cache BRow cacheCDictionary cache DLarge area EBuffer cache
多选题When does a transaction complete?（）Awhen a DELETE statement is executedBwhen a ROLLBACK command is executedCwhen a PL/SQL anonymous block is executedDwhen a data definition language (DDL) statement is executedEwhen a TRUNCATE statement is executed after the pending transact ion
单选题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？（）AfunctionsBpackagesCproceduresDdatabase triggersEanonymous PL/SQL block
单选题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（）ABecause 4194304 is the granule sizeBBecause 4194304 is the standard block sizeCBecause 4194304 is the largest nonstandard block size defined in the databaseDBecause 4194304 is the total size of data already available in the database buffer cache
单选题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（）Abecause 4194304 is the granule sizeBbecause 4194304 is the standard block sizeCbecause 4194304 is the largest nonstandard block size defined in the databaseDbecause 4194304 is the total size of data already available in the database buffer cache
单选题You issued the following block of code： SQLBEGIN 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.
单选题Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）AFORMS_DDL BDO_SQL CFORM_SUCCESS DFORM_NOT_SUCCESSEDBMS.ERROR_CODE
单选题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.
单选题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 functionsB packageC procedureD database triggerE anonymous PL/SQL block
单选题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.
单选题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.DThe statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
单选题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 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
单选题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.