call center interview questions..

--Here are some don’ts: Don’t become angry Don’t make negative or disparaging remarks about your former employer Don’t in any way imply that it was the employer’s fault --Why should we hire you?: Even if the interviewer doesn’t ask this outright, the underlying tenor of the interview is to get the answer to this question. There is no single correct answer. It will depend both upon 1) what the employer needs and 2) what you bring to the table to satisfy that need. You cannot answer the question without knowing both of these. Happily, you already know the latter; what you must discover is the former. As the interview progresses, the interviewer should be communicating at least some of the need. As he/she does, try to ask questions that help put a fine point on the need. There actually are some wrong answers to this question: Because I’m a hard worker I don’t know I’m good with numbers I’m a fast learner Answers like these will not get you the job.The best way to answer this question is to ask it of yourself before the interview and to have a plausible answer prepared. Once in the interview, and with new information, you can revise your answer as appropriate. --Thought problems: This type of question is often asked of technical customer service people and is intended to 1) place a little pressure on you and 2) test the your ability to think through and solve a problem on the fly. For the majority of these questions, the correct answer isn’t usually the most obvious one. The most important aspect of getting to the answer is to ask questions. Consider your interviewer as a resource or expert on the subject (i.e., a coach). Your best avenue, especially if you get stuck, is to ask questions that will help clarify the issues and help crystallize your thinking so that you can arrive at the correct answer. Often these types of questions aren’t so much about the right answer, but more about your ability to ask intelligent questions as you consider the various aspects of the problem. Once you have asked some questions, begin to visualize the problem. Imagine stepping through scenarios -- out loud. If you misstep, the employer may inadvertently help you by correcting you. --What questions can I answer for you?: This question is deceptive. At first blush, it appears as though the interviewer is preparing to conclude the interview. Not so. This is a test to see if you have been paying attention and whether or not you have any interest in the job. --Here are some good questions to ask. How many candidates besides me are you considering for this opening? How do I rank compared to the other candidates? Why? If you think this question will put the interviewer on the defensive, you are correct. Your job, therefore, is to disarm them and get an answer. Be sincere. Let them know that they can tell you without any risk to themselves. Phrase your encouragement in terms that say "you don’t have to worry about taking back what you say later." For example, if you say, "Don’t worry about hurting my feelings. Truth is truth." You can also ask "what could I have done better during this interview?" If you encourage the interviewer to take the role of coach, you can disarm them and get the information you need. What is your hiring process like? What’s the next step? --Here are some bad responses: I don’t know. Can I get back to you on that? I can’t think of any right now, but I’ll call you if I think of anything. These answers display a lack of interest in the company and reduce your chances of getting the job.

Databases How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships. One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships. Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

What’s the difference between a primary key and a unique key? Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn’t allow NULLs, but unique key allows one NULL only.

What are user defined datatypes and when you should go for them? User defined datatypes let you extend the base SQL Server datatypes by providing a descriptive name, and format to the database. Take for example, in your database, there is a column called Flight_Num which appears in many tables. In all these tables it should be varchar(8). In this case you could create a user defined datatype called Flight_num_type of varchar(8) and use it across all your tables.

What is bit datatype and what’s the information that can be stored inside a bit column? Bit datatype is used to store boolean information like 1 or 0 (true or false). Untill SQL Server 6.5 bit datatype could hold either a 1 or 0 and there was no support for NULL. But from SQL Server 7.0 onwards, bit datatype can represent a third state, which is NULL.

Define candidate key, alternate key, composite key. A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table. If the table has more than one candidate key, one of them will become the primary key, and the rest are called alternate keys. A key formed by combining at least two or more columns is called composite key.

What are defaults? Is there a column to which a default can’t be bound? A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can’t have defaults bound to them. Networking Interview Questions Page 1 Next>> 1. What are 10Base2, 10Base5 and 10BaseT Ethernet LANs 10Base2—An Ethernet term meaning a maximum transfer rate of 10 Megabits per second that uses baseband signaling, with a contiguous cable segment length of 100 meters and a maximum of 2 segments. 10Base5—An Ethernet term meaning a maximum transfer rate of 10 Megabits per second that uses baseband signaling, with 5 continuous segments not exceeding 100 meters per segment. 10BaseT—An Ethernet term meaning a maximum transfer rate of 10 Megabits per second that uses baseband signaling and twisted pair cabling.

2. Explain the difference between an unspecified passive open and a fully specified passive open An unspecified passive open has the server waiting for a connection request from a client. A fully specified passive open has the server waiting for a connection from a specific client.

3. Explain the function of Transmission Control Block A TCB is a complex data structure that contains a considerable amount of information about each connection.

4. Explain a Management Information Base (MIB) A Management Information Base is part of every SNMP-managed device. Each SNMP agent has the MIB database that contains information about the device’s status, its performance, connections, and configuration. The MIB is queried by SNMP.

5. Explain anonymous FTP and why would you use it Anonymous FTP enables users to connect to a host without using a valid login and password. Usually, anonymous FTP uses a login called anonymous or guest, with the password usually requesting the user’s ID for tracking purposes only. Anonymous FTP is used to enable a large number of users to access files on the host without having to go to the trouble of setting up logins for them all. Anonymous FTP systems usually have strict controls over the areas an anonymous user can access.

6. Explain a pseudo tty A pseudo tty or false terminal enables external machines to connect through Telnet or rlogin. Without a pseudo tty, no connection can take place.