0

performance Online Quiz - 8

Description: performance Online Quiz - 8
Number of Questions: 20
Created by:
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?

  1. Load 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

  1. Doubly Linked list

  2. Singly linked list

  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.

Therefore, the correct answer is 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

Ideal Elapsed time for a SQL in OLTP type of Application

  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

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

  2. HP Load Runner

  3. JMeter

  4. Open STA


Correct Option: B
- Hide questions