|
Question |
Rating |
View Answer |
|
What is an integrity constraint ? |
|
View Answer |
|
What is a event handler ? |
|
View Answer |
|
What are the types of processes that a server runs ? |
|
View Answer |
|
Why do stored procedures reduce network traffic ? |
|
View Answer |
|
What does teh term upsizing refer to ? |
|
View Answer |
|
Why is the most of the processing done at the sever ? |
|
View Answer |
|
What does preemptive in preemptive multitasking mean ? |
|
View Answer |
|
What is the difference between Truncate and Delete interms of Referential Integrity? |
|
View Answer |
|
What are steps required tuning this query to improve its performance? |
|
View Answer |
|
How to Select last N records from a Table? |
|
View Answer |
|
Which of the following is not a feature of a cursor FOR loop? |
|
View Answer |
|
Which of the following statements is true about implicit cursors? |
|
View Answer |
|
If a view on a single base table is manipulated will the changes be reflected on the base table?
|
|
View Answer |
|
Can a view be updated/inserted/deleted? If Yes, then under what conditions? |
|
View Answer |
|
What are the advantages of VIEW? |
|
View Answer |
|
How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value? |
|
View Answer |
|
How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY? |
|
View Answer |
|
What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type? |
|
View Answer |
|
What are the data types allowed in a table? |
|
View Answer |
|
What is ON DELETE CASCADE? |
|
View Answer |