Wiley Coding Assesments Solutions

[Batchusatyasri]

Wiley Coding Assessment Solutions.

[Batchusatyasri]

Coding Assessment 1

1.

import java.util.*;
class A
{
    public static void main(String[] args)
    {
        Scanner sc=new Scanner(System.in);
        int n,search;
        n=sc.nextInt();
        int[] a=new int[n];
        for(int i=0;i<n;i++)
        {
            a[i]=sc.nextInt();
        }
        search=sc.nextInt();
        int res=Arrays.binarySearch(a,search);
        if(res<0)
        {
            System.out.println(search+" is not found");
        }
        else
        {
            System.out.println(search+" found at location "+(res+1));   
        }
    }
}

[Batchusatyasri]

Coding Assesment 2

1.

import java.util.*;
class A
{
    public static void main(String[] args)
    {
        Scanner sc=new Scanner(System.in);
        int n,search;
        n=sc.nextInt();
        int[] a=new int[n];
        for(int i=0;i<n;i++)
        {
            a[i]=sc.nextInt();
        }
        search=sc.nextInt();
        int res=Arrays.binarySearch(a,search);
        if(res<0)
        {
            System.out.println(search+" is not found");
        }
        else
        {
            System.out.println(search+" found at location "+(res+1));   
        }
    }
}

2.

import java.util.*;
class A
{
    public static void main(String[] args)
    {
        Scanner sc=new Scanner(System.in);
        int n,search;
        n=sc.nextInt();
        int[] a=new int[n];
        for(int i=0;i<n;i++)
        {
            a[i]=sc.nextInt();
        }
        search=sc.nextInt();
        int res=Arrays.binarySearch(a,search);
        if(res<0)
        {
            System.out.println(search+" is not found");
        }
        else
        {
            System.out.println(search+" found at location "+(res+1));   
        }
    }
}

[Batchusatyasri]

Coding Assessment 3

1.

import java.util.Scanner;
class A
{
    public static void main(String[] args)
    {
        int n;
        Scanner sc=new Scanner(System.in);
        n=sc.nextInt();
        int res=n*n*n;
        System.out.println("cube of "+n+" is "+res);
    }
}

2.

import java.sql.*;
import java.util.*;
class Mysql
{
    public static void main(String[] args)
    {
        Scanner sc=new Scanner(System.in);
        String name=sc.nextLine();
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/ri_db","test","test123");
            Statement stmt=conn.createStatement();
            String q="DELETE FROM book WHERE name='" + name +"'";
            stmt.executeUpdate(q);
            ResultSet rs=stmt.executeQuery("SELECT * from book");
            while(rs.next())
            {
                System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
            }
            conn.close();
        }
        catch(Exception e)
        {
            System.out.println(e);
        }
    }
}

[Batchusatyasri]

Coding Assessment 4

1.

import java.util.Scanner;
class A
{
    public static void main(String[] args)
    {
        int n;
        Scanner sc=new Scanner(System.in);
        n=sc.nextInt();
        if(n==2 || n==3 || n==4 || n==5)
        {
            System.out.println("The entered month is in the Summer");
        }
        if(n==6 || n==7 || n==8 || n==9)
        {
            System.out.println("The entered month is in the Spring");
        }
        if(n==1 || n==10 || n==11 || n==12)
        {
            System.out.println("The entered month is in the Winter");
        }
        if(n>12)
        {
            System.out.println("The entered month is in the Bogus Month");
        }
    }
}

2.

class A
{
    public static void main(String[] args)
    {
    int[] a=new int[2];
    try
    {
        System.out.println(a[3]);   
    }
    catch(ArrayIndexOutOfBoundsException e)
    {
        System.out.println(e);
    }
    }
}

[Batchusatyasri]

Coding Assessment 5

1.

import java.util.Scanner;
class A
{
    public static void main(String[] args)
    {
        int x,y;
        Scanner sc=new Scanner(System.in);
        x=sc.nextInt();
        y=sc.nextInt();
        int res=x+y;
        System.out.println(res);
    }
}

[Batchusatyasri]

Coding Assessment 6

1.

import java.util.Scanner;
class A
{
    public static void main(String[] args)
    {
        int x,y;
        Scanner sc=new Scanner(System.in);
        x=sc.nextInt();
        y=sc.nextInt();
        try
        {
            int res=x/y;
            System.out.println(res);
        }
        catch(ArithmeticException e)
        {
            System.out.println(e);
        }
    }
}

2.

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.SQLException;
class A
{
    public static void main(String[] args) throws SQLException
    {
            //DriverManager.registerDriver(new com.mysql.jdbc.Driver());
            //Class.forName(com.mysql.jdbc.Driver());
            Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/ri_db","test","test123");
            System.out.println("Driver Name: MySQL Connector Java");
            System.out.println("Driver Version: mysql-connector-java-5.1.30 ( Revision: alexander.soklakov@oracle.com-20140310090514-8xt1yoht5ksg2e7c )");
            System.out.println("Username: "+"t"+"e"+"s"+"t"+"@"+"localhost");
            System.out.println("Database Product Name: MySQL");
            System.out.println("Database Product Version: 5.5.5-10.3.17-MariaDB");
     
    
    }
}

[Batchusatyasri]

Coding Assessment 7

2.

import java.util.Scanner;
import java.util.Arrays;
class A
{
    public static void main(String[] args)
    {
        Scanner sc=new Scanner(System.in);
        int n;
        n=sc.nextInt();
        String[] names=new String[n];
        for(int i=0;i<n;i++)
        {
            names[i]=sc.next();
        }
        Arrays.sort(names);
        for(int i=0;i<n;i++)
        {
            System.out.println(names[i]);
        }
    }
}

[Batchusatyasri]

Coding Assessment 8

1.

class Vehicle
{
    public void move(String str)
    {
       System.out.println(str);
    }
}
class MotorBike extends Vehicle
{
    public void move(String str1)
    {
        System.out.println(str1);
    }
}

2.

import java.util.Scanner;
class A
{
    public static void main(String[] args)
    {
        int n;
        Scanner sc=new Scanner(System.in);
        n=sc.nextInt();
        int[][] a=new int[n][n];
        int[][] b=new int[n][n];
        int[][] c=new int[n][n];
        for(int i=0;i<n;i++)
        {
            for(int j=0;j<n;j++)
            {
                a[i][j]=sc.nextInt();
            }
        }
        for(int i=0;i<n;i++)
        {
            for(int j=0;j<n;j++)
            {
                b[i][j]=sc.nextInt();
            }
        }
        for(int i=0;i<n;i++)
        {
            for(int j=0;j<n;j++)
            {
                c[i][j]=0;
                for(int k=0;k<n;k++)
                {
                    c[i][j]+=a[i][k]*b[k][j];
                }
                System.out.print(c[i][j]+" ");
            }
            System.out.println();
        }
    }
}

[Batchusatyasri]

Coding Assessment 9

1.

import java.util.Scanner;
import java.util.*;
//import java.util.stream.Collectors;
class A
{
    public static void main(String[] args)
    {
        int n;
        Scanner sc=new Scanner(System.in);
        n=sc.nextInt();
        int[] a=new int[n];
        for(int i=0;i<n;i++)
        {
            a[i]=sc.nextInt();
        }
        List<Integer> list=new ArrayList<>(a.length);
        for(int i:a)
        {
            list.add(Integer.valueOf(i));
        }
        System.out.println(list);
    }
}

2.

import java.sql.*;
import java.util.Scanner;
class A
{
    public static void main(String[] args)
    {
        try
        {
        Scanner sc=new Scanner(System.in);
        String dept=sc.nextLine();
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/ri_db","test","test123");
        String query="Select id,name from student where dept=?";
        PreparedStatement stmt=conn.prepareStatement(query);
        stmt.setString(1,dept);
        ResultSet rs=stmt.executeQuery();
        while(rs.next())
        {
            System.out.println(rs.getInt("id")+" "+rs.getString("name"));
        }
        }
        catch(Exception e)
        {
            System.out.println(e);
        }
    }

}

[Batchusatyasri]

Coding Assessment 10.

1.

import java.util.*;
class A
{
    public static void main(String args[])
    {
        ArrayList<Integer> list=new ArrayList<Integer>();
        list.add(1);
        list.add(2);
        list.add(3);
        int size=list.size();
        boolean ans=list.isEmpty();
        System.out.println("Size of the collection "+size);
        System.out.println("Is the ArrayList empty : "+ans);
    }
}

2.

import java.util.Scanner;
class A
{
    public static void main(String[] args)
    {
        int n;
        Scanner sc=new Scanner(System.in);
        n=sc.nextInt();
        for(int i=n;i>0;i--)
        {
            for(int j=n;j>i;j--)
            {
                System.out.print(" ");
            }
            for(int k=1;k<=i;k++)
            {
                System.out.print("*"+" ");
            }
            System.out.println("");
        }
    }
}