|
Related Questions |
View Answer |
|
What are the various uses of database triggers ?
|
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
|