IDBI Intech Limited Interview Questions, Process, and Tips

Technical aptitude test ,on Java Sql

Q1. Direct interview and questions asked on SQL and java
Add your answer

It was an off-campus placement drive at Bharati Vidyapeeth Belapur.
1st round was MCQ based 
2nd round was interview with HR. Kunal Yadav
If you have a degree in your hand, then you are eligible for a Management trainee position; otherwise, you will have to work as an intern.
A fixed salary and a bond period of 2 years.

Questions asked in the MCQ - Anti Money Laundering department:

1. Which of the following is smallest integer data type?
-Long
-Int
-Short
-Byte

2. What will be the output of the program?
class Bitwise
{
     public static void main (String [ ] args)
     {
           int x = 11 & 9;
           int y = x ^ 3;
           System.out.println( y | 12 );
     } }

12
7
8
14

3. Integer Data type does not include following primitive data type ___ .
-Double -Short -Byte -Enum

4. class Equals
{
    public static void main(String [ ] args)
    {
        int x = 100;
        double y = 100.1;
        Boolean b = (x = y); /* Line 7 */
        System.out.println(b);
    } }

-True
-False
-Compilation fails
-An exception is thrown at runtime

5. GROUP BY typically involves aggregates fn. as:
-COUNT ()
-MAX ()
-SUM ()
-All of the above

6. public void foo( boolean a, Boolean b)
{
     if ( a )
     {
          System.out.println("A"); /* Line 5 */
     }
     elseif(a && b) /* Line 7 */
     {
          System.out.println("A && B");
      }
      else /* Line 11 */
      {
            if ( !b )
            {
                System.out.println( "not B") ;
             }
             else
             {
                  System.out.println( "ELSE");
             }
        }
 }

-If a is true and b is true then the output is "A && B"
-If a is true and b is false then the output is "notB"
-If a is false and b is true then the output is "ELSE"
-If a is false and b is false then the output is "ELSE"

7. class PassS
{
     public static void main (String [ ] args)
     {
         PassS p = new PassS( );
         p.start ( );
     }
     void start ( )
     {
          String s1 = "slip".
          String s2 = fix(S1);
          System.out.println(s1 + " " + s2);
     }
     String fix(String s1)
     {
          s1= s1 + "stream";
          System.out.println(s1 + " ");
          return "stream";
      }
}

-slip stream
-slipstream stream
-stream slip stream
-slipstream slip stream

8. switch (x)
{
    default:
        System.out.println("Hello");
}

Which two are acceptable types of x?
byte
long
char
float
short
long

-1 and 3
-2 and 4
-3 and 5
-4 and 6

9. What will be the output of the program?

class Test
{
    public static void main(String [ ] args)
    {
        int x = 0;
        int y = 0;
        for (int z = 0; z < 5; z++)
        {
            if (( ++x > 2 ) || (++y > 2))
            {
                  x++;
             }
       }
      System.out.println(x + " " + y);
       }  }

11
82
83
85

10. Which three statements inserts a row into the table ? (Choose three)
A. INSERT INTO employees
VALUES ( NULL, 'John' ,'Smith');
B. INSERT INTO employees ( first_name,last_name)
VALUES ('John' ,'Smith');
C. INSERT INTO employees
VALUES ('1000' ,'John', NULL);
D. INSERT INTO employees (first_name,last_name, employee_id)
VALUES (1000,'John', 'Smith');
E. INSERT INTO employees (employee_id)
VALUES (1000);
F. INSERT INTO employees (employees_id,first_name,last_name)
VALUES ( 1000, 'John' , ");

-A,C,D,F
-B,C,F
-C,E,F
-All of the above

11. class Test
{
    public static void main (String [ ] args)
    {
        int x = 20;
        String sup = (x < 15) ? "small" : (x < 22)? "tiny" : "huge";
        System.out.println(sup);
     }
}

-Small
-Tiny
-Huge
-Compilation fails

12. What will be the output of the program?
class Test
{
    public static void main(String [ ] args)
    {
        int x = 0;
        int y = 0;
        for (int x = 0; z < 5; z++)
        {
            if (( ++x > 2 ) && (++y > 2))
            {
                  x++;
             }
       }
       System.out.println(x + " " + y);
       }
 }

52
53
63
64

13. Which of the following is not a primitive data type?
-Int
-Short
-Byte
-Enum

14. Which of the following is an OOP feature in Java*
-Encapsulation
-Abstraction
-Polymorphism
-All of the above

15. Byte variables are declared by use of the ___ keyword ( Using Primitive Data Type).
-Bytes
-byte
-Byte
-bytes

16. public class While
{
    public void loop()
    {
         int x= 0;
         while ( 1 ) /* Line 6 */
         {
            System.out.print("x plus one is " + (x+1));/* Line 8 */
          }
   }
}

Which statement is true?
-There is a syntax error on line 1
-There are syntax errors on lines 1 and 6
-There are syntax errors on lines 1,6, and 8.
-There is a syntax error on line 6.

17. Members of a base class are never accessible to a derived class*
-Public
-Private
-Protected
-All of the above

18. Which of the following is the correct statement to create an object of Data class?*
-Data d=new object ( );
-Data d =new Data ( );
-Data d( ) = new Data ( );
-Data d( )= new Data ( );

19. public void test (int x)
{
   int odd = 1;
   if(odd) /* Line 4 */
   {
       System.out.println("odd");
   }
    else
   {
       System.out.println("even");
    }
}

Which statement is true?
-Compilation fails.
-odd will always be output
-even will always be output.
-odd will be output for odd values of x and even for even values.

20. A stored procedure is a :-
-Sequence of SQL or PL/SQL statements to perform specific function
-Stored in compiled form in the database
-Can be called from all client environments
-All of the above.

Q1. I was not eligible for HR round. But still this website asked me to write at least 2 questions Other wise this form won't submit.
Add your answer
Q2. About the resume and projects done.
Add your answer

Q1. Nouns Pronouns Verb Adverb
Add your answer

Q1. What are the basic details of the project?
Ans. 
The project is a web application for managing inventory and sales for a retail store.
• Developed using React for the front-end and Node.js for the back-end

• Implemented features such as product management, sales tracking, and reporting

• Integrated with a payment gateway for online transactions
Answered by AI
Add your answer
Q2. What is .net/ what is java/ what is PHP
Ans. 
Java, .NET, and PHP are popular programming languages used for developing software applications.
• Java is a versatile, platform-independent language commonly used for building web applications, mobile apps, and enterprise software.

• .NET is a framework developed by Microsoft for building Windows applications, web services, and web applications.

• PHP is a server-side scripting language used for creating dynamic web pages and ...read more
Answered by AI
Add your answer

ChatGPT is the topic of group discussion and this interview scheduled by CDAC mumbai

Q1. What is spring boot I which file we give database connection
Ans. 
Spring Boot is a framework that simplifies the development of Java applications by providing pre-configured settings and tools.
• Spring Boot is used to create stand-alone, production-grade Spring-based Applications.

• Database connection details are typically provided in the application.properties or application.yml file.

• Example: spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase
Answered by AI
Add your answer

Q1. About your experience
Add your answer
Q2. Previous experience
Add your answer