Interview Questions Part 4 - AJAX , Javascript , SQL , Software Estimation

Interview Questions Part 4 - AJAX , Javascript , SQL , Software Estimation

Question 1 :
What does AJAX stand for ?

Answer 1 :
AJAX stands for Asynchronous JavaScript and XML.

Question 2 :
State various attributes of window.open ?

Answer 2 :

Various Window attributes are listed below :

1. channelmode - Specifies if window should be opened in channel mode. IE only.
2. fullscreen - Specifies if window should be opened in full screen mode. IE only.
3. height - Specifies the height of the window.
4. left - Specifies the x coordinates of the window in pixels. IE only. See "screenX" as well.
5. location - Specifies if the location bar of the window should be included.
6. menubar - Specifies if the menu bar of the window should be included.
7. resizable - Specifies if window should be resizable.
8. screenX - Specifies the x coordinates of the window in pixels. NS only. See "left" as well.
9. screenY - Specifies the x coordinates of the window in pixels. NS only. See "top" as well.
10. scrollbars - Specifies if window should contain scrollbars.
11. status - Specifies if the status bar of the window should be included.
12. toolbar - Specifies if the toolbar of the window (ie: reload button) should be included.
13. top - Specifies the y coordinates of the window in pixels. IE only. See "screenY" as well.
14. width - Specifies the width of the window.

Question 3 :
What are different parameters to window.open ?
 
Answer 3 :
Different parameters of window.open are :

1. URL - Specifies url of page to open
2. Name - Assigns a target name to the newly opened window.
3. Attributes - Controls the look of the opened window

window.open("URL","Name","Attributes");
Example :
window.open('www.google.com','win1','width=300,height=200,menubar');

Question 4 :
How to open pop up window using javascript ?

Answer 4 :
window.open

Question 5 :
What is third normal form in SQL ?

Answer 5 :
To be in third normal form i.e 3NF , non key field should not depend on other non key field. In other words, third normal form does not permit any strictly informational attribute to depend upon anything other than a superkey.

Question 6 :
What is second normal form in SQL ?
 
Answer 6 :
To be in second normal form i.e 2NF , all information attributes or fields of the table are attributes of entity of table schema. All information fileds in the table is directly related to entire primary key or entity of table.

Question 7 :
What is first normal form in SQL ?
 
Answer 7 :
To be in first normal formal i.e 1NF , each fields in table should be atomic and unique. There should not be any duplicate information.

Question 8 :

What are characterstics of well designed normalized database ?
 
Answer 8 :
Characteristics of well designed normalized database are :

1. Table should have identifier
2. Table should store data for single type of entity
3. Table should not have repeating values or columns
4. Table should avoid nullable columns

Question 9 :
What is noramaization and different types of normalization ?

Answer 9 :
Normalization is set of rules to design tables and table relationships. Normalized database would have large number of narrow tables i.e with less number of columns.

There are 3 types of normalization :

1. First Normal Form
2. Second Normal Form
3. Third Normal Form

Question 10 :
What are various software estimation technique ?
 
Answer 10 :
Various software estimation techniques are listed below :

•Expert Judgment Method
• Lines of Code estimation
• Three Point estimation technique,
• Work break down structure based estimation.
• Task complexity Based estimation,
• Function Point Estimation
• Use Case based Estimation