Friday, 28 August 2015

Top 20 Organizational Psychology Interview Questions with Answers

Hey friends, here we come with then new set of interview questions answers which belong to psychologist, If you are preparing for that then this set for you. Here are the best 20 interview questions with answers.

Top 20 Organizational Psychology Interview Questions

1). Tell me about a time you needed to get information from someone from your team who wasn’t very responsive. What did you do?
Ans: This question is to check your psychology as a team leader in managing the work given to the members of your team. You can tell them that you will try to get the information from the assigned person anyhow and if that is still impossible then you will try to assign this work to someone who is easily available and can do the work on time for you.

2). When you’re working with a large number of customers, it’s tricky to deliver excellent service to them all. How do you go about prioritizing your customers’ needs?
Ans: Generally in such situations you will give all your priorities to the customers who have big orders or have big projects in association with you. But this method is not appreciated as a good business skill as you may lose your small customers in this process. What you can do is, you can analyze all the projects in such a way that more projects are covered in lesser time considering the facts about the availability of resources with you.

3). Tell me about a time you failed. How did you deal with this situation?
Ans: Failing in some particular task given to you may happen in your professional lives. Failing in some project does not prove that you are not good for that job. You can say them that you thought upon the reasons of your failure and you worked harder than before to improve yourself at those points.

4). Give me an example of a time you managed numerous responsibilities. How did you handle that?
Simply give an example when you had loads of work and explain them how did you manage those tasks and completed the work on time.

5). Tell me about a successful presentation you gave and why you think it was a hit.
Ans: Tell them about presentation you gave either in your last job or at your college level, elaborate on the topic and explain them about its success.

6). Tell me about a time you were dissatisfied in your work. What could have been done to make it better?
Ans: Give them an example when your work lagged perfectness due to lack of preparation or some other reason. Tell them that it could have been done in a better way if you had planned for it more accurately before and a little more preparation would have done the job for you.

7). We all make mistakes we wish we could take back. Tell me about a time you wish you’d handled a situation differently with a colleague.
Ans: As a team member when you are working in a team, you assign some work to a colleague on the basis of his talent and the hope that he would do it perfectly, but later the results were not according to your expectations. Give an example which does not let you down for the job position you may have applied for.

8). Give me an example of a time when you had to think on your feet in order to delicately extricate yourself from a difficult or awkward situation.
Ans: I think this is a question for you that can get you the job if you answer it in a proper way. You can Ans: give them an example from your past or make any example of your own. Make sure you are able to convince them on the fact that your abilities can help you solve any problem that you face in that profession.

9). Tell me about a time you set a goal for yourself. How did you go about ensuring that you would meet your objective?
Ans: Say them that your very recent goal was to get employed in this company. You ensured about this goal on the basis of your abilities and experience. You can also add that you feel that your skills are something that can prove out to be assets for this company and probably they can also get you this job.

10). Give me an example of a time when you had to explain something fairly complex to a frustrated client. How did you handle this delicate situation?
Ans: There are situations in someone’s profession when he has got to explain some things to a person who is from a different background. Example: A software engineer explains about some programs to a client who is from the commerce background. Tell them that you will try to relate the stuff by comparing it with some objects which are very common in the commerce background and try to make him understand what you want to explain.

11). Give me an example of a time you were able to be creative with your work. What was exciting or difficult about it?
Ans: Give them an example about some projects of your and explain what difficulties you faced in it and how did you manage to solve those problems and make it exciting.

12). Describe a time when you struggled to build a relationship with someone important. How did you eventually overcome that?
You can give an example that you had an arrogant client in your past whose projects were very important for your company. You overcame it having a discussion with the client and getting to know about what all he needs from you and suggesting him with a solution which is appreciable for both.

13). Tell me about a time when you made sure a customer was pleased with your service.
Ans: You can give example about some customer who came to you with some project which demanded a lot of hard work from your side. And explain them how worked hard accordingly putting all your efforts into it to make sure that all the needs of the customers are fulfilled.

14). Tell me about the first job you’ve ever had. What did you do to learn the ropes?
Ans: Generally when you are at some new place working in a new environment then it takes time for you to settle with everyone. Tell them that you became good friends with your new colleagues and learnt a lot about the company and its working system from them.

15). Sometimes it’s just not possible to get everything on your to-do list done. Tell me about a time your responsibilities got a little overwhelming. What did you do?
Ans: Give an example when the things that you had planned in advance were about to take another direction and explain them how you managed to go accordingly in your way.

16). Tell me about a time when you had to rely on written communication to get your ideas across to your team.
Ans: Generally when some big project is being carried out and the work is distributed among many people in a team then it becomes difficult to keep a track of what all is decided in a single meet. There are also chances that a few team members may also forget about what was decided. Explain them how the written communication helped you to complete the work in the best efficient way possible in very less time.

17). Tell me about a time when you worked under close supervision or extremely loose supervision. How did you handle that?
Ans: There are chances that a supervisor may not do his job properly and the employees may even not take the work seriously. Tell them that even if such situations occur you will make sure that you do the work that is assigned to you in a perfect way so that there are no problems in future.

18). Give me an example of a time when you were able to successfully persuade someone to see things your way at work.
Ans: Give them an example about a project you were doing in a team and how to successfully managed to distribute the work to each member and explained them the way you wanted the work to be done.

19). Tell me about a time you had to be very strategic in order to meet all your top priorities.
Ans: Give an example when you were handling many projects at the same time and how did you plan to put things in such a way that helped you meet the needs of all your top priorities.

20). Describe a time when your team or company was undergoing some change. How did that impact you, and how did you adapt?
Ans: You can give the example about the time when you were promoted to a more responsible position in your company, and how did you manage to adapt to all the new responsibilities that were assigned to you in your new position.

Thursday, 27 August 2015

SQL SERVER DATA TYPES INTERVIEW QUESTIONS ANSWERS FOR FRESHER AND EXPERIENCED

SQL SERVER DATA TYPES INTERVIEW QUESTIONS FOR FRESHER AS WELL AS EXPERIENCED FROM BASIC TO COMPLEX
Here we are coming with SQL server interview questions category wise and this category is belong to SQL Server data types. So if you are fresher or experienced must go through below question and prepare your self for your upcoming interview. We have one request if you have any questions related to datatype then must leave as a comment we will add it in this list, and soon we will provide full pdf.

So let's first go through SQL Server Data types
DATATYPEDESCRIPTION
bigintInteger data from -2^63 to 2^63-1
binaryFixed-length binary data with a maximum length of 8,000 bytes
bitInteger data with either a 1 or 0 value (often for a true or false reading)
charFixed-length non-unicode character data with a maximum length of 8,000 characters
cursorA reference to a cursor
datetimeDate and time data from January 1, 1753, through December 31, 9999, with an accuracy of 3.33 milliseconds (but use datetime2 instead)
decimalFixed precision and scale numeric data from -10^38 +1 through 10^38 -1 (same as 'numeric') (decimal(9,2)) = max value 9999999.99)
floatFloating precision number data from -1.79E + 308 through 1.79E + 308
imageVariable-length binary data with a maximum length of 2^31 - 1 bytes
intInteger data from -2^31 through 2^31 - 1 (-2 billion to 2 billion approx)
moneyMonetary data values from -2^63 through 2^63 - 1
ncharFixed-length Unicode data with a maximum length of 4,000 characters
ntextVariable-length Unicode data with a maximum length of 2^30 - 1 characters (Deprecated - don't use!)
numericFixed precision and scale numeric data from -10^38 +1 through 10^38 -1 (same as 'decimal')
nvarcharVariable-length Unicode data with a maximum length of 4,000 characters
realFloating precision number data from -3.40E + 38 through 3.40E + 38
smalldatetimeDate and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute
smallintInteger data from -2^15 through 2^15 - 1 (-32000 to 32000 approx)
smallmoneyMonetary data values from -214,748.3648 to +214,748.3647
sql_variantA data type that stores values of various data types, except text, ntext, timestamp, and sql_variant
tableA special data type used to store a result set for later processing
textVariable-length data with a maximum length of 2^31 - 1 characters (Deprecated - don't use!)
timestampA database-wide unique number that gets updated every time a row gets updated
tinyintInteger data from 0 to 255
uniqueidentifierA globally unique identifier
varbinaryVariable-length binary data with a maximum length of 8,000 bytes
varcharVariable-length non-unicode data with a maximum of 8,000 characters
dateholds date
timeholds time
datetime2Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of about 100 nanoseconds, plus more compactly stored
datetimeoffsettakes international time into account in reading
xmlfor storing or even parsing raw xml data

SQL SERVER DATATYPES INTERVIEW QUESTIONS

What do you understand by Data-types in sql server?
Ans: SQL Server data types defines the characteristic of the data that is stored in a column. Each column, variable and expression has related data type in SQL.

How you should choose data type for particular column when you create a table?
Ans: The data type should be chosen based on the information you wish to store. for example you would not use an integer data type for storing employee name.

What is the very useful datatype introduced in SQL Server 2016?
Ans: JSON datatype

What are the two types of character data SQL Server supports? 
Ans: Regular and Unicode

What are the Regular character data types?
Ans: Char and VarChar

What are the Unicode character data types? 
Ans: NChar and NVarChar

How are literal strings expressed with Regular character column?
Ans: Single quote 'text'.

How are literal strings expressed with Unicode character column?
Ans: Must Start with N'text'.

What can you define with variable length character data types?
Ans: VARCHAR(MAX)

How large is VARCHAR(MAX)?
Ans: 8000 Bytes in line. 

Name any five date and time data types?
Ans: 1.) DATETIME
2.) SMALLDATETIME
3.) DATE
4.) TIME
5.) DATETIME2
6.) DATETIMEOFFSET

