Technical SQL Questions:

  1. What are the three different types of replication and how does replication work?
  2. What is the purpose of log shipping and how does it work?
  3. What is the difference between a clustered and a non clustered index?
  4. What is a derived table and when would you use one?
  5. What is a VIEW? How to get script for a view?
    View is virtual table based on record set of select statement. View cantain the field from on one or more than one table's fields. The using view we can use JOIN and where statement and IT' s looks like single table .
    Ex:- Create View view_name AS SELECT Column(s) from TABLEname where Condition
    If we have several tables in a db and we want to view only specific columns from specific tables we can go for views. It would also suffice the needs of security some times allowing specfic users to see only specific columns based on the permission that we can configure on the view. Views also reduce the effort that is required for writing queries to access specific columns every time.
  6. What is a "trigger"?

    Triggers are stored procedures that database should take action when relevant event occur
    In other word we can say trigger are stored procedure that fire when a relevant event occurs such as insertion , deletion, update
  7. What is a "transaction"? Why are they necessary?

    Transactions are an atomic piece of instructions in SQL which have to be executed all or none.The word atomic signifies the all or none character of a transaction.
  8. How to remove duplicate records from a table?

    delete from emp where en not in (select min(en) from emp order by columnname)
  9. How will you copy the structure of a table without copying the data?

    select * Into NEWTABLE from OLDTABLE where 1=2
  10. What is a Stored Procedure? - Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements.
  11. Can you give an example of Stored Procedure? - sp_helpdb , sp_who2, sp_renamedb are a set of system defined stored procedures. We can also have user defined stored procedures which can be called in similar way.
  12. What is an Index? - When queries are run against a db, an index on that db basically helps in the way the data is sorted to process the query for faster and data retrievals are much faster when we have an index.
  13. What are the types of indexes available with SQL Server? - There are basically two types of indexes that we use with the SQL Server. Clustered and the Non-Clustered.

  1. What are the basic difference between clustered and a non-clustered index? - The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index. Whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have as many non-clustered indexes as we can on the db.
  2. When do we use the UPDATE_STATISTICS command? - This command is basically used when we do a large processing of data. If we do a large amount of deletions any modification or Bulk Copy into the tables, we need to basically update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly
  3. Can you tell me the difference between DELETE & TRUNCATE commands? - Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command.
  4. Can we use Truncate command on a table which is referenced by FOREIGN KEY? - No. We cannot use Truncate command on a table with Foreign Key because of referential integrity.
  5. What is the use of DBCC commands? - DBCC stands for database consistency checker. We use these commands to check the consistency of the databases, i.e., maintenance, validation task and status checks.
  6. Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
  7. What command do we use to rename a db? - sp_renamedb ‘oldname’ , ‘newname’
  8. What is a Join in SQL Server? - Join actually puts data from two or more tables into a single result set.
  9. Can you explain the types of Joins that we can have with Sql Server? - There are three types of joins: Inner Join, Outer Join, Cross Join
  10. What is a Linked Server? - Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements.
  11. What are the OS services that the SQL Server installation adds? - MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution transac co-ordinator).

Testing Scenarios

Test a Vending machine?
· I’ll try to test it with different coins of the same currency and I’ll see if it gives change back.
· I’ll try to test with different currencies.
· I’ll try to put a fake input coin and see how it reacts to it
· I’ll try to press the menu button before inserting coins.
· I’ll try to press two menu buttons simultaneously.
· I’ll try to press and hold the menu button after I put a coin
· I’ll try to open the door
· I’ll put two coins one after the other before pressing any button and I’ll try to get two items. I’ll try to test if it can manage tasks and etc.
· I’ll test it by putting coins and pressing item button at the same time and I’ll see how it reacts
· I’ll put an item which has a size greater than the hole size of the vending machine and I’ll try to buy that product and If it doesn’t work I’ll try to buy another product, here I’ll try to see if the bigger one blocked the way.
· I’ll flip it up side down and see if it can give me certain item.
· I’ll disconnect the power cord after I put coins and connect it again and press the button and see if it can handle the request which was in the process before the power failure.
· I’ll try to test it if it can operate with different power supplies like main supply and generator etc.
· I’ll try to test its compatibility with the environment.

