SAP4INDIA.COM

Oracle Interview Questions   The interview process can be quite stressful. Here is the first part of a two part series on helping you answer those tough questions that you might experience in your quest for an Oracle DBA position.   Ever since I wrote the past article on the Oracle Technical Interview, I have [...]

Does user exits supports DLL on MSWINDOWS ?YES . What is path setting for DLL? Make sure you include the name of the DLL in the FORMS45_USEREXIT variable of the ORACLE.INI file, or rename the DLL to F45XTB.DLL. If you rename the DLL to F45XTB.DLL, replace the existing F45XTB.DLL in the ORAWINBIN directory with the [...]

How does one stop and start the OMS? (for DBA)Use the following command sequence to stop and start the OMS (Oracle Management Server): oemctl start omsoemctl status oms sysman/oem_tempoemctl stop oms sysman/oem_tempWindows NT/2000 users can just stop and start the required services. The default OEM administrator is “sysman” with a password of “oem_temp”. NOTE: Use [...]

· What are the various types of queries ? Answer: The types of queries are: l Normal Queries l Sub Queries l Co-related queries l Nested queries l Compound queries · What is a transaction ? Answer: A transaction is a set of SQL statements between any two COMMIT and ROLLBACK statements. · What is [...]

Hot backup vs. cold backupWhat are actual and formal parameters?Can we protect our PL/SQL source code?Clarify an Exception and its types. Write a PL/SQL program for a trigger. Latest answer: PL/SQL program for tracking operation on a emp tableMake or Replace Trigger EmpTrackingBefore Insert or Delete or Update on Emp………………Read answer Advantage of a stored [...]