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

Different types of Indexes available

  1. B*Tree

  2. Bitmap

  3. Bmap

  4. Function Based Indexes

Correct Option: A,B,D
  1. Doubly Linked list

  2. Singly linked list

  3. Pointers

  4. Structures

Correct Option: A

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

Usage of Hints is advisable in a SQL statement

  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