How would you design the lights at a traffic intersection?

See how creative they are. In particular, synchronizing with lights at other intersections, how they provide smooth flow of traffic (turns etc). Do they consider traffic patterns (rush hour/ special event/ emergency vehicles)?
Solution

There are so many processes to consider these are as follows
· Serving traffic moving straight from east to west
· Serving traffic coming from east and turning to the right at the intersection
· Serving traffic coming from east and turning to the left at the intersection
· Serving traffic moving straight from west to east
· Serving traffic moving from west and turning to the right at the intersection
· Serving traffic coming from west and turning to the left at the intersection
· Serving traffic moving straight from north to south
· Serving traffic coming from north and turning to the right at the intersection
· Serving traffic coming from north and turning to the left at the intersection
· Serving traffic moving straight from south to north
· Serving traffic coming from south and turning to the right at the intersection
· Serving traffic coming from south and turning to the left at the intersection

TEST CASES FOR TESTING A TOSTER?
Does it handle all common types of breads.
Does it perform toasting well.
I’ll try to examine the performance by repeatedly using a tester and I’ll try to see if the performance degrades through repeated use.
I’ll try to test it with different kinds of bread, pizza slice, cracker type bread, flat bread, bread with high sugar content, very thin,medium,and thick
I’ll turn the taster on for a long time without putting any bread in it and see what happened. Here I’ll try to check if it has a certain controlling mechanism if the temperature is above a certain limit.
I’ll test it with for chemical reaction when it is in contact with a certain chemical.
I’ll test it with different power supplies.
I’ll test its reaction with the environment(like does it generate a certain gas which is harmful to the environment)
I’ll try to adjusting all the controls while operating and see every control produces the required result.
I’ll try to see if there is an electric shock when we touch the body of the toaster.
I’ll put more bread than it can accommodate and I’ll see what happens
I’ll try to flip it on side position and see whether it works well or not.
I’ll put a Frosted bread and see what is going to happen.
I’ll turn the toaster on until it gets very hot and then turn it off and put some bread to toast and see how it handles it.
I’ll try to discover which parts of the toaster to touch when in operation.
Should work with diffent voltage ranges(considering internationalization)


Given a screen with customer name, address, phone number, date of birth, SSN, and functions like ADD, DELETE, UPDATE, what types of tests would you execute (backend and GUI)?

GUI Testing:
· I’ll insert a proper data on each field and press add button.
· I’ll select a certain record and delete it.
· I’ll select a certain record and edit some fields with valid data and press update button.
· I’ll press the add button with out entering data in all fields.
· I’ll press the delete button with out selecting a particular record and see what happened.
· I’ll press the try to update without selecting a particular field.
· I’ll try to add an already existing record and see what happened.
· I’ll try to add a certain data in which certain fields are left.
· I’ll try to add data with long strings for each field.
· I’ll try to add data which is in different language and see what happened.
· I’ll try to add data which has a space or some special characters.
· I’ll try to add data which is inconsistent like negative ssn,birth date which is in the feauture, phone and address which is not valid,
· I’ll try to delete a certain record which doesn’t exist.
· I’ll try to update with out changing any value.
· I’ll try to update a record which doesn’t exist
· I’ll try to update a certain record with empty fields all.

DATABASE TESTING:
· I’ll check to see if a certain record has added to the database after I pressed add button.
· Check to see the performance by adding a record repeatedly in a fast manner.
· I’ll try to add so many records and I’ll see if disk space is a constraint
· I’ll try to delete a record which doesn’t exist and see how the Database reacts to this
· I’ll try to update a certain record with out making any changes.
· I’ll try to update a certain record with an invalid data.
· I’ll try to delete a record from an empty table int that particular database.
· I’ll try to see network failure while performing database operations.
· I’ll try to check how the database handles when I try to put duplicate records.
· I’ll try to execute the above GUI from so many client locations and see if there is a possibility of memory leakage.
Testing Enter File Name Text box of a dialog box
· I’ll try to save the specified file with out specifying a name
· I will try to put a certain specific length character and save it using a save button
· I’ll try to enter a file name consists of only numbers.
· I’ll try to enter a file name which will start with dot.
· I’ll try to enter a file name which is already existed.
· I’ll try to insert different combination of special characters and try to save it.
· I’ll try to enter a very long character equal to the maximum number of the characters that the text box accommodate and try to test it.
· I’ll enter a certain file name and click a cancel button.
· I’ll enter a file name which has a space in between words
· I’ll enter a file name which has only spaces.
· I’ll enter a directory name and try to save it and see what happened.
· I’ll enter a file name which exists but holds a different data format.

