|
Question |
Rating |
View Answer |
|
1)What ll be in the redolog file after deleting the table ,will it stores the table or any thing else? 2)Can we resize the redolog files?
|
|
View Answer |
|
Whats the difference between indexes,views,synonyms? |
|
View Answer |
|
What is the difference between DATABASE ADMINISTRATION & ORACLE? |
|
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 |