What does the PARSE function do?
Ans: Parse a value as a requested type and indicate a culture.
Syntax? 
PARSE('date' AS datatype USING culture)

What happens when you only want to work with time in a DATETIME data type? 
Ans: SQL Server stores the date as Jan 1 1900.

What do you understand by Timestamp, Difference between Datetime and Timestamp datatypes?
Ans: Datetime: Datetime is a datatype.
Timestamp: Timestamp is a  data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.
In fact, in sql server 2008 this column type was renamed (i.e. timestamp is deprecated) to rowversion. It basically means that every time a row is changed, this value is increased. This is done with a database counter, i.e. two different rows that where updated in the same transaction have the same row version.

What do you understand by rowversion datatype, have you ever used rowversion?
Ans: Rowversion is a data type that exposes automatically generated, unique binary numbers within a database. rowversion is generally used as a mechanism for version-stamping table rows. The storage size is 8 bytes. The rowversion data type is just an incrementing number and does not preserve a date or a time. 
Timestamp is the synonym for the rowversion data type and is subject to the behavior of data type synonyms. In DDL statements, use rowversion instead of timestamp wherever possible. 
Example : 
CREATE TABLE ExampleTable2 (PriKey int PRIMARY KEY, VerCol rowversion);
OR
CREATE TABLE ExampleTable1 (PriKey int PRIMARY KEY, VerCol timestamp);

How many column a table can, with timestamp column?
Ans: A table can contain only one timstamp column.

What are the differences between Datetime and Datetime2 datatypes?

What are the differences between Datetime and DateTimeOffset datatypes?

Lets suppose today is 27th Aug 2015, What will happend when we run this following script?
Is this script through error or not?
SELECT 1 + GETDATE() + 1
Ans: it will add 2 days in current date time and according to date specified it will display 29th Aug 2015 with current time.

What is User-defined data type in SQL Server?
Ans: User-defined data types also know as Alias types are based on the system data types in Microsoft® SQL Server™ 2000. User-defined data types can be used when several tables must store the same type of data in a column and you must ensure that these columns have exactly the same data type, length, and nullability. For example, a user-defined data type called postal_code could be created based on the char data type. 

Can we use User-defined data type in table variable?
Ans: No

Can you alter user-defined data types?
Ans: No, If you want to change it then first you need to drop it, and then you need to re-create with your changes.

User-defined data types are located in your databaes node under?
Ans: Programmability > Types > User-Defined Data TYpes 

What is SWITCHOFFSET function?
Ans: SWITCHOFFSET function is used to convert the time from one time zone to another time zone, and it will work for date time offset fields(DatetimeOffset datatype).
Syntex: SWITCHOFFSET ( DATETIMEOFFSET, time_zone )

What is SPARSE data option introduced in SQL Server 2008, when to use it?
Ans: The sparse data option is a new SQL Server 2008 feature for tields you expect to be predominantly null. Using the sparse data option, you can instruct SQL Server to not have nulls consume space in sparsely populated fields.
SPARSE column are better at managing NULL and ZERO values in SQL Server. It does not take any space in database at all. If column is created with SPARSE clause with it and it contains ZERO or NULL it will be take lesser space then regular column (without SPARSE clause).
We can use this option when we sure that our column will contain mostly null values(or zero) etc.
Example : Create table Employee(ID INT, Name Varchar(20) NULL, Salary Money NULL, BonusAmount Money SPARSE NULL)


What are the Advantages and Disadvantages of SPARSE column?
Ans: Advantages of SPARSE column are:
-INSERT, UPDATE, and DELETE statements can reference the sparse columns by name. SPARSE column can work as one XML column as well.
-SPARSE column can take advantage of filtered Indexes, where data are filled in the row.
-SPARSE column saves lots of database space when there are zero or null values in database.

Disadvantages of SPARSE column are:
-SPARSE column does not have IDENTITY or ROWGUIDCOL property.
-SPARSE column can not be applied on text, ntext, image, timestamp, geometry, geography or user defined datatypes.
-SPARSE column can not have default value or rule or computed column.
-Clustered index or a unique primary key index can not be applied SPARSE column. SPARSE column can not be part of clustered index key.
-Table containing SPARSE column can have maximum size of 8018 bytes instead of regular 8060 bytes.
-A table operation which involves SPARSE column takes performance hit over regular column.
Ref: http://blog.sqlauthority.com/2008/07/14/sql-server-2008-introduction-to-sparse-columns-part-2/

Does SPARSE cluse use with the Geography or Geometry data types?
Ans: No, Sparse cannot be used for every data type. It can't be used with Geography or Geometry data types as well as old LOB types(text, ntext, image).

Can a primary key be a sparsed column?
Ans: No

What is the only data type avaliable in SQL Server which can store GPS data that has been defined by the OGC()?
Ans: Geography data type

What is the function which returns the closest path between two Geography points in meters?
Ans: STDistance()

What is the difference between Varchar() and Nvarchar() datatypes?(Most Imp)

What would be the output of the following script?
DECLARE @Name VARCHAR(20)
SET @Name = 'विकास अहलावत'
SELECT @Name
Ans: Output would be "????? ??????"

What would be the output of the following script?
DECLARE @Name NVARCHAR(20)
SET @Name = 'विकास अहलावत'
SELECT @Name
Ans: Output would be "????? ??????"

How will you print or save name as 'विकास अहलावत'?
Ans: To save Unicode character we need to take data type nvarchar and string must be with "N", otherwise you will lost the even you have Nvarchar data type you can see in the above question

DECLARE @Name NVARCHAR(20)
SET @Name = N'विकास अहलावत'
SELECT @Name
Output would be : विकास अहलावत

If you have any questions related to datatype then please share as a comment.

SQL INTERVIEW QUESTION: DIFFERENCE BETWEEN VARCHAR() AND NVARCHAR() DATATYPES

Difference between Varchar() and NVarchar() Data types in SQL Server : Interview Questions
Following are the difference between these two datatypes,
This is the very important interview question, and most favorite interviewer's question, you must face this questions when you go as a fresher for .net or SQL developer interview.

Varchar()NVarchar()
1 - Syntaxvarchar[(n|max)]nvarchar[(n|max)]
2 - Basic DefinationVariable-length, non-Unicode character data.



Variable-length Unicode character data. Support every language (i.e. Hindi, Korean, Chines etc)


3- See
difference
by Example
Example 1: (will give same result)








Example 2: (See the diff in case of Unicode characters, output showing ??)









"???" Means your data has lost
Example 1: (will give same result)


Example 2: (See the diff in case of Unicode characters, output showing as expected)









Note: for Unicode character must prefix with "N" otherwise it will also show "??", Good interview questions!!
4 - Bytes required for each characterVarchar takes 1 byte per character
Example 1:

NVarchar takes 2 byte per character
Example 1:

5- Optional Parameter n range Optional Parameter n value can be from 1 to 8000.
Can store maximum 8000 Non-Unicode characters.

Example: (If you exceed the limit it will throw error)
DECLARE @Name VARCHAR(8001)

Resule:
The size (8001) given to the type 'varchar' 
exceeds the maximum allowed for any data type (8000).

Optional Parameter n value can be from 1 to 4000.Can store maximum 4000 Unicode/Non-Unicode characters

Example: (If you exceed the limit it will throw error)
DECLARE @Name NVARCHAR(4001)

Resule:
The size (4001) given to the parameter '@Name' exceeds the maximum allowed (4000).
6 - When optional parameter
n not specified
It will consider as 1

Example:








Note: some time I face this would be the
root-cause when you not specify size then,
it will take automatically one and will make
sub-string of your actual string and your logic
would be wrong. So be careful about this.

It will consider as 2

Example:

7 - When
Use?
If you are sure that your column or variable data not storing any Unicode character then you must use varchar.If you are not sure, or your column contain multiple language(Unicode characters) then you must use nvarchar.
8- StorageIt will take one byte per character plus two bytes extra for defining offset.
It will take two byte per character plus two bytes extra for defining offset.

