itgle.com

单选题Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by ‘safe literals only’?()A No literal value is su

题目
单选题
Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by ‘safe literals only’?()
A

No literal value is substituted for a shared cursor. 

B

Different execution plans are generated for substituted literal values. 

C

The substitution of a literal value will produce different execution plans. 

D

The substitution of any literal value will produce exactly the same execution plan.


相似考题
更多“单选题Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by ‘safe literals only’?()A No literal value is su”相关问题
  • 第1题:

    Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()

    A. Bind Variable Peeking

    B. SQL Plan Baselines

    C. Adaptive Cursor Sharing

    D. Bind variable used in a SQL statement

    E. Literals in a SQL statement


    参考答案:A, C, E

  • 第2题:

    package test; class Target{ public String name="hello"; } What can directly access and change the value of the variable name?()

    • A、any class
    • B、only the Target class
    • C、any class in the test package
    • D、any class that extends Target

    正确答案:C

  • 第3题:

    During routine examination of the log files,a message similar to "TS_DMS_WRINING_ST" was discovered. To avoid future problems,change the Network Module failure detection rate to:()

    • A、 a faster value on the fastest heartbeat network.
    • B、 a slower value on the slowest heartbeat network.
    • C、 a faster value on the slowest heartbeat network.
    • D、 a slower value on the fastest heartbeat network.

    正确答案:B

  • 第4题:

    11. public void someMethod(Object value) {  12. // check for null value ....  20. System.out.println(value.getClass());  21. }  What, inserted at line 12, is the appropriate way to handle a null value?() 

    • A、 assert value == null;
    • B、 assert value !null, “value is null”;
    • C、 if (value == null) { throw new AssertionException(”value is null”);
    • D、 if (value == null) { throw new IllegalArgumentException(”value is null”);

    正确答案:D

  • 第5题:

    Given a method that must ensure that its parameter is not null: 11. public void someMethod(Object value) { 12. // check for null value ... 20. System.out.println(value.getClass()); 21. } What inserted at line 12, is the appropriate way to handle a null value?()

    • A、assert value == null;
    • B、assert value != null, "value is null";
    • C、if (value == null) { throw new AssertionException("value is null"); }
    • D、if (value == null) { throw new IllegalArgumentException("value is null"); }

    正确答案:D

  • 第6题:

    Given: 1.package test; 2. 3.class Target { 4.public String name = "hello";5.} What can directly access and change the value of the variable name?()

    • A、any class
    • B、only the Target class
    • C、any class in the test package
    • D、any class that extends Target

    正确答案:C

  • 第7题:

    单选题
    public class Foo {  public int a;  public Foo() { a = 3; }  public void addFive() { a += 5; }  }  and:  public class Bar extends Foo { public int a;  public Bar() { a = 8; }  public void addFive() { this.a +=5; }  }  invoked with:  Foo foo = new Bar();  foo.addFive();  System.out.println(”Value: “+ foo.a);  What is the result?()
    A

     Value: 3

    B

     Value: 8

    C

     Value: 13

    D

     Compilation fails.

    E

     The code runs with no output.

    F

     An exception is thrown at runtime.


    正确答案: F
    解析: 暂无解析

  • 第8题:

    单选题
    int index = 1;  String [] test = new String[3];  String foo = test[index];     What is the result?()
    A

     Foo has the value “”

    B

     Foo has the value null

    C

     An exception is thrown

    D

     The code will not compile


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

  • 第9题:

    单选题
    String foo = “blue”;    Booleanbar = new Boolean [1];    if (bar[0]) {    foo = “green”;    }   What is the result?()
    A

     Foo has the value of “”

    B

     Foo has the value of null.

    C

     Foo has the value of “blue”

    D

     Foo has the value of “green”

    E

     An exception is thrown.

    F

     The code will not compile.


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

  • 第10题:

    单选题
    1. public class SimpleCalc {  2. public int value;  3. public void calculate() { value += 7; }  4. } And:  1. public class MultiCalc extends SimpleCalc {  2. public void calculate() { value -= 3; }  3. public void calculate(int multiplier) {  4. calculate();  5. super.calculate();  6. value *=multiplier;  7. }  8. public static void main(String[] args) {  9. MultiCalc calculator = new MultiCalc();  10. calculator.calculate(2);  11. System.out.println(”Value is: “+ calculator.value);  12. }  13. }  What is the result?()
    A

     Value is: 8

    B

     Compilation fails.

    C

     Value is: 12

    D

     Value is: -12

    E

     The code runs with no output.

    F

     An exception is thrown at runtime.


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

  • 第11题:

    单选题
    package test;  class Target {  public String name = “hello”;  }  What can directly access and change the value of the variable name?()
    A

     any class

    B

     only the Target class

    C

     any class in the test package

    D

     any class that extends Target


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

  • 第12题:

    单选题
    What is meant by the term overhaul in firefighting?()
    A

    Slow down the spread of fire by cooling adjacent structures

    B

    Cover the fire with foam

    C

    Smother the fire with a blanket or similar object

    D

    Break up solid objects to ensure that any deep seated fires are extinguished


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

  • 第13题:

    1. public class SimpleCalc {  2. public int value;  3. public void calculate() { value += 7; }  4. } And:  1. public class MultiCalc extends SimpleCalc {  2. public void calculate() { value -= 3; }  3. public void calculate(int multiplier) {  4. calculate();  5. super.calculate();  6. value *=multiplier;  7. }  8. public static void main(String[] args) {  9. MultiCalc calculator = new MultiCalc();  10. calculator.calculate(2);  11. System.out.println(”Value is: “+ calculator.value);  12. }  13. }  What is the result?() 

    • A、 Value is: 8
    • B、 Compilation fails.
    • C、 Value is: 12
    • D、 Value is: -12
    • E、 The code runs with no output.
    • F、 An exception is thrown at runtime.

    正确答案:A

  • 第14题:

    Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()

    • A、Bind Variable Peeking
    • B、SQL Plan Baselines
    • C、Adaptive Cursor Sharing
    • D、Bind variable used in a SQL statement
    • E、Literals in a SQL statement

    正确答案:A,C,E

  • 第15题:

    For SLIP to work, what should the "Enable Login" value be set to on both systems?()

    • A、Enable
    • B、Disable
    • C、Share
    • D、Delay

    正确答案:B

  • 第16题:

    public class Foo {  public int a;  public Foo() { a = 3; }  public void addFive() { a += 5; }  }  and:  public class Bar extends Foo { public int a;  public Bar() { a = 8; }  public void addFive() { this.a +=5; }  }  invoked with:  Foo foo = new Bar();  foo.addFive();  System.out.println(”Value: “+ foo.a);  What is the result?() 

    • A、 Value: 3
    • B、 Value: 8
    • C、 Value: 13
    • D、 Compilation fails.
    • E、 The code runs with no output.
    • F、 An exception is thrown at runtime.

    正确答案:A

  • 第17题:

    Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by ‘safe literals only’?() 

    • A、No literal value is substituted for a shared cursor. 
    • B、Different execution plans are generated for substituted literal values. 
    • C、The substitution of a literal value will produce different execution plans. 
    • D、The substitution of any literal value will produce exactly the same execution plan.

    正确答案:D

  • 第18题:

    单选题
    Given a method that must ensure that its parameter is not null: 11. public void someMethod(Object value) { 12. // check for null value ... 20. System.out.println(value.getClass()); 21. } What inserted at line 12, is the appropriate way to handle a null value?()
    A

    assert value == null;

    B

    assert value != null, value is null;

    C

    if (value == null) { throw new AssertionException(value is null); }

    D

    if (value == null) { throw new IllegalArgumentException(value is null); }


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

  • 第19题:

    单选题
    In JUNOS software, what is the only BGP attribute where a higher value is preferred?()
    A

    MED

    B

    origin

    C

    preference

    D

    local preference


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

  • 第20题:

    单选题
    String foo = “blue”;  Boolean[]bar = new Boolean [1];  if (bar[0])  {  foo = “green”;  }   What is the result? ()
    A

     Foo has the value of “”

    B

     Foo has the value of null.

    C

     Foo has the value of “blue”

    D

     Foo has the value of “green”

    E

     An exception is thrown.

    F

     The code will not compile.


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

  • 第21题:

    单选题
    During routine examination of the log files,a message similar to "TS_DMS_WRINING_ST" was discovered. To avoid future problems,change the Network Module failure detection rate to:()
    A

     a faster value on the fastest heartbeat network.

    B

     a slower value on the slowest heartbeat network.

    C

     a faster value on the slowest heartbeat network.

    D

     a slower value on the fastest heartbeat network.


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

  • 第22题:

    单选题
    int index = 1;   String test = new String;   String foo = test[index];  What is the result?()
    A

      Foo has the value “”

    B

     Foo has the value null

    C

     An exception is thrown

    D

     The code will not compile


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

  • 第23题:

    单选题
    11. public void someMethod(Object value) {  12. // check for null value ....  20. System.out.println(value.getClass());  21. }  What, inserted at line 12, is the appropriate way to handle a null value?()
    A

     assert value == null;

    B

     assert value !null, “value is null”;

    C

     if (value == null) { throw new AssertionException(”value is null”);

    D

     if (value == null) { throw new IllegalArgumentException(”value is null”);


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