Interview Questions

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) );

The Sales Order is a confirmation document sent to the customers before delivering the goods or services. 

Sales Order (SO) can be created once the quote is accepted by your prospective customer and the Purchase Order (PO) is sent by the customer for further processing.

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);

The JVM performs three main tasks:

• Loads code

• Verifies code

• Executes code

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.

A NSArray’s contents can not be modified once it’s been created whereas a NSMutableArray can be modified as needed, i.e items can be added/removed from it.

- Frames make it easier to navigate through a site. 

- The links that appear in the frame can appear through out the site.

switches are configured using the .config file

<system.diagnostics>

<switches>

<add name="MyTraceSwitch" value="1" />

<add name="TraceSwitch2" value="1" />

</switches>

</system.diagnostics>

both are on.