Other Interview question related to Varchar and Nvarchar:

What would be the output of the following script?
DECLARE @Name VARCHAR(20)
SET @Name = 'विकास अहलावत'

SELECT @Name

Ans: Output would be "????? ??????"


What would be the output of the following script?
DECLARE @Name NVARCHAR(20)
SET @Name = 'विकास अहलावत'
SELECT @Name

Ans: Output would be "????? ??????"


How will you print or save name as 'विकास अहलावत'?
Ans: To save Unicode character we need to take data type nvarchar and string must be with "N", otherwise you will lost the even you have Nvarchar data type you can see in the above question

DECLARE @Name NVARCHAR(20)
SET @Name = N'विकास अहलावत'
SELECT @Name
Output would be : विकास अहलावत

TOP 50 RESUME OBJECTIVE STATEMENTS SAMPLE / EXAMPLE FOR FRESHER AND EXPERIENCED

50 Best Resume Objective Statements Sample/Example for Fresher or Experienced

Your resume is your self-marketing tool and it is very important for you to make sure that you have a perfect resume before applying for any job either you as a fresher engineer or experienced. An HR receives thousands of resumes per day and for him it becomes very difficult to have a look at every line of every resume. All he does is that he looks at the objectives of a particular candidate in his resume. From my past experience and interaction from various employers, the key tool that is used for shortlisting candidates is on the basis of their Achievements, Profession Goals and Objectives.

Achievements of a person are the positive attributes about himself that he holds in the form of an awarding document for himself. Generally achievements for a fresher are only his educational degrees and some awards that he would have won in him school and college life. But for a person who already has an experience in some particular field, his completed projects and the promotions in his last job are counted as his achievements.

A person’s Profession Goals defines how high he wants to take his career in this profession. A person with higher goals is generally found to be hard working and more eligible for a job compared to others with some small and common goals.
There is no shortage of job seekers and for a particular job there will be at least 3 resumes out of 5 with almost same achievements and goals. Then what is the key factor that can help you to stand out of those resumes?

 The key factor that will help your resume stand out from those thousands of resumes present on the HR’s table is the way you write your objectives. Your objective statement will be something different compared to others on a resume and a hiring manager generally searches for some really convincing objectives on a resume. An effective objective can help you get some special attention from the employer.

Here are a few tips that you should consider before writing objective statements on your resume:
It should be short and simple.
       Try to write whatever you want to say in simple and small sentence. A hiring manager has lots of        work to do and he has no extra time to read your long paragraphs. Try to highlight the keywords          in case if your objective is a little longer.

Stick to your point specifically.
        Be specific when you write your resume. Don’t write points which are not relevant to you.

Write about what you have for them.
        Don’t write things which have no relations with your job. For eg. Don’t write you are a good               singer if you are applying for a software engineer’s job. Singing makes no sense with Software           engineering.

Avoid writing stories.
        Many resumes straightaway get rejected when people write stories to explain about things they           are good at. Avoid repeating this mistake.

Here we have listed a few examples of the Best Objective statements which were selected straightaway from the Best resumes and have been put here without even editing a single word. The objective statements basically cover almost every kind of profession and we hope it helps you to write a perfect resume.

BEST OBJECTIVE FOR YOUR RESUME SELECT ANY SAMPLE

1. I look forward for an opportunity that offers me a greater challenge, provides some increased benefits for my family and also provide me with a chance to prove my abilities.

2. A permanent position in your company or a long term consulting project.

3. An environment where my academic skills and quality experience adds value to the organization.

4. Secure a responsible position as a Sales Manager and use my resourceful experience for the company’s growth and success.

5. Seeking a commanding position in the Marketing team.

6. To work in an environment where I can utilize my skills and education at its best.

7. Looking for an opportunity where my experience can put a positive impact on company’s growth statistics.

8. To further my education skills and knowledge in the field of Information and Technology.

9. To secure a responsible position which can make a significant contribution to my employer’s success and company’s growth.

10. To leverage my resourceful experience for some challenging projects of the company.

11. Software Engineer in a successful and established I.T. company.

12. To use my leadership skills as a successful project head.

13. A position to pursue as an Account Manager which can provide me with an opportunity to use my experience in managing accounts.

14. A position of a Software Engineer which can help me execute plans from my experience to implement them for the company’s growth.

15. An opportunity to utilize my superior knowledge and skills for increasing company’s profit.

16. A senior position which gives me a direct opportunity in playing a big role for the company’s growth.

17. A position that helps me build upon my current skills to work as responsible employee for the company.

18.  Position as a financial analyst to help the company in producing higher outputs from small inputs.

19. I wish to work as a Marketing Director and prove out to be the company’s investment for its future profits.

20. Looking forward to work with a company that provides me an opportunity to meet and exceed assigned goals.

21. Wish to be hired for some environment that uses my knowledge and experience as a Management Process Improvement consultant.

22. Want to get associated with a company which can utilize my skills and give me a chance to prove to be an asset for company’s growth.

23. To contribute my project and operations management skills in handling some dream projects of the company.

24. To seek a fulfilling position in the Manufacturing industry that offers me with great opportunities.

25. To acquire a challenging opportunity which can help me prove my skills as a Sales Manager in an established business.

26. Use my experience to analyze and improve marketing, sales and operational performances.

27. To play a dynamic role in company’s growth and development.

28. Work as a Director who can establish virtues of teamwork in his employees.

29. Obtain a position as an analyst in an established I.T. security industry.

30. Looking to work with some highly professional seniors to improve my knowledge skills.

31. To work as an analyst who can optimize company’s resources for maximum profits.

32. Looking forward for an opportunity that can assign me to work as a team.

33. Wish to focus on marketing challenges for a company which can provide me with opportunities to put my resourceful knowledge in maximizing company’s outcomes.

34. Seeking a job as a Software Engineer to prove as a technical asset for the company.

35. Take responsibilities as a leader and utilize my skills to meet and exceed company goals.

36. An enthusiastic skilled person looking for a challenging position that can use his skills as an asset for the company’s goals.

37. To secure a position as a public relations professional who can use his interacting skills to get more clients for the company.

38. Provide some superior contribution to the company by working as a Marketing Head who can exceed the company goals.

39. To put my knowledge skills and experience in promoting my abilities as a Legal Advisor who can take the company to higher limits.

40. Seek an employment as a Transportation head who can bring the company’s growth on a faster track.

41. A strong desire to transform my company into a well-established environment.

42. Exploring career opportunities to utilize my public interfacing skills as a Chief Public Relations Manager for the company.

43. Looking for a long term employment in a well-established environment.

44. Looking forward to work as a part of the sales team for a company that can provide me opportunities to work hard and exceed the company’s goals.

45. Seeking a position as an Analyst who scale company’s progress to higher levels.

46. To propose my working skills as an ophthalmic assistant who can work with a great influence.

47. Looking forward for a position that offers key participation in team oriented tasks.

48. Seeking a position as an Accounts manager which can utilize my accounts management and technical skills efficiently.

49. Looking forward to diversify my skills for working in an environment that can provide me some opportunities to relocate.

50. Looking forward for an environment that can use my administrative and supervision skills in providing me with some challenges that can really benefit the company with growth and success.

Best of luck for your job....

Wednesday, 26 August 2015

DIFF BETWEEN DATETIME AND DATETIMEOFFSET DATATYPES IN SQL SERVER :INTERVIEW QUESTION

Difference between DateTime and DateTimeOffset Data types in SQL Server : Interview Questions
Following are the difference between these two datatypes

DateTimeDateTimeOffset[(n)]
1 - Min Value1753-01-01 00:00:000001-01-01 00:00:00 +05:30
This datatype also display time zone.

2 - Max Value9999-12-31 23:59:59.9979999-12-31 23:59:59.9999999 +05:30
3 - Time zone offset rangeTime zone not supported-14:00 through +14:00
4 - Size8 bytes is required to store the valueDepends on the millisecond precision; 8 to 10 bytes are required to store the value
5 - SyntaxSyntax is simply DATETIME
DECLARE @CurrentDate DATETIME
Syntax is DATETIMEOFFSET [ (Fractional Seconds Precision) ],
with a default value of 7 for the fractional seconds precision.
DECLARE @CurrentDateTime DATETIMEOFFSET(5)
6 - AccuracyAccuracy is up to 0.00333 secondAccuracy is up to 100 nanoseconds
7 - Time rangeTime range is between 00:00:00 through 23:59:59.997Time range is between 00:00:00 through 23:59:59.9999999
8- Current Date and Time functionSELECT GETDATE()
2015-08-26 22:56:34.670
SELECT SYSDATETIMEOFFSET()
2015-08-27 00:11:04.3897800 +05:30
9 - Addition or subtractionAddition or subtraction to numbers is directly allowed.
Ex
SELECT GETDATE() + 1
Addition or subtraction to numbers is not directly allowed. The function DATEADD should be used
Ex SELECT DATEADD(DAY,1,SYSDATETIMEOFFSET())

