What is the difference between static and dynami

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the difference between static and dynamic SQL?

Static SQL is hard-coded in a program when the programmer knows the statements to be executed.
For dynamic SQL the program must dynamically allocate memory to receive the query results.

(Continued on next question...)

Other Job Interview Questions

• How would you find out the total number of row in a table?
• What are foreign keys?
• Describe a primary key?
• What is a correlation name?
• What is minimum authority required for one to create a tablespace?
• What RDMS objects are required before you can create a table ?
• Can you use MAX on a CHAR column?
• What is normalization and what are the five normal forms?
• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• What is a cursor? Why should it be used ?
• More...