|
Question |
Rating |
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 under what conditions ? |
|
View Answer |
 |
What are the advantages of VIEW ? |
|
View Answer |
 |
What is CYCLE/NO CYCLE in a Sequence ? |
|
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 |
 |
What is a database link ? |
|
View Answer |
 |
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ? |
|
View Answer |
 |
How will you a activate/deactivate integrity constraints ? |
|
View Answer |
 |
Where the integrity constraints are stored in Data Dictionary ? |
|
View Answer |
 |
What are the pre requisites ? |
|
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 are the usage of SAVEPOINTS ? |
|
View Answer |
 |
What is Referential Integrity ? |
|
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, INTERSECT ? |
|
View Answer |