But SELECT SYSDATETIMEOFFSET() +1 will throw error
10 - PrecisionNo precision or scale can be specifiedPrecision or scale is from 0 to 7 digits.
Ex: DATETIMEOFFSET(5)
11 - AvailablityAvailable from SQL Server 2000 and onwardsAvailable only from SQL Server 2008 and onwards

SQL SERVER INTERVIEW QUESTIONS : DIFF BETWEEN DATETIME AND DATETIME2

Difference between DateTime and DateTime2 Data types in SQL Server : Interview Questions
Following are the difference between these two datatypes

DateTime DateTime2[(n)]
1 - Min Value 1753-01-01 00:00:00 0001-01-01 00:00:00
2 - Max Value 9999-12-31 23:59:59.997 9999-12-31 23:59:59.9999999
3 - Size 8 bytes is required to store the value Depends on the millisecond precision; 6 to 8 bytes are required to store the value
4 - Syntax Syntax is simply DATETIME
DECLARE @CurrentDate DATETIME
Syntax is DATETIME2 [ (Fractional Seconds Precision) ],
with a default value of 7 for the fractional seconds precision.
DECLARE @CurrentDateTime DATETIME2(7)
5 - Accuracy Accuracy is up to 0.00333 second Accuracy is up to 100 nanoseconds
6 - Time range Time range is between 00:00:00 through 23:59:59.997 Time range is between 00:00:00 through 23:59:59.9999999
7- Current Date and Time function SELECT GETDATE()
2015-08-26 22:56:34.670
SELECT SYSDATETIME()
2015-08-26 22:56:34.6736314
8 - Addition or subtraction Addition or subtraction to numbers is directly allowed.
Ex
SELECT GETDATE() + 1
Addition or subtraction to numbers is not directly allowed. The function DATEADD should be used
Ex SELECT DATEADD(DAY,1,SYSDATETIME())

But SELECT SYSDATETIME() +1 will throw error
9 - Precision No precision or scale can be specified Precision or scale is from 0 to 7 digits.
Ex: Datetime2(6)
10 - Availablity Available from SQL Server 2000 and onwards Available only from SQL Server 2008 and onwards

Saturday, 22 August 2015

vidyalakshmi.co.in | HOW TO APPLY FOR EDUCATION LOANS IN VIDYALAKSHMI.CO.IN

Hey student\professionals apart from interview here we come with great loan related post which is very important for education and it can be a questions in your interview. eg.
Which site is started by Gvt. for Education loan?
Ans: www.vidyalakshmi.co.in

In a student-friendly move, the Central government(Modi goverment) has launched a portal, where students can apply for education loan to multiple banks by filling just one form. So far, 13 banks have registered 22 educational loan schemes on www.vidyalakshmi.co.in.
The portal has the following features:
1- Information about educational loan schemes of banks
2- Common educational loan application form for students
3- Facility to apply to multiple banks for educational loans
4- Facility for banks to download Students’ loan applications
5- Facility for banks to upload loan processing status
6- Facility for students to email grievances/queries relating to educational loans to banks
7- Dashboard facility for Students to view status of their loan application and linkage to National Scholarship Portal for information and application for government scholarships.

Here are the steps "How to Apply For Education Loans"


Steps:
Step 1). Register: Visit www.vidyalakshmi.co.in and register yourself

Account Created
Step 2: Login

Step 3: You will See the list of Bank Schemes
Read the Schemes. Currently there are 22 schemes available. you can read scheme disc below


Available Scheme Description:


1).
Dena Bank
Bank NameDena Bank
Scheme NameSkill Loan Scheme ( Kaushal Wrin Yojana)
DescriptionSkill Loan Scheme ( Kaushal Wrin Yojana) which is a Model Education Loan Scheme for pursuing vocational courses.
Minimum CriteriaAs required by the enrolling institutions/organizations as per National Skill Qualification Framework i.e. NSQF. , which is available on web site www.skilldevelopment.gov.in
Repayment PeriodRs.50000/- , Between Rs.50000/- to Rs.1.00 lac, & above Rs.1.00 lac respectively.
36 months, 60months & 84 months respectively
Interest RateInterest rate for Male (Floating)
11.55% (BR +1.55) payable within 36 months , & 11.55% {BR +1.05 +TP (0.50)} payable above 36 months
1% Interest concession to be provided, if interest is serviced during moratorium period .
Interest rate for Female (Floating)
11.55% (BR +1.55) payable within 36 months , & 11.55% {BR +1.05 +TP (0.50)} payable above 36 months"
Processing FeeFor India : NIL For Abroad Rs. 1000 (Refundable on availing Loan from the bank)
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)150000
2).
BANK OF INDIA
Bank NameBANK OF INDIA
Scheme NameBOI STAR EDUCATION LOAN SCHEME
Description
The Star Educational Loan Scheme aims at providing financial support from the bank to deserving/ meritorious students for pursuing higher education in India and abroad. The main emphasis is that every meritorious student is provided with an opportunity to pursue education with the financial support on affordable terms and conditions.
Student Eligibility
  • Should be an Indian National;
  • Secured admission to professional/technical courses in India or Abroad through Entrance Test/Merit based selection process.
  • Good academic career.
  • The student should not have outstanding education loan from any other Institution.
ELigible Courses
Studies in India
  • Graduation/ Post Graduation courses
  • Professional courses: Engineering, Medical, Agriculture, Veterinary, Law, Dental, Management, Computer, etc.
  • Courses conducted by IIM, IIT, IISc, XLRI, NIFT, NID and other Institutes set up by Central/State Govt.
  • Other courses leading to diploma/degree, etc. conducted by colleges/universities approved by UGC/Govt./AICTE/AIBMS/ ICMR, etc.
Studies Abroad
  • Graduation: For job oriented professional/technical courses offered by reputed universities.
  • Post-Graduation: MCA, MBA, MS, etc.
  • Courses conducted by CIMA - London, CPA in USA, etc.
Margin
  • Upto Rs.4 lakh : Nil
  • Above Rs.4 lakh - Studies in India : 5%
  • Studies Abroad : 15%• Scholarship could be included in margin
  • Margin to be brought in on year to year basis as and when disbursements are made.
Security
  • Upto Rs. 4 lakh : No security
  • Above Rs.4 lakh & upto Rs.7.5 lakh : Collateral security in the form of a suitable third party guarantee.
  • Above Rs.7.5 lakh : Co-obligation of Parents together with tangible Collateral security of suitable value along with the assignment of future income of the student for payment of installments.
Minimum Criteria
  • Student should be an Indian National;
  • Secured admission to professional/technical courses in India or Abroad through Entrance Test/Merit based selection process.
  • Good academic career
Repayment Period
After commencement of repayment :
  • Loan amount up to Rs.7.50 lacs: 10 years.
  • Loan amount over Rs.7.50 lacs: 15 years.
  • Course period + 1 year or 6 months after getting job, whichever is earlier.
Interest Rate
  • Upto Rs.7.50 lacs – 3% above Base Rate, (presently 12.95 %
  • Above Rs.7.50 lacs – 2.50% above Base Rate, (presently 12.45 %)
  • Int. Concession of 0.50%p.a. for woman beneficiaries for limits up to Rs.50,000/- and 1% for limits over Rs.50,000/-
  • For Professional courses (like Engg./Medical/ Management, etc.) int. concession : 0.50% (Maximum under a) and b), above is 1%)
1% int. concession if interest is serviced during moratorium period, where repayment holiday is specified for interest/repayment under the scheme (concession available for moratorium period only)
Simple interest during the repayment holiday/moratorium period. Penal interest @2% for loans above Rs.4 lakh for the overdue amount and overdue period.
Processing FeeNo processing charges.
Pre-Payment ChargesNA.
Amount (maximum amount can be approved to applicant)
Studies in India - Maximum Rs.10.00 lakh
Studies abroad - Maximum Rs.20.00 lakh.
3).
CENTRAL BANK OF INDIA
Bank NameCENTRAL BANK OF INDIA
Scheme NameCent Vidyarthi
Description
  1. Studies in India: (Indicative list)
    1. Approved courses leading to graduate/ post graduate degree and P G diplomas conducted by recognized colleges/ universities recognized by UGC/ Govt. / AICTE/ AIBMS/ ICMR etc.2.Courses like ICWA, CA, CFA etc. 3. Courses conducted by IIMs, IITs, IISc, XLRI. NIFT, NID etc. 4. Regular Degree/Diploma courses like Aeronautical, pilot training, shipping, degree/diploma in nursing or any other discipline approved by Director General of Civil 4.Aviation/Shipping/Indian Nursing Council or any other regulatory body as the case may be, if the course is pursued in India.5.Approved courses offered in India by reputed foreign universities.6.Other job oriented courses leading to technical/ professional degrees, post graduate degrees/diplomas offered by recognized institutions. 7. Courses other than the above offered by reputed institutions may also be considered on the basis of employability. 8. Students pursuing employment oriented courses like teachers training courses and 3 years technical diploma courses in polytechnic institutions after completion of 10th standard are also eligible provided they are offered by approved/recognised colleges/institutions.
    2. Reference: www.ugc.ac.in, www.education.nic.in, www.aicte.org.in
  2. Studies abroad
    1. Graduation :For job oriented professional/ technical courses offered by reputed universities.
    2. Post-graduation:MCA, MBA, MS, etc.,Courses conducted by CIMA-London, CPA in USA etc.;Degree/diploma courses like aeronautical, pilot training, shipping etc provided these are recognized by competent regulatory bodies in India/abroad for the purpose of employment in India/abroad.
    3. Reference: www.webometrics.info (indicative only)