Test a clutch pencil
· I’ll try to sharpen a regular pencil
· I’ll try to sharpen diffent pencil which are made up of different materials for example hard, soft wood…etc
· I will try to put a pencil inside a hole with out pressing the clutch
· I will try to sharpen another material which has the same shape as a regular pencil
· I will try to sharpen a pencil by rotating the arm in opposite direction than the usual
· I’ll try to see the material composition is it hazardous if it is put in some chemical, is it going to burn.
· I’ll try to see the strength of the material by placing a high load.
· Does it need some safety precaution for children to use it.
· Is it continue to work if one of its components is failed like the arm,clutch or blade…etc
· Does the blade and other metal parts rest if it is stored in a frosted environment.

Test An Elivator?
· I’ll try to load an elevator with some rated load specified by the manufacturers
· I’ll try to load it with a heavy load which is much much greater than the rated load.
· I’l l see how it reacts when it’s not loaded.
· I’ll try to disconnect the main power supply while the elevator is working with a certain load and see what happened.
· I’ll try to call the elevator from a certain floor and by pressing both up and down arrow.
· I’ll try to open the door of the elevator manually and see what happened.
· I’ll try to disconnect the elevator and it’s controlling part and see what happened.
· From the inside of the elevator I’ll try to press a floor number button which is the same as where the elevator is
· From inside I will press and hold the open door button and see what happened.
· I’ll try to open the door manually from inside and see what happened.
· I’ll see when the final destination of the elevator is if it’s not called or loaded.

Behavioral Questions

Provided By: Barun Poudel.
Some important points which can make an interview successful:

Sleep – A good previous night’s sleep makes you feel fresh and it is reflected in your eyes. This is required because the client doesn’t want to deal with dull face.

Confidence – Confidence is automatically reflected in your looks, body language, and the way you walk, sit and talk. If you are confident you look confident, you walk confidently, you sit confidently and talk confidently. So be confident. One tip is, don’t feel too nervous about the last chapter you did not get to study for the interview.

Eating – Before going to the interview have a nice, good, stomach-full meal, because you may not know how much time you need to wait before the interview or how long it would take for the interview. If you are starving, you cannot answer well in the interview. So eat well, even if you are on a diet on the day of the interview.

What to wear for the interview – At the first look, what you are is what you wear. So wear a nice dress (type of formal dress – Black single breasted suit with buttoned down white cotton shirt, red tie, black shoes, black socks and black leather belt) and give that extra look for the interviewer. If you interview is in the evening and you need to drive in the morning, wear a different shirt while driving, and change to the well-ironed shirt before the interview (where do you change? – in the car or in the rest room)

What to carry for the interview –
In a neat folder put the following:
1) 3 copies of your resume – crisp, unfolded, unscrambled, un-scribbled.
2) A spiral notebook to take notes.
3) A pen
4) Photo-ID, preferably the driver license or State-ID
5) Mouth freshener
6) Directions for address
7) Address of the interview site
8) Name and phone number of the contact person

Busy Waiting – Wait in the lobby for the interview. Don’t be nervous be calm and cool. It is not uncommon that interview schedules are not met. There will be in ardent delays. Bear with them and wait (Busily!!!). Don’t worry. You will be escorted to the interview chamber, as soon as they are ready to see you.


Entering (the 3e Chamber of Shoaling) – Don’t worry. Interview chamber is not going to decide your future. It only sees, whether you have the technical and physiological qualities to deliver their job. That’s all! Therefore enter the chamber by gently pushing the door (if you are not escorted and you were asked to enter). Wish everybody a good day.


