300+ [UPDATED] Dimensions Interview Questions

  1. 1. Define The Term ‘dimension’?

    The term ‘dimension’ is used to refer to the physical nature of a quantity and the type of unit used to specify it. Mathematically dimensions of a physical quantity are the powers to which the fundamental quantities must be raised.

  2. 2. What Are Dimensional Constants?

    Constants which possess dimensions are called dimensional constants.

    Example:
    Planck’ Constant.


  3. Physics Interview Questions

  4. 3. What Are Dimensional Variables?

    Those physical quantities which possess dimensions but do not have a fixed value are called dimensional variables.

    Example:
    Displacement, Force, velocity etc.

  5. 4. What Are Dimensionless Quantities?

    Physical quantities which do not possess dimensions are called dimensionless quantities.

    Example:
    Angle, specific gravity, strain. In general, physical quantity which is a ratio of  two quantities of same dimension will be dimensionless.

  6. 5. Define The Principle Of Homogeneity Of Dimensions. On What Principle Is It Based?

    The principle of homogeneity of dimensions states that an equation is dimensionally correct if the dimensions of the various terms on either side of the equation are the same.
    This principle is based on the fact that two quantities of the same dimension only can be added up, and the resulting quantity also possess the the same dimension.

    in equation X + Y = Z is valid if the dimensions of X, Y and Z are same.


  7. Unit of Measurement Interview Questions

  8. 6. List The Basic Dimensions?

    • Length – L
    • Time – T
    • Mass – M
    • Temperature – K or  θ
    • Current – A
  9. 7. What Are The Uses (applications) Of Dimensional Analysis?

    The applications of dimensional analysis are:

    • To convert a physical quantity from one system of units to another.
    • To check the dimensional correctness of a given equation.establish a relationship between different physical quantities in an equation.

  10. Machine Dynamics Interview Questions

  11. 8. What Are The Limitations Of Dimensional Analysis?

    Limitations of Dimensional Analysis are:

    • It cannot determine value of dimensionless constants.
    • We cannot use this method to equations involving exponential and trigonometric functions.
    • It cannot be applied to an equation involving more than three physical quantities.
    • It is a too not a solution i.e.  It can check only if the equation is dimensionally correct or not. But cannot say the equation is absolutely correct.
  12. 9. What Do You Mean By “ Dimensions Of A Derived Unit ” ?

    We know that that the units that depend upon the fundamental units of mass, length and time are called derived units. The unit of mass, length and time are denoted by M, I and T. ( The dimensions of a derived unit may be defined as the powers to which the fundamental units of mass, length and time must be raised so as to completely represent it.


  13. Gravitational Interview Questions

  14. 10. What Id Dimensional Formula ?

    It is an compound expression, showing how and which of the fundamental units enter into the unit of a physical quantity.

  15. 11. What Is Dimensional Equation?

    It is an expression which expresses the physical quantity in terms of a fundamental units of mass, length and time.


  16. Light Interview Questions

  17. 12. What Are Non- Dimensional Variable?

    Physical quantities which are variable but have no dimensions are called non – dimensional variable,

    Example:
    strain, specific gravity, angle etc.


  18. Physics Interview Questions

  19. 13. What Is Dimensional Lumber?

    It is a term used for lumber that is finished and cut to standerdized width and depth specified in inches.

  20. 14. What Is The Principle Of Homogeneity Of Dimensons ?

    According to this principle, the dimensions of all the terms on the two sides of an equation must be same.Therefore in a given relation the terms on either side have same dimensions, If the relation is a correct one, but if it is not so, th erelation is not correct

  21. 15. What Is Random Error?

    The error which creeps in during a measurement due to individual measuring person and the care taken by him in the measuring process is called random error. In order to minimise this error, measurements are repeated many times.


  22. Photon Interview Questions

  23. 16. What Is Meant By Instrumental Error?

    The error which creeps in during a measurement due to limit or resolution of the measuring instrument is called instrumental error. 

  24. 17. What Is Meant By Absolute Error In A Measurement?

    The magnitude of the difference between the true value ( i.e. the mean )of the quantity and the individual measured value is called absolute error.


  25. Matter Interview Questions

  26. 18. What Is Meant By Significant Figures ?

    It indicates the extent to which the reading are reliable.


  27. Unit of Measurement Interview Questions

  28. 19. How Many Base Units Are There In The S.i System ?

    There are only seven base units and two supplementary units.

  29. 20. What Is Kinematics?

    The word kinematics is derived from the greek word “ Knemia ” which means motion. Thus kinematics is the study of motion. We study the position, velocity, acceleration etc. of a body without specifyng the nature of the body and the nature of the forces which cause motion. In this branch we study ways to describe motion of object independent of causes of motion and independent of the nature of the body.


  30. Earthquake Interview Questions

  31. 21. What Is Dynamics?

    It is dervied from the greek word “ dynamics ” which means power. It deals with the study of motion taking into consideration the forces which cause motion.

  32. 22. What Is Statics?

    It is the study of objects at rest i.e. when a large number of forces acting on a body are in equilibrium.

  33. 23. What Is Mechanics?

    This deals with all the subjects namely, kinematics, dynamics and statics.


  34. Bacteria Interview Questions

  35. 24. What Is Motion?

    It is the change of position of an object in the course of time.

    The body in motion is treated as a particle.

    The motion has been classfied as :-

    1.  Motion in one dimension – i.e atrain running on a railway track.
    2.  Motion in two dimensions – i.e motion of a stone which is thrown in the horizontal direction from the top of a tower.
    3.  Motion in three dimensions – i.e the motion of the molecules of a gas. 

  36. Machine Dynamics Interview Questions

  37. 25. Which Type Of Motions Are The Following ?

    1. Motion along a circle.
    2. Motion along a curve

    Both are motions in two dimensions

  38. 26. What Is Meant By Negative Time And Positive Time?

    If we assign a negative time to an event, it means that it occured before the event to which positive time was assigned.


  39. Asia Interview Questions

  40. 27. What Is Meant By Instanteous Position Of An Object?

    The position co – ordinate in a moving body describes te definite and exact position of the body at any time. The position of a body at any instant is called instantaneous position.


  41. Gravitational Interview Questions

  42. 28. What Is Uniform Motion?

    A motion is said to be uniform if the body moves equal distances in equal intervals of time and always in the same direction. For such a motion, the actual distance covered in time t is the magnitude of the displacement.

  43. 29. What Is Uniform Velocity?

    If the body moves equal distances in equal intervals of time and always in the same direction, then it is said to possess uniform velocity.


  44. Solar System Interview Questions

  45. 30. What Is Non – Uniform Motion?

    When a body travels unequal distance in equal intervals of time, the motion is said to be non – uniform motion.

  46. 31. What Is Variable Velocity?

    If a body covers unequal distances in equal intervals of time along a straight line or if the body changes the direction of motion ( though it may be covering equal intervals of time ) , it is said to process variable velocity.

  47. 32. What Is Average Velocity?

    It is the ratio of the total distance travelled to the total time taken by the body.

  48. 33. What Is Instantaneous Velocity?

    The velocity of a body in a non – uniform motion at any instant is called instantaneous velocity. It is different from the average velocity over an interval of time.


  49. Light Interview Questions

  50. 34. What Is Acceleration?

    It is the rate of change of velocity with time.

  51. 35. What Is Uniform Acceleration?

    A body is said to be moving with uniform acceleration, if its velocity changes by equal values in equal intervals of time.

  52. 36. What Is Instantaneous Acceleration?

    If the motion changes of a body is such that its velocity changes by unequal values in equal intervals of time, then the value of the accleration at any instant is called instantaneous acceleration.


  53. Photon Interview Questions

  54. 37. What Is Retardation?

    If the velocity increases, the acceleration is positive and if the velocity decreases, the acceleration is negative. The negative acceleration is called retardation.

  55. 38. What Is The Direction Of The Velocity And Acceleration When It Is Thrown Upwards ?

    Velocity is vertically upward and acceleration is vertically downwards.

  56. 39. What Is The Direction Of The Velocity And Acceleration When It Is Thrown Down Wards?

    Velocity is vertically downward and acceleration is also vertically downwards.

  57. 40. How Is The Position Time Graph Helpful In Studying The Motion Of The Body?

    With the help of this graph, we can determine, distance travelled during any interval of time and also the velocity of the body at any instant of time.


  58. Matter Interview Questions

  59. 41. Why We Do Not Ever Consider Rate Of Change Of Acceleration?

    It is found that the basic laws of motion involve only acceleration and not the rate of change of acceleration, so we never consider the rate of change of acceleration.

  60. 42. What Is Angle Of Departure Or Angle Of Projection?

    The angle that the of projection makes with the horizontal is called angle of departure or angle of projection. Clearly angle of projection for a horizontal projectile is zero.


  61. Earthquake Interview Questions

  62. 43. What Is Range Of Projectile?

    The distance between the point of projection and the point where the trajectory meets the horizontal plane through the point of projection is called its range ( horizontal ).

  63. 44. What Is Horizontal Velocity Of Projectile ?

    The horizontal component of the velocity of the body remains same throughout because there is no acceleration ( due to gravity ) in the horizontal direction.

    The vertical component of the veocity initially ( i.e. at t = 0 ) is zero and the vertical component keeps on increasing till body touches the ground.

  64. 45. What Is Velocity?

    Velocity is the rate of change of the position, equal to speed in a particular direction.

  65. 46. Which Indian Physcist Worked With Albert Einstein ?

    Satyendranath Bose, who with Einstein developed a system of statical quantum mecahnics now known sa Bose Einstein Statistics.

  66. 47. What Is Escape Velocity?

    The minimum speed that a space rocket must reach to escape the earth’s gravity.

  67. 48. Which Are The Basic Forces?

    The basic forces are gravity, electricity, magnetism and two kinds of nuclear forces called weak and strong forces.

  68. 49. Which Scientist Proved The Electro Weak Force They?

    Abdus Salam became the first person from pakistan who won a nobel prize for prove this theory.

  69. 50. Which Are Called Non – Contact Forces?

    Some forces are only produced when the one object touches another. These force are called non – contact forces.

  70. 51. What Is Metastable State?

    This is a state of a system in which it is apparently in a stable equilibrium, however if slightly distrubed the system changes to a new state of lower energy.

  71. 52. What Is Dimensional Analysis?

    A method used to find a relation between various physical quantities. Also to calculate how a physical quantity will depend in terms of the powers of fundamental units on which it intuitively depends.

    The method is based on the prinicple that the dimensions of the fudamental quantities ( M, L and T ) must be the same on both sides of an equation.

  72. 53. What Is Physical Quantity Of Dimesion?

    These are the powers to which the fundamental units must be raised, when the quantity is expressed interms of these units.

  73. 54. What Are The Main Uses Of Dimensional Equations?

    1.  To test of correctness of equations.
    2.  To derive the equations
    3.  To convert one system of units into another.
    4.  To recapitulate important formulae.
  74. 55. (ncert): A Book With Many Printing Errors Contains Four Different Formulas For The Displacement Y Of A Particle Undergoing A Certain Periodic Motion:
    (a) Y = A Sin 2π T/t
    (b) Y = A Sin Vt
    (c) Y = (a/t) Sin T/a
    (d) Y = (a 2) (sin 2πt / T + Cos 2πt / T )
    (a = Maximum Displacement Of The Particle, V = Speed Of The Particle. T = Time-period
    Of Motion). Rule Out The Wrong Formulas On Dimensional Grounds.

    Given,

    Dimension  of a = displacement = [M0L1T0]

    Dimension of v (speed) =  distance/time = [M0L1T-1]

    Dimension of  t or T (time period) = [M0L0T1]

    Trigonometric function sine is a ratio, hence it must be dimensionless.

    (a)  y = a sin 2π t/T (correct ✓ )

    Dimensions of RHS =  [L1] sin([T].[T-1] ) =  [M0L1T0] = LHS  (eqation is correct).

    (b) y = a sin vt  (wrong ✗)

    RHS =  [L1] sin([LT-1] [T1]) =  [L1] sin([L]) = wrong, since trigonometric function must be dimension less.

    (c) y = (a/T) sin t/a (wrong ✗)

    RHS = [L1] sin([T].[L-1] ) = [L1] sin([TL-1] ) = wrong, sine function must be dimensionless.

    (d)  y = (a 2) (sin 2πt / T + cos 2πt / T )  (correct ✓ )

    RHS =  [L1] ( sin([T].[T-1] + cos([T].[T-1] ) = [L1] ( sin(M0L1T0) + cos(M0L1T0) )

    = [L1]  = RHS  = equation is dimensionally correct.

  75. 56. (ncert): A Famous Relation In Physics Relates ‘moving Mass’ M To The ‘rest Mass’ Mo Of A Particle In Terms Of Its Speed V And The Speed Of Light, C. (this Relation First Arose As A Consequence Of Special Relativity Due To Albert Einstein). A Boy Recalls The Relation Almost Correctly But Forgets Where To Put The Constant C. He Writes?

    Dimension of m (mass) = [M1L0T0]

    Dimension of m0 (mass) = [M1L0T0]

    Dimension of v (velocity) = [M0L1T-1]

    ∴ Dimension of v2= [M0L2T-2]

    Dimension of c (velocity) = [M0L1T-1]

    Applying principle of homogeneity of dimensions,  [LHS] = [RHS] = [M1L0T0]

    ⇒ The equation (1- v2)½  must be dimension less, which is possible if we have the expressions as:

    (1 –  v2/c2) The equation after placing ‘c’

  76. 57. Check The Following Equation For Calculating Displacement Is Dimensionally Correct Or Not
    (a) X = X0 + Ut + (1/2) At2
    Where, X Is Displacement At Given Time T
    Xo Is The Displacement At T = 0
    U Is The Velocity At T = 0
    A Represents The Acceleration.
    (b) P = (ρgh)½
    Where P Is The Pressure,
    ρ Is The Density
    G Is Gravitational Acceleration
    H Is The Height.

    (a)  x = x0 + ut + (1/2) at2

    Applying principle of homogeneity, all the sub-expressions  of the equation must have the same dimension and be equal to [LHS]

    Dimension of  x = [M0L1T0]

    Dimensions of  sub-expressions of [RHS] must be [M0L1T0]

    ⇒ Dimension of  x0 (displacement) = [M0L1T0] = [LHS]

    Dimension of ut  = velocity x time = [M0L1T-1][M0L0T1] = [M0L1T0] = [LHS]

    Dimension of  at2 = acceleration x (time)2  = [M0L1T-2][M0L0T-2] = [M0L1T0] = [LHS]

    ∴ The equation is dimensionally correct.

    (b) P = (ρgh)½

    Dimensions of LHS i.e. Pressure [P] = [M1L-1T-2]

    Dimensions of ρ = mass/volume =  [M1L-3T0]

    Dimensions of g (acceleration) = [M0L1T-2]

    Dimensions of h (height) = [M0L1T0]

    Dimensions of RHS = [(ρgh)½] = ([M1L-3T0]. [M0L1T-2].[M0L1T0])½ = ([M1L-1T-2])½

    = [M½LT-1]  ≠ [LHS]

  77. 58. Ncert): A Man Walking Briskly In Rain With Speed V Must Slant His Umbrella Forward Making An Angle θ With The Vertical. A Student Derives The Following Relation Between θ And V : Tan θ = V And Checks That The Relation Has A Correct Limit: As V → 0, θ →0, As Expected. (we Are Assuming There Is No Strong Wind And That The Rain Falls Vertically For A Stationary Man). Do You Think This Relation Can Be Correct ? If Not, Guess The Correct Relation?

    Given, v = tanθ

    Dimensions of  LHS = [v] = [M0L1T-1]

    Dimension of  RHS = [tanθ] = [M0L0T0]      (trigonometric ratios are dimensionless)

    Since [LHS] ≠ [RHS]. Equation is dimensionally incorrect.

    To make the equation dimensionally correct, LHS should also be dimension less. It may be possible if consider speed of rainfall (Vr) and the equation will become:

    tan θ = v/Vr

  78. 59. Hooke’s Law States That The Force, F, In A Spring Extended By A Length X Is Given By F = −kx.
    According To Newton’s Second Law F = Ma, Where M Is The Mass And A Is The Acceleration.
    Calculate The Dimension Of The Spring Constant K?

    Given, F = -kx

    ⇒ k = – F/x

    F = ma,

    the dimensions of force is:

    [F] = ma = [M1L0T0].[M0L1T-2] = [M1L1T-2]

    Therefore, dimension of spring constant (k) is:

    [k] = [F]/[x] = [M1L1T-2].[M0L-1T0] = [M1L0T-2] or [MT-2] …..

  79. 60. Compute The Dimensional Formula Of Electrical Resistance (r)?

    According to Ohm’s law

    V = IR or R = V/I

    Since Work done (W) = QV  where Q is the charge

    ⇒ R = W/QI = W/I2t         (I = Q/t)

    Dimensions of Work [W] = [M1L2T-2]

    ∴Dimension of R =  [R] = [M1L2T-2][A-2T-1] = [M1L2T-3A-2]

  80. 61. A Calorie Is A Unit Of Heat Or Energy And It Equals About 4.2 J Where 1j = 1 Kg M2 S–2. Suppose We Employ A System Of Units In Which The Unit Of Mass Equals α Kg, The Unit Of Length Equals β M, The Unit Of Time Is γ S. Show That A Calorie Has A Magnitude 4.2 α–1 β–2 γ2 In Terms Of The New Units?

    Considering the unit conversion formula,

    n1U1 = n1U2

    n1[M1aL1bT1c] = n2[M2aL2bT2c]

    Given here,  1 Cal = 4.2 J = 4.2  kg m2 s–2.

    n1 = 4.2,  M1 = 1kg,  L1 = 1m,  T1 = 1 sec

    and

    n2 = ?,  M2 = α kg,  L2 = βm,  T2 = γ sec

    The dimensional formula of energy is =  [M1L2T-2]

    ⇒ a = 1, b =1 and c = -2  Putting these values in above equation,

    n2= n1[M1/M2]a[L1/L2]b[T1/T2]c

        = n1[M1/M2]1[L1/L2]2[T1/T2]-2

        = 4.2[1Kg/α kg]1[1m/βm]2[1sec/γ sec]-2 = 4.2 α–1 β–2 γ2  

  81. 62. The Kinetic Energy K Of A Rotating Body Depends On Its Moment Of Inertia I And Its Angular Speed ω. Considering The Relation To Be K = Kiaωb Where K Is Dimensionless Constant.
    Find A And B. Moment Of Inertia Of A Spehere About Its Diameter Is (2/5)mr2?

    Dimensions of Kinetic energy K = [M1L2T-2]

    Dimensions of Moment of Inertia (I) = [ (2/5)Mr2] = [ML2T0]

    Dimensions of angular speed ω = [θ/t] = [M0L0T-1]

    Applying principle of homogeneity in dimensions in the equation K = kIaωb

    [M1L2T-2] = k ( [ML2T0])a([M0L0T-1])b

    [M1L2T-2] = k [MaL2aT-b]

    ⇒ a = 1 and b = 2

    ⇒ K = kIω2  

  82. 63. Convert 1 Newton Into Dyne Using Method Of Dimensions?

    Dimensions of Force = [M1L1T-2]

    Considering dimensional unit conversion formula i.e.  n1[M1aL1bT1c] = n2[M2aL2bT2c]

    ⇒ a = 1, b = 1 and c = -2

    In SI system,  M1 = 1kg,        L1 = 1m   and T1 = 1s

    In cgs system, M2 = 1g,         L2 = 1cm  and T2 = 1s

    Putting the values in the conversion formula,

    n2 = n1(1Kg/1g)1.(1m/1cm)1(1s/1s)-2= 1.(103/1g)(102cm) = 105dyne

  83. 64. The Centripetal Force (f) Acting On A Particle (moving Uniformly In A Circle) Depends On The Mass (m) Of The Particle, Its Velocity (v) And Radius (r) Of The Circle. Derive Dimensionally Formula For Force (f)?

    Given,   F ∝ ma.vb.rc

    ∴ F = kma.vb.rc     (where k is constant)

    Putting dimensions of each quantity in the equation,

     [M1L1T-2] = [M1L0T0]a.[M0L1T-1]b. [M0L1T0]c = [MaLb+cT+cT-b]

    ⇒  a =1, b +c = 1, -b = -2

    ⇒  a= 1, b = 2, c = -1

    ∴ F = km1.v2.r-1= kmv2/r

  84. 65. If The Velocity Of Light C, Gravitational Constant G And Planks Constant H Be Chosen As Fundamental Units, Find The Value Of A Gram, A Cm And A Sec In Term Of New Unit Of Mass, Length And Time Respectively.
    (take C = 3 X 1010 Cm/sec, G = 6.67 X 108 Dyn Cm2/gram2 And H = 6.6 X 10-27 Erg Sec)?

    Given,

    c = 3 x 1010 cm/sec

    G = 6.67 x 108 dyn cm2/gm2

    h = 6.6 x 10-27 erg sec

    Putting respective dimensions,

    Dimension formula for c = [M0L1T-1] = 3 x 1010 cm/sec                             …. (I)

    Dimensions of G             =  [M-1L3T-2] = 6.67 x 108dyn cm2/gm2                …(II)

    Dimensions of h             = [M1L2T-1] =  6.6 x 10-27erg sec                         …(III)

    (Note: Applying newton’s law of gravitation, you can find dimensions of G i.e. G = Fr2/(mM)

    Similarly, Planck’s Constant (h) = Energy / frequency)

    To get M, multiply eqn-I and III and divide by eqn.-II,

    ⇒ [M0L1T-1].[M1L2T-1].[M1L-3T2]

    = ( 3 x 1010 cm/sec).( 6.6 x 10-27 erg sec)/ 6.67 x 108 dyn cm2/gm2

    ⇒[M2] = 2.968 x 10-9

    ⇒[M] =  0.5448 x 10-4 gm

    or 1gm = [M]/0.5448 x 10-4 = 1.835 x 10-4 unit of mass

    To obtain length [L],  eqn.-II x eqn-III / cube of eqn.-I i.e.

    [M-1L3T-2].[M1L2T-1].[M0L-3T3]

    = (6.67 x 108 dyn cm2/gm2 ).( 6.6 x 10-27erg sec)/(3 x 1010 cm/sec)3

    ⇒ [L2] =  1.6304 x 10-65cm2

    ⇒ [L]  =  0.4038 x 10-32 cm

    or  1cm = [L]/ 0.4038 x 10-32 = 2.47 x 10-32unit of length

    In eqn-I,  [M0L1T-1] = 3 x 1010cm/sec

    ⇒  [T] = [L] ÷ 3 x 1010cm/s

    ⇒  [T] =  0.4038 x 10-32 cm  ÷ 3 x 1010cm/s = 0.1345 x 10-42 s

    or 1s = [T]/0.1345 x 10-42s = 7.42 x 1042unit of time 

  85. 66. A Student While Doing An Experiment Finds That The Velocity Of An Object Varies With Time And It Can Be Expressed As Equation: V = Xt2 + Yt +z . If Units Of V And T Are Expressed In Terms Of Si Units, Determine The Units Of Constants X, Y And Z In The Given Equation?

    Given,  v = Xt2 + Yt +Z

    Dimensions of velocity v =  [M0L1T-1]

    Applying applying principle of homogeneity in dimensions, terms must have same dimension.

    [v] = [Xt2] + [Yt] + [Z]

    ∴ [v] = [Xt2]

    ⇒ [X] = [v] /[t2]  =  [M0L1T-1] / [M0L0T2] = [M0L1T-3]              ….(i)

    Similarly, [v] = [Yt]

    ⇒  [Y] = [v] / [t] = [M0L1T-1]/ [M0L0T-1] = [M0L1T-2]             …(ii)

    Similarly, [v]= [Z]

    [Z] =  [M0L1T-1]      …(iii)

    ⇒ Unit of X = m-s-3

    ⇒ Unit of Y = m-s-2

    ⇒ Unit of Z = m-s-1

  86. 67. Express Capacitance In Terms Of Dimensions Of Fundamental Quantities I.e. Mass (m), Length(l), Time(t) And Ampere(a)?

    Capacitance(C) is defined as the ability of a electric body to store electric charge.

    ∴ Capacitance (C) = Total Charge(q) / potential difference between two plates (V)

    = Coulomb/ Volt

    ∵  Volt = Work done (W)/ Charge(q) = Joule/Coulomb

    ⇒  Capacitance (C) = Charge(q)2/ Work(W)

    ∵ Charge (q) = Current (I) × Time(t)

    Dimension of [q] = [AT]                                                 ———– (I)

    Dimension of Work = Force × distance = [MLT-2][L] = [ML2T-2]            ——— (II)

    Putting values of I and II,

    [C] = ([AT])2/ [ML2T-2] = [M-1L-2T2+2A2] = [M-1L-2T4A2]

    Physical Quantities having the same dimensional formula:

    a. impulse and momentum.

    b. force, thrust.

    c. work, energy, torque, moment of force, energy

    d. angular momentum, Planck’s constant, rotational impulse

    e. force constant, surface tension, surface energy.

    f. stress, pressure, modulus of elasticity.

    g. angular velocity, frequency, velocity gradient

    h. latent heat, gravitational potential.

    i. thermal capacity, entropy, universal gas constant and Boltzmann’s constant.

    j. power, luminous flux.

  87. 68. If Force (f), Velocity (v) And Acceleration (a) Are Taken As The Fundamental Units Instead Of Mass, Length And Time, Express Pressure And Impulse In Terms Of F, V And A?

    We know that Force = mass ✕ acceleration

    ⇒ mass = FA-1

    and  length = velocity ✕ time = velocity ✕  velocity ÷  acceleration = V2A-1

    and time = VA-1

    ∵ Pressure = Force  ÷ Area = F ÷ (V2A-1)2 = FV-4A2

    Impulse = Force ✕ time = FVA-1 

300+ [UPDATED] Denodo Interview Questions

  • 1. Why Is Denodo Inexpensive And Quick ?

    The process of replication is the key to the agile, systematic and prompt nature of Denondo. Also, in this process, there is no requirement of information storage or information transfer. It can be managed, monitored and used from anywhere, anytime without any hassles. This is the main reason it allows users to stick to a reasonable budget and be ahead of time.

  • 2. How Does The Concept Of ‘replication’ Help Business Professionals ?

    In this rapid moving industry, business individuals often undergo panicky situations which are quite reasonable. Business professionals require tools and techniques that can provide advancement and facility beyond data management. This is where the process of replication is highly useful. It is of utmost use during crisis scenarios and data loss.

  • RDBMS Interview Questions

  • 3. Explain About The Performance Of Denovo In Few Lines ?

    The Denodo interface is highly used for large-scale business enterprises due to its sheer ability to manage large and complex databases. The features like performance upsurge strategies, intelligence cache, routine back up, price and regulation based optimization and operation devolution can be applied in Denodo. It is one of the top-ranked procedures in data virtualization when it comes to industrial use. It is mostly utilized for critical and substantial project works.

  • 4. Explain The Concept Of Denodo In Detail ?

    Denodo is ranked as the most advanced package today due to its modern and high-end approach towards data management. The particular platform holds a cogitation layer that prevents data to get indulged into data knots and unnecessary complexities. The specific interface also allows users to obtain highly detailed information and specification about a specific data. The entire navigation and operational approach are user-friendly.

  • Data Warehousing Tutorial

  • 5. What Type Of Project Works Or Assignments Are Suitable For Denodo According To You ?

    The best suitable projects for the particular process include projects demanding versatile and advanced requirement. Denodo deliberately broadens and heightens the area of operation during critical or crisis scenarios and allows users to seek real-time data reports. Assignments might include the systematic BI, information for one-time consumer view, rational information services are some of the tasks where it can alter or contribute to the conventional procedures of Data management.

  • Data Warehousing Interview Questions

  • 6. Is The Particular Approach Used For A Data Warehouse Set-up ?

    The Denodo can add value and agility to the entire infrastructure of a data warehouse. It is widely used for extending and prolonging infrastructure which can be performed in a comparably easier way. The Denodo interface also allows Warehouse is moving, prototyping, aligning several data resources to establish virtual information emporiums. The particular process assimilates with ESB to produce real-time information for application of an SOA.

  • 7. Explain What You Understand By Abstraction Layer In Denodo Platform ?

    The abstraction layer is one of the key features in the entire procedure. It is utilized between actual information resources and derivational sources that is ESB, ETL and relevant middleware operation to enhance business adaptability and add quality to business technology.

  • MySQL Tutorial MySQL Interview Questions

  • 8. Explain Difference Between Information Federation Techniques ?

    The Denodo interface is much advanced than that of the information federation procedure. It is an interface that allows facilities lie write, observe, read and admittance to all categories of information and resource. Unlike Federation procedures, the particular procedure also facilitates users to utilize their data safely with its high-security features. 

  • 9. Why Denodo Is One Of The Highly Suggested Procedures In The Business Realm Today ?

    Most of the organizations and industries in the modern age are data-driven, and the need for agile and progressive approaches is vast. Organizations get the opportunity to process complex data and obtain an agile and systemized version of the same without having to generate any additional or replicated information storage for allocation.

  • DB2 Using SQL Interview Questions

  • 10. Define The Concept Of Hypervisors ?

    The hypervisor is referred to a virtual system manager that aids multiple operating systems to utilize one hardware hosting system. This has simplified the overall operating procedure and provided the business industry with several facilities.

  • DB2 Using SQL Tutorial

  • 11. Explain The Term Virtualization ?

    Virtualization is one of the most significant innovations in technology. It is a technology that allows converts hardware into a virtual form or software. It is broadly used in today’s age and has been a significant segment of the Information technology industry. The technique of virtualization is relevant to Denodo as it mainly aims to convert conventional information and make it much more ascendable.

  • Data Structures Interview Questions

  • 12. Explain The Execution Of Roi In The Denodo Platform ?

    The ROI plays a vital role in the particular platform as it possesses a massive reduction in areas like storage, development, software, hardware, and price of maintenance. It is one of the most significant advantages of the DV platform.

  • RDBMS Interview Questions

  • 13. What Is The Primary Format Of Tackling Information Quality Requirements Of Dv ?

    The Denodo interface is suffused with in-built techniques and tools provides ample amount of leverages to users. The tools include the facilities of information pairing, transforming, editing. The mentioned areas are solely stationed on the regulations of ‘apply-on-the-fly.’ The trend of tackling involves detecting or tracking information sources which has made the entire operation much simpler for all categories of users.

  • Data Structures Tutorial

  • 14. Elaborate The Relationship Between Data Virtualization And The It Industry ?

    Data virtualization plays a magnificent role in redefining the norms and trends of the IT industry. The high-end and futuristic features of the Denodo are equipping the information technology domain with ample agility and dependability in the recent years. The BI techniques and tools along with the advanced virtualization technology have facilitated the IT industry in several forms and under multiple names but the most significant and only aim is to improve and advance data management and advancement in every possible form.

  • 15. How Denodo Allows The Assimilation Of Web Data ?

    The Internet is one of the most versatile, vast and rapidly growing information sources. Unlike other approaches available in the market stack, the Denodo consists of semantic techniques, internet automation, and unformed information, which are often efficiently used to add instant value to a business.

  • Database Interview Questions

  • 16. Name The Top Proficiencies Of Denodo ?

    There are several capabilities of Denodo but some of the key capacities include

    • Rational abstraction
    • Agile information services
    • Consolidated information security and monitoring
    • Analytical and non-analytical semantic integration
    • Data Federation
  • 17. How Does The Process Help In Obtaining Data Value In A Short Span Of Time ?

    First of all, the operation and navigation of data are highly flexible in the particular process as it does not require a physical storage or allocating location neither does it need data transfer. The Denodo lets the user get access to real-time information and data and allows dynamic operational leverages at the same time. It is one of the top-most reasons behind business owners and industrialists using the same as their right hands in making the most out of the data.

  • Data Stage Interview Questions

  • 18. Does The Particular Process Aid In Sound And Agile Decision Making And How ?

    Definitely, the advanced approach poses a massive impact on decision making which is hundred percent positive. The specific process allows traders of business owners to access operate and navigate data completely on their own. In order to cope up with the rapid-paced pragmatic occurrences of the business industry, professionals require automated services and business intelligence assistance. Therefore, if business individuals do not have to entirely depend on manual experts to seek essential data insights and directly obtain it from a much agiler and automated procedure, the entire functionality shall turn out fast and productive.

  • Data Warehousing Interview Questions

  • 19. How Denodo Helps In Navigating Large Database And Obtain The Actual Data ?

    The process with its inbuilt tools and techniques breakdowns and normalizes the mass of data and makes it accessible from one virtual layer which eventually gets interlinked with discordant data sources. You will automatically get the leverage to proceed in an agile and disciplined way with the help of DV and shall be finally able to concentrate on the desired or target data.

  • 20. How Can Business Intelligence (bi) Leverages Be Spread Or Expanded To The Entire Employee Chain In An Organization ?

    As it is known that one of the critical features of the Denodo includes the abstraction layer, you can directly choose to develop the same. This facility will eventually shield the basic or elemental complexities of information procedures from the end of the business user, and the advantage of self-navigation of Business Intelligence (BI) can easily be experienced by all employees involved in the business with maximum data security.

  • Database Design Interview Questions

  • 21. State The Differences Between Whole-virtualization And Para-virtualization ?

    Both of the above mentioned categorize tied to one single pole that is the hardware virtualization. In case of full virtualization, the VMS are heedless of the fact that they exist in a virtualized space. Hence the guest VMS interacts to the accelerated apparatus developed by the hosting although the VMS considers the same to be original hardware.

    On the other hand, the process of Para-virtualization involves absolute alertness from the guest VMS that it exists in a virtualized environment. Henceforth, in case of any concern or need for resources, it straightway places command to the hosting system.

  • 22. Explain The Concept And Function Of Zone Data Collector (zdc) ?

    The data collector stocks versatile types or categories of information that involves published operation, session. Load in servers. The ZDC helps in interacting with the zone-specific information with the information present in other zones.

  • 23. What Is Hosted Architecture And How Does It Work ?

    A hosted architecture is storage where the package of virtualization is equipped in the form of an application within the existing hosting system. This generally depicts that the virtualization layers are entirely dependent on the hosting system for hardware and resource maintenance. One of the blazing samples of the above-explained subject is the VMware server.

  • Database Administration Interview Questions

  • 24. What Are The Best Sources To Seek Virtualization Services And Facilities From ?

    To be specific, there are no definite ways to obtain the particular service and shall ultimately depend on your preferences and business requirements although some of the top-recommendations that have been predominating the specific field and have been of utmost assistance to several business owners include the following.

    • Microsoft Hyper-V
    • Critix
    • VMware server
  • MySQL Interview Questions

  • 25. Provide An Average Idea Of The Memory That Can Be Used While Using Services From Denodo ?

    Although it shall mostly depend on your business infrastructure and performance requirements, the ultimate capacity of memory that can be suffused to a VM is 8GB. The memory capability also depends on the host machine. You have to keep the mentioned criteria in mind prior to installing a Denovo facility for your business.

  • 26. State The Difference Between Xen And Kvm In Denovo ?

    The KVM process includes kernel-centric virtualization and can be installed without any external assistance. The hypervisor also allows whole-cycled or full-fledged virtualization whereas the Xen hypervisor does not allow a whole cycled virtualization. The Xen hypervisor also involves a lengthier installation process compared to the KVM. The foremost step involved in this process is to install the Xen kernel and restart or reboot the system along with the same.

  • Anz Sql Server Interview Questions

  • 27. Explain The Term Hypervisor And What Its Fundamental Needs In The Industry Include ?

    The term as mentioned earlier has spread its leverages and advantageous facilities widely and rapidly in the industry. Hypervisors are operations or functions that separate or detach the web applications, packages and operating systems (OS) from the actual or physical hardware. Hypervisors have also gained sheer advancement and modification in the recent years from the traditional functionality trend.

  • DB2 Using SQL Interview Questions

    300+ [REAL TIME] Embryology Interview Questions

    1. 1. What Are The Three Types Of Germ Layers That Form Tissues And Organs In Animals?

      The three germ layers are the ectoderm, the mesoderm, and the endoderm.

    2. 2. How Is The Mesoderm (third Germ Layer) Of Triploblastic Animals Formed?

      The mesoderm appears from differentiation of endodermal cells that cover the dorsal region of the archenteron.

    3. Inventory Management Interview Questions

    4. 3. What Are The Archenteron And The Blastopore? What Is The Stage Of The Embryonic Development In Which These Structures Are Formed? What Are The Destinations Of The Archenteron And Of The Blastopore?

      Archenteron is the tube formed during gastrulation by means of invagination of the blastula wall inside the blatocele. It is the origin of the gastrointestinal tract. Blastopore is the opening of the archenteron to the exterior. The blastopore gives birth to one of the extremities of the digestive tube: the mouth in protostome beings, or the anus in deuterostome beings.

    5. 4. What Is Gastrulation? How During Gastrulation Are The &rst Two Germ Layers Formed? Which Are These Germ Layers?

      Gastrulation is the process through which a portion of the blastula wall undergoes invagination inside the blastocele forming a tube called archenteron (primitive intestine). The cells of the inner side of the tube form the endoderm (germ layer) and the cells of the outer side form the ectoderm (another germ layer). It is the beginning of the tissue differentiation in the embryonic development.

    6. 5. After The Blastula Stage What Is The Following Stage Of The Embryonic Development? How Is The Passage From Blastula To The Next Stage Called?

      The blastula turns into gastrula in a process known as gastrulation.

    7. Teacher Interview Questions

    8. 6. After The Morula Stage What Is The Next Stage? What Is The Morphological Feature That Defines That Stage?

      After passing the morula stage in which the embryo was a compact mass of cells, the next stage is the blastula stage. In the blastula stage, the compactness is lost and an internal cavity filled with fluid appears inside, the blastocele.

    9. 7. What Are The Cells Produced In The First Stage Of The Embryonic Development Called?

      The cells that resulted from the cleavage (the first stage of the embryonic development) are called blastomeres. In this stage the embryo is called morula (similar to a “morus”, mulberry).

    10. Records Management Interview Questions

    11. 8. What Is The Cell Division During The First Stage Of The Embryonic Development Called? How Is This Stage Characterized?

      The cell division in the first stage of the embryonic developments is called cleavage, or segmentation. In this stage, mitosis occurs from the zygote forming the new embryo.

    12. 9. What Are The Four Initial Stages Of The Embryonic Development?

      The four initial stages of the embryonic development are the morula stage, the blastula stage, the gastrula stage, and the neurula stage.

    13. Pre School Teacher Interview Questions

    14. 10. What Are The Animal Pole And The Vegetal Pole Of The Vertebrate Egg?

      The animal pole of a telolecithal egg is the portion of the egg with little vitellus, it is opposite to the vegetal pole that is the region where the yolk is concentrated.

    15. 11. What Is The Function Of The Vitellus In The Vertebrate Egg? How Are These Eggs Classified According To The Amount Of Vitellus Within Them?

      Vitellus (yolk) is the nutritive material that accumulates in the cytoplasm of the egg (zygote) with the function of nourishing the embryo. According to the amount of vitellus in them, the vertebrate eggs are classified as oligolecithal (little yolk), centrolecithal, or heterolecithal (more yolk diffusely distributed) and telolecithal (more yolk concentrated in one end of the egg).

    16. 12. What Is The Cell Division Process Directly Related To The Embryonic Growth?

      The embryonic growth depends directly on mitosis. Through this type of cell division, the zygote divides itself giving birth to a series of cells that by mitosis too compose differentiated tissues and organs until the formation of a complete individual.

    17. Inventory Management Interview Questions

    18. 13. How Are Animals Classified According To The Germ Layers Present In Their Embryonic Development?

      Cnidarians are diploblastic, i.e., they present only endoderm and ectoderm. With the exception of poriferans, all remaining animals are triploblastic. Poriferans do not present differentiated tissue organization and so they do not classify regarding germ layers (although sometimes they are mentioned as diploblastic).

    19. 14. How Does The Embryo Turn From Gastrula Into Neurula? How Is The Neural Tube Formed? What Is The Embryonic Origin Of The Nervous System In Vertebrates?

      The neurula stage is characterized by the appearing of the neural tube along the dorsal region of the embryo. The growing of mesoderm in that region induces the differentiation of ectodermal cells just above. These cells then differentiate forming the neural tube. Therefore, the origin of the nervous system is the ectoderm (the same germ layer that gives birth to the skin).

    20. 15. What Is Notochord? How Is This Structure Formed?

      Notochord is a rodlike structure that forms the supporting axis of the embryo and gives birth to the vertebral column in vertebrates. It is formed by differentiation of mesodermal cells.

    21. 16. What Is Coelom? To Which Structures Do Coeloms Give Birth? Are All Animals Coelomate?

      Coeloms are cavities delimited by mesoderm. Coeloms originate the cavities where the internal organs of the body are located, like the pericardial cavity, the peritoneal cavity, and the pleural cavity. Besides coelomate animals, there are acoelomate animals, like platyhelminthes, and pseudocoelomate animals, like nematodes.

    22. 17. What Is The Germ Layer From Which The Coeloms Originate?

      The coeloms are originated from mesoderm.

    23. 18. What Are Pleura, Pericardium, And Peritoneum?

      Pleura are the membrane that covers the lungs and the inner wall of the chest; pericardium is the membrane that covers the heart; peritoneum is the membrane that covers most organs of the gastrointestinal tract and part of the abdominal cavity. All these membranes delimit coeloms (internal cavities).

    24. Teacher Interview Questions

    25. 19. After The Neurula Stage And From Its Ventral Portion To The Dorsal How Can The Morphology Of The Embryo Be Described?

      In a schematic longitudinal section of the embryo after the neurula stage, the outermost layer of cells is the ectoderm. In the ventral region comes the archenteron tube formed of endodermal cells. In both sides of the embryo, coeloms delimited by mesoderm are present. In the central region above the archenteron and in the middle of the coeloms there is the notochord. In the dorsal region just above the notochord lies the neural tube.

    26. 20. What Are Somites?

      Somites are differentiated portions of mesodermal tissue longitudinally distributed along the embryo. The somites originate the muscle tissue and portions of the connective tissues.

    27. 21. What Are Histogenesis And Organogenesis?

      Histogenesis is the process of tissue formation in the embryonic development. Organogenesis is the process of organ formation. Before histogenesis and organogenesis the primitive embryonic structures have been already formed: germ layers, neural tube, notochord, coeloms, somites.

    28. 22. From Which Germ Layer Do The Epidermis And The Nervous System Originate? What Are Other Organs And Tissues Made From That Germ Layer?

      Epidermis and nervous system have the same embryonic origin: the ectoderm. The epidermal appendages (like nails, hair, sweat glands, and sebaceous glands), the mammary glands, the adenohypophysys, the cornea, the crystalline lens and the retina are also derived from ectoderm.

    29. 23. From Which Germ Layer Do Blood Cells Originate? What Are Other Organs And Tissues Made From That Germ Layer?

      Blood cells have mesodermal embryonic origin. Other organs made from mesoderm are covering serous membranes like the pericardium, the peritoneum and the pleura, muscles, cartilages, dermis, adipose tissue, kidneys, ureters, bladder, urethra, gonads, blood and lymph vessels, bones.

    30. 24. From Which Germ Layer Do The Liver And The Pancreas Originate? What Are Other Organs And Tissues Made From That Germ Layer?

      The liver and the pancreas are originated from the endoderm. Also from endodermal origin are the epithelia of the airway, the epithelia of the bladder, of the urethra and of the GI tube (excepted of the mouth and anus), the alveolar cells of the lungs and the thyroid and parathyroid glands.

    31. Records Management Interview Questions

    32. 25. What Is Polyembryony?

      Polyembryony is the phenomenon in which a single embryo in its initial embryonic stage divides itself forming many new individuals of the same sex and genetically identical. This is the way, for example, in which reproduction takes place in armadillos of the genus Dasypus. Polyembryony is an example of natural “cloning”.

    33. 26. What Are Extra Embryonic Membranes?

      Extra embryonic membranes are membranous structures that appear paralleling the embryo and play important roles in the embryonic development. They form from the embryo but do not become part of the individual organism after its birth.

    34. 27. What Are The Extra Embryonic Membranes Present In Vertebrates?

      The extra embryonic membranes that may be present in vertebrates are the yolk sac, the amnion, the chorion, the allantois and the placenta.

    35. Pre School Teacher Interview Questions

    36. 28. Are The Extra Embryonic Membranes The Same In All Vertebrates?

      The presence of each extra embryonic membrane varies according to the vertebrate class.

      In fishes and amphibians, only the yolk sac is present. In reptiles and aves besides the yolk sac, there are also the amnion, the chorion and the allantois. In placental mammals besides all these membranes, the placenta is present too.

    37. 29. How Is The Yolk Sac Formed? What Is The Function Of The Yolk Sac?

      The yolk sac is formed from the covering of the vitellus by some cells originated from the primitive gut.

      The yolk sac stores vitellus, the main nourishment source of nonplacental embryos.

    38. 30. Which Is The Extra Embryonic Membrane Whose Function Is To Store Nitrogen Wastes Of The Embryo? Is This Function Present In Placental Mammalian Embryos?

      The allantois is the extra embryonic membrane whose function is to store excretes of the embryo.

      In placental mammals, the allantois is present but it does not exert that function since the embryonic wastes are collected by the mother’s body through the placenta.

    39. 31. Why Can The Allantois Be Considered An Adaptation To Terrestrial Life?

      The allantois is an adaptation to dry land because in embryos of oviparous terrestrial beings, like reptiles and birds, the metabolic residuals cannot be immediately excreted to the aquatic surrounds (as fishes and amphibian larvae do). It was necessary then the appearing of a structure capable of storing the embryonic excretes until hatching.

    40. 32. What Is The Difference Between Amnion And Chorion?

      Amnion is the membrane that covers the embryo. Chorion is the membrane that covers the amnion, the yolk sac, and the allantois. The space delimited by the chorion and the amnion is called amniotic cavity and it is filled with aminiotic fluid. The amniotic cavity has the functions of preventing desiccation of the embryo and of protecting it against mechanical shocks.

    41. 33. Why Can The Amnion Also Be Considered An Adaptation To Terrestrial Life?

      The amnion is also an adaptation to dry land since one of its functions is to prevent desiccation of the embryo.

    42. 34. What Is The Chorioallantois Membrane Present In The Embryonic Development Of Reptiles And Birds? How Does This Membrane Participate In The Energetic Metabolism Of The Embryo?

      The chorioallantois membrane is formed by juxtaposition of some regions of the chorion and the allantois. Since it is porous, the chorioallantois membrane allows the passage of gases between the embryo and the exterior thus making aerobic cellular respiration possible.

    43. 35. In Which Type Of Animals Does The Placenta Exist? What Is Its Main Function?

      True placenta is present in placental mammals.

      The placenta is formed from the chorion of the embryo and from the mother’s endometrium. Its main function is to allow the exchange of substances between the fetus and the mother’s body.

    44. 36. What Are The Main Substances Transferred From The Mother To The Fetus Through The Placenta And From The Fetus To The Mother?

      From the mother to the fetus the main transferred substances through the placenta are water, oxygen, nutrients, and antibodies. From the fetus to the mother, metabolic wastes including urea (nitrogen waste), and carbon dioxide are transferred.

    45. 37. Is There Exchange Of Cells Between The Mother And The Fetus Through The Placenta?

      Under normal conditions, there is no passage of cells across the placenta during gestation. The placenta has a smooth mucosa separating the richly vascularized region in contact with the mother’s endometrium from the umbilical cord in contact with the fetal blood. This barrier is known as placental barrier. Although permeable to some substances (selective permeability), the placental barrier forbids the passage of cells.

    46. 38. What Are The Endocrine Functions Of The Placenta?

      The placenta has endocrine function since it secretes the hormones progesterone and estrogens that maintain the endometrium (internal covering of the uterus) and prevent menses during pregnancy. The placenta also secretes other important hormones for pregnancy regulation.

    47. 39. What Is The Function Of The Umbilical Cord?

      The umbilical cord is a set of blood vessels that connect the fetus with the placenta. In the fetus, one extremity of the cord inserts into the center of the abdominal wall (the later scar of this insertion is the umbilicus).

      The function of the umbilical cord is to allow the transport of substances, nutrients, gases, and residuals, between the fetus and the mother’s body.

    300+ [UPDATED] EDI (electronic data Interchange) Interview Questions

    1. 1. What Is Edi?

      Electronic Data Interchange is the exchange of business documents, such as purchase orders and invoices, between business partners in a common format directly from one computer to another.

    2. 2. Who Typically Uses Edi?

      EDI is used in nearly all the major industries such as automotive, aerospace, retail, finance and CPG sectors. EDI is regarded as the standard for the electronic exchange of documents from one company to another.


    3. Business Process Reengineering Interview Questions

    4. 3. What Is A Business Partner?

      An EDI business partner is simply another company that you exchange documents with. Most OEMs will have a large network of business partners which are sometimes referred to as ‘Trading Communities’.

    5. 4. An Edi Partner That I Am Working With Has Asked Me To Use A Specific Edi Solution, Do I
      Need To Use Exactly This Method To Send Documents?

      EDI solutions are regarded as universal in nature and there are a number of functioning standards in existence which govern how companies should send EDI documents to one another. Your exact choice of which EDI solution to use should be aligned with those which suit your business requirements the best.


    6. MySQL Tutorial

    7. 5. Is Edi Difficult To Implement?

      EDI can be implemented almost immediately, depending on the type of EDI solution chosen. If it is a web-based solution hosted by your customer or client, then all you will need to do is log into their web portal and simply fill in the necessary online forms before sending the required documents. More complex systems will require software to be installed on your company’s network that will then allow integration with your back-office systems. An EDI system can be considered as an evolving solution. As your business grows and you begin trading with more partners, the complexity of your EDI system will grow as well.


    8. MySQL Interview Questions

    9. 6. What Is The Difference Between Edi Provided By A Van And Edi Delivered Over The Internet?

      VAN stands for ‘Value Added Network’, which is private network where EDI traffic is exchanged securely. Business partners will typically require an account with an EDI VAN such as GXS and this account simply acts as an electronic mailbox to both send and receive electronic documents. In addition to sending EDI documents to your business partner via a VAN it is also possible to send EDI documents between VANs, these are known as ‘interconnects’. Interconnects are beneficial in so much as they will give you access to a much broader range of business partners distributed across the world.

      Whilst EDI VANs have been around for nearly 30 years now, the Internet does provide an alternative method of transferring EDI documents. Even though the business benefits of using both are similar, the deciding factor of which to use will depend upon the partner agreement that has been prepared. Ideally, both EDI business partners need to use the same method of transport, either a VAN or direct exchange through the Internet. Many of the larger companies will insist that all their suppliers should use the same method of sending documents.

    10. 7. What Types Of Edi Solutions Are Available For Me?

      Essentially there are three types of EDI solutions: EDI software, web-based EDI and EDI service bureaus. EDI software resides directly on a computer that your company owns and offers the highest level of flexibility and control. EDI software also allows you to possibly integrate with back office systems, thus improving business process efficiency. EDI documents are exchanged directly between your EDI software and your business partner’s EDI software. This ‘point to point’ method of communication allows for minimal delays and reduced errors and a secure method of interacting with business partners. Since the software for web-EDI resides on the Internet, using it requires some type of internet connection. Web based EDI is an interactive process and requires manual entry of your EDI information.

      This method provides little opportunity for integration and lessens the control you have over the day to day operations. Since data with a web-based EDI system is interactive, customization of the EDI process is very limited. EDI service bureaus act as EDI contractors performing your EDI operations, they will typically use some form of pay as you go method. An EDI service bureau provides the least control over your day to day operations and the smallest opportunity for data integration with your business systems.


    11. Unix/Linux Tutorial
      SQL Interview Questions

    12. 8. Why Would I Choose An Edi Software Solution Over A Web-based Or Service Bureau Solution?

      The first consideration is to understand the impact that EDI will have on your business processes. Since web-based and service bureau solutions will have a ‘manual’ element embedded in the process, there is scope for introducing errors to the business process. EDI software allows you to exchange data directly with back office systems, thus eliminating manual errors in the process. The time saved entering data and eliminating errors allows your company to spend more time improving order fulfillment and more importantly improves customer satisfaction levels. The important thing to remember is that whatever EDI solution is chosen it will impact your company’s operation moving forwards.

    13. 9. Do I Need Specific Experience To Be Able To Do Edi?

      In most cases you will not need specific experience; it is directly related to the type of EDI solution you end up choosing for your business. Internet based EDI solutions are normally ‘hosted’ by a company and you merely access this through a web browser. This is therefore the simplest method of interacting with an EDI system. If you decide to implement EDI software then it would be advisable to ask your chosen EDI vendor to undertake some simple training for your employees.


    14. Web Methods Interview Questions

    15. 10. I Have Heard Of Outsourcing It Services. Is It Possible To Outsource Edi?

      Yes, as with any other form of IT technology, EDI can be outsourced to a company with the necessary resources to manage your total EDI requirements. GXS Managed Services provides an EDI outsourcing capability and this service will look after your complete EDI requirements — from developing maps to link documents together to recruiting partners to form trading communities. GXS has successfully worked with 135 companies around the world to undertake the management of their EDI infrastructures. GXS Managed Services will allow you to enable your entire supply chain, on a global basis, if required to do so.

    16. 11. I Don’t Have The Resources To Be Able To Recruit Business Partners And Explain My Edi
      Strategy To Them. Is There A Way Of Achieving This Efficiently?

      Yes, GXS Community Link allows a company to quickly recruit business partners to your EDI program. GXS will undertake the necessary marketing of your EDI service to your potential business partners and will work with them to ensure they are able to trade documents with your company as quickly and seamlessly as possible.


    17. Unix/Linux Interview Questions

    18. 12. I Currently Use A Number Of Automotive Suppliers Based In China. Is It Possible To Trade Electronically With These Companies, If So, How Is It Achieved?

      Yes, it is possible to trade electronically with automotive suppliers in China. GXS recently announced a partnership with China Enterprise Online Data Exchange Services Ltd (CEDEX). This partnership has developed one of the only trading hubs dedicated to China’s growing automotive industry. The hub allows automotive companies in China to trade documents with both their domestic and international customers. China e-AutoHub is directly connected to GXS Trading Grid which allows a seamless connection to any business partner around the world.


    19. Business Process Reengineering Interview Questions

    20. 13. I Have Heard About Various Edi Related Industry Associations And Data Standards. Are These Important?

      Yes, the industry associations are very important as they will allow you to implement industry best practices and get a better understanding of what other companies, in terms of EDI usage, are doing in your particular industry. They also work closely to develop industry standards for document exchange. These are important to understand if you want to implement EDI correctly and hence obtain a competitive advantage in the market place. Please take a look in the ‘Resources’ area of this microsite to find out further information about the numerous industry associations and EDI document types.

    21. 14. I Have Heard That Edi Is A Relatively Old Technology. Is This True?

      EDI has been around for over thirty years now and is regarded as a very mature IT technology. As EDI is so entrenched within many companies it is very difficult to replace with another technology overnight. As new technology, such as the Internet, has emerged, EDI has had to embrace these new technologies to remain an efficient business tool for communicating documents between companies. EDI will be around for many years to come.

    22. 15. What Is The Difference Between Electronic Data Interchange Provided By An Edi Van And Internet Edi?

      VAN a Value Added Network, often referred to as an EDI VAN, is a private network dedicated to the secure exchange of EDI data. Trading partners obtain an account with an EDI VAN such as GXS VAN, Sterling, EDS/ELIT, COVISINT INTERCONNECT etc. This account serves as an electronic mailbox for sending and receiving electronic documents.

      Internet EDI is another way of communication, it’s similar to OFTP2. You r partner can send you the data to your server via Internet or vice versa.


    23. Network Troubleshooting Interview Questions

    24. 16. What Are Different Edi Standards And Application Standards Formats?

      EDI Standard : ANSI X12, UCS, EDIFACT, VDA, TREDACOM etc. Application Format Standard : IDoc, Delimited Files, CSV etc.

    25. 17. How Do I Know What Type Of File I Received?

      The ST segment is the transaction set header. The ST purpose is to indicate the start of a transaction set. The ST01 is the Transaction Set Identifier Code. The ST01 uniquely identifies a transaction set. The ST01 will identify if a file is a 997, 835 or 277.


    26. Middleware Interview Questions

    27. 18. What Do I Do If My File Is Rejected (ak501 Not = A Or E And Ak901 Not = A Or E)?

      Contact the trading partner to resend the file.


    28. MySQL Interview Questions

    29. 19. What Is As1, As2 And As3?

      AS1 : AS2 (Applicability Statement 2) is a specification about how to transport data securely and reliably over the Internet

      AS2 : AS2 (Applicability Statement 2) is a specification about how to transport data securely and reliably over the Internet. Security is achieved by using digital certificates and encryption.

      Files are sent as “attachments” in a specially coded SMIME message (an AS2 message)

      AS2 messages are always sent using the HTTP or HTTPS protocol (Secure Sockets Layer — also known as SSL — is implied by HTTPS) and usually use the “POST” method (use of “GET” is rare).

      AS3 : AS3 (Applicability Statement 3) is the draft specification standard by which vendor applications communicate EDI (or other data such as XML) over the Internet using File Transfer Protocol (FTP).

    30. 20. What Is Difference Between 855 And 997 Ts?

      855 : Used to provide for customary and established business and industry practice relative to a seller’s acknowledgment of a buyer’s purchase order. 855 is acknowledge for 850.

      997 : Used to define the control structures for a set of acknowledgments to indicate the results of the syntactical analysis of the electronically encoded documents. 997 generally indicates EDI standard problems rather than business rule errors 997 is Acknowledge for all transaction.

    31. 21. What Is 824 Ts?

      It result of error checking by the trading partner’s business application program.

    32. 22. Can A 997 Ts Is Used To Acknowledge 997 Ts?

      No, it will cause an infinite loop.

    33. 23. What Is Ddf? Can We Created Ddf For Edi Side?

      Map Editor enables you to create (save as a DDF) a DDF  file (Data Definition Format File) so that you can use it as a starting place in other maps or as a means to update existing maps.

    34. 24. What Is Isa? Isa 6,8,14,15?

      ISA 6 is sender id, 8 is date, 14 is the file indicator(P/T) and 15 is sub element separator.


    35. SQL Interview Questions

    36. 25. What Is Gs Control Number?

      GS*6 is the group control number which is unique for one GS in side one ISA segment.

    37. 26. What Is Auto Trim Function?

      Auto trim is the way to activate the EDI segment base on input file.

      Instead of activating map components manually, you can use the Auto Trim function to modify the EDI side of the map according to a sample EDI file that you select.

      The sample EDI file must be of the same standard, version, and transaction set (message) as the map for Auto Trim to match map components.

      Delimiters for the EDI side of the map must be set to match the delimiters used in the sample EDI file.

    38. 27. What Is Writeblock(), Readblock(), Unreadblock() Function?

      Writeblock() : The writeblock function writes the data contained in the argument of a string variable to the output file. The readblock and writeblock functions are used together to pass a block of data from the input file to the output file without compliance checking or testing for proper EDI syntax.

      Readblock(): The readblock function reads a block of data (segment or record) from the input file and places it into the argument of a string variable. The readblock and writeblock functions are used in conjunction with each other to pass a block of data from the input file to the output file without compliance checking or testing for proper EDI syntax. Together, these functions provide a more efficient alternative of using wildcard segments, which are typically implemented in build and break maps.

      Unreadblock() : The unreadblock function provides a method of moving the input file-pointer back one block (a block of data is equivalent to one EDI segment or one positional record). This function “unreads” the block of data that was just processed by the readblock function.


    39. Web Methods Interview Questions

    40. 28. What Is Pre And Post Session Rules?

      Pre-session rules define variables that have global scope (can be accessed from any other extended rule in the map). Pre-session extended rules are processed before the translation object is processed, and apply to every extended rule defined in the map.

      Post-session rules are run after the translation object is processed and thus have no permanent scope.

    41. 29. What Are Indexes?

      To write valid extended rules, you must understand how to use indexes. Without indexes, it is possible that a rule which moves data from one field to another may result in lost data.

      An index is a number that is used within an extended rule only when referencing a field contained by a repeating record or group. This number is used to specify the exact occurrence (iteration) of the repeating group or record that you want the translator to access.

    42. 30. What Is Basic Flow Of Map Editor?

      First Input file will read, then it will apply for standard rule on source side then check for extended rule then linking, then it will go to target side and apply standard rule, then extended rule.

      Pre and Post rule will applicable according.

    43. 31. What Do You Understand By Promotion In Map Editor?

      The Promote function extracts one iteration (instance) of one of the following map components:

      • Group
      • Repeating record
      • Repeating element
      • repeating composite

      Promote is a specialized version of the Split function. For example, if you have a group with 50 iterations and you select Promote, you then have two groups: one group with an iteration of 1 and a group that iterates 49 times.

      This function enables you to map unique data from a document and to type a specialized definition. The translator specifies that only one-to-one (no loop) or many-to-many (loop) mapping relationships are valid. The Promote function is available only if a group or repeating record, element, or composite is selected.

    44. 32. Different Type Of Delimiters?

      Tag Delimiter:

      • Segment Delimiter*
      • Element Delimiter*
      • Sub Element Delimiter  
      • Repeating Element Delimiter  
    45. 33. What Are Edi Drivers?

      • Ability to strengthen partnerships
      • Improve business processes
      • A communication tool to allow new ways to do business
      • A preferred way of doing business among Fortune 500 companies
      • A business basic for the industry

    46. Unix/Linux Interview Questions

    47. 34. How Is Edi Used?

      EDI is used as a strategic tool to reduce expenses, streamline business procedures, and create a competitive advantage.

       

    48. 35. How Is Edi Started?

      Usually Reactive or Proactive.

    300+ [UPDATED] DB2 Using SQL Interview Questions

  • 1. What Is Db2 (ibm Database 2)?

    DB2 is a subsystem of the MVS operating system. It is a Database Management System (DBMS) for that operating system.

  • 2. How Would You Find Out The Total Number Of Rows In A Db2 Table?

    Use SELECT COUNT(*) … in db2 query

  • PL/SQL Interview Questions

  • 3. How Do You Eliminate Duplicate Values In Db2 Select ?

    Use SELECT DISTINCT … in db2 query

  • 4. How Do You Select A Row Using Indexes In Db2?

    Specify the indexed columns in the WHERE clause of db2 query.

  • IBM DB2 Tutorial

  • 5. How Do You Find The Maximum Value In A Column In Db2?

    Use SELECT MAX(…) .. in db2 query

  • IBM DB2 Interview Questions

  • 6. How Do You Retrieve The First 5 Characters Of Firstname Column Of Db2 Table Emp ?

    SQL Query : SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP;

  • 7. What Are Aggregate Functions?

    Built-in mathematical functions for use in SELECT clause.

  • COBOL Tutorial Oracle Interview Questions

  • 8. Can You Use Max On A Char Column?

    YES.

  • 9. My Sql Statement Select Avg(salary) From Emp Yields Inaccurate Results. Why?

    Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.

  • COBOL Interview Questions

  • 10. How Do You Concatenate The Firstname And Lastname From Emp Table To Give A Complete Name?

    SELECT FIRSTNAME || ‘ ‘ || LASTNAME FROM EMP;

  • DB2 Using SQL Tutorial

  • 11. What Is The Use Of Value Function?

    1. Avoid -ve SQLCODEs by handling nulls and zeroes in computations
    2. Substitute a numeric value for any nulls used in computation

  • IBM Mainframe Interview Questions

  • 12. What Is Union,union All?

    UNION : eliminates duplicates
    UNION ALL: retains duplicates
    Both these are used to combine the results of different SELECT statements.

  • PL/SQL Interview Questions

  • 13. What Is The Restriction On Using Union In Embedded Sql?

    It has to be in a CURSOR.

  • IBM Mainframe Tutorial

  • 14. In The Where Clause What Is Between And In?

    BETWEEN supplies a range of values while IN supplies a list of values.

  • 15. Is Between Inclusive Of The Range Values Specified?

    Yes.

  • MYSQL DBA Interview Questions

  • 16. What Is ‘like’ Used For In Where Clause? What Are The Wildcard Characters?

    LIKE is used for partial string matches. ‘%’ ( for a string of any character ) and ‘_’ (for any single character ) are the two wild card characters.

  • IMS/DB Tutorial

  • 17. When Do You Use A Like Statement?

    To do partial search e.g. to search employee by name, you need not specify the complete name; using LIKE, you can search for partial string matches.

  • DB2 SQL Programming Interview Questions

  • 18. What Is The Meaning Of Underscore ( ‘-‘ ) In The Like Statement?

    Match for any single character.

  • IBM DB2 Interview Questions

  • 19. What Do You Accomplish By Group By … Having Clause?

    GROUP BY partitions the selected rows on the distinct values of the column on which you group by.
    HAVING selects GROUPs which match the criteria specified

  • 20. Consider The Employee Table With Column Project Null Able. How Can You Get A List Of Employees Who Are Not Assigned To Any Project?

    SELECT EMPNO
    FROM EMP
    WHERE PROJECT IS NULL;

  • IMS/DB Interview Questions

  • 21. What Is The Result Of This Query If No Rows Are Selected:

    SELECT SUM(SALARY)
    FROM EMP
    WHERE QUAL=‘MSC’;
    NULL

  • 22. Why Select * Is Not Preferred In Embedded Sql Programs?

    For three reasons:

    • If the table structure is changed ( a field is added ), the program will have to be modified.
    • Program might retrieve the columns which it might not use, leading on I/O over head.
    • The chance of an index only scan is lost.
  • 23. What Are Correlated Subqueries?

    A subquery in which the inner ( nested ) query refers back to the table in the outer query. Correlated subqueries must be evaluated for each qualified row of the outer query that is referred to.

  • Mainframe DB2 Interview Questions

  • 24. What Is A Cursor? Why Should It Be Used?

    Cursor is a programming device that allows the SELECT to find a set of rows but return them one at a time.
    Cursor should be used because the host language can deal with only one row at a time.

  • Oracle Interview Questions

  • 25. How Would You Retrieve Rows From A Db2 Table In Embedded Sql?

    Either by using the single row SELECT statements, or by using the CURSOR.

  • 26. How Do You Specify And Use A Cursor In A Cobol Program?

    Use DECLARE CURSOR statement either in working storage or in procedure division(before open cursor), to specify the SELECT statement. Then use OPEN, FETCH rows in a loop and finally CLOSE.

  • 27. What Happens When You Say Open Cursor?

    If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement. Other wise simply the cursor is placed on the first row.

  • COBOL Interview Questions

  • 28. Is Declare Cursor Executable?

    No.

  • 29. Can You Have More Than One Cursor Open At Any One Time In A Program?

    Yes.

  • 30. When You Commit, Is The Cursor Closed?

    Yes.

  • 31. How Do You Leave The Cursor Open After Issuing A Commit? ( For Db2 2.3 Or Above Only )

    Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs.

  • 32. What Is The Physical Storage Length Of Each Of The Following Db2 Data Types: Date, Time, Timestamp?

    DATE: 4bytes
    TIME: 3bytes
    TIMESTAMP: 10bytes

  • 33. What Is The Cobol Picture Clause Of The Following Db2 Data Types: Date, Time, Timestamp?

    DATE: PIC X(10)
    TIME : PIC X(08)
    TIMESTAMP: PIC X(26)

  • IBM Mainframe Interview Questions

  • 34. What Is The Cobol Picture Clause For A Db2 Column Defined As Decimal(11,2)?

    PIC S9(9)V99 COMP-3.
    Note: In DECIMAL(11,2), 11 indicates the size of the data type and 2 indicates the precision.

  • 35. What Is Dclgen

    Declarations GENerator: used to create the host language copy books for the table definitions. Also creates the DECLARE table.

  • 36. What Are The Contents Of A Dclgen?

    1. EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes.
    2. A host language copy book that gives the host variable definitions for the column names.
  • MYSQL DBA Interview Questions

  • 37. Is It Mandatory To Use Dclgen? If Not, Why Would You Use It At All?

    It is not mandatory to use DCLGEN.
    Using DCLGEN, helps detect wrongly spelt column names etc. during the pre-compile stage itself ( because of the DECLARE TABLE ). DCLGEN being a tool, would generate accurate host variable definitions for the table reducing chances of error.

  • 38. Is Declare Table In Dclgen Necessary? Why It Used?

    It not necessary to have DECLARE TABLE statement in DCLGEN. This is used by the pre-compiler to validate the table-name, view-name, column name etc., during pre-compile.

  • 39. Will Precompile Of An Db2-cobol Program Bomb, If Db2 Is Down?

    No. Because the precompiler does not refer to the DB2 catalogue tables.

  • 40. How Is A Typical Db2 Batch Program Executed ?

    1. Use DSN utility to run a DB2 batch program from native TSO.

    An example is shown:

    DSN SYSTEM(DSP3)
    RUN PROGRAM(EDD470BD) PLAN(EDD470BD) LIB(‘ED 01T.OBJ.LOADLIB’)
    END
    2. Use IKJEFT01 utility program to run the above DSN command in a JCL.

  • DB2 SQL Programming Interview Questions

  • 41. Name Some Fields From Sqlca.

    SQLCODE, SQLERRM, SQLERRD

  • 42. How Can You Quickly Find Out The # Of Rows Updated After An Update Statement?

    Check the value stored in SQLERRD(3).


  • IMS/DB Interview Questions

  • 43. What Is Explain?

    EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement) or in BIND step (for embedded SQL ).

  • 44. What Do You Need To Do Before You Do Explain?

    Make sure that the PLAN_TABLE is created under the AUTHID.

  • 45. Where Is The Output Of Explain Stored?

    In userid.PLAN_TABLE

  • 46. Explain Has Output With Matchcols = 0. What Does It Mean?

    A non matching index scan if ACCESSTYPE = I.

  • 47. How Do You Do The Explain Of A Dynamic Sql Statement?

    1. Use SPUFI or QMF to EXPLAIN the dynamic SQL statement
    2. Include EXPLAIN command in the embedded dynamic SQL statements

  • 48. What Are The Isolation Levels Possible ?

    CS: Cursor Stability
    RR: Repeatable Read

  • 49. What Is The Difference Between Cs And Rr Isolation Levels?

    CS: Releases the lock on a page after use
    RR: Retains all locks acquired till end of transaction

  • 50. Where Do You Specify Them ?

    ISOLATION LEVEL is a parameter for the bind process.

  • 51. What Are The Various Locking Levels Available?

    PAGE, TABLE, TABLESPACE

  • 52. How Does Db2 Determine What Lock-size To Use?

    1. Based on the lock-size given while creating the tablespace
    2. Programmer can direct the DB2 what lock-size to use
    3. If lock-size ANY is specified, DB2 usually chooses a lock-size of PAGE

  • 53. What Is Alter ?

    SQL command used to change the definition of DB2 objects.

  • 54. What Is A Dbrm, Plan ?

    DBRM:
    Data Base Request Module, has the SQL statements extracted from the host language program by the pre-compiler.
    PLAN:
    A result of the BIND process. It has the executable code for the SQL statements in the DBRM.

  • 55. What Is Acquire/release In Bind?

    Determine the point at which DB2 acquires or releases locks against table and tablespaces, including intent locks.

  • 56. What Else Is There In The Plan Apart From The Access Path?

    PLAN has the executable code for the SQL statements in the host program

  • 57. What Happens To The Plan If Index Used By It Is Dropped?

    Plan is marked as invalid. The next time the plan is accessed, it is rebound.

  • 58. What Are Packages ?

    They contain executable code for SQL statements for one DBRM.

  • 59. What Are The Advantages Of Using A Package?

    1. Avoid having to bind a large number of DBRM members into a plan
    2. Avoid cost of a large bind
    3. Avoid the entire transaction being unavailable during bind and automatic rebind of a plan
    4. Minimize fallback complexities if changes result in an error.

  • 60. What Is A Collection?

    A user defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.
    In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.

  • 61. What Are The 2 Sqlcodes That Are Returned?

    100 ( for successful completion of the query ), 0 (for successful COMMIT if AUTOCOMMIT is set to Yes).

  • 62. How Would You Print The Output Of An Sql Statement From Spufi?

    Print the output dataset.

  • 63. Lot Of Updates Have Been Done On A Table Due To Which Indexes Have Gone Haywire. What Do You Do?

    Looks like index page split has occurred. DO a REORG of the indexes.

  • 64. What Is Dynamic Sql?

    Dynamic SQL is a SQL statement created at program execution time.

  • 65. When Is The Access Path Determined For Dynamic Sql?

    At run time, when the PREPARE statement is issued.

  • 66. How Does Db2 Store Null Physically?

    As an extra-byte prefix to the column value Physically, the null prefix is Hex ’00’ if the value is present and Hex ‘FF’ if it is not.

  • 67. How Do You Retrieve The Data From A Nullable Column?

    Use null indicators. Syntax … INTO :HOSTVAR:NULLIND

  • 68. What Is The Picture Clause Of The Null Indicator Variable?

    S9(4) COMP.

  • 69. What Does It Mean If The Null Indicator Has -1, 0, -2?

    -1 : the field is null
    0 : the field is not null
    -2 : the field value is truncated

  • 70. How Do You Insert A Record With A Nullable Column?

    To insert a NULL, move -1 to the null indicator
    To insert a valid value, move 0 to the null indicator

  • 71. What Is Runstats?

    A DB2 utility used to collect statistics about the data values in tables which can be used by the optimizer to decide the access path. It also collects statistics used for space management. These statistics are stored in DB2 catalog tables.

  • 72. When Will You Chose To Run Runstats?

    After a load, or after mass updates, inserts, deletes, or after REORG.

  • 73. Give Some Example Of Statistics Collected During Runstats?

    # of rows in the table
    Percent of rows in clustering sequence
    # of distinct values of indexed column
    # of rows moved to a nearby/far way page due to row length increase

  • 74. What Is Reorg? When Is It Used?

    REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. It is used after heavy updates, inserts and deletes activity and after segments of a segmented tablespace have become fragmented.

  • 75. What Is Copy Pending Status?

    A state in which, an image copy on a table needs to be taken, In this status, the table is available only for queries. You cannot update this table. To remove the COPY PENDING status, you take an image copy or use REPAIR utility.

  • 76. What Is Check Pending ?

    When a table is Loaded with ENFORCE NO option, then the table is left in CHECK PENDING status. It means that the LOAD utility did not perform constraint checking.

  • 77. What Is Quiesce?

    A QUIESCE flushes all DB2 buffers on to the disk. This gives a correct snapshot of the database and should be used before and after any IMAGECOPY to maintain consistency.

  • 78. What Is A Clustering Index ?

    Causes the data rows to be stored in the order specified in the index. A mandatory index defined on a partitioned table space.

  • 79. How Many Clustering Indexes Can Be Defined For A Table?

    Only one.

  • 80. What Is The Difference Between Primary Key & Unique Index ?

    Primary :
    a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.
    Unique index:
    a physical object that stores only unique values. There can be one or more unique indexes on a table.

  • 81. What Is Sqlcode -922 ?

    Authorization failure

  • 82. What Is Sqlcode -811?

    SELECT statement has resulted in retrieval of more than one row.

  • 83. What Does The Sqlcode Of -818 Pertain To?

    This is generated when the consistency tokens in the DBRM and the load module are different.

  • 84. Are Views Updateable?

    Not all of them. Some views are updateable e.g. single table view with all the fields or mandatory fields. Examples of non-updateable views are views which are joins, views that contain aggregate functions(such as MIN), and views that have GROUP BY clause.

  • 85. If I Have A View Which Is A Join Of Two Or More Tables, Can This View Be Updateable?

    No.

  • 86. What Are The 4 Environments Which Can Access Db2 ?

    TSO, CICS, IMS and BATCH

  • 87. What Is An Inner Join, And An Outer Join ?

    Inner Join:
    combine information from two or more tables by comparing all values that meet the search criteria in the designated column or columns of on e table with all the clause in corresponding columns of the other table or tables. These kinds of join which involve a match in both columns are called inner joins.
    Outer join
    is one in which you want both matching and non matching rows to be returned. DB2 has no specific operator for outer joins, it can be simulated by combining a join and a correlated sub query with a UNION.

  • 88. What Is Freepage And Pctfree In Tablespace Creation?

    PCTFREE:
    percentage of each page to be left free
    FREEPAGE:
    Number of pages to be loaded with data between each free page

  • 89. What Are Simple, Segmented And Partitioned Table Spaces ?

    Simple Tablespace:

    • Can contain one or more tables
    • Rows from multiple tables can be interleaved on a page under the DBAs control and maintenance

    Segmented Tablespace:

    • Can contain one or more tables
    • Tablespace is divided into segments of 4 to 64 pages in increments of 4 pages. Each segment is dedicated to single table. A table can occupy multiple segments.

    Partitioned Tablespace:

    • Can contain one table
    • Tablespace is divided into parts and each part is put in a separate VSAM dataset.
  • 90. What Is Index Cardinality?

    The number of distinct values a column or columns contain.

  • 91. What Is A Synonym ?

    Synonym is an alternate name for a table or view used mainly to hide the leading qualifier of a table or view. A synonym is accessible only by the creator.

  • 92. What Is The Difference Between Synonym And Alias?

    SYNONYM:
    is dropped when the table or tablespace is dropped. Synonym is available only to the creator.
    ALIAS:
    is retained even if table or tablespace is dropped. ALIAS can be created even if the table does not exist. It is used mainly in distributed environment to hide the location info from programs. Alias is a global object & is available to all.

  • 93. What Do You Mean By Not Null With Default? When Will You Use It?

    This column cannot have nulls and while insertion, if no value is supplied then it will have zeroes, spaces or date/time depending on whether it is numeric, character or date/time.
    Use it when you do not want to have nulls but at the same time cannot give values all the time you insert this row.

  • 94. What Do You Mean By Not Null? When Will You Use It?

    The column cannot have nulls. Use it for key fields.

  • 95. When Would You Prefer To Use Varchar?

    When a column which contains long text, e.g. remarks, notes, may have in most cases less than 50% of the maximum length.

  • 96. How Do I Create A Table Manager ( Emp#, Manager) Where Manager Is A Foreign Key Which References To Emp# In The Same Table? Give The Exact Ddl.

    First CREATE MANAGER table with EMP# as the primary key. Then ALTER it to define the foreign key.

  • 97. When Is The Authorization Check On Db2 Objects Done – At Bind Time Or Run Time?

    At run time.

  • 98. What Is Auditing?

    Recording SQL statements that access a table . specified at table creation time or through alter.

  • 99. What Is An Access Path?

    The path that is used to get to data specified in SQL statements.

  • 100. What Is An Alias?

    Answer :

    It is an alternate name that can be used in SQL statements to refer to a table or view in the same or remote DB2 subsystem.

  • 101. Explain What A Plan Is?

    Plan is a DB2 object (produced during the bind process) that associates one or more database request modules with a plan name.

  • 102. What Is A Db2 Bind?

    Bind is a process that builds “access paths” to DB2 tables. A bind uses the Database Request Modules(s) (DBRM(s)) from the DB2 pre-compile step as input and produces an application plan. It also checks the user’s authority and validates the SQL statements in the DBRM(s).

  • 103. What Information Is Used As Input To The Bind Process?

    The database request module produced during the pre-compile. The SYSIBM.SYSSTMT table of the DB2 catalog.

  • 104. What Is Meant By The Attachment Facility?

    The attachment facility is an interface between DB2 and TSO, IMS/VS, CICS, or batch address spaces. It allows application programs to access DB2.

  • 105. What Is Meant By Auto Commit?

    AUTO COMMIT is a SPUFI option that commits the effects of SQL statements automatically if they are successfully executed.

  • 106. What Is A Base Table?

    A base table is a real table – a table that physically exists in that there are physical stored records.

  • 107. What Is The Function Of Buffer Manager?

    The buffer manager is the DB2 component responsible for physically transferring data between an external medium and (virtual) storage (performs the actual I/O operations). It minimizes the amount of physical I/O actually performed with sophisticated buffering techniques(i.e., read-ahead buffering and look-aside buffering).

  • 108. What Is A Buffer Pool?

    A buffer pool is main storage that
    is reserved to satisfy the buffering requirements for one or more tablespaces or indexes, and is made up of either 4K or 32K pages.

  • 109. How Many Buffer Pools Are There In Db2?

    There are four buffer pools: BP0, BP1, BP2, and BP32.

  • 110. On The Create Tablespace, What Does The Close Parameter Do?

    CLOSE physically closes the tablespace when no one is working on the object. DB2 (release 2.3) will logically close tablespaces.

  • 111. What Is A Clustering Index?

    It is a type of index that (1) locates table rows and (2) determines how rows are grouped together in the tablespace

  • 112. What Will The Commit Accomplish?

    COMMIT will allow data changes to be permanent. This then permits the data to be accessed by other units of work. When a COMMIT occurs, locks are freed so other applications can reference the just committed data.

  • 113. What Is Meant By Concurrency?

    Concurrency is what allows more than one DB2 application process to access the same data at essentially the same time. Problems may occur, such as lost updates, access to uncommitted data, and un-repeatable reads.

  • 114. What Is Cursor Stability?

    It is cursor stability that “tells” DB2 that database values read by this application are protected only while they are being used. (Changed values are protected until this application reaches the commit point). As soon as a program moves from one row to another, other programs may read or the first row.

  • 115. What Is The Function Of The Data Manager?

    The Data Manager is a DB2 component that manager the physical databases. It invokes other system components, as necessary, to perform detailed functions such as locking, logging, and physical I/O operations (such as search, retrieval, update, and index maintenance).

  • 116. What Is A Database Req
    uest Module(dbrm)?

    A DBRM is a DB2 component created by the DB2 pre-compiler containing the SQL source statements extracted from the application program. DBRMs are input to the bind process.

  • 117. What Is A Data Page?

    A data page is a unit of retrievable data, either 4K or 32K (depending on how the table is defined), containing user or catalog information.

  • 118. What Are Data Types?

    They are attributes of columns, literals, and host variables. The data types are SMALLINT, INTEGER, FLOAT, DECIMAL, CHAR, VARCHAR, DATE and TIME.

  • 119. What Is Declaration Generator(dclgen)?

    DCLGEN is a facility that is used to generate SQL statements that describe a table or view. These table or view descriptions are then used to check the validity of other SQL statements at precompile time. The table or view declares are used by the DB2I utility DCLGEN to build a host language structure, which is used by the DB2 precompiler to verify that correct column names and data types have been specified in the SQL statement.

  • 120. What Does Dsndb07 Database Do?

    DSNDB07 is where DB2 does its sorting. It includes DB2’s sort work area and external storage

  • 121. What Will The Free Command Do To A Plan?

    It will drop(delete) that existing plan.

  • 122. What Is A Host Variable?

    This is a data item that is used in an SQL statement to receive a value or to supply a value. It must be preceded by a colon (:) to tell DB2 that the variable is not a column name.

  • 123. What Will The Db2 Optimizer Do?

    The optimizer is a DB2 component that processes SQL statements and selects the access paths.

  • 124. What Is A Page?

    Answer :

    This is the unit of storage within a table space or indexspace that is accessed by DB2.

  • 125. What Is Pagespace?

    Pagespace refers to either to an unpartitioned table, to an index space, or to a single partition of a partitioned table of index space.

  • 126. What Is A Predicate?

    A predicate is an element of a search condition that expresses or implies a comparison operation.

  • 127. What Is A Resource Control Table(rct)? Describe Its Characteristics.

    The RCT is a table that is defined to a DB2/CICS region. It contains control characteristics which are assembled via the DSNCRCT macros. The RCT matches the CICS transaction ID to its associated DB2 authorization ID andplan ID(CICS attachment facility).

  • 128. Where Are Plans Stored?

    Each plan is defined uniquely in the SYSIBM.SYSPLANS table to correspond to the transaction (s) that are to execute that plan.

  • 129. What Is Meant By Repeatable Read?

    When an application program executes with repeatable read protection, rows referenced by the program can’t be changed by other programs until the program reaches a commit point.

  • 130. Describe What A Storage Group(stogroup) Is?

    A STOGROUP is a named collection of DASD volumes to be used by tablespaces and index spaces of databases. The volumes of STOGROUP must be of the same device type.

  • 131. What Is The Format (internal Layout) Of “timestamp”?

    This is a seven part value that consists of a date (yymmdd) and time(hhmmss and microseconds).

  • 132. What Is Meant By A Unit Of Recovery?

    This is a sequence of operations within a unit of work(i.e., work done between commit points).

  • 133. Can Dasd Types Assigned To Storage Groups Be Intermixed(i.e., 3350s And 3380s)?

    No

  • 134. What Are The Three Types Of Page Locks That Can Be Held?

    Exclusive, update, and share.

  • 135. Can Db2 Be Accessed By Tso Users? If Yes, Which Command Is Used To Invoke Db2?

    DB2 can be invoked by TSO users by using the DSN RUN command.

  • 136. How Are Write I/os From The Buffer Pool Executed?

    Asynchronously.

  • 137. What Is A Db2 Catalog?

    The DB2 catalog is a set of tables that contain information about all of the DB2 objects(tables, views, plans etc.).

  • 138. In Which Column Of Which Db2 Catalog Would You Find The Length Of The Rows For All Tables?

    In the RECLENGTH column of SYSIBM.SYSTABLES

  • 139. What Information Is Held In Sysibm.syscopy?

    The SYSIBM.SYSCOPY table contains information about image copies made of the tablespaces.

  • 140. What Information Is Contained In A Syscopy Entry?

    Included is the name of the database, the table space name, and the image copy type(full or incremental etc.,) as well as the date and time each copy was made.

  • Ques
    tion 141. What Information Can You Find In Sysibm.syslinks Table?

    The SYSIBM.SYSLINKS table contains information about the links between tables created by referential constraints.

  • 142. Where Would You Find Information About The Type Of Database Authority Held By The User?

    SYSIBM.SYSDBAUTH

  • 143. Where Could You Look If You Had A Question About Whether A Column Has Been Defined As An Index?

    This information can be found in SYSIBM.SYSINDEXES.

  • 144. Once You Create A View, Where Would Information About The View Be Stored?

    When a view is created, system information about the view is stored in SYSIBM.SYSVIEWS.

  • 145. What Is The Sql Communications Area And What Are Some Of Its Key Fields?

    It is a data structure that must be included in any host-language program using SQL. It is used to pass feedback about the sql operations to the program. Fields are return codes, error messages, handling codes and warnings.

  • 146. How To Get The Value With Leading Zeros?

    SELECT POLICY_NUMBER, DIGITS (BASE_PREM_TOT)
    FROM DB2K.CGIST.TW4T0
    If the value of BASE_PREM_TOT is 472.00 then it will be selected as like this 00000047200

  • 147. Correlated Sub Query?

    SELECT A.DRIVER_REFERENCE
    FROM CGDEV4.TU4ML A
    WHERE A.LICENSE_NUMBER = ‘POTAPA*355B2’ AND
    A.DRIVER_REFERENCE =
    (SELECT C.CLIENT_REFERENCE
    FROM CGDEV4.TZ1SR C
    WHERE A.DRIVER_REFERENCE = C.CLIENT_REFERENCE AND
    SUBSTR(C.Z_UPPER_FIRST_NAME,1,1) = ‘A’ AND
    SUBSTR(C.Z_UPPER_LAST_NAME,1,3) = ‘JZB’)

  • 148. How To Delete Duplicated Based On Certain Column Retaining One

    DELETE FROM TABLE1 A WHERE A.PRIMARYKEY<>(SELECT MIN(PRIMARYKEY) FROM TZCHC B
    WHERE A.COLUMN1= B.COLUMN1);

  • Question 149. How To Count Occurrence Of Letter In A String?

    SELECT (LENGTH(‘SUBASH’) – LENGTH(REPLACE(‘SUBASH’,’S’,”))) AS S_COUNT FROM SYSIBM.SYSDUMMY1

  • 150. How To Execute The Sql Through Jcl Using Utility

      //CREATE EXEC PGM=IKJEFT01,DYNAMNBR=20  //SYSTSPRT DD SYSOUT=*  //SYSPRINT DD SYSOUT=*  //SYSTSIN DD *  DSN SYSTEM(DB2T)  RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) LIB('DB2T.RUNLIB.LOAD')  END  /*  //SYSIN DD *  SELECT COUNT(USER_UPDATED)  FROM CGDEV4.TWC39  WHERE USER_UPDATED='DPPLSPP'  GROUP BY USER_UPDATED  /*  

  • 151. How To Eliminate Duplicate Records Except One

      DELETE FROM TZCHC TD1  WHERE HOLIDAY_DATE<> (SELECT MIN (HOLIDAY_DATE)  FROM TZCHC TD2  WHERE TD1.LONG_DESC = TD2.LONG_DESC  AND TD2.LONG_DESC = 'CHRISTMAS DAY’);

  • 152. How To Subtract The Years, Months And Days Separately From Date

    SELECT DATE (‘2003-10-13′) – DEC (’03’) YEARS – DEC (’07’) MONTHS – DEC (’13’) DAYS FROM SYSIBM.SYSDUMMY1;

    SELECT DATE (‘2003-10-13’) – DEC (‘2000’) YEARS –
    DEC (’27’) MONTHS – DEC (’45’) DAY
    FROM SYSIBM.SYSDUMMY1;

  • 153. How To Get The Max Count When Group By Some Other Field

      SELECT USER_UPDATED, COUNT (USER_UPDATED) AS COUNT1  FROM CGDEV4.TWC39  GROUP BY USER_UPDATED  HAVING COUNT (USER_UPDATED) >= ALL  (SELECT COUNT (USER_UPDATED)  FROM CGDEV4.TWC39  GROUP BY USER_UPDATED);  

  • 154. How To Find N Th Max Or Min

    SELECT DISTINCT A.TIMESTAMP_UPDATED, A.USER_UPDATED
    FROM CGDEV4.TWC39 A
    WHERE 5 =
    (SELECT COUNT (DISTINCT B.TIMESTAMP_UPDATED)
    FROM CGDEV4.TWC39 B
    WHERE B.TIMESTAMP_UPDATED >= A.TIMESTAMP_UPDATED)

  • 155. What Is Tsq And Tdq?

    TSQ:

    • Its like a scratch pad, This will not go to permanent memory unless you explicitly specify.
    • This is used if you have page up/page down logic in your CICS screens.
    • Program A calling Program B which selects db2 rows, So in program B you can write all your rows fetched to a TSQ and come back to program A, now you can read these rows from TSQ rather than going to Db2 every time.
    • If you have large amount of data to be passed between to tasks of a transaction you can use TSQ.

    TDQ:

    • If you want some processing should happen depending on the data that you have read from the screen for example. user wants to print the screen, take the information write it to a TDQ this will trigger a transaction which does the printing.
    • Trigger level tells and indicates, after nth record is written to a TDQ it should trigger the transaction associated with it.
    • TDQ has to be defined prior to use.
  • 300+ [REAL TIME] Facets Testing Interview Questions

    Facets Testing Interview Questions

    1. What about Facets.
    The Facets tool is the core administrative processing system built by Cognizant in 1993. It is used to process medical and hospital transactions or facility claims. It helps in billing, claims processing, care management, and network management workflow. It is currently processing millions of transactions per week for more than 80 health plans. It integrates consumers, claims, care, and revenue management into a single platform.

    2. List the modules of Facets.
    The Facets tool offers a lot of modules. Some of them include subscribers/ members, providers, medical, billing, NetworX, etc.

    3. What are the advantages of Facets?
    Here are some of the advantages of the Facets tool.

    1. It provides increased stability.
    2. It has increased resilience to disturbances.
    3. The performance of the Facets tool is very reliable.
    4. It generates and consumes a huge amount of data.
    5. It offers real-time processing.
    6. It comes with security incorporated at each stage of the life cycle.

    4. Where can we use Facets?
    The Facets tool is widely used in the following places.

    • Enrollment – When a new member has to be enrolled, ID card requests, update demographic details, etc.
    • Customer Service – Manage customer service operations in real-time.
    • Billing – It can perform comprehensive billing summary, billing requests, payments, etc.
    • Interoperability – Provides an integrated view and access to consumer demands.
    • Claim Processing – Helps with real-time claim submission and processing.
    • Customer Transparency – It can be used where transparency is required for eligibility, benefits, and cost estimates.

    5. How do Facets achieve real-time processing?
    The architecture that leverages a data streaming platform is the event-driven ‘Facets Data Publishing’. The system can publish data generated by claims, providers, and subscribers in real-time. The clients can publish or consume data through batch or real-time processes.

    6. Give the differences between medical claims and hospital claims?
    Medical claims, also known as professional claims, are the claims that can be submitted by an individual provider or clinic. It is for the treatment received by an individual while in a hospital. Hospital claims, also known as facility claims, are the claims submitted by the hospitals.

    7. What are the fields in a claims screen?
    The claims screen contains the following fields.

    • Provider id
    • Subscriber id
    • Date of service
    • Diagnosis code
    • Procedure code
    • Revenue code
    • Unit price
    • Number of units

    8. What is the difference between revenue code and procedure code?
    Revenue code can only be used in hospital claims. The revenue codes are priced by the revenue codes.
    Procedure code can only be used in medical claims. The medical claims are priced by the procedure codes.

    9. List the common errors faced while processing claims in Facets.
    Here are the common errors faced during claims processing in the Facets tool.

    • Provider record not found
    • Procedure code invalid
    • Service definition error

    10. How can you adjudicate a claim?
    The F3 button is used in the Facets tool to adjudicate a claim.

    11. How can you save a claim?
    We can save a claim in the Facets tool using the F4 button.

    12. Why do we need to pend a claim?
    We can pend a claim when it is not paying as expected.

    13. What are the stylistic properties?
    It is an optional property which controls the elements with stylistic aspects of FacetDive.

    14. Name two stylistic properties used by Facet?
    itemPositioningVerticalLabelColor – It is used in labeling the color for item positioning in the vertical direction.
    itemPositioningHorizontalLabelColor – It is used in labeling the color for item positioning in the horizontal direction.

    15. What is Facets Atlasmaker?
    The Facets Atlasmaker is a command-line utility and library used to create the sprite atlases.

    16. What are the functionalities of Atlasmaker?
    The functionalities of Atlasmaker are

    1. To read the input image files from URL and local file.
    2. Using default image file during unsuccessful conversion or retrieval of images in atlas.
    3. Image resizing and conversion.
    4. Parallelization of image fetch/conversion.

    17. What are the four Facet Dive controls?
    The four Dive controls are

    • Faceting controls – which lays the records out in a grid information.
    • Positioning controls – arranges the items in each cell grid by stacking them to place it in a scatter plot.
    • Color controls – enables to specify the color for individual items.
    • Display controls – lets you specify the dive to render on each point.

    18. Name the data properties of FacetsDive polymer.
    The FacetsDive visualizations has two properties

    data – Array<{}> – An array of data objects to visualize.
    filteredDataIndicies – number[] – An array of indices into data object array.

    Subscribe To Our Youtube Channel To Get New Updates..!

    19. What are the interactive properties?
    The properties that drive the interactivity of FacetDive are the interactive properties controlled by the user.

    20. Name any four interactive properties in FacetDive.

    • vertical Facet – Name of the field of the data to facet vertically.
    • vertical bucket – Number of buckets to use when faceting vertically.
    • horizontalFacet – Name of the area of the data to facet horizontally.
    • horizontal bucket – Number of buckets to use when faceting horizontally.

    If you have any doubts on Facets, then get them clarified from Facets Industry experts on our Facets community!

    21. Which attribute is used to position the items in grid cells?
    The interactive “position mode” attribute used in positioning items within a grid cell with stacked and scatter choices.

    22. Which attribute is used to generate the data-specific color palette?
    The “palette choice” attribute is used to generate the data-specific color palette with the four values standard, warm, cool and assist.

    23. How can you position the items along the axis with Facet interactions?
    The “vertical position” and “horizontal position” are the two attributes.

    • vertical position – is used to position the items along the vertical axis.
    • horizontal position – is used to position the items along the horizontal axis.

    24. What are the things that an overview tool displays after uploading the data?
    The overview tool displays the following four things:

    • Statistics of data – This includes statistics of Min, Max, Median, and Standard Deviation.
    • Missing values – The number of rows which has no data.
    • Zero values – what percentage of data is zero.
    • Train/test split – A plot which displays the dataset split between training and testing data.

    25. What is a Seaborn FacetGrid?
    The Seaborn FacetGrid is a class that helps in visualizing the distribution of one variable and the relationship between multiple variables separately. FacetGrid object considers the data frame as input and names the variables that form a row, column, and hue dimensions.

    26. Name any two methods that are used by Seaborn FacetGrid.
    facet_axis (self,row_i,col_j) – Make the axis identified by these indices active and return it.
    facet_data (self) – Generator for name indices and data subsets for each Facet.

    27. What Seaborn FacetGrid map method does?
    The Seaborn FacetGrid.map() method applies the plotting function to each Facet’s subset of data.

    • Facets Training
    • Weekday / Weekend Batches

    28. Name the parameters of Seaborn FacetGrid map method.
    The parameters include

    • func – A plotting function which takes data and arguments.
    • args – The column names in self.data which identifies variable with data to plot.
    • Kwargs – The keyword arguments which are passed to the plotting function.

    Syntax: FacetGrid.map(self, func, *args, **kwargs)

    29. What are Facets in Health Care systems?
    The Facets is mainly developed for Health Care systems for providing advanced care management capabilities. The Facets platform automates data points in training the healthcare datasets to produce better outcomes through visualizations.

    30. What are the Trizetto Facets?
    Trizetto Facets are the number of functionalities that assist in managing an application group’s business operations. The Trizetto Facets includes the business rules which process the client/server systems.

    Facets Testing Interview Questions with Answers Pdf Download