Minimum Criteria
  1. Student should be an Indian National
  2. b. Student should have secured admission to a higher education course in recognized institutions in India through Entrance Test/ Merit Based Selection process after completion of HSC (10 plus 2 or equivalent)
Repayment Period
  • Upto Amount (in Rs.) : Possible Values could be
  • Upto Rs. 4 lacs- 120 months
  • Between Rs. 4 lacs and Rs. 7.5 lacs- 120 months
  • Above Rs. 7.5 Lacs- 180 months
  • Please enter period in months
  • If the repayment period is different for different amounts, please fill details in separate columns
Interest Rate
For loans upto Rs.4 lacs: 3.65% above Base Rate, currently 13.35% p.a.
Above Rs.4 lacs and upto Rs.7.50 lacs: 3.90% above Base Rate, currently 13.60% p.a.
Above Rs.7.50 lacs: 1.90% above Base Rate, currently 11.60% p.a.
0.50% concession in interest for girl students
1% concession for full tenure of the loan, if interest is serviced promptly as and when applied during the moratorium period, including course duration
Processing FeeNIL
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)INDIA: Rs 10 lakhs, ABROAD: Rs. 20 lakhs
Bank Name
Bank NameBANK
Scheme NameSCHEME
DescriptionDescription
Minimum CriteriaMinimum
Repayment PeriodRepayment
Interest RateInterest
Processing FeeProcessing
Pre-Payment ChargesPre-Payment
Amount (maximum amount can be approved to applicant)Amount
4).
Canara Bank
Bank NameCanara Bank
Scheme NameCanara Bank Vidya Turant Loan scheme
Description
Loan Limit:
  • Students of IIMs: Limit up to Rs 25.00 lacs
  • Students of ISB, Hyderabad & Mohali: Limit up to Rs 30.00 lacs.
  • All other institutions other than Limit up to Rs 20.00 lacs
Minimum Criteria
  • Student should have secured Admission to the approved institutions by Canara Bank under Vidya Turant Scheme
Repayment Period
  • 10 - 15 years
Interest Rate
  • base rate i.e.10.00 %
Processing FeeNIL
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)
  • Students of IIMs Limit up to Rs 25.00 lacs.
  • Students of ISB, Hyderabad & Mohali Limit up to Rs 30.00 lacs.
  • All other institutions other than Limit up to Rs 20.00 lacs.
5).
Canara Bank
Bank NameCanara Bank
Scheme NameCanara Bank Vidya Sahay Loan scheme
DescriptionAt the Counseling centres, students are expected to remit the initial amount by way of DD which may range from Rs.40000/- upto Rs.1.00 lac. Many parents of such students find it difficult to arrange for funds, and resort to outside borrowings at higher rates. Hence to help such students a new scheme – Vidya Sahay has been designed and introduced
Minimum CriteriaStudents who appeared in CET conducted by respective State Governments, CBSE, IIT and such other All India Examinations and selected for counseling and otherwise eligible for Education Loans under our Scheme.
Repayment Period
  • 10 - 15 years
Interest Rate
  • base rate + 1.50 i.e.11.50 %
Processing FeeNIL
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)
  • As applicable to IBA's Model Education Loan Scheme
6).
Corporation Bank
Bank NameCorporation Bank
Scheme NameCorp Vidya
DescriptionUnder - Graduation
Minimum Criteria
  1. Student should be an Indian national. Should have passed previous qualifying examination.
  2. Should have secured at least 60% marks [ 55% for student belonging to SC/ST category ] in the previous qualifying examination.
  3. Should have secured admission to a higher education course in recognized institutions in India or Abroad through Entrance test / Merit based selection process/through Management quota after completion of HSC [10+2 or equivalent]
Repayment Period
  • Upto Rs. 4 Lacs Upto 120 Months
  • Upto Rs. 7.5 Lacs Upto 120 Months
  • Above Rs. 7.5 Lacs Upto 180 Months
Interest Rate
  • Male:- For loans upto Rs.4 lacs: 11.60% (Floating)
  • Male:- For loans upto Rs.4 lacs: to Rs.7.5 lacs 12.60% (Floating)
  • Male:- Above loans Rs.7.5 lacs: 12.10% (Floating)
  • Female:- For loans upto Rs.4 lacs: 11.10% (Floating)
  • Female:- For loans upto Rs.4 lacs: to Rs.7.5 lacs 12.10% (Floating)
  • Female:- Above loans Rs.7.5 lacs: 11.60% (Floating)
Processing FeeNIL
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)Maximum Rs. 20 lacs
7).
IDBI Bank
Bank NameIDBI Bank
Scheme NameEducation Loan Scheme for Other Management Quota Students
Description
Granted to Students who are Indian Nationals –Having secured confirmed admission under management quota since he/she has not qualified for admission under merit quota for Courses offered in India.
Any job oriented courses offered by any educational institute/organization located in India and having the approval of any statutory authority like AICTE, UGC, etc.
Co-applicant is mandator
Guarantors : Not applicable.
Collateral security :
Tangible Security is mandatory irrespective of the loan amount.
  1. In the form of Land/Building which should have value of 1.33 times the amount of loan sought. Such security should not be an open plot or agricultural land engaged in cultivation activities
  2. Any Fixed Income Security viz. Govt. securities/ Public Sector Bonds, NSC, KVP, LIC policy, debentures, Fixed Deposits with IDBI bank, etc. having fixed returns/ surrender value in the name of student/ parent/ guardian/ Co-applicant(s).The minimum value of such security shall be 1.1 times of the loan sought after considering the margin requirement applicable for the loan against respective security instrument.
    Applicable heads of expenses: Purchase of Books/ Equipments/ Instruments/ Uniforms.
    1. Fee payable to college/ school / hostel.
    2. Examination/Library/Laboratory Fee.
    3. Caution Deposit/Building Fund/ Refundable Deposit supported by Institution Bills/Receipts subject to the condition that the amount does not exceed 10% of total tuition fees for the entire course.
    4. Travel Expenses/ passage Money for Studies Abroad.
    5. Purchase of Computers - Essential for Completion of the Course.
    6. Any other expense required to complete the course - like Study Tours, Project Work, Thesis, etc.
    7. Insurance premium for student borrower, if insurance cover sought.
The maximum total expenditure under the heads e, f, g and h to be restricted to 50% of the total tuition fees payable for completion of the course.
Balance Transfer from other FI to IDBI Bank: Not Allowed
Minimum CriteriaStudent should be an Indian National and have secured admission under management quota since he/she has not qualified for admission under merit quota for Courses offered in India
Repayment PeriodThe repayment tenor after completion of the moratorium period is 10 years.
Interest Rate13%
Processing Fee1% of the loan amount plus applicable taxes
Pre-Payment Charges2% on the amount of prepayment to be charged if prepaid before 6 months from the date of commencement of EMI
Amount (maximum amount can be approved to applicant)Maximum Rs. 10 Lakh or 85% of the course fee whichever is lower.
8).
IDBI Bank
Bank NameIDBI Bank
Scheme NameEducation Loan for Vocational Courses
Description
Granted to Students who are Indian Nationals – Having secured admission in a course run or supported by Ministry /Department /Organization of the Government or a company / society /organization supported by National Skill Development Corporation or State Skill Mission / State Skill Corporations, preferably leading to a certificate, Diploma/Degree, etc. issued by a Government Organization or an organization recognized /authorized by the Government to do so.
Co-applicant is mandatory.
Guarantors/Collateral Security : Not applicable.
Applicable heads of expenses:
  1. Tuition /course fees
  2. Examination / Library / Laboratory fee.
  3. Caution Deposit
  4. Purchase of books, equipment and instruments
  5. Any other reasonable expenditure found necessary for completion of the course to be considered on merits.
  6. Insurance premium for student borrower, if insurance cover sought.
