Interview Questions

Q:

Write an SQL Query to check whether date passed to Query is date of given format or not.

Answer

SQL has IsDate() function which is used to check passed value is date or not of specified format ,it returns 1(true) or 0(false) accordingly.


SELECT  ISDATE('1/08/13') AS "MM/DD/YY";


It will return 0 because passed date is not in correct format.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

9 12881
Q:

This events sends the web page to the server for processing. Web page sends data back to the

same page on the server.
Which among the following events does the above stated task?

A) Validation events B) Cached events
C) Postback events D) None
 
Answer & Explanation Answer: C) Postback events

Explanation:

Postback events does the bove stated task

Report Error

View Answer Report Error Discuss

Filed Under: .NET
Job Role: Software Architect

0 12858
Q:

Which of the following is a comparison operator in SQL?

A) = B) <>
C) ` D) /
 
Answer & Explanation Answer: A) =

Explanation:

The comparison operator that is used in SQL is '='. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

3 12263
Q:

What is STPI ? why STPI knowledge required in Accounts Payable?

Answer

Software Technology Parks of India (STPI).Some of the software service providers will get exemption from STPI for their software exports. In accounts payable may be we need to define the vendor STPI location wise.


In India we have different STPI location. If one vendor supplying services or materials to all OR some of the STPI locations we need to maintain the same vendor STPI wise.  

Report Error

View answer Workspace Report Error Discuss

Subject: Accounts Payable

18 12255
Q:

What is the general syntax for accessing the namespace variable?

A) namespaceid::operator B) namespace,operator
C) namespace#operator D) none of the mentioned
 
Answer & Explanation Answer: A) namespaceid::operator

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: C++

1 12036
Q:

Difference between %TYPE and %ROWTYPE.

Answer

%type is used to declare a field of a table while %rowtype is used to declare a record with the same type as specified in that table, view or cursor.


Example of %type:


DECLARE


         v_EmployeeName emp.ename%TYPE


 


Example of %rowtype


DECLARE


          v_empployee emp%ROWTYPE;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

8 12028
Q:

What are SD37, SB37, SE37 abends?

Answer

All indicate dataset out of space. SD37 - no secondary allocation was specified. SB37 - end of vol. and no further volumes specified. SE37 - Max. of 16 extents already allocated.

Report Error

View answer Workspace Report Error Discuss

5 11710
Q:

How many constructors can a class have?

A) 1 B) 2
C) 4 D) None of the above
 
Answer & Explanation Answer: D) None of the above

Explanation:

A class can have any number of constructors. If a class have more than one constructor, we call it as the constructor is overloaded.

Report Error

View Answer Report Error Discuss

Filed Under: Java
Job Role: Database Administration , IT Trainer

9 11670