Interview Questions on PL-SQL

Q1.Rate your communication skills.
Q2.Name the different types of SQL statement.
Q3.Choose the line which will produce an error in the statement cursor action_cursor is
a) from action_table
b) select name, rate, action
c) into action_record
d) None of the statements are incorrect
Q4. Mention the steps involved in the compilation process of PL/SQL Block in detail.
Q5. State the difference between single row function and group function.
Q6. What is Translate? What is Decode? Differentiate between these two in detail.
Q7. What is BTitle? How is it different from Title?
Q8. Can you explain the basic structure of PL/SQL?
Q9. Choose one of these modes which you will choose for V_COST_PER_TICKET
a) Return
b) Out
c) In Out
d) In
Q10. Explain a parameterized cursor. What is a simple cursor? Differentiate between these two.
Q11. What do you know about database triggers? Explain some of its functions in detail.
Q12. Name some of the pseudo columns used in PL/SQL.
Q13. What are two-dimensional arrays in PL/SQL? How will you define them?
Q14. Consider a situation when the whole disk is corrupted--- which steps will you take to ensure the recovery of the database?
Q15. Is it possible to truncate some rows from the table and not the whole table instead?
Q16. What is a Cursor? Why is it required? Explain the two types of cursors.
Q17. What do you mean by Cursor For loop? Which one of these is a feature of cursor for Loop
a) Opening and parsing of SQL statements
b) Record type declaration
c) Exit Condition to be defined
d) Fetches records from cursor.
Q18. What do you mean by SQLEERM? Why do you think it’s important for PL/SQL developers?
Q19. What are character functions? What are Synonyms?
Q20. What do you mean by % rowtype? What do you mean by % type? Are they more advantageous than datatypes? Why?
Q21. What are PL/SQL Cursor Exceptions?
Q22. What is SQLCode? Why do you think PL/SQL developers require it?
Q23. What do you mean by Cascade Constraints? Explain their functions in detail.
Q24. Differentiate between Synonym and View.
Q25. What are Stored Procedures? State its advantages.
Q26. Consider a situation when the application is running slow. When do you think you need to check on the database to improve the working?
Q27. What are Implicit Cursors? List some of its attributes.
Q28. Can rollback be done in trigger?
Q29. What do you mean by SQL Integrity?
Q30. What do you mean by Fetch statement? What happens when rows use these statements?
Q31. What do you mean by PL/SQL collections?
Q32. What are Unique Constraints? Is it possible to insert multiple nulls through them?
Q33. What is an Infinite Loop?
Q34. What is a declare statement? When should it be used?
Q35. What do you know about a Flashback concept?
Q36. What do you mean by a Savepoint?
Q37. State the difference between function and procedure.
Q38. Say something about a DML Statement.

Q39. What do you mean by a Spool?
Q40. What can you tell us about a data dictionary?
Q41. Explain “mutating an SQL Table.”
Q42. Share your database designing skills with us.
Q43. What kind of Linux/Unix skills do you possess?
Q44. Tell us something about JDBC.
Q45. How do you think you can work towards query certification if we hire you?
Q46. Share your knowledge on Shell Scripting.
Q47. What kind of experience do you have in Support?
Q48. Tell us something about Hibernate.
Q49. Do you have any experience in Java?
Q50. Rate your negotiation skills.

Post New Comment:

This website is up for sale at $3,000.00. Please contact 9811053538 for further details.