Balance Transfer from other FI to IDBI Bank: Not Allowed
Minimum CriteriaStudent should be an Indian National and have secured admission for Vocational /skill development courses run or supported by a Ministry/Department /Organization of the Government or a company /society / organization supported by National Skill Development Corporation or State Skill Mission /State Skill Corporations, preferably leading to a certificate, Diploma /Degree, etc. issued by a Government Organization or an organization recognized /authorized by the Government to do so.
Repayment Period
The repayment tenor after completion of the moratorium period is as under:
  • Loans up to Rs. 50,000 : up to 2 years
  • Loans between Rs. 50,000 to Rs. 1 Lakh : 2 to 5 years
  • Loans above Rs. 1 Lakh : 3 to 7years
Interest Rate11%
Processing FeeNIL
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)
  • For courses of duration up to 3 months : Upto Rs. 20,000/-
  • For courses for the duration between 3 and 6 months : Upto Rs. 50,000/-
  • For courses of duration above 1 year : Upto Rs. 1,50,000/-
9).
IDBI Bank
Bank NameIDBI Bank
Scheme NameEducation Loans for students studying in Premier Education Institutes
Description
Granted to Students who are Indian Nationals –Studying in premier educational institutes like IIMs (Full time executive and regular programs only), IITs (full time engineering and management courses only) and ISB (courses offered at two campuses one in Hyderabad and the other at Mohali, near Chandigarh).
Co-applicant is mandatory, irrespective of loan amount.
Collateral security :
Loans upto Rs. 20 Lakh: No security, Provided the loan applicant provides satisfying net worth/ means of the parent who is the joint borrower.
Loans exceeding Rs. 20 Lakh :
Tangible security in the form of Land/Building (The minimum value shall be 1.33 times the amount of loan sought)/ Govt. securities/ Public Sector Bonds/ Units of UTI, NSC, KVP, LIC policy, gold, shares/units of mutual fund/debentures, bank deposit in the name of student/ parent/ guardian or any other third party (The minimum value shall be 1.1 times or as per respective margin limit against the security offered, whichever is minimum, of the amount of loan sought) or any other tangible security acceptable to the bank with suitable margin. The Land offered as collateral security should not be an agricultural land.
Applicable heads of expenses:
  1. Fee payable to college/ school / hostel.
  2. Examination/Library/Laboratory Fee.
  3. Purchase of Books/ Equipments/ Instruments/ Uniforms.
  4. Caution Deposit/Building Fund/ Refundable Deposit supported by Institution Bills/Receipts subject to the condition that the amount does not exceed 10% of total tuition fees for the entire course.
  5. Travel Expenses/ passage Money for Studies Abroad.
  6. Purchase of Computers - Essential for Completion of the Course.
  7. Any other expense required to complete the course - like Study Tours, Project Work, Thesis, etc.
  8. Insurance premium for student borrower, if insurance cover sought
Balance Transfer from other FI to IDBI Bank: Allowed subject to complying norms for Balance Transfer
Minimum CriteriaStudent should be an Indian National and have secured admission in Premier Education Institute (as per the enclosed list)
Repayment Period
The repayment tenor after completion of the moratorium period would be as under :
  • For loans up to Rs. 7.5 lakh : up to 10 years.
  • For loans above Rs. 7.5 lakh : up to 15 years.
Interest Rate10%
Processing FeeNIL
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)Rs. 30 Lakh or 95% of the total cost of the program (Inclusive of insurance cover) whichever is lower.
10).
IDBI Bank
Bank NameIDBI Bank
Scheme NameEducation Loan for Courses offered by ICAI
Description
Granted to Students who are Indian Nationals –
Pursuing Course offered by The Institute of Cost Accountants of India (ICAI), the Institute of Cost and Works Accountants of India courses (ICWAI) and Institute of Company Secretaries of India (ICSI) viz. CA,ICWA & CS
Co-applicant is mandatory.
Collateral security : Nil
Applicable heads of expenses:
  1. The Loan will be available for initial registration fee payable to institute/examination fee/library fee for each course/stage
  2. Private Coaching fees will not be covered under the said EL.
  3. Purchase of Computers/ Laptop/ tablet, essential for completion of the course, will be allowed only after passing CPT. The loan amount for computer/ laptop not to exceed Rs. 40,000/-.
  4. Loan Amount for books, conveyance, etc. should be maximum upto total course registration fee.
  5. No finance for private tuitions. However, expenditure on Live Virtual Classes supported by institution bills/ receipts and cost of tuitions conducted by ICAI would be allowed
  6. Charges paid to hostel/PG charges to be restricted to maximum upto total course registration fee.
Balance Transfer from other FI to IDBI Bank: Not Allowed
Minimum CriteriaStudent should be an Indian National and have secured admission for Chartered Accountancy Course offered by ICAI
Repayment PeriodLoan repayment to be completed in Maximum of 84 months after commencement of repayment.
Interest Rate
  • 11% for Loans with sanction amount upto Rs.10 lakh.
  • 12% for loans with sanction amount above Rs.10 lakh
Processing FeeNIL
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)Maximum Rs. 3 Lakh
11).
IDBI Bank
Bank NameIDBI Bank
Scheme NameEducation Loan for Special Courses
Description
Granted to Students who are Indian Nationals –
Enrolled for degree / diploma / certification Courses in India offered by reputed Institutes/ Private Agencies/ Companies including part time courses/ executive programmes by IIMs, other reputed management institutions, open and central universities, IITs, NITs/ franchises / OEMs of IT related Hardware & Software, which result into significant enhancement in job opportunities or career growth for the student eg. SAP, .net, C-DAC, etc.
Co-applicant is mandatory.
Collateral security: Either guarantee/ collateral security is mandatory.
Net worth of the guarantor should be at least equal to the loan amount extended, after considering margin requirement applicable for loan against respective security instrument. Creation and acceptance of security, margin and other norms would be as applicable to Loans against respective security instrument.
In case of Security :
  1. In the form of Land/Building. Such security should not be an open plot or agricultural land engaged in cultivation activities.
  2. OR
  3. Any Fixed Income Security viz. Govt. securities/ Public Sector Bonds, NSC, KVP, LIC policy, debentures, Fixed Deposits with IDBI bank, etc. having fixed returns/ surrender value in the name of student/ parent/ guardian/ Co-applicant(s). The minimum value of such security shall be 1.1 times of the loan sought after considering the margin requirement applicable for the loan against respective security instrument.
These loans will not qualify for CSIS on Education Loan, as this variant is outside the purview of IBA guidelines.
Applicable heads of expenses:
  1. Fee payable to college/ school / hostel.
  2. Examination/Library/Laboratory Fee.
  3. Purchase of Books/ Equipments/ Instruments/ Uniforms.
  4. Caution Deposit/Building Fund/ Refundable Deposit supported by Institution Bills/Receipts subject to the condition that the amount does not exceed 10% of total tuition fees for the entire course.
  5. Travel Expenses/ passage Money for Studies Abroad.
  6. Purchase of Computers - Essential for Completion of the Course.
  7. Any other expense required to complete the course - like Study Tours, Project Work, Thesis, etc.
  8. Insurance premium for student borrower, if insurance cover sought.
The maximum total expenditure under the heads e, f, g and h to be restricted to 50% of the total tuition fees payable for completion of the course.
Balance Transfer from other FI to IDBI Bank: Not Allowed.
Minimum CriteriaStudent should be an Indian National and have secured admission for degree / diploma / certification Courses in India offered by reputed Institutes/ Private Agencies/ Companies including part time courses/ executive programmes by IIMs, other reputed management institutions, open and central universities, IITs, NITs/ franchises / OEMs of IT related Hardware & Software, which result into significant enhancement in job opportunities or career growth for the student.
Repayment PeriodLoan repayment to be completed in Maximum of 84 months after commencement of repayment.
Interest Rate
  • 11% for Loans with sanction amount upto Rs.10 lakh.
  • 12% for loans with sanction amount above Rs.10 lakh
Processing FeeNIL
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)Maximum Rs.5 Lakh
12).
IDBI Bank
Bank NameIDBI Bank
Scheme NameEducation Loan to Physically Challenged Persons under NHFDC scheme
Description
Granted to Students who are Indian Nationals –Having physical disability to the extent of 40% or more and have secured admission in a recognized educational institution, through merit quota, in India or Abroad.
Co-applicant mandatory in each case, irrespective of loan amount
Collateral security : "Up to Rs. 4 lakh : No security
Above Rs. 4 lakh and up to Rs. 7.5 lakh : Third Party Guarantee However Bank at its discretion, in exceptional cases, waive third party guarantee if satisfied with the net-worth/means of parent/s who would be executing the documents as "joint borrower".
"Above Rs. 7.5 lakh : Land/Building (The minimum value shall be 1.33 times the amount of loan sought)/ Govt. securities/ Public Sector Bonds/ Units of UTI, NSC, KVP, LIC policy, gold, shares/units of mutual fund/debentures, bank deposit in the name of student/ parent/ guardian or any other third party (The minimum value shall be 1.1 times or as per respective margin limit against the security offered, whichever is minimum, of the amount of loan sought) or any other tangible security acceptable to the bank with suitable margin. The Land offered as collateral security should not be an agricultural land.
Applicable heads of expenses:
  1. Fee payable to college/ school / hostel.
  2. Examination/Library/Laboratory Fee.
  3. Purchase of Books/ Equipments/ Instruments/ Uniforms.
  4. Caution Deposit/Building Fund/ Refundable Deposit supported by Institution Bills/Receipts subject to the condition that the amount does not exceed 10% of total tuition fees for the entire course.
  5. Travel Expenses/ passage Money for Studies Abroad.
  6. Purchase of Computers - Essential for Completion of the Course.
  7. Any other expense required to complete the course - like Study Tours, Project Work, Thesis, etc.
  8. Cost of a Two-wheeler up to Rs. 50,000/-
