CareerCup

I have been asked to do the following by the interviewer before the Interview:
"
In the meantime we're asking each of the candidates to prepare an analysis of our current School Of Architecture website as a well-informed and objective user. This will be a topic of discussion during the interviews."

I am not sure what does that means , well-formed and objective user? Could any one please explain?

I was asked to give corresponding number of days for the date string. Say for example, if we have string date variable as follows:

String date = "2011-12-31";

the output should be : 365

If we have ; String date = "2015-01-01"

The output should be : 01

I kind of started like the following but had no clue how to move forward:

public class DayPrint {

    
    public static void main(String[] args) {
       
        String jdate = "2011-12-31";
        
        String months = jdate.substring(5,7);
        
        int intMonths = Integer.valueOf(months);
        
        String date = jdate.substring(8,10);
        
        int intdate = Integer.valueOf(date);
        
        System.out.println("Months = " + months + "Date =" + date);

      for (int i = 0 ; i <= intMonths ; i++) {
      int count = 0;
        for (int j = 0 ; j < intdate ; j++){
         count ++ ;
       }


        
        
    }

}

Please consider the following tables:

Code:

Table Name: Person

Person_Id Name


Table Name: DVD

DVD_ID Owner_ID Title

Here is the query:
Write a query that returns the list of DVDs that belong to owners who own “Superman”

Here is my solution:

Code:

SELECT p.name,d.dvd_id
FROM DVD d,Person p
WHERE p.person_id = d.dvd_id
AND Title = 'Superman' ;

I answered above answer. But interviewer was expecting me to do using Subquery. Is that possible?Please let me know if the above query is correct or not.

We have a very large excel file that is produced every day by a batch process. We need to report what records were added and which records were removed compared to the file generated on the previous day. The challenge is that there is no sortable field in the list that we could use (such as a creation date), imagine for the sake of this test that there’s only First Name, Last Name and Email in the excel file, and that the ordering is not consistent from one day to the next. How would you approach the problem?

Suppose you reach your home and noticed that the light bulb in your corridor is not working. What will you do in such a situation?