|
Question |
Rating |
View Answer |
|
How do you find the numbert of rows in a Table ? |
|
View Answer |
|
What is use of a cursor variable? How it is defined? |
|
View Answer |
|
What is difference between UNIQUE and PRIMARY KEY constraints? |
|
View Answer |
|
Difference between database triggers and form triggers? |
|
View Answer |
|
How will you delete duplicating rows from a base table? |
|
View Answer |
|
When do you use WHERE clause and when do you use HAVING clause? |
|
View Answer |
|
How you open and close a cursor variable. Why it is required? |
|
View Answer |
|
What is OCI. What are its uses? |
|
View Answer |
|
What is the purpose of a cluster? |
|
View Answer |
|
Difference between an implicit & an explicit cursor.? |
|
View Answer |
|
What is difference between Rename and Alias? |
|
View Answer |
|
What are various joins used while writing SUBQUERIES? |
|
View Answer |
|
What is difference between a formal and an actual parameter? |
|
View Answer |
|
What is Database Trigger ? |
|
View Answer |
|
What are the uses of Database Trigger ? |
|
View Answer |
|
What are the advantages of having a Package ? |
|
View Answer |
|
What is difference between % ROWTYPE and TYPE RECORD ? |
|
View Answer |
|
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ? |
|
View Answer |
|
What is a cursor ? Why Cursor is required ? |
|
View Answer |
|
What is a database trigger ? Name some usages of database trigger ? |
|
View Answer |