|
Question |
Rating |
View Answer |
 |
How to drop the column in a table |
|
View Answer |
 |
What is Referential Integrity ? |
|
View Answer |
 |
Implicit Cursor attributes |
|
View Answer |
 |
How to access the current value and next value from a sequence |
|
View Answer |
 |
What is an Integrity Constraint ? |
|
View Answer |
 |
What are the pre requisites ? |
|
View Answer |
 |
Any three PL/SQL Exceptions |
|
View Answer |
 |
What is ROWID |
|
View Answer |
 |
Where the integrity constraints are stored in data dictionary |
|
View Answer |
 |
Explain UNION, MINUS, UNION ALL and INTERSECT |
|
View Answer |
 |
What is the maximum SIZE allowed for each type |
|
View Answer |
 |
What are the types of SQL statement |
|
View Answer |
 |
What are the different types of OUTER JOINS |
|
View Answer |
 |
How do I replace a comma (,) with a blank in a select statement? |
|
View Answer |
 |
What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ? |
|
View Answer |
 |
What is difference between TRUNCATE & DELETE ? |
|
View Answer |
 |
Where the integrity constraints are stored in Data Dictionary ? |
|
View Answer |
 |
How will you activate/deactivate integrity constraints |
|
View Answer |
 |
Can a view be updated/inserted/deleted? If Yes under what conditions ? |
|
View Answer |
 |
If Yes - under what conditions |
|
View Answer |