Introduction

CA Gen enables application development on Windows workstations and supports application deployment to integrate multiple platforms on z/OS (CICS and IMS), UNIX, Linux, Windows, .NET and J2EE.

CA is Computer Associates. And CA Gen is one of their product.

40) Relational Databases - Oracle



One can do a logical data modelling in CA Gen or COOL GEN. Once logical design is complete with physical TD names etc, they can be implemented for Oracl , DB2 or SQL Server database system.

Database Interview Questions 
Interview questions for Oracle database administrator
Interview questions for Oracle database architect, data modeler


  1. What is a difference between procedure and function ? 
  2. Can cursor variables be stored in PL/SQL tables.If yes how. If not why? 
  3. How do you pass cursor variables in PL/SQL? 
  4. How do you open and close a cursor variable.Why it is required? 
  5. What should be the return type for a cursor variable.Can we use a scalar data type as return type? 
  6. What is use of a cursor variable? How it is defined? 
  7. What WHERE CURRENT OF clause does in a cursor? 
  8. Difference between NO DATA FOUND and %NOTFOUND 
  9. What is a cursor for loop? 
  10. What are cursor attributes? 
  11. Difference between an implicit & an explicit cursor. 
  12. What is a cursor? 
  13. What is the purpose of a cluster? 
  14. How do you find the number of rows in a Table ? 
  15. Display the number value in Words? 
  16. Differentiate between TRUNCATE and DELETE 
  17. What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function? 
  18. Can you use a commit statement within a database trigger? 
  19. What is an UTL_FILE.What are different procedures and functions associated with it? 
  20. Difference between database triggers and form triggers? 
  21. What is OCI. What are its uses? 
  22. What are ORACLE PRECOMPILERS? 
  23. What is syntax for dropping a procedure and a function? Are these operations possible? 
  24. Can a function take OUT parameters. If not why? 
  25. Can the default values be assigned to actual parameters? 
  26. What is difference between a formal and an actual parameter? 
  27. What are different modes of parameters used in functions and procedures? 
  28. What is a pseudo column. Give some examples? 
  29. How you will avoid your query from using indexes? 
  30. What is a OUTER JOIN? 
  31. Which is more faster - IN or EXISTS? 
  32. When do you use WHERE clause and when do you use HAVING clause? 
  33. There is a % sign in one field of a column. What will be the query to find it? 
  34. What is difference between SUBSTR and INSTR? 
  35. Which datatype is used for storing graphics and images? 
  36. What is difference between SQL and SQL*PLUS? 
  37. What is difference between UNIQUE and PRIMARY KEY constraints? 
  38. What is difference between Rename and Alias? 
  39. What are various joins used while writing SUBQUERIES? 


No comments:

Post a Comment

Subscribe to: Post Comments (Atom)