Shaking hands – If you are escorted, escorting person will tell you his name while shaking hand, and then you should say, “ How are you John?”
If you are entering the chamber by yourself say Good morning/afternoon to everybody and introduce yourself to him or her. “ I am Rajendra Sedhain”(your name)
Always your handshake should be warm, firm and friendly. A loose handshake indicates that you are not interested.

Wishing – Shake hands with all of the interviewers and try to remember their names and gently be seated.

Sitting – You can sit in a comfortable position, (but not with your legs crossed and/ or body leaning backward, which shows arrogance). Look forward, be enthusiastic, and bend forward, showing that you are interested in the interview.

Taking Notes – After the warming up and sitting, seek the interviewer’s permission to take down notes. Almost all the interviewers agree and let you. Then Open a clean page in your notebook, write down the date, heading (a typical heading would be interview with IBM at NYC) and the names of the interviewers.

If there is more than one interviewer, write their names in the order in which they have sat opposite to you. The first name you have written down in your notes shall correspond to the left most person sitting opposite to you and so on. You can use this information during interview to recollect their names. If the third person asked a question, look at the third name and start answering him using his first name (Example. John).


1) How are you?
Ans: I am Excellent. (Never use I am not too bad, I am all right, I am fine or I am good).

2) How did you arrive here?
Ans: I cam e by Train and bus or I came by Train and Taxi or I drove down.

3) Do you drive? Do you have a driver’s license?
Ans: Yes, John I drive and I have a IOWA state driver’s license (Never say I don’t drive or I don’t have a DL)

4) Your last project was in Nepal? What are you doing in IOWA(any other)?
I came to IOWA, USA for my master’s degree in Computer science and completed my on-campus study. Currently in CPT under F-1 status so looking for a full-time or contract job in .NET technology and attending interviews.

5) Tell me about yourself?
Ans: John, I have BS in computer science. I have 3 years of web development experience.
I have 2 years experience as .NET developer.
I am an expert in .NET, SQL server, XML, HTML, JavaScript, CSS.

6) Tell me something about your current project?
---------------------------------------------------------

7) What was your role in this project?
Ans: Enumerate the responsibilities from the resume

8) There are two managers, who want their tasks done in the next 6 hours. Each manager’s task takes 6 hours even if you are a superman. How will you handle this situation?
Ans: John, First I shall try and meet their demands as far as possible. Then talk to them and find out how 1 could meet their expectations. Ask for suggestions/advice.

9) Would you be willing to work extended hours as needed in order to complete the tasks?
Ans: Yes John, I am open to working extended hours. In fact, in my previous projects, I carried a mobile and a pager and was available 24/7.

10) What are your technical strengths?
Ans: John, I am a .NET developer. In my previous work places I always got commending letters and awards.

11) Are you open to new environments?
Ans: Yes John, I am open to work in new environments. I am eager to work in multiple environments. I always enjoy learning new technologies, and offer my best effort to complete the tasks given to me. In my last project I was a .NET developer, when I was required to work in the PHP I took this opportunity, I learnt quickly and did PHP developer job.

12) Would you like to work in a team or individually?
Ans: John, I am comfortable to work both as an individual and a team member. I have prior experience working both in a team as well as an individual. In IBM I worked as an individual (as a Java developer) and in AT&T I worked in a team, I excelled in both environments.

13) What is your status?
Ans: I am legally authorized to work in the USA. I am in CPT.

14) Quality Vs. Time; what is more important to you?
Ans: Both quality and time are equally important to me John. In all my previous projects, my target has always been delivering quality work in the given time.

15) Where do you see yourself in 5 years down the line?
Ans: 5 years down the line, I am looking forward to becoming a Project Manager John.

16) How soon can you join?
Ans: Immediately John (Within a week – couple of days for relocation).

17) Can you give some references?
Ans: Yes John, I have excellent references. I would love to give them to you but I need to inform my references each time I use their names because they asked me to do so. I shall get back to you in 24 hours.

18) If you were not able to complete a task within a deadline, how would you deal with the situation?
Ans: John, I would update my project manager immediately and explain the situation. I would work extra-time in the evenings and on weekends and complete the task up to my managers’ satisfaction.

