No literal value is substituted for a shared cursor.
Different execution plans are generated for substituted literal values.
The substitution of a literal value will produce different execution plans.
The substitution of any literal value will produce exactly the same execution plan.
第1题:
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
第2题:
package test; class Target{ public String name="hello"; } What can directly access and change the value of the variable name?()
第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:()
第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?()
第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?()
第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?()
第7题:
Value: 3
Value: 8
Value: 13
Compilation fails.
The code runs with no output.
An exception is thrown at runtime.
第8题:
Foo has the value “”
Foo has the value null
An exception is thrown
The code will not compile
第9题:
Foo has the value of “”
Foo has the value of null.
Foo has the value of “blue”
Foo has the value of “green”
An exception is thrown.
The code will not compile.
第10题:
Value is: 8
Compilation fails.
Value is: 12
Value is: -12
The code runs with no output.
An exception is thrown at runtime.
第11题:
any class
only the Target class
any class in the test package
any class that extends Target
第12题:
Slow down the spread of fire by cooling adjacent structures
Cover the fire with foam
Smother the fire with a blanket or similar object
Break up solid objects to ensure that any deep seated fires are extinguished
第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?()
第14题:
Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?()
第15题:
For SLIP to work, what should the "Enable Login" value be set to on both systems?()
第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?()
第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’?()
第18题:
assert value == null;
assert value != null, value is null;
if (value == null) { throw new AssertionException(value is null); }
if (value == null) { throw new IllegalArgumentException(value is null); }
第19题:
MED
origin
preference
local preference
第20题:
Foo has the value of “”
Foo has the value of null.
Foo has the value of “blue”
Foo has the value of “green”
An exception is thrown.
The code will not compile.
第21题:
a faster value on the fastest heartbeat network.
a slower value on the slowest heartbeat network.
a faster value on the slowest heartbeat network.
a slower value on the fastest heartbeat network.
第22题:
Foo has the value “”
Foo has the value null
An exception is thrown
The code will not compile
第23题:
assert value == null;
assert value !null, “value is null”;
if (value == null) { throw new AssertionException(”value is null”);
if (value == null) { throw new IllegalArgumentException(”value is null”);