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

7 12194
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

7 11635
Q:

When should we use container classes instead of arrays?

Answer

It is advisable to use container classes of the STL so that you don’t have to go through the pain of writing the entire code for handling collisions, making sure its working well, testing it repeatedly with an overhead of time consumption.


Suppose you have some data that has values associated with strings and its fields consist of grades> in this situation you can directly use hash table instead of having it created by yourself.

Report Error

View answer Workspace Report Error Discuss

Subject: C++

7 3758
Q:

What are the support tickets given in SAP fico module? please give some examples.

Answer

Support tickets are basically the problems that arise in day to day usage of SAP. 


So any sap fico consultant who is resolving the day to day production issues is actually supporting the tickets.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

7 8429
Q:

What is the purpose of UIWindow object?

Answer

The presentation of one or more views on a screen is coordinated by UIWindow object..

Report Error

View answer Workspace Report Error Discuss

Subject: IOS

7 2825
Q:

"National Volunteer Day" is observed on ____ ?

A) 1st October B) 21st September
C) 11th October D) 29th September
 
Answer & Explanation Answer: B) 21st September

Explanation:

"National Volunteer Day" & "International Peace Day" are observed on 21st september every year.

Report Error

View Answer Report Error Discuss

Filed Under: Important Days and Years
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Bank Clerk , Bank PO

7 2463
Q:

Who is the new president of News Broadcasters Association (NBA) for 2017-18 ?

A) Barun Das B) K. V. L Narayan Rao
C) Ashok Venkatramani D) Rajat Sharma
 
Answer & Explanation Answer: D) Rajat Sharma

Explanation:

India TV chairman and editor-in- chief Rajat Sharma will be the new president of the News Broadcasters Association (NBA) for 2017-18.

Report Error

View Answer Report Error Discuss

Filed Under: General Awareness
Exam Prep: CAT , Bank Exams
Job Role: Bank PO , Bank Clerk

7 1913
Q:

Indians who have been featured on Forbe's list of the 100 Greatest Living Business Minds ?

A) Ratan Tata B) Lakshmi Mittal
C) Vinod Khosla D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

Three Indians – Ratan Tata, Lakshmi Mittal and Vinod Khosla have been featured on Forbe's list of the 100 Greatest Living Business Minds.

Report Error

View Answer Report Error Discuss

Filed Under: Famous Personalities
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Bank Clerk , Bank PO

7 2109