Oracle Interview  Questions And Answers Set - 12   ... the logic involved with that, and loads directly into the Oracle data files. More information about the restrictions of direct path ... on the triggering table. Describe Oracle database's physical and logical structure ? Physical : Data files, ...

Blog entry - admin - 2008-01-21 17:28 - 0 comments - 0 attachments

[ Apex Tech ]   Oracle /Dev 2000 Test - 1. 1. Which of the ... to Wordpad. b. Change FORMS45_EDITOR parameter in the oracle Environment. c. Using forms menu Tools -> Options -> Runtime ... .. [ SET-2 ] {Oracle /Dev 2000 Test - 2} 1. A stored program unit needs to ...

Blog entry - root - 2007-04-02 19:09 - 0 comments - 0 attachments

  Paper: Oracle Campus Interview Held on 11th July 2003  1. given ... some other table (CAMPUS, Interview, PAPER, Oracle, 2003, Interview Zone) ...

Blog entry - admin - 2009-02-10 21:05 - 0 comments - 0 attachments

PAPER: ORACLE PLACEMENT PAPER (TECHNICAL- OBJECT GROUP, CANVAS VIEW, WINDOWS, MODULES) ... ANS:- For a modelless window, it determines whether oracle forms hides the window automatically when the operators navigates to an ... 17. What are different types of modules available in oracle form? ANS:- Form module - a collection of objects and ...

Blog entry - admin - 2009-01-20 17:36 - 0 comments - 0 attachments

ORACLE INTERVIEW QUESTONS - SET-17   What are ... cannot use POSTION(x:y) with delimited data. Luckily, from Oracle 8i one can specify FILLER columns. FILLER columns are used to skip ... when you can't use direct load. Refer to chapter 8 on Oracle server Utilities manual. Turn off database logging by specifying the ...

Blog entry - admin - 2008-03-05 19:11 - 0 comments - 0 attachments

ORACLE INTERVIEW QUESTIONS - SET-7   How do you trap ... ? SQL *forms is 4GL tool for developing and executing; Oracle based interactive application. How do you control ... graphics What are the type of User Exits ? ORACLE Precompliers user exits OCI (ORACLE Call Interface) Non-ORACEL user ...

Blog entry - admin - 2008-03-05 18:48 - 0 comments - 0 attachments

PAPER: ORACLE   PLACEMENT PAPER (TECHNICAL- ASP & DATABASE) ... When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new ... the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions. 16. ...

Blog entry - admin - 2009-01-19 16:07 - 0 comments - 0 attachments

... What is the difference between oracle,sql and sql server ? Oracle is based on RDBMS. ...

Blog entry - admin - 2008-03-08 13:30 - 0 comments - 0 attachments

PAPER: ORACLE   PLACEMENT PAPER (SQL, PL/SQL ) 1. ... a] Raised automatically / Explicitly in response to an ORACLE_ERROR b] An exception will be raised when an error occurs in that ... explicitly c] Raised automatically in response to an Oracle error d] None of the above Ans : C ...

Blog entry - admin - 2009-01-19 16:22 - 0 comments - 0 attachments

Paper: Oracle Campus Placement Paper (Aptitude & Technical) 1. A ... creates an object without a TABLESPACE clause, where will Oracle store the segment? (A) System tablespace ... (C) Default tablespace for the user (D) Oracle will give an error 21. The primary key on table EMP ...

Blog entry - admin - 2009-01-20 17:32 - 0 comments - 0 attachments