Common Interview Questions and Answers

Common Interview Questions and Answers:

I am giving you some commonly asking interview questions and answers. Read carefully and face the interview very confidently.
1. Tell me about yourself :
This is very commonly asked question. So it is better to prepare a short note for it. Try to include work related matters. That is what you have done, what you can do etc related to the position you are interviewing for.
2. Why did you leave your last job?
Say positive reasons regardless of the situations. You can tell, to get a better opportunity to do something special etc.
3. What experience do you have in this field?
Speak about your experience that relate to the position you are applying for.
4. Do you consider yourself successful?
For this question the answer should always be ‘YES’ and you have to tell the reason briefly. You can tell your achieved goals and the set goals.
5. What do co-workers say about you?
Be prepared with a quote or two from co-workers. It should always positive.
6. What do you know about this organization?
You must do a research about the organization before attending the interview. Find out where they have been and where they are going, current issues of the organization etc

10 TIPS FOR INTERVIEW

10TIPS FOR INTERVIEW

1. Do your homework. Know about the company and improve your knowledge about the company. This will help you in interview

2. Know where you’re going. Know where is the interview place. Keep address and phone numbers of the office with you. This will help to save your time and avoids unnecessary stress.

3. Look the part. Wear neat dress with professional look.Your clothing should be neat, pressed, and professional looking. Make sure to have a fresh haircut and clean, manicured nails.

4. Rehearse beforehand. Prepare answers to common questions the interviewer is likely to ask. If possible conduct a mock interview with a trusted friend as practice.

5. Secure your references. Find at least three key people — former supervisors, colleagues, or instructors — who are willing to serve as your professional references. Before interview be sure to secure their permission ,and be certain that they will speak highly of you when an employer contact him.

6. Arrive early. Be sure to arrive the interview place at least 15 minutes before the interview. Then announce yourself to the receptionist to let him or her know that you have arrived and that you have an appointment. Don’t forget to turn your cell phone off so it doesn’t ring during your meeting.

7. Bring necessary documentation. Prepare a checklist of documents that you will need for the interview, and make sure that you have taken them in your briefcase before leaving home. Don’t forget to take extra copies of your resume, a passport, driver’s license, Social Security card, or portfolio of writing samples or other professional work.

8. Sell yourself. The interview is your chance to shine. Develop a 25-second sales pitch that sings your praises. In business this is called an “elevator speech,” a compelling overview of why you? that can be recited in the time it takes to ride the elevator. IThis should include your strengths, your abilities, your knowledge and what sets you uniquely apart from other applicants.

9. Don’t neglect to ask questions. Based on your earlier research about the company, ask how the responsibilities of the open position relate to the company’s goals and plans for the future. Interviewers are impressed by candidates who show that they are knowledgeable about the organization.

10. Follow up. After the interview, don’t forget to send a handwritten note or friendly email. The email includes thanking the interviewer for his or her time and consideration, as well as restating your interest and commitment to the position. If you don’t hear anything after one week, you can call to politely inquire when they will be making a final decision.

Seven Manthras of Success

SEVEN MANTRAS FOR SUCCESS

1. Communication Skills – Communication is very important in an organization. So the we should be master in both verbal as well as written.

2. Influencing Abilities - we should have leadership power. This includes both persuading and negotiating skills.persuation means convincing and encouraging people to work when a hard situation occurs. It is a very powerful tool in conflicting situations in professional and personal life.

3. Managing Skills – this term means getting things done. That is managing things,people and yourself.managing yourself means managing your time, money etc .

4. Problem Solving – this means to know how to recognize ,define and solve problems. . Effective problem solving skills will help to become the backbone of any team, which in turn will help in career prospects.

5. Creative Thinking – the ability to generate new ideas .that is we have to use both part of the brain effectively. Watch everything around the world very carefully to get new ideas.

6. Social Skills – this means the ability to relate peole, having inslights, helping others and facilitating. Interdependence has a great value in today’s life.

7. Managing Money- develop the ability to manage money efficiently.

Computer Science Seminar Topic

SPINS -Security Protocol For Sensor Network

Abstract

