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？ （）

相似题目

• The system analysts have requested heavy use of object features. The database design makes use of PL/SQL8 object types, methods, and LOB types. How do you work with these features on the client?（）

  A . Write client-side subprograms containing the PL/SQL8 constructs, and move them into an object group.  B . Write server-side subprograms, and call the subprograms from the form application.  C . Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.

  查看最佳答案

• 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

  查看最佳答案

• You execute the following PL/SQL:Which two statements are true?（）

  A . Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed. B . FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed. C . FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column. D . FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

  查看最佳答案

• 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.

  查看最佳答案

• 假定已经定义了一个名为arr_type的PL/SQL表类型，那么怎样实例化一个arr_type类型的变量（）

  A . v_arr arr_type; B . v_arr is arr_type; C . v_arr of arr_type; D . v_arr arr_type%type

  查看最佳答案

• Loran-C is which type of system（）.

  A . Reflected electron B . Electrical radiation C . Quarterpoint electrical navigation D . Hyperbolic radio navigatio

  查看最佳答案

• 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

  查看最佳答案

• A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition.  What happens to the PL/SQL procedure after the online table redefinition？（）

  A .  It remains valid. B .  It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used. C .  It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table. D .  It becomes invalid only if the storage parameters have been modified and it automatically gets  revalidated the next time it is used.

  查看最佳答案

• Which two PL/SQL8 features are supported in Oracle Forms?（）

  A . methods  B . object tables  C . object columns  D . collection types  E . object as stored procedure parameter

  查看最佳答案

• Which of the following are types of flow control？（）

  A .  buffering B .  cut-through C .  windowing D .  congestion avoidance E .  load balancing

  查看最佳答案

• Which of the following are types of flow control (Choose three.)（）。

  A . buffering B . cut-through C . windowing D . congestion avoidance E . load balancing

  查看最佳答案

• Which ones are the two type of ciphers？（）

  A .  Blocking cipher andnon-blocking cipher B .  CBC cipher and EBC cipher C .  Block cipher and Stream cipher D .  Blocker cipher and Streamer cipher E .  3DES cipher and AES cipher

  查看最佳答案

• Which of the following are types of members？（）

  A . non-registered users B . stores C . organizations D . products E . access grou

  查看最佳答案

• Which of the following are types of flow control?（）

  A . buffering B . cut-through C . windowing D . congestion avoidance E . loadbalancing

  查看最佳答案

• Which of the following are types of flow control? (Choose three.)（）

  A . buffering B . cut-through C . windowing D . congestion avoidance E . load balancing

  查看最佳答案

• Which two statements are true regarding a PL/SQL package body？（）

  A . It cannot be created without a package specification. B . It cannot invoke subprograms defined in other packages. C . It can contain only the subprograms defined in the package specification. D . It can be changed and recompiled without making the package specification invalid.

  查看最佳答案

• Which is the most serious type of fracture?（）

  A . Compound B . Greenstick C . Closed D . Crack

  查看最佳答案

• Which is not the type of Ionizing Radiation（）？

  查看最佳答案

• Which is one of the different types of the booth?

  查看最佳答案

• Which of the following is NOT one of the types of idioms?

  查看最佳答案

• Which of the following are types of manageable questions?

  查看最佳答案

• Which of the following types of organizations need cost accounting?

  查看最佳答案

• Which of the following is not a target type of ‘makefile'（）

  A．Ultimate target B．Intermediate target C．Label D．Dependency file

  查看最佳答案

• Which of the following is nota type of operating asset？

  A．inventory B．cash C．land D．investments

  查看最佳答案