|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Dual table explain. Is any data internally storing in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why Latest Answer : when we try access a table which is locked or manipulated by another user ... All the users are complaining that their application is hanging. How you will resolve this situation All the users are complaining that their application is hanging. How you will resolve this situation in OLTP In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan The DBA has added STATE column to the CUSTOMERS table and has asked you to add acorresponding State item to the Customers block of the Orders form. You want to make it easier for order entry clerks to enter the correct state abbreviation. Most customers are located in five southeastern states, although on very rare occasions there will be customers from outside that area. You decide to implement a list item with five values for the State item and allow clerks to enter the state abbreviation director Very next day on the prodction box It looks some procedres/packages got invlidated. What command I should give to know how many packges are invalidated. If suppose thousands are the packages invalidated then what command I should Issut to get then validated.
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0