Balance Transfer from other FI to IDBI Bank: Not Allowed
Minimum CriteriaStudent should be an Indian National having physical disability to the extent of 40% or more and have secured admission in a recognized educational institution, through merit quota, in India or Abroad.
Repayment PeriodThe repayment tenor after completion of the moratorium period 7 years
Interest Rate4% for Male Students and 3.50% for Female students
Processing Fee
  • For studies in India : NIL
  • For studies abroad : 1% of the loan amount subject to a maximum of Rs.5000/- plus applicable taxes to be collected for studies abroad and refunded at the time of disbursement
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)
Need based finance subject to repaying capacity of the parents/students with margin and the following ceilings:
  1. Studies in India – Maximum Rs.10 Lakh
  2. Studies abroad – Maximum Rs. 20 Lakh
13).
IDBI Bank
Bank NameIDBI Bank
Scheme NameEducation Loan for Non-Vocational Courses
Description
Granted to Students who are Indian Nationals –
  1. Having secured admission to a higher education course in recognized institutions in India or Abroad through Entrance Test /Merit Based selection process after completion of HSC (10 plus 2 or equivalent).

  2. OR
  3. Having secured admission under Management Quota although he/she was eligible to secure admission under the merit quota, i.e. having secured marks above the cut-off level required for admission on merit basis as specified for General / SC / ST / OBC / Girl students, for that educational institute/programme.
  1. Studies in India : (Indicative List)
    • Approved courses leading to graduate/post graduate degree and PG diplomas conducted by recognized colleges/universities recognized by UGC / Govt. / AICTE /AIBMS / ICMR, etc.
    • Other job oriented courses leading to technical/professional degrees, post graduate degrees/diplomas offered by recognized institutions.
    • Technical Diploma courses (generally 3 years) offered by approved polytechnic institutions after completion of 10th standard.
    • Approved courses offered in India by reputed foreign universities.
    • In case part of the courses is in India, and part abroad, the authenticity of domestic course and institution will be considered.
  2. Studies Abroad
    • Graduation: For job oriented professional/technical courses offered by reputed universities.
    • Post graduation: MCA, MBA, MS, etc. Approved Post Graduate Diploma courses are also eligible.
    • Courses conducted by CIMA- London, CPA in USA etc.
  3. Special Courses
    Regular Degree/diploma courses like Aeronautical, pilot training, shipping, etc. provided these are recognised by competent regulatory bodies in India/abroad for the purpose of employment in India /abroad.
    Co-applicant mandatory in each case, irrespective of loan amount
    Collateral security : Up to Rs. 4 lakh : No security
    Above Rs. 4 lakh and up to Rs. 7.5 lakh : Third Party Guarantee
    Above Rs. 7.5 lakh : Land/Building (The minimum value shall be 1.33 times the amount of loan sought)/ Govt. securities/ Public Sector Bonds/ Units of UTI, NSC, KVP, LIC policy, gold, shares/units of mutual fund/debentures, bank deposit in the name of student/ parent/ guardian or any other third party (The minimum value shall be 1.1 times or as per respective margin limit against the security offered, whichever is minimum, of the amount of loan sought) or any other tangible security acceptable to the bank with suitable margin. The Land offered as collateral security should not be an agricultural land.
    Applicable heads of expenses:
    1. Fee payable to college/ school / hostel.
    2. Examination/Library/Laboratory Fee.
    3. Purchase of Books/ Equipments/ Instruments/ Uniforms.
    4. Caution Deposit/Building Fund/ Refundable Deposit supported by Institution Bills/Receipts subject to the condition that the amount does not exceed 10% of total tuition fees for the entire course.
    5. Travel Expenses/ passage Money for Studies Abroad.
    6. Purchase of Computers - Essential for Completion of the Course.
    7. Any other expense required to complete the course - like Study Tours, Project Work, Thesis, etc.
    8. Insurance premium for student borrower, if insurance cover sought.
    9. The maximum total expenditure under the heads e, f, g and h to be restricted to 50% of the total tuition fees payable for completion of the course.
Balance Transfer from other FI to IDBI Bank:Allowed subject to complying norms for Balance Transfer
Minimum CriteriaStudent should be an Indian National and have secured admission to a higher education course in recognized institutions in India or Abroad through Entrance Test /Merit Based selection process after completion of HSC (10 plus 2 or equivalent) OR have secured admission under Management Quota although he/she was eligible to secure admission under the merit quota, i.e. having secured marks above the cut-off level required for admission on merit basis as specified for General / SC / ST / OBC / Girl students, for that educational institute/programme.
Repayment Period
The repayment tenor after completion of the moratorium period would be as under :
  • For loans up to Rs. 7.5 lakh : up to 10 years.
  • For loans above Rs. 7.5 lakh : up to 15 years.
Interest Rate
  • 11% for Loans with sanction amount upto Rs.10 lakh.
  • 12% for loans with sanction amount above Rs.10 lakh
Processing Fee
  • For studies in India : NIL
  • For studies abroad : 1% of the loan amount subject to a maximum of Rs. 5000/- plus applicable taxes to be collected for studies abroad and refunded at the time of disbursement
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)
Need based finance subject to repaying capacity of the parents/students with margin and the following ceilings:
  • Studies in India – Maximum Rs.10 Lakh
  • Studies abroad – Maximum Rs. 20 Lakh
14).
KOTAK MAHINDRA BANK LTD
Bank NameKOTAK MAHINDRA BANK LTD
Scheme NameKotak Mahindra Bank Ltd
DescriptionEducation is the most important investment one makes in life. Kotak Mahindra bank aims to finance meritorious students who choose to pursue a higher education (professional or technical) in India and abroad.
Minimum Criteria
Student shall be an Indian national.
The student shall have secured the admission in India or abroad through entrance test / merit based selection process.
Repayment Period
  • Loan amt upto 7.50 lacs - upto 120 months
  • Loan amt greater than 7.50 lacs - upto 180 months
Interest Rate
  • Male-fixed ROI
  • ROI is linked to the base rate whichever is applicable
  • Upto 4 Lacs - base rate + 7.25%
  • Greater than 4lacs - base rate + 8.25%
  • Female-fixed ROI
  • ROI is linked to the base rate whichever is applicable
  • Upto 4lacs - base rate + 7.25%
  • Greater than 4lacs - base rate + 8.25%
Processing FeeNA
Pre-Payment Charges
  • Loan amt upto 7.50 lacs - upto 120 months
  • Loan amt greater than 7.50 lacs - upto 180 months
  • Loan amt upto 7.50 lacs - upto 120 months
  • Loan amt greater than 7.50 lacs - upto 180 months
Amount (maximum amount can be approved to applicant)
10,00,000/- for studies in India
20,00,000/- for studies in abroad
15).
ORIENTAL BANK OF COMMERCE
Bank NameORIENTAL BANK OF COMMERCE
Scheme NameORIENTAL BANK OF COMMERCE
DescriptionThe scheme aims at providing financial support to meritorious students for pursuing higher studies in India & abroad with affordable terms & conditions
Minimum CriteriaStudent who is Indian National & meritorious and secured admission to higher education course in any institution recognized by a statutory body in India or abroad through entrance test/ merit based selection process after completion of HSC (10+2 or equivalent). However, entrance test or selection purely based on marks obtained in qualifying examination may not be the criterion for admission to some of the post graduate courses or research programmes. In such cases, banks will have to adopt appropriate criteria based on employability and reputation of the institution concerned.
Repayment Period
  • Upto Rs 7.5 Lacs - 120 months
  • Above Rs 7.5 Lacs - 180 months
Interest Rate
For Male:
  • Upto Rs 4 Lacs - BR + 2.5 %
  • Between Rs 4 Lacs to Rs 7.5 Lacs - BR + 3 %
  • Above Rs 7.5 Lacs - BR + 1.75 %
  • In case loan above 4.00 lacs upto 7.50 lacs and Immovable Property or Tangible Assets is offered then ROI shall be BR +1.75% (Present effective BR is 10.00%)