19) What are you looking here?
Ans: I am a solution provider (developer). I am looking for challenging work environment.

20) Have you ever handled multiple jobs simultaneously?
Ans: Yes John, I was a developer as well as Analyst. John! In fact in my previous project I had to redesign the code at the same gather new requirements from the users.

21) Tell me about your greatest success professionally?
John, I was a entry level developer to start with and I became a mid level developer in 2 years. I was given the responsibility of .NET developer because of my commitment and integrity. I was chosen from among 5 people.

22) What are you best at?
Ans: I am best at adapting to new technologies very fast. In my previous project, they purchased a new TOOL and I was asked to work using that tool without training. I learned it in my spare time and came to normal speed within 1 or 2 weeks.

23) What is the most difficult situation you have faced while on any of your projects and how did you resolve it?
Ans: John, Just before releasing into production, we had discovered that there were duplicate keys. I wrote utility to scan and delete duplicate keys. This utility is still being used at IBM.

24) Is there any project which you liked the least?

Ans: I liked all my previous projects John. I really enjoyed working on each of them.

25) How do you handle conflicts?
Ans: I solve conflicts by keeping communication open.

26) What is your approach towards work?
Ans: I divide the work in sub tasks and keep monitoring the sub-tasks against their dead lines. In case of any sub task crossing the deadline, I reschedule the tasks, so the final task can be completed in time. In case of red flag, I inform to my manager well in advance.

27) Tell me about a project in which you were disappointed with your personal performance.
Ans: When I was with XYZ Company John, I initially designed .NET but they asked us to do the same thing using share point. Naturally I was not happy with the security issues.

28) Give an example of how you handle rejections.
Ans: John, I always take them in the right stride. I will take them as an opportunity to improve myself. Also I will make sure that I will not repeat the mistakes again.

29) What kind of skills and knowledge do you hope to acquire if you join us?
Ans: Well John, I possess all the required skills to perform the tasks assigned to me, yet I would like to learn rich values and working culture of your company.

30) Tell me something about your boss?
Ans: He was an honorable gentleman and I had a very cordial relationship with him.

31) What are your personal strengths?
Ans: I am always on time, I am a positive thinker and very enthusiastic. Every morning I get up early and plan my schedules and e-mails.

32) What are your personal weaknesses?
Ans: I am workaholic and I am a perfectionist.

33) Did you have a culture shock when you first came to the U.S?
Ans: No John, I am used to working in global companies even in my country, Nepal where I used to interact with people from various cultures. Education and working environments in my country are similar to that of UK and US.

34) What are your hobbies/free-time activities?
Ans: Reading books John. I play pool, I like going for long walks, swimming, and watching movies. I watch basketball, baseball and play golf sometimes. I love going out with friends and simply having fun. I go to nearby beaches and I enjoy fishing, and of course trekking.

35) Why are you leaving your current project?
Ans: I have successfully completed my last project John.


36) How good are your writing skills?
Ans: Very good, John, My project manager always used to ask me to write documents and in fact John! He provided me extra hours on weekends.

37) How do you motivate people?
Ans: By giving sincere appreciation John, by listening to them and also by rewarding them for their good work.

38) Tell me of an instance where your employer wasn’t happy with your performance?
Ans: John, all of my previous employers was satisfied with my performance on all my projects.

39) How do you resolve conflicts?
Ans: John, when I know I have a problem I will conduct a meeting and discuss the issues. By keeping communications open within the team, I try to evaluate the situation personally and in a group. I try to highlight our reasons and prioritize our tasks. In spite of all efforts if the conflict is not resolved, usually we arrange for a meeting with supervisor. And his/her decision is final.

40) Tell me if and how you think you can make a difference if you are hired?
Ans: I possess the functional background along with the desired skill sets John. So I can, understand the system along with the application in a better manner.


Questions to be asked to the interviewer after the interview:

1) Can you please tell me at what stage is the project in?
2) What is the environment in which the project is being developed?
3) What is the version of the Tool?
4) Do I need to travel?
5) When can I Join?
6) Would I be working with a team or individually?
7) What are the databases being used?