Interview Questions

Too_many_rows.

No_Data_Found.

Zero_Error.

A collection just like an array is an ordered group of elements of the same type. Each elements position is determined by a unique subscript.

Index by tables:- They are similar to hash arrays that allows to search for subscript values using arbitrary numbers and strings.

They can be declared as:

TYPE type_name IS TABLE OF element_type [NOT NULL]

INDEX BY [BINARY_INTEGER | PLS_INTEGER | VARCHAR2(size_limit)];

INDEX BY key_type;

Example:

TYPE studenttyp IS TABLE OF emp%ROWTYPE

INDEX BY BINARY_INTEGER;

stud_tab studenttyp;

Nested tables:- they hold random number of elements and use sequential numbers as sub scripts.

They can be declared as:

TYPE type_name IS TABLE OF element_type [NOT NULL];

Example: TYPE employee_type IS TABLE OF NUMBER INDEX BY VARCHAR2(64);

Varrays: Holds a fixed number of elements which can be changed in run time. 

They can be declared as:

TYPE type_name IS {VARRAY | VARYING ARRAY} (size_limit) OF element_type [NOT NULL];

Example: TYPE Calendar IS VARRAY(366) OF DATE;

You should not use AJAX if:

             =>  You want the page to show in a search engine, such as Google, because WebCrawler does not execute JavaScript code.

             =>  The browser does not support JavaScript.

             =>  You want to create a secure application.

I mostly follow my intuitions with full belief in them. But the outcome decision is based upon the analysis of the situations. So for people around me i am an analytical person, which is true to an extent. I don't come to, even a simplest decision in a rush.

PHP is rapidly gaining the popularity and many companies are switching their current language for this language. PHP is a server side scripting language. PHP executes the instructions on the server itself. Server is a computer where the web site is located. PHP is used to create dynamic pages and provides faster execution of the instructions.

Node.js is a framework for web applications built on Google Chrome's JavaScript Engine(V8 Engine).

Node.js is comes with runtime environment on which a cript based on javascript can be interpreted and executed (It is analogus to JVM to JAVA byte code). This runtime environment allows to execute a JavaScript code on any machine outside a browser. Because of this runtime of Node.js, JavaScript is now can be executed on server also.

Node.js is provides a rich library of various javascript modules which eases the developement of web application using Node.js to greater extents.

PL/SQL is Procedural Language SQL that is an extension of SQL that results in a more structural language composed of blocks. It is mainly used in writing applications that needs to be structured and has error handling.