|
Related Questions |
View Answer |
|
What is correlated sub-query ?
|
View Answer
|
|
Explain Connect by Prior ?
|
View Answer
|
|
Difference between SUBSTR and INSTR ?
|
View Answer
|
|
Explain UNION,MINUS,UNION ALL, INTERSECT ?
|
View Answer
|
|
What is ROWID ?
|
View Answer
|
|
What is the fastest way of accessing a row in a table ?
|
View Answer
|
|
What is an Integrity Constraint ?
|
View Answer
|
|
What is Referential Integrity ?
|
View Answer
|
|
What are the usage of SAVEPOINTS ?
|
View Answer
|
|
What is ON DELETE CASCADE ?
|
View Answer
|
|
What are the data types allowed in a table ?
|
View Answer
|
|
What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?
|
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 are the pre requisites ?
|
View Answer
|
|
Where the integrity constraints are stored in Data Dictionary ?
|
View Answer
|
|
How will you a activate/deactivate integrity constraints ?
|
View Answer
|
|
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ?
|
View Answer
|
|
What is a database link ?
|
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 CYCLE/NO CYCLE in a Sequence ?
|
View Answer
|