IBM数据相关面试真题

6.Companies with Average Salaries above a Certain Threshold

7.Poisson Distribution Estimation for Various Scenarios

8.Programming Question: Server Request Handling with Thread Pool.

9.Minimum Number of Partitions Required

10.Optimizing Nested For Loop for Card Packet Creation

11.SQL Query for Interest Cash Flow Analysis

12.Maximize Positive Prefix Sums in Array Rearrangement

13.Maximum Even Sum of Subelements in a List

14.Maximize Shopkeeper's Revenue

15.SQL Query for Filtering Professors' Salaries

16.SQL Query for Text Rewriting Service Statistics

17.Minimum Number of Chairs

18.Get Largest Number

19.Closest Numbers

20.Account Transactions Query

21.Finest Food Outlet Retrieval

22.SQL Grouping and Filtering

23.Algorithm to Minimize Cost Function by Inserting a Number

24.Algorithm for Packet Transmission Times

25.SQL Query to Find Overloaded Game Inventories

26.SQL Query to Count Active Domains and Identify Nearest Expiration

27.SQL Query for Accounting Number Format Transactions

28.SQL Query for Top Three Math Scores

29.Convert Integers to Roman Numerals

30.MMORPG Inventory Query Problem

31.Good Array Query Problem

32.SQL Query for Active Users and Domains

33.Find protocols where the sum of incoming traffic is greater than the sum of outgoing traffic

34.Retrieve the top three math scores from students

35.Count the number of purchase records for May 2022

36.Select hardware with higher downstream rate than upstream rate and minimal downtime

37.Identify students with a total score over 500

38.Find CVM configurations and number of deployments for the year 2021

39.Calculate Total Inventory Weight for MMORPG Accounts

40.SQL Query for Banner Information by City

41.SQL Query for Protocol Traffic Analysis

42.SQL Query for Banners in Cities

43.Network Traffic Database Query

44.HTTP Request Log Analysis

45.Active Encryption Salt Length Audit

46.Find the k-th Factor of a Number

47.Calculate the Product of Elements in an Array After Modulo Operation

48.Database Security Audit Query

49.Simple SQL JOIN Query

50.Find the Number of Active Encryptions

51.Generate a Sales Report for June 2022

52.SQL Query Writing

53.SQL Query to Filter Sum Greater Than 10 After Join

54.SQL Query for Account-Item Relationship

55.MMORPG SQL Query

56.SQL Problem

57.Generate a Summary Table from Accounts and Transactions

58.SQL Query to Find Professors Teaching Courses Outside Their Department

59.Coding Task: File Reading and Data Testing Function

60.Experience Detailing

61.Simple SQL Query Execution

62.SQL Formatting Challenge

63.Maximize the Minimum Missing Integer After Reduction