Welcome to IBM US - Standard - Back-End

• Test duration: 45 mins
• No. of questions: 2 questions

Question 1

Given a string, return the character that appears the maximum number of times in the string. The string will contain only ASCII characters, from the ranges ('a'-'z', 'A'-'Z', '0'-'9'), and case matters. If there is a tie in the maximum number of times a character appears in the string, return the character that appears first in the string.

Example
Input: text = abbbaccc
Output: a
Explanation: Both 'a' and 'b' occur 3 times in the text. Since 'a' occurs earlier, 'a' is the answer.

Function Description
Complete the function maximumOccurringCharacter in the editor below.

• Parameter:
  string text: the string to be operated upon
• Returns:
  char: The most occurring character that appears first in the string.

Constraints:

• 10 ≤ |text| ≤ 10^4
• All characters are alphanumeric, in the ranges ('a'-'z', 'A'-'Z', '0'-'9')

Sample Input for Custom Testing
text = "helloworld"

Sample Output
l

Explanation: The character 'l' occurs the most, 3 times in the string 'helloworld'.

---

Question 2

In the dynamic world of web hosting, providing customers with a clear overview of their assets is key to enhancing user experience. A development team must create a feature for an online hosting customer's panel that generates a dashboard report of all customers and the number of active websites they own.

The results should include the following columns:

• email: the email address of the customer
• total_active_sites: the total number of active websites for each customer

The results should be sorted in ascending order by email.

Note: Only active websites should be included.

Schema:

• customers:
  • id (INT, Primary Key): The identifier of the customer
  • email (VARCHAR(255)): The email address of the customer
• sites:
  • customer_id (INT, Foreign Key): The reference to the customer's ID
  • url (VARCHAR(255)): The URL of the site
  • is_active (BOOLEAN): The status of the website (1 for active, 0 for inactive)

Schema

• customers
  • id (INT, Primary Key): The identifier of the customer
  • email (VARCHAR(255)): The email address of the customer
• sites
  • customer_id (INT, Foreign Key): The reference to the customer's ID
  • url (VARCHAR(255)): The URL of the site
  • is_active (BOOLEAN): The status of the website (1 for active, 0 for inactive)

Sample Data Tables

customers

id	email
1	dcristofol0@slashdot.org
2	mbillanie1@japanpost.jp
3	hmainz2@utexas.edu

sites

customer_id	url	is_active
1	https://trellian.com	1
1	https://www.google.de	1
1	https://merriam-webster.com	1
1	https://wordpress.com	1
1	https://nsw.gov.au	1
1	https://www.barnesandnoble.com	1
1	https://www.yahoo.com	1
2	https://cloudflare.com	0
2	https://www.is.gd	1
2	https://www.unesco.org	1
3	https://www.sina.com.cn	0
3	https://xinhuanet.com	1
3	https://cyberchimps.com	1
3	https://ask.com	1
3	https://businessinsider.com	1
3	https://www.dailymail.co.uk	1
3	https://www.guardian.co.uk	1
3	https://www.microsoft.com	1
3	https://www.gizmodo.com	1
3	https://www.163.com	1

Sample Output

email	total_active_sites
dcristofol0@slashdot.org	7
hmainz2@utexas.edu	9
mbillanie1@japanpost.jp	2

我们长期稳定承接各大科技公司如TikTok、Google、Amazon等的OA笔试代写服务，确保满分通过。如有需求，请随时联系我们。

We consistently provide professional online assessment services for major tech companies like TikTok, Google, and Amazon, guaranteeing perfect scores. Feel free to contact us if you're interested.