|
Question |
Rating |
View Answer |
|
Differentiate between TRUNCATE and DELETE |
|
View Answer |
|
How you were passing cursor variables in PL/SQL 2.2? |
|
View Answer |
|
What is the purpose of a cluster? |
|
View Answer |
|
What is difference between a formal and an actual parameter? |
|
View Answer |
|
What are ORACLE PRECOMPILERS? |
|
View Answer |
|
Whet are the difference between primary key and foreign key? |
|
View Answer |
|
How do you find the number of rows in a Table ? |
|
View Answer |
|
Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments? |
|
View Answer |
|
How will you delete duplicating rows from a base table? |
|
View Answer |
|
What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function? |
|
View Answer |
|
Can a function take OUT parameters. If not why? |
|
View Answer |
|
Difference between database triggers and form triggers? |
|
View Answer |
|
Can cursor variables be stored in PL/SQL tables.If yes how. If not why? |
|
View Answer |
|
What are different Oracle database objects? |
|
View Answer |
|
What is a cursor for loop? |
|
View Answer |
|
What are various privileges that a user can grant to another user? |
|
View Answer |
|
What is use of a cursor variable? How it is defined? |
|
View Answer |
|
Can the default values be assigned to actual parameters? |
|
View Answer |
|
When do you use WHERE clause and when do you use HAVING clause? |
|
View Answer |
|
What is a view? |
|
View Answer |