网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Examine the following PL/SQL block: DECLARE my_plans pls_integer; BEGIN my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_id=> ?9twu5t2dn5xd?; END; Which statement is true about the plan being loaded into the SQL plan baseline by the above command?()
A
It is loaded with the FIXED status.
B
It is loaded with the ACCEPTED status.
C
It is not loaded with the ENABLED status.
D
It is not loaded with the ACCEPTED status.
参考答案
参考解析
解析:
暂无解析
更多 “单选题Examine the following PL/SQL block: DECLARE my_plans pls_integer; BEGIN my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_id= ?9twu5t2dn5xd?; END; Which statement is true about the plan being loaded into the SQL plan baseline by the above command?()A It is loaded with the FIXED status.B It is loaded with the ACCEPTED status.C It is not loaded with the ENABLED status.D It is not loaded with the ACCEPTED status.” 相关考题
考题
设在SQL Server 2008某数据库中有按如下格式定义的存储过程首部:CREATE PROC Pl@X int,@Y int,@Z int output AS…请补全下列调用该存储过程的语句。DECLARE@S intEXEC Pl 20,30,@S【7】
考题
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?()
A. ADR diagnostic filesB. all the optimizer statisticsC. initialization parameter settingsD. PL/SQL functions, procedures, and packagesE. the table and index definitions and actual data
考题
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.
考题
下列关于PL/SQL的说法正确的是()
A.PL/SQL是应用于各种数据库上的通用语言B.PL/SQL是过程化的SQL语言C.PL/SQL是只能在SQL*PLUS中运行D.在PL/SQL可以直接执行所有的SQL操作
考题
关于PL/SQL说法错误的是()。A、PL/SQL是达梦数据库的过程化语言B、PL/SQL并不能支持所有的SQL数据类型和SQL函数C、包括一整套的数据类型、条件结构、循环结构和异常处理结构D、PL/SQL可以执行SQL语句,SQL语句中也可以使用PL/SQL函数
考题
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
考题
Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?()A、ADR diagnostic filesB、all the optimizer statisticsC、initialization parameter settingsD、PL/SQL functions, procedures, and packagesE、the table and index definitions and actual data
考题
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
考题
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.
考题
下列关于PL/SQL的说法正确的是()A、PL/SQL是应用于各种数据库上的通用语言B、PL/SQL是过程化的SQL语言C、PL/SQL是只能在SQL*PLUS中运行D、在PL/SQL可以直接执行所有的SQL操作
考题
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 of the following methods can be used to detect block corruption?() A、 ANALYZE operationsB、 dbvC、 SQL queries that access the potentially corrupt blockD、 RMANE、 All of the above
考题
单选题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
考题
多选题Examine the following command used to perform incremental level 0 backup: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()AThe block change tracking data will be used only from the next incremental 0 backup.BThe incremental backup will use change tracking data for accomplishing the backup.CThe incremental backup will not use change tracking data for accomplishing the backup.DThe block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
考题
单选题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.
考题
单选题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
考题
多选题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?()A
functionsB
packagesC
proceduresD
database triggersE
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.
考题
单选题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 are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY BEGIN TRANSACTION DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY BEGIN CATCH DECLARE @ErrorMessage nvarchar(2000) DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE(),@ErrorSeverity=ERROR SEVERITY(),@ErrorState = ERROR STATE() RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState) END CATCH; You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do?()A
Add a COMMIT TRANSACTION command to the CATCH block.B
Remove the COMMIT TRANSACTION command from the TRY block.C
Add a ROLLBACK TRANSACTION command to the CATCH block.D
Add a ROLLBACK TRANSACTION command to the TRY block.
考题
单选题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.
考题
单选题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.
热门标签
最新试卷