PDA

View Full Version : PLSQL


  1. What is the difference between SQL table and the PLSQL table
  2. How to retrieve only duplicate values in a table
  3. What is TABLE SPACE
  4. Write the SQL query for creating database backup
  5. Explain the Difference between sub query and co-relater query
  6. What is the difference between function and procedure
  7. What is SGA
  8. What is pseudo column
  9. How to connect oracle database from UNIX. is there any way other than using SQLPLUS
  10. What is the difference between unique key and primary key
  11. Can we create command in the PLSQL block
  12. What is the default Oracle triggers
  13. What is inline command
  14. What are the advantages and disadvantages, compared to the standard SQL and SQL*plus
  15. When we give SELECT * FROM EMP; How does oracle respond
  16. What is the boundary line in varrays
  17. What is the bond code in materialized view
  18. Write a query to delete similar records in different tables with same structure
  19. Write a query to delete similar records in particular fields in different tables
  20. Write a query to delete similar records in same table
  21. How will we see framework of a table
  22. What are the advantages of package
  23. What is difference between procedure and function, procedure and trigger
  24. Delete the emps whose salaries are lowest sals of their own dept
  25. How can I pass the inner procedure value to outer procedure
  26. What is bulk bind
  27. How cursor allocate context area for executing the SQL statement
  28. What is global table
  29. What is purge command explain about oracle performance tuning
  30. Can a table have two primary keys
  31. What is mean by forward declaration and where we'll use it
  32. What is the order of pre-defined exceptions
  33. What is the difference between RDBMS and DBMS
  34. What is a bitmap index
  35. What is global variable in PL/SQL
  36. What is the command for user data type
  37. How to convert ms-excel file to oracle table
  38. What are the different types of joins
  39. What is variable in package specification
  40. How can we read and write files from PL/SQL
  41. How can we create a user defined datatype
  42. What is the difference between oracle 8i and oracle 9i
  43. What is the difference between cursor and procedure in a package
  44. What is Overloading of procedures
  45. What is Data Concurrency and Consistency
  46. How to return more than one value from a function
  47. What is mutating table
  48. How to call DDL statements from PL/SQL
  49. How to perform a loop through all tables in PL/SQL
  50. How to maintain the history of code changes of PL/SQL
  51. What are Dynamic SQL statements
  52. What is PL/SQL and what is it used for
  53. What is constraining table
  54. How PL/SQL source code can be protected
  55. What is the result, when NULL is compared with NULL
  56. What can be a size of a PL/SQL block
  57. How many LONG columns are allowed in a table
  58. What are the data types allowed in a table
  59. What is an Integrity Constraint
  60. Explain Connect by Prior
  61. What are the types of SQL Statement
  62. How to access the current value and next value from a sequence
  63. Is it possible to access the current value in a session before accessing next value
  64. Is it possible to use LONG columns in WHERE clause or ORDER BY
  65. Does it possible to pass object (or) table as an argument to a remote procedure
  66. What is CYCLE/NO CYCLE in a Sequence
  67. What is a database link
  68. What is on DELETE CASCADE
  69. What are the difference between SUBSTR and INSTR
  70. What are the usage of SAVEPOINTS
  71. What is correlated sub-query
  72. What is difference between TRUNCATE & DELETE
  73. What is the Subquery
  74. Explain UNION,MINUS, UNION ALL, INTERSECT
  75. What are the pre requisites
  76. What is ROWID
  77. What is the fastest way of accessing a row in a table
  78. what is NOCOPY
  79. What is meant by DML
  80. What is hash join
  81. What are the forced views
  82. What are the advantages of primary key over unique, notnull
  83. What are the advantages of the packages
  84. What is the purpose of update command in oracle
  85. How to find string or key value using PL/SQL code
  86. Does SQL*Plus contains PL/SQL Engine
  87. Which one is the Best approach to put code, among Triggers and Procedures
  88. What is the best strategy to use COMMIT in a PL/SQL loop
  89. How to execute operating system command from PL/SQL
  90. How to create a primary key with out creating an index
  91. When a procedure /package is getting invalidated
  92. How will you activate/deactivate integrity constraints
  93. Where the integrity constraints are stored in Data Dictionary
  94. What is difference between CHAR and VARCHAR2
  95. What is the maximum SIZE allowed for each type
  96. Which one of the following join types will always create a Cartesian Product
  97. Which one of the following pairs of aggregate functions you use with character fields
  98. What SQL keyword must immediately follow the UNION ALL statement
  99. How are multiple column = value pairs delimited in SET clause of an UPDATE statement
  100. Which clause of an UPDATE statement allows you to affect only certain rows of a table
  101. If you want a column to be part of the result set, after which SQL keyword
  102. What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY
  103. What is the main difference between a UNION statement and a UNION ALL statement
  104. SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c
  105. How many rows are returned by the sample code above
  106. SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id
  107. SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2
  108. What is the basic structure of PL/SQL
  109. What are the components of a PL/SQL block
  110. What are % TYPE and % ROWTYPE ? What are the advantages of using these over data type
  111. What is difference between % ROWTYPE and TYPE RECORD
  112. What is PL/SQL table
  113. Explain the two type of Cursors
  114. What is the cursor attributes used in PL/SQL
  115. What are the PL/SQL Statements used in cursor processing
  116. What will happen after commit statement
  117. Explain the usage of WHERE CURRENT OF clause in cursors
  118. What is a database trigger? Name some usages of database trigger
  119. How many types of database triggers can be specified on a table
  120. Give the structure of the function
  121. Give the structure of the procedure
  122. What are the two parts of a procedure
  123. What are the modes of parameters that can be passed to a procedure
  124. What are advantages of Stored Procedures
  125. What is difference between a PROCEDURE & FUNCTION
  126. Where the Pre_defined_exceptions are stored
  127. What are the return values of functions SQLCODE and SQLERRM
  128. What is Raise_application_error
  129. What is Pragma EXECPTION_INIT ? Explain the usage
  130. What is an Exception? What are types of Exception
  131. Write the order of precedence for validation of a column in a table
  132. What are two virtual tables available during database trigger execution
  133. Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT
  134. What happens if a procedure that updates a column of table X is called in a database
  135. What is a cursor for loop
  136. What is organizational index
  137. What is the difference between join and union
  138. What is the difference between anonymous block and named blocks
  139. What is the difference between implicit conversions and explicit conversions
  140. What is a 'instead of trigger'
  141. What are the advantages of cursors than procedures
  142. What is the difference between to_char and to_date functions
  143. What is sql and plsql
  144. Name the tables where characteristics of Package, procedure and functions are stored
  145. How packaged procedures and functions are called from the following
  146. What are two parts of package
  147. Explain how procedures and functions are called in a PL/SQL block
  148. What is difference between a Cursor declared in a procedure and Cursor declared
  149. When would you denormalize
  150. How do you get all records from 2 tables Which join do you use
  151. How can you create Cursor with parameters
  152. How you will create Toad Function
  153. What is difference between procedure and function
  154. What is meant by forward declaration in functions
  155. What are the Restrictions on Cursor Variables
  156. How can we schedule the procedure to run automatically
  157. What are definer rights invoke rights
  158. How would you hide a table in sql. ie the table can be only visible to its maker
  159. How the execution will be done in exceptions
  160. What is the difference between SQL/PL-SQL/EMBEDDED SQL
  161. What is difference between "Primary key" and "Unique key"
  162. What is the forward declaration in packages
  163. How to fetch the rows by dynamically passing table name through cursor
  164. State the difference between implicit and explicit cursor's
  165. What is difference between stored procedures and application procedures
  166. How to import .dmp file in lower version of oracle from higher version
  167. What is ref cursor in PL/SQL
  168. What is a self join
  169. What are different types of joins
  170. What is a trigger
  171. What are code pages
  172. What is a constraint and types of constraints
  173. What is an index and types of indexes
  174. How many number of indexes can be used per table
  175. What are nested triggers
  176. What is INSTEAD OF trigger
  177. What are Types of backups
  178. What is the difference between granting and creating a view
  179. How to return multiple records from procedure
  180. What is user defined stored procedures
  181. How do you call in & out parameters for stored procedures
  182. What are the blocks in stored procedure
  183. What are the differences between Database Trigger and Integrity constraints
  184. What is a Procedure
  185. What is difference between Procedures and Functions
  186. What is the difference between binary_integer and pls_integer
  187. What will be the output ?
  188. What will be the output
  189. Can we update a view which is created from two tables
  190. What are the demerits of SQL
  191. What cursor type do you use to retrieve multiple record sets
  192. What are the different types of PL/SQL program units that can be defined and stored
  193. How do you assign Construct the where clause without concatenating Field value pairs
  194. What action do you have to perform before retrieving data from the next result set
  195. What are the difference between PL/SQL table and normal PL/SQL table
  196. State the advantage and disadvantage of Cursors
  197. How to display the contents of a current record fetched in a reference cursor
  198. In a Distributed Database System Can we execute two queries simultaneously
  199. How to come back in normal stage in Mutating Table if mutating table is locked
  200. What are difference between views and materialized views