Interview questions

Personal oracle lite (POL)


<<Previous   Next>>
Personal oracle lite (POL) - June 17, 2010 at 12:30 PM by Babu Kunwar

Test your Peoplesoft Skills!

How compatible is Oracle Lite with the standard oracle server?

Oracle Lite is a database with a small footprint designed to fit on hand held devices and laptops. Primary use is for replication of an enterprise database. On the other the oracle server can be used anywhere either for small scale or large application...............
Read Answer

What is personal oracle lite?

Personal Oracle lite is single user database for distributed and mobile computing. It supports a full range of Java database features as well as advanced replication..............
Read Answer

Explain how to connect to a POL database

The one of the most interesting features of POL database is that it is not authenticated. That is the password part for connecting to the database is optional..............
Read Answer

Explain how to write Java Stored Procedures

A Java stored procedure is a procedure that is written in Java instead of 3GL languages like PL/SQL and stored in the Oracle database.................
Read Answer

Explain how to replicate data using Oracle Lite

Oracle Database Lite has built in replication functionality. At the database level Oracle Lite supports the CREATE SNAPSHOT command. This creates a special table.................. 
Read Answer

<<Previous   Next>>
What is snapshot in oracle?

A recent copy of a table or a subset of rows or cols of a table is called as snapshot in oracle. A snapshot is more useful in distributed computing environment. We can create..........

What is a sequence in oracle?

A Sequence is a user created database object. A sequence can be shared by multiple users to generate unique integers. This object is used to create a primary key value...............

How to call a trigger inside a stored procedure?

A trigger cannot be called within a stored procedure. Triggers are executed automatically as a result of DML or DDl commands.............



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring