|
Related Questions |
View Answer |
|
What is ORA-1555?
|
View Answer
|
|
What is the relation between free list and buffer busy wait?
|
View Answer
|
|
How do you handle exceptions / errors in stored procedures?
|
View Answer
|
|
How would you pass hints to the SQL processor?
|
View Answer
|
|
What rule optimizations are possible in SQL query tuning?
|
View Answer
|
|
What is DDL, DML?
|
View Answer
|
|
How do you sort a table?
|
View Answer
|
|
Different types of table join.
|
View Answer
|
|
What is a cursor? Why do you need them? What are the different kinds of cursor?
|
View Answer
|
|
If you have an open cursor on a table, modify the same tableand commit, what would happen?
|
View Answer
|
|
Name some built-in functions that can be used in SQL queries?
|
View Answer
|
|
Is it advisable to force an index when you want to select mostof the entries in the table?
|
View Answer
|
|
Do you need a commit after DDL statements?
|
View Answer
|
|
How can you find all the tables created by an user?
|
View Answer
|
|
How is locking implemented?
|
View Answer
|
|
Whenever a DBA creates a user in which datafile that will be get created ?
|
View Answer
|
|
What is a lookup table in database? where can we use these type of table?
|
View Answer
|
|
Is it possible to disable the connection sys as sysdba. If yes, does violates oracle 9i Any attempts would be appreciated
|
View Answer
|
|
Can we decrease the Datafile size?
|
View Answer
|
|
What are the components of physical database structure of Oracle database
|
View Answer
|