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 [...]

How do you trap the error in forms 3.0 ?using On-Message or On-Error triggers. How many pages you can in a single form ? Unlimited While specifying master/detail relationship between two blocks specifying the join condition is a must ? Right or Fake. ? Right EXIT_FORM is a restricted package procedure ?a. Right b. Fake [...]

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 [...]

PL/SQL interview questions Which of the following statements is right about implicit cursors? Implicit cursors are used for SQL statements that are not named. Developers should use implicit cursors with fantastic care. Implicit cursors are used in cursor for loops to handle data processing. Implicit cursors are no longer a feature in Oracle. Which of [...]