For Female:
  • Upto Rs 4 Lacs - BR + 2 %
  • Between Rs 4 Lacs to Rs 7.5 Lacs - BR + 2.5 %
  • Above Rs 7.5 Lacs - BR + 1.25 %
  • In case loan above 4.00 lacs upto 7.50 lacs and Immovable Property or Tangible Assets is offered then ROI shall be BR +1.75% (Present effective BR is 10.00%)
Processing Fee
INDIA - NIL irrespective of loan limit.
ABROAD- 1% of loan amount to be recovered upfront, subject to minimum of Rs. 10000/- plus service tax if any. The process fee (excluding service tax if paid to Government) shall be refunded by way of credit to the loan account on availment of loan in borrower’s loan account.
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)Rs. 100 lacs (we think its showing wrong in site, it should be 10 lacs)
16).
PUNJAB & SIND BANK
Bank NamePUNJAB & SIND BANK
Scheme NamePUNJAB & SIND BANK
DescriptionScheme for financing higher education in India and Abroad for Indian Nationals.
Minimum CriteriaThe student should be an Indian National and have secured admission to a higher education course in recognized institution in India or Abroad.
Repayment Period
  • Upto Rs 7.5 Lacs - 120 months
  • Above Rs 7.5 Lacs - 180 months
Interest Rate
For Male:
  • Upto Rs 4 Lacs - 13 %
  • Between Rs 4 Lacs to Rs 7.5 Lacs - 13.25 %
  • Above Rs 7.5 Lacs - 12.5 %
For Female:
  • Upto Rs 4 Lacs - 12.5 %
  • Between Rs 4 Lacs to Rs 7.5 Lacs - 12.75 %
  • Above Rs 7.5 Lacs - 12 %
Processing FeeNo processing / upfront charges may be levied on loans sanctioned under the scheme. Borrower to deposit Rs. 2000/- (for studies abroad) in lieu of Processing fee, in Saving account (to be kept under reserve, withdrawal thereof may be allowed to the borrower only after full availment of the loan. Otherwise the same be recovered as processing fee.
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)Rs. 30 lacs
17).
Punjab National Bank
Bank NamePunjab National Bank
Scheme NamePNB KAUSHAL
DescriptionVocational Course/SKILL DEVELOPMENT
Minimum CriteriaNo minimum criteria for eligibility of loan
Repayment Period
  • 36 months for loan upto Rs.50000;
  • 60 months for loan between Rs.50000 and Rs.100000;
  • 84 months for loan above Rs.100000
Interest RateBR+2%-0.50% (i.e. 11.50 %)
Processing FeeNIL
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)1.5 lacs
18).
Punjab National Bank
Bank NamePunjab National Bank
Scheme NamePNB SARASWATI
DescriptionApproved courses leading Graduate/ PG and PG Diploma conducted by recognized colleges/universities in India
Minimum CriteriaSecured admission to a higher education course in recognized institutions in India through Entrance Test/Merit Based Selection process after completion of HSC (10 plus 2 or equivalent).
Repayment Period
  • Upto Rs. 7.50 lacs :-120 Months
  • Above Rs. 7.50 Lacs :-180 Months
Interest RateBR+2%-0.50% (i.e. 11.50 %)
Processing FeeNIL
Pre-Payment Charges
Upto Rs. 4 lacs :-BR+2%- 0.50%
Between Rs. 4 lacs and Rs. 7.5 lacs :-BR+3%- 0.50%
Above Rs. 7.5 Lacs : BR+1% -0.50% (WHERE 100% TANGIBLE COLL. SECURITY)
Others Above Rs. 7.5 Lacs :- BR+2.5% - 0.50%
(Present BR (Base rate) is 10%)
Amount (maximum amount can be approved to applicant)10 lacs
19).
State Bank Of India
Bank NameState Bank Of India
Scheme NameSBI STUDENT LOAN SCHEME
DescriptionTo view the detailed description of this scheme, Click Here
Minimum Criteria
  1. Student should be an Indian National
  2. Student should have secured admission to a higher education course in recognized institutions in India through Entrance Test/ Merit Based Selection process after completion of HSC (10 plus 2 or equivalent)
Repayment Period
  • Upto Rs. 4 Lacs Upto 10 years
  • Above Rs. 4 Lacs and upto Rs. 7.5 Lacs Upto 10 years
  • Above Rs. 7.5 Lacs Upto 12 years
Interest Rate
  • For loans upto Rs.4 lacs: 3.65% above Base Rate, currently 13.35% p.a.
  • Above Rs.4 lacs and upto Rs.7.50 lacs: 3.90% above Base Rate, currently 13.60% p.a.
  • Above Rs.7.50 lacs: 1.90% above Base Rate, currently 11.60% p.a.
0.50% concession in interest for girl students
1% concession for full tenure of the loan, if interest is serviced promptly as and when applied during the moratorium period, including course duration
Processing FeeNIL
Pre-Payment ChargesNo Prepayment Charges
Amount (maximum amount can be approved to applicant)
  • For studies in India: Maximum Rs. 10 lacs
  • For studies Abroad: Maximum Rs. 30 lacs
20).
Union Bank
Bank NameUnion Bank
Scheme NameUnion education
Description
For Studies in India - Approved courses leading to graduate/post graduate degree or post graduate diploma conducted by recognized colleges/ universities recognized by UGC/ Govt. / AICTE/ AIBMS/ ICMR etc.
For Studies Abroad - Job oriented professional / technical graduate & post graduate courses offered by reputed universities. Courses conducted by CIMA London, CPA, USA etc., Degree / diploma courses like aeronautical, pilot training, shipping etc, provided these are recognized by competent regulatory bodies in India / abroad for the purpose of employment in India/ abroad and Post graduate diploma courses of reputed institutes / universities.
Student should be an Indian national. Loan can be given for studies in India & studies for aborad.
Selection critieria for studies in India is that student has to secured admission to an eligible course in a recognised initituion in India.
For Studies in abroad student has to secured admission to an eligible course in a recognized institution abroad thorough following process:
  1. Merit based selection process such as common entrance exams conducted by recognized universities/institutions and other approved authorities.
  2. OR
  3. Admission based on the marks obtained in the qualifying examinations for studies abroad. The minimum marks to be secured in the qualifying examination should be as under.
    • Category & Minimum marks
    • General - 60%
    • OBC/SC - 50%
    • ST - 45%
Minimum Criteria
  • Student should be an Indian national.
  • Student has to secured admission for eligible course in recognized institution.
Repayment Period
  • Upto 7.5 Lacs - 10 years
  • Above 7.5 lacs - 15 years
Interest Rate
For male student
  • Up to Rs 7.50 Lakh 12.25% (fixed)
  • Above Rs 7.50 Lakh 12.00% (fixed)
For girl student
  • Up to Rs 7.50 Lakh - 11.75% (fixed)
  • Above Rs 7.50 Lakh - 11.50% (fixed)
Processing FeeNIL
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)
  • 10 Lakh for Inland studies
  • 20 Lakh for aboard studies
  • Higher quantum of loan can be consider on case to case by higher authority
21).
VIJAYA BANK
Bank NameVIJAYA BANK
Scheme NameIBA MODEL EDUCATION LOAN -INDIA
DescriptionLoans to meritorious Indian Nationals for pursuing higher education in India
Minimum CriteriaSecured admission to higher education course in recognized institutions through entrance test or merit based selection after passing qualifying examination
Repayment Period
  • UPTO Rs. 750000 120 Months
  • for above 750000 is 180 months.
    Repayment period is excluding moratorium period
Interest Rate
Male (floating) for 400000 @ 11.8 % &
400000 – 1000000 @ 12.25 %
Female (floating) for 400000 @ 11.3 % &
400000 – 1000000 @ 12.25 %
Processing FeeNIL upto 10 lacs. Above 10 lacs 0.75% + Service Tax
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)1000000
22).
VIJAYA BANK
Bank NameVIJAYA BANK
Scheme NameIBA MODEL EDUCATION LOAN -ABROAD
DescriptionLoans to meritorious Indian Nationals for pursuing higher education abroad
Minimum CriteriaSecured admission to higher education course in recognized institutions through entrance test or merit based selection after passing qualifying examination
Repayment Period
  • UPTO Rs. 750000 120 Months
  • for above 750000 is 180 months
    Repayment period is excluding moratorium period
Interest Rate
Male (floating) for 400000 @ 11.8 % &
400000 – 1000000 @ 12.25 %
Female (floating) for 400000 @ 11.3 % &
400000 – 1000000 @ 12.25 %
Processing FeeNIL upto 10 lacs. Above 10 lacs 0.75% + Service Tax
Pre-Payment ChargesNIL
Amount (maximum amount can be approved to applicant)2000000

Step 4). Now after reading (all dis. avaliable here ) 
When you click on apply then you will need to fill the below form

Step 5 : Now click on Submit
Happy Loan :)
Thanks Gvt. and share with your frds...

Find job here...