Tiktok Interview Questions (5+ Questions)

Inspect HTTPS headers and TLS certificate details using advanced curl techniques for endpoint troubleshooting. Learn how to fetch response headers without downloading the body, follow redirect chains to inspect each hop, extract TLS handshake information including certificate subject and issuer, and force specific TLS versions for protocol-specific testing. This guide covers using curl flags for header-only requests, certificate validation, and TLS version negotiation to diagnose inconsistent HTTPS behavior. Essential for debugging webhook failures, diagnosing redirect issues, and identifying TLS compatibility problems in API integrations.

Objective

Develop a SQL query to extract the year and month from each order_date in the orders table. Your query should return the order_id, total_amount, along with the derived year and month for each order. Ensure that the results are sorted in ascending order based on the `order_d...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

How to Calculate Cancellation Rate Per Order Date in SQL

Objective:

You are provided two tables, orders and cancellations, and your task is to write an SQL query that calculates the cancellation rate for each order date where the cancellation rate is greater than 20%. The cancellation ...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

SELECT
s.user_id
FROM
signups s
JOIN confirmations c ON s.user_id = c.user_id
WHERE
DATE (c.confirmation_date) = DATE (s.signup_date) + INTERVAL '1 day'
ORDER BY
s.user_id ASC;

SELECT
ROUND(
COUNT(DISTINCT t.user_id)::DECIMAL / COUNT(DISTINCT e.user_id) * 100,
2
) AS activation_rate
FROM
emails e
LEFT JOIN texts t ON e.user_id = t.user_id
AND t.signup_action = 'Confirmed'
WHERE
e.signup_action = 'Signup';