Tag: performance

Questions Related to performance

Leaf nodes of B*Tree index are connected by
technology performance

  1. Doubly Linked list

  2. Singly linked list

  3. Pointers

  4. Structures

Show answer
Correct Option: A

Different steps in SQL execution
technology performance

  1. a. Parse

  2. b. Fetch

  3. c. Retrieve

  4. d. Bind

  5. e. Execute

Show answer
Correct Option: A,B,D,E

Hard parse is expensive than Soft Parse

technology performance

  1. True

  2. False

Show answer
Correct Option: A

Ideal Elapsed time for a SQL in OLTP type of Application
technology performance

  1. Less than 10ms

  2. 100ms

  3. 150ms

  4. 50ms

Show answer
Correct Option: A

Usage of Hints is advisable in a SQL statement
technology performance

  1. True

  2. False

Show answer
Correct Option: B

Provision should be there for Blind searches
technology performance

  1. True

  2. False

Show answer
Correct Option: B

Which of the following can be used as first steps to tune SQL Statements
technology performance

  1. Explain Plan

  2. Trace

  3. Parse

  4. Bind

Show answer
Correct Option: A,B

Ideal Blocks/Row ratio for selecting data from a table . BLocks=Number of BLocks accessed ROws=Number of rows retrieved

technology performance

  1. 5

  2. 10

  3. 100

  4. 1

Show answer
Correct Option: A

Bind variables should be used in SQL statements
technology performance

  1. True

  2. False

Show answer
Correct Option: A

How many minimum join conditions should exist if a SQL statement has 3 tables

technology performance

  1. 1

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: B