PHP, Drupal & SQL Online Test

What will the following PHP code output?

// OPTION ONE
Array
(
		[0] => basappa
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
    [4] => fakhruddin
)

// OPTION TWO
Array
(
		[0] => hidayatullah
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
    [4] => fakhruddin
)

// OPTION THREE
Array
(
		[0] => fakhruddin
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
    [4] => hidayatullah
)

// OPTION FOUR
Array
(
		[0] => basappa
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
)

What does the following code output?

What does the following code output?

Consider the following table data and PHP code. What is the result?

Review the following Drupal code:

Pick the correct statements:

A: When /sample is accessed, access is allowed without checking for permissions and SampleController::content method is invoked
B: When /sample is accessed, ‘access content’ permission is checked on the accessing user and, if access is granted, SampleController::content method is invoked
C: When /sample is accessed, the page outputs ‘A’ on the page with title ‘B’
D: When /sample is accessed, the page outputs ‘B’ on the page with title ‘A’
E: When /sample is accessed, the page outputs ‘A’ on the page with no title
F: When /sample is accessed, the page outputs nothing on the page with title ‘B’

Review the following Drupal code:

Pick the correct statements:

A: Both the snippets create the queries to run but are not executed until $query→execute() is called
B: When Snippet 2 is run, the insert statements are executed one after the other always. Equivalent to calling →execute() two separate times for each item in $values.
C: When Snippet 2 is run, depending on the database, the insert statements will be executed together in a transaction
D: The return value of $result→execute will be the inserted record entry

Consider the following SQL table:

How many rows does the following SQL query return?

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:

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 startup company E-Motors is building driverless automated cars. The car contains a sensor that checks the road quality for the next N meters to decide the optimal speed at which the cars should move. We are given recorded data by the sensor in the form of an array, where each element of the array is the rating given to 1 meter of the road in sequence. 

The rating given by the sensor is from 1 to 100, where 100 represents the road with the best condition, and any rating above 60 is optimal. Find the longest stretch of road in meters that is categorized as optimal by the sensor.

The input is an array of "strings" which needs to be converted from string to integer/number inside the function.

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.