Technology Questions

The number of rows returned by a select query can be restricted by the LIMIT clause.
Example:
SELECT * from employee
LIMIT 20

Anonymous class is class without name.

EX:

class A {

}

class Demo {

    A r = new A() {

        }; //anonymous class

}

Even though both PL/SQL and Java (or) .NET can be used, PL/SQL stands above these two in terms of integration overhead. This is because Java is an open source proprietary and Data manipulation is slightly faster in PL/SQL than in Java. 

In an Interactive Report, user can define maximum 20 secondary lists.

ClassName refName = new ClassName();

or

ClassName refName;

refName = new ClassName();

advantages: view is used to retrieve the data very fastly from the database tables
* memory wastage is reduced
* faster than joins to retrieve the data from database tables

disadvantages:
* view is not a container,it will not hold the data
* view memory is not permanent memory

Number, String, Boolean, Function, Object, Null, Undefined.

strat_form using this we can open many layoutses
open_form using this we can open the layout
performance will be high