### performance Online Quiz - 8

 Description: performance Online Quiz - 8 Number of Questions: 20 Created by: Aliensbrain Bot Tags: performance
Attempted 0/20 Correct 0 Score 0

We can create a Load Runner script without Recording the application workflow , just by manual coding

1. True

2. False

Correct Option: A

Which of these options is a type of Performance Testing?

2. Volume Testing

3. Stress Testing

4. All Of The Above

Correct Option: D

On a single processor system, if the CPU utilization is u% and a transaction takes a CPU time of t seconds, the overall time including wait time for the transaction to execute is

1. t*100/(100-u)

2. t*u/(100-u)

3. t*100/u

4. t*u/100

Correct Option: A

A quicksort algorithm to sort n records has a performance proportional of the order of

1. n

2. n squared

3. n log(n)

4. e raised to n

Correct Option: C

Different types of Indexes available

1. B*Tree

2. Bitmap

3. Bmap

4. Function Based Indexes

Correct Option: A,B,D

Leaf nodes of B*Tree index are connected by

3. Pointers

4. Structures

Correct Option: A

#### AI Explanation

To answer this question, we need to understand the structure of a B*Tree index and how leaf nodes are connected.

A B*Tree index is a balanced tree data structure commonly used in database systems. It is designed to provide efficient searching, insertion, and deletion operations. In a B*Tree index, the leaf nodes contain the actual key-value pairs or references to the actual data.

The leaf nodes of a B*Tree index are connected by a doubly linked list. This means that each leaf node has pointers to both its previous and next leaf nodes. The doubly linked list allows for efficient traversal of the leaf nodes in both directions, which is useful for range queries or sequential access.

Option A) Doubly Linked List - This option is correct because the leaf nodes of a B*Tree index are indeed connected by a doubly linked list. This allows for efficient traversal of the leaf nodes in both directions.

Option B) Singly Linked List - This option is incorrect because the leaf nodes of a B*Tree index are connected by a doubly linked list, not a singly linked list.

Option C) Pointers - This option is incorrect because although pointers are used to establish the connections between the leaf nodes, specifically the previous and next leaf nodes, it is more accurate to say that they are connected by a doubly linked list.

Option D) Structures - This option is incorrect because structures are not used to connect the leaf nodes of a B*Tree index. Rather, the connections between the leaf nodes are established using pointers and a doubly linked list.

Different steps in SQL execution

1. a. Parse

2. b. Fetch

3. c. Retrieve

4. d. Bind

5. e. Execute

Correct Option: A,B,D,E

Hard parse is expensive than Soft Parse

1. True

2. False

Correct Option: A
1. Less than 10ms

2. 100ms

3. 150ms

4. 50ms

Correct Option: A

Usage of Hints is advisable in a SQL statement

1. True

2. False

Correct Option: B

Provision should be there for Blind searches

1. True

2. False

Correct Option: B

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

1. Explain Plan

2. Trace

3. Parse

4. Bind

Correct Option: A,B

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

1. 5

2. 10

3. 100

4. 1

Correct Option: A

Bind variables should be used in SQL statements

1. True

2. False

Correct Option: A

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

1. 1

2. 2

3. 3

4. 4

Correct Option: B

The Oracle optimizer should be controlled in choosing the type of joins

1. True

2. False

Correct Option: B

It is a good practice to update all the columns in a Table, than only changed columns.

1. True

2. False

Correct Option: B

Always fetch all the columns data from the table

1. True

2. False

Correct Option: B

Which is the Java Profiler developed by TCS

1. JProfiler

2. YourKit

3. Jensor

4. DataXplod

Correct Option: C

Which is the most popular Performance Testing Tool

1. Rational Performance Tester