KyaPoocha.com

Related Interview Questions

• Explain about the advantages of using PHP?  17.11.08

  There are many advantages of PHP they are 1) Easy and fast creation of dynamic web pages and a developer can also embed these dynamic functions into HTML. 2)...

• What is meant by dynamic SQL ?  25.07.08

  Dynamic SQL are SQL statements that are prepared and executed within a program while the program is executing. The SQL source is contained in host variables rat...

• Explain the EXPLAIN statement ?  14.07.08

  The explain statement provides information about the optimizer's choice of access path of the SQL....

• When is the access path determined for dynamic SQL ?  17.03.08

  At run time, when the PREPARE statement is issued....

• What is dynamic SQL ?  17.03.08

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

• What is EXPLAIN?  13.03.08

  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 s...

• What is the difference between MVG & Dynamic Pick List?  06.12.06

  A new value could be added through an MVG where as Dynamic Pick Applet could only be used to pick a value from a pick applet which could be constrained to show...

• Explain the difference between MyISAM Static and MyISAM Dynamic.  14.11.06

  In MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with vari...

• How would you go about generating an EXPLAIN plan?  06.08.06

  Create a plan table with utlxplan.sql. Use the explain plan set statement_id = ‘tst1′ into plan_table for a SQL statement. Look at the explain plan with utl...

• What is the difference between a break statement and a continue statement?  07.03.06

  A break statement results in the termination of the statement to which it applies (switch, for, do, or while). A continue statement is used to end the current l...