Java, Spring & SQL Online Test

What does the following code output?

What does the following Java code output?

Given following interface:

Which of these are correct classes?

After which line is "bs" object, created on Line 4, eligible for garbage collection?

What does the following code output?

1) G A B E D H
2) G B A D E H
3) G B A D E H C F
4) C F G A B E D H
5) C F G B A D E H
6) G C F A B E D H
7) G C F B A D E H

Review the following two Spring components- SampleA and SampleB:

Notice @Autowired line added to SampleService in SampleB (rest of the code is same for both components). What happens when the components are run as a @SpringBootApplication?

A: SampleA prints true null
B: SampleA prints true class package.SampleService
C: SampleA throws a null pointer exception
D: SampleA prints false null

E: SampleB prints true null
F: SampleB prints true class package.SampleService
G: SampleB throws a null pointer exception
H: SampleB prints false null

Spring allows specific operations to be performed after the bean is initialized and before the bean is destroyed. Review the following sample Bean that implements init method and overrides afterPropertiesSet. 

Here’s the bean definition added to the configuration file:

What does the code print when the Spring container is started?

Review the following Spring Boot application code:

Here are two possible SampleConfig class definitions:

When the code is run as @SpringBootApplication, what would happen?

A: Using X as SampleConfig will print- true SimpleDateFormat
B: Using X as SampleConfig will print - true class java.text.SimpleDateFormat
C: Using X as SampleConfig will print a NullPointerException stacktrace
D: Using X as SampleConfig will print a BeanDefinitionParsingException stacktrace

E: Using Y as SampleConfig will print- true SimpleDateFormat
F: Using Y as SampleConfig will print - true class java.text.SimpleDateFormat
G: Using Y as SampleConfig will print a NullPointerException stacktrace
H: Using Y as SampleConfig will print a BeanDefinitionParsingException stacktrace

Consider the following SQL table:

How many rows does the following SQL query return?

Consider the following SQL table:

Which of the following SQL commands will find the ‘nth highest Sales’ if it exists (returns null otherwise)?

Consider the following SQL table:

Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?

Consider the following SQL table:

What will be the first two tuples resulting from the following SQL command?

Consider the following SQL table:

How many tuples does the following query return?

We want to register students for the next semester. All students have a receipt which shows the amount pending for the previous semester. A positive amount (or zero) represents that the student has paid extra fees, and a negative amount represents that they have pending fees to be paid. The students are in a queue for the registration. We want to arrange the students in a way such that the students who have a positive amount on the receipt get registered first as compared to the students who have a negative amount. We are given a queue in the form of an array containing the pending amount.

For example, if the initial queue is [20, 70, -40, 30, -10], then the final queue will be [20, 70, 30, -40, -10]. Note that the sequence of students should not be changed while arranging them unless required to meet the condition.

⚠️⚠️⚠️ Note:
- The first line of the input is the length of the array. The second line contains all the elements of the array.
- The input is already parsed into an array of "strings" and passed to a function. You will need to convert string to integer/number type inside the function.
- You need to "print" the final result (not return it) to pass the test cases.

For the example discussed above, the input will be:
5
20 70 -40 30 -10

Your code needs to print the following to the standard output:
20 70 30 -40 -10

A manager hires a staff member to keep a record of the number of men, women, and children visiting the museum daily. The staff will note W if any women visit, M for men, and C for children. You need to write code that takes the string that represents the visits and prints the count of men, woman and children. The sequencing should be in decreasing order. 

Example:

Input:
WWMMWWCCC

Expected Output: 
4W3C2M

Explanation: 
‘W’ has the highest count, then ‘C’, then ‘M’. 

⚠️⚠️⚠️ Note:
- The input is already parsed and passed to a function.
- You need to "print" the final result (not return it) to pass the test cases.
- If the input is- “MMW”, then the expected output is "2M1W" since there is no ‘C’.
- If any of them have the same count, the output should follow this order - M, W, C.