EXTjs interview questions

1) What is the use of extjs in asp.net ?

To enrich the user interface using inbuilt API’s in extjs . Extjs also suppotrs jason which is light weight when compared to XML.

will update with further more questions with answers

Oracle interview questions

1) What are the various databases you have worked with ?

Oracle , SQl server , MySql are the mostly used , but be prepared for questions on other databases if you are going to say u have worked on others  besides oracle .

2) what is sql and what is PL/SQL ?

SQL – structured query language which has a  a single line executable statement .

PL/SQL a super set of SQL enables a procedural langaue model where we can write multiple lines of SQL statements as a block.

3) how do you select the second largest salary from a table ?

using a rank function .

4) what is normalization ?

The process of decomposing tables to eliminate data redundancy is called Normalization. There are five normal forms . Google around for this .one of the irritating interview questions

5) difference between char and varchar ?

6) what is a trigger and why you need it , this can also be done bywriting the trigger code as a seperate function ?

7) what is a cursor and have you heard of REF – cursor ?

8) what is a index and when u need this . what are the different types ?

9) Difference between drop and truncate ?

10) what are the DML and DDL commands ?

11) what is a view and can we create a trigger for a view ?

12) do u know stored procedure, packages,functions ?

13) commit and rollback , savepoint ?

14) what is a package and what is UTIL ?

Package is used to group related objects like procedures , functions under one roof . UTIL is a package provided by oracle to extract or load file in oracle .

 

15) what  is decode and what is varray ?

Decode is a function which enables us to use it like IF >> THEN >> ELSE statement.

 

decode (’empname’,1000,’rich’

,101,’poor’)

 

the above code will check empname column and will return as rich if the value is 1001 and return as poor if the value is 101 .

 

16)how to catch exception errors in oracle ?

In the exception block , use raise_application_error(errcode,’err message’) for user defined exceptions .

 

These are some of the important questions when answered the interviewer believes that the resource can be trained and deployed . Happy job hunting

Home and its beauty

When we choose a home , besides the locality and the legal procedures included in it . It’s very important to choose the interiors which will determine  our taste and make our home a better place for a family . Each and every individual have a different taste and hence the accessories should go with his/her aesthetic sense .

Bathrooms are one of the area that needs to be designed and maintained in a very good manner . when we choose out accessories like bathtubs,shower enclosures , bathroom tiles etc we should go for a store which provides a variety of designs so that we can choose the one which prefers our taste .

Besides the design it should be of good quality and easy to clean , because these are the accessories which are going to be used on a daily basis and hygiene is very important . Hence we should choose a store that has all these properties , one such store is betterbathrooms. The store  provides good quality and a wide range of bath accessories to choose from . Besides this there are also some great deals out there for you which can be  an added advantage . All products purchased through betterbathrooms have a very high reliable and genuine guarantee which is a boon to all its customers . Besides a user-friendly website enables us to choose the products of our choice with great ease .

Congress will be washed out of power in India

Congress party of  India will be wiped out of power at the next general assembly elections . The government faced embarrisment due to corrupt officials and leaders accross the party and its allies . The 2G scam being the No 1 positon , followed by adarsh , bofors etc . Attacks are striked right at the top most leaders of the party including the prime minister and the congress state president .