Interview Questions

To send the characters that can not be specified in a URL should be converted into their equivalent hex encoding. To perform this task the methods encodeURI() and decodeURI() are used.

For example, the following code snippet performs the encoding of URL:

<script type="text/javascript">

          var uri = https://www.mysite.com/city?=Banglore; // original URI

          var ncodeuri=encodeURI(uri);

          document.write("<br />ncodeuri”);

          var dcodeuri = decodeURI(ncodeuri); 

          document.write(“<br>/>dcodeuri”);

</script>

The UTL_FILE database package can be used to read and write operating system files. You need to have read /write access rights in that directory before the package can be used.

Example to write file:

Fhandler is a variable of type UTL_FILE.FILE_TYPE

UTL_FILE.PUTF(fHandler, 'Im writing to a file\n');

Example to read file:

UTL_FILE.GET_LINE(fHandler, buf);

A unique constraint on a column uniquely identifies the record by a combination of one or more fields. Few unique constraint fields can have a NULL value as long as the combination of values is unique.

Example:
create table employee ( id number NOT NULL, dob DATE, professor_id NOT NULL, Name varchar(200) Constraint id_unique UNIQUE(id,dob) );

These are accessibility modifiers. Private is the most restrictive, while public is the least restrictive. There is no real difference between protected and the default type (also known as package protected) within the context of the same package, however the protected keyword allows visibility to a derived class in a different package.

By monitoring ad campaign performance an advertiser may obtain the information needed to determine if campaigns are meeting overall marketing and conversion goals compare campaign performance to that of other advertisers create separate adwords accounts for low-performing keywords create duplicate ad groups with identical keywords and different ad variations.

Standard deviation measures total risk in stocks.

CDATA - (Unparsed) Character Data

The term CDATA is used when you dont want some text data to be parsed by the XML parser.

A CDATA section starts with "<![CDATA[" and ends with "]]>": 

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