Wireless sensor networks will be widely deployed in the near future. Many researched are doing on making these networks feasible and useful. Sensor networks are identified as being useful in different domains to include battlefield and perimeter defense. So we have to give high attention to security.

A suite of security protocols optimized for sensor networks: SPINS. SPINS has two secure building blocks: SNEP and _TESLA. SNEP the following important baseline security primitives: data confidentiality, two-party data authentication, and evidence of data freshness. Providing efficient broadcast authentication, which is an important mechanism for sensor networks is a hard problem._TESLA provides authenticated broadcast for severely resource-constrained environments.

Oracle Functions

ORACLE FUNCTIONS

·         SIGN(n)  :     positive = 1, zero = 0, negative = -1 

·         SIN(n)    :    Sine of n in Radians 

·         SINH(n)  :     Hyperbolic Sine of n in Radians

·         SOUNDEX(char)  : It returns a char value representing the sound of the words 

·         SQRT(n)   :   to find  Square Root of a number

                                  Eg : sqrt(4)=2 

·         STDDEV([DISTINCT] n) :  Standard deviation of n 

·         SUBSTR(char, s[,l]) : A substring of char, starting at character s, length l 

·         SUBSTRB(char, s[,l]) : A substring of char, starting at character s, length l. The same as SUBSTR, except that 's', 'l' and the return value are expressed in bytes, use for double-byte char sets 

·         SUM([DISTINCT] n) :  Sum of values of n, ignoring NULLs 

·         SYS_CONTEXT('namespace','attribute_name') :  Examine the package associated with the context namespace .

              Possible attributes are: NLS_TERRITORY, NLS_CURRENCY, NLS_CALENDAR ,              NLS_DATE_FORMAT, NLS_DATE_LANGUAGE, NLS_SORT, SESSION_USER, CURRENT_USER, CURRENT SCHEMAID,SESSION_USERID, CURRENT_USERID 

·         SYS_CONTEXT ('USERENV','IP_ADDRESS') 

·         SYS_GUID()  :  Returns a globally unique identifier (16 byte RAW value) 

·         SYSDATE   :    The current system date & time

·         TAN(n)      :  Tangent of n in Radians

·         TANH(n)     :  Hyperbolic tangent of n in Radians

·         TO_CHAR  :     Convert to character String

                               Eg :to_char(to_date(‘1/sep/2009’),’MON’)  =sep 

·         TO_DATE  :     Convert to date value 

·         TO_LOB(long)  : Convert LONG values to CLOB or NCLOB values  or convert LONG RAW values to BLOB values.  Use only as part of an "INSERT INTO ... SELECT..." subquery.  

·         TO_MULTI_BYTE(char) :  Convert single-byte char to multi-byte char. 

·         TO_NUMBER   :  Convert to numeric format

·         TO_SINGLE_BYTE(char) :  Convert multi-byte char to single-byte char.

·         TRANSLATE('char','search_str','replace_str') :Replace every occurrence of search_str with replace_str  unlike REPLACE() if replace_str is NULL the function returns NULL 

·         TRANSLATE (text USING charset) :  Convert text into a specific character set. Use this instead of CONVERT() if either the input or output datatype  is NCHAR or NVARCHAR2. 

·         TRIM(LEADING|TRAILING|BOTH trim_char FROM trim_source) : Returns trim_source as a VARCHAR2 with leading/trailing items removed.  trim_char defaults to a space ' ' but may be numeric or char 'A' 

·         TRUNC(i,d)  :  i truncated to d decimal places (d defaults to 0)

·         TRUNC(date,fmt) :  date truncated to nearest fmt

·         UID  :         User id - unique number

·         UPPER(char)  :  Returns Chars in uppercase 

·         USER      :    Returns the current Username 

·         USERENV('option') : Can return any of the options: ENTRYID, SESSIONID, TERMINAL, LANGUAGE, ISDBA, LANG, INSTANCE, CLIENT_INFO 

·         VALUE(correlation_variable) : Return the object instance for a row of an object table as associated with the correlation_variable 

·         VARIANCE([DISTINCT] n) : Variance of n, ignoring NULLs

·         VSIZE(expr)  :  Value Size - returns the number of bytes used by each row of expr.

Oracle Functions

ORACLE FUNCTIONS
·         LAST_DAY(date) : Returns the last day of month in Date
                   Eg : last_day('23/sep/2009')  = 9/30/2009
 ·         LEAST(expression, expression...) :  Returns the smallest in a list of expressions
                   Eg : least (2,4,3)=2
 ·         LENGTH(char)  :  Returns the number of characters in char
                   Eg : length(‘abc’)=3
 ·         LENGTHB(char) :  Returns the number of bytes in char                
·         LIKE wildcard/value :    Wildcards are [% = any chars] [ _ = any one char]
                                                   Where 'x' LIKE 'ajith%' [will find 'Ajithraj']
                                                   Where 'x' LIKE 'ajith_' [will find 'Ajitha']
·         LN(n)      :    Natural Log of n, where n>0
·         LOG(b,n)    :  log of n, base b
            ·         LOWER(char)  :  Returns character string in lowercase
                                              Eg : lower(‘Lima’) = lima
·         LPAD(char, n[,PadChar]) :    Left Pad char with n spaces [or PadChars]
                                  Eg : lpad('abc',5,0) = 00abc
·         LTRIM(char[,set]) : Left Trim char - remove leading spaces [or char set]
·         MAKE_REF(table,key) :  Create a REF to a row of an OBJECT view/table
·         MAX([DISTINCT] expr) :  Maximum value returned by expr
·         MIN([DISTINCT] expr) :   Minimum value returned by expr
·         MOD(x,y)  :    Remainder of x divided by y
·         MONTHS_BETWEEN(end_date, start_date) : Number of months between the 2 dates (integer)
·         NEW_TIME(date, zone1, zone2) :   Convert between GMT and US time zones 
·         NEXT_DAY(date,day_of_week) :   '12-OCT-01','Monday' will return the next Mon after 12 Oct
·         NLS_CHARSET_DECL_LEN (bytecount,charset) :  Returns the declaration width (no of chars) of an NCHAR column
·         NLS_CHARSET_ID(varchars) :  Returns the char set ID given a charset name 
·         NLS_CHARSET_NAME(charset_id) :  Returns the char set name given a charset id
·         NLS_INITCAP(char[,'NLS_SORT = sort_sequence']) :  Returns char in Initial Caps, using an NLS sort_sequence  either the session default or specified directly
·         NLS_LOWER(char[,'NLS_SORT = sort_sequence']) : Returns char in lower case, using an NLS sort_sequence  either the session default or specified directly
·         NLSSORT(char[,'NLS_SORT = sort_sequence']) :  Return the string of bytes used to sort char, using an NLS sort_sequence  either the session default or specified directly 
·         NLS_UPPER(char[,'NLS_SORT = sort_sequence']) :  Returns char in UPPER case, using an NLS sort_sequence  either the session default or specified directly
·         NVL(expression, value_if_null) : If expression in the function is null, returns value_if_null; if expression is not null, returns expression.  
·         PERCENT_RANK : Calculate the percent rank of a value in a group.
·         POWER(m,n)  :  m raised to the nth power
·         RANK   :       Calculate the rank of a value in a group
·         RAWTOHEX(raw) : Convert  a raw to a character value containing its hex equivalent
·         REF(table_alias) : Returns a REF value for an object instance .The table alias (correlation variable) is associated with one row of an object table or an object view in an SQL statement. 
·         REFTOHEX(ref)  : Convert ref (object type) to a char value containing its hex equivalent. 
·         REPLACE(char, search_str[, replace_str]) :  ANSI alternative to decode() Replace every occurrence of search_str  with replace_str, replace_str defaults to null.
·         ROUND(n,d)  :  n rounded to d decimal places (d defaults to 0)
                                              Eg : round(3.5345,2)=3.53
·         ROUND(date,fmt) : date rounded to fmt
·         ROWIDTOCHAR(rowid) :  Convert a rowid value to VARCHAR2
·         ROW_NUMBER   : It assign a unique number to each row of the results.  
·         RPAD(char, n[,PadChar]) :   Right Pad char with n spaces [or PadChars]
·         RTRIM(char[,set]) :  Right Trim char - remove trailing spaces [or char set]