|
Related Questions |
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
|
|
What is the usage of SAVEPOINTS?
|
View Answer
|
|
What is referential integrity constraint?
|
View Answer
|
|
What is an integrity constraint?
|
View Answer
|
|
What is the fastest way of accessing a row in a table?
|
View Answer
|
|
What is ROWID?
|
View Answer
|
|
Explain UNION, MINUS, UNION ALL and INTERSECT?
|
View Answer
|
|
Difference between SUBSTR and INSTR?
|
View Answer
|
|
What is a join? Explain the different types of joins?
|
View Answer
|
|
What is difference between TRUNCATE & DELETE ?
|
View Answer
|
|
What's an SQL injection?
|
View Answer
|
|
What is the use of DESC in SQL?
|
View Answer
|