ORACLE COMPANY LATEST WALK-INS@2016

Oracle Requirement For Application Developer @2016

Oracle company profile:

Oracle With more than 420,000 customers and deployments in more than 145 countries, Oracle offers a comprehensive and fully integrated stack of cloud applications, platform services, and engineered systems. Learn more about Oracle and who we are.View more

Oracle company job location:

Mumbai View more

Oracle company selection process:

written test and PR/TR/HR ROUND view more

Oracle company previous placement papers:

Which system variables can be set by users?

ANS:

SYSTEM.MESSAGE_LEVEL

SYSTEM.DATE_THRESHOLD

SYSTEM.EFFECTIVE_DATE

SYSTEM.SUPPRESS_WORKING.

Q2. What is ALERT?

ANS:

An ALERT is a modal window that displays a message notifying operator of some application condition.

Q3. What is call form stack?

ANS:

When successive forms are loaded via the CALL_FORM procedure, the resulting module hierarchy is known as the call form stack.

Q4. What is a visual attribute?

ANS:

Visual attributes are the font, color, and pattern properties that you set for form and menu objects that appear in your applications interface.

Q5. Which trigger related to mouse?

ANS:

When-Mouse-Click

When-Mouse-DoubleClick

When-Mouse-Down

When-Mouse-Enter

When-Mouse-Leave

When-Mouse-Move

When-Mouse-Up

Q6. Can you change VAT at run time?

ANS:

Yes. You can programmatically change an object named visual attribute setting to change the font, color, and pattern of the object at runtime.

Q7. What are the steps involved in Database Startup?

ANS:

Start an instance, Mount the Database and Open the Database.

Q8. What are the different modes of mounting a Database with the Parallel Server?

ANS:

Exclusive Mode: If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database.

Parallel Mode: If the first instance that mounts

Q9. What are the steps involved in Instance Recovery?

ANS:

Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments. Rolling back transactions that have been explicitly rolled back or have not been committed as indicated by the rollback segments regenerated in step a. Releasing any resources (locks) held by transactions in process at the time of the failure. Resolving any pending distributed transactions undergoing a two-phase commit at the time of the instance failure.

Q10. What are different modes of parameters used in functions and procedures?

ANS:

-IN

-OUT

-INOUT

view more Papers

click Here for more job updates

Click Here For More Info

Click Here To Submit Resume Here