Programming & Computer Science Answers

Get all the potential users. Fetch the user_ids who liked at least 2 videos published by "Disney" channel, and who did not subscribe to the channel (channel_id = 352).

Note:

Consider reaction_type LIKE as liked.

Sort the output in the descending order of no_of_likes, and then in the ascending order of potential_user_id.

Expected Output Format

potential_user_id no_of_likes

table:

View Schema

user_likes

user_id video_id reaction_type reacted_at

video

channel_id

channel

channel_id name owner_id

At which OSI layer does IP operate?

1.      What field in a TCP segment is used to determine if an arriving data unit exactly matches the data unit sent by the source?

Q4) Create a class named User with the following attributes and it needs above address entity as subelement name of type StringmobileNumber of type String

email of type Stringaddress of type AddresscreditCardNumber of type String

Include appropriate getters, setters and constructors.

Include methods to Search for user details using mobile number. If no records, print “No records found”.Search for user details using mobile number and then change the email id of the above user to new id provided. If no records exist, print “No records found”.

List the names of users in which the given string is a substring. List the users sorted in alphabetical order. If no records exist, print “No records found”.

List the names of users from a particular district. List the users sorted in alphabetical order. If no records exist, print “No records found”.

Write a main method to test the above class. Input and Output Format:

All text in bold corresponds to inp

Q3) Create class name Addressfollowing attributes:doorNumber of type Integerstreet of type Stringcity of type Stringdistrict of type Stringstate of type String

pinCode of type IntegerInclude appropriate getters, setters ,constructors.

Include method that lists all districts in particular state sorted in alphabetical order.collections.Write a main method to test the above class. Input and Output FormatAll text in bold corresponds to input and the rest corresponds to output. Sample Input and Output:Enter the number of addresses to be inserted 2Enter address 1 details Enter door number2Enter street nameLMCEnter city nameOotyEnter district nameNilgirisEnter state nameTamilnaduEnter pin code641044Enter address 2 details Enter door number5Enter street nameRed CrossEnter city nameSatyamangalamEnter district nameErodeEnter state nameTamilnaduEnter pin code642054Enter a state nameTamilnaduList of districts in Tamilnadu are ErodeNilgirisEnter a district name ErodeList of cities in Erode areSathyamangalam

Q2) Problem Statement:Write a Program to perform the basic operations like insert,delete,display and search in list. List contains String object items where these operations are to be performed.Sample Input and Output 1 :1. Insert2. Search3. Delete4. Display5. ExitEnter your choice :1Enter the item to be inserted:BottleInserted successfully

ExitEnter your choice :1Enter the item to beinserted:WaterInserted successfully1. Insert2. Search3. Delete4. Display5. ExitEnter your choice :1Enter the item to beinserted:CapInserted successfullyEnter your choice :1Enter the item to beinserted:MonitorInserted successfully1. : 2Enter the item to search : MouseItem not found in the list.Enter your choice : 2Enter the item to search : MonitorItem found in the list.. Exit : 3Enter the item to delete : Mouse : 4The Items in the list are : BottleWater Cap Monitor : 3Enter the item to delete : CapDeleted successfullyEnter your choice : 4The Items in the list are : BottleWater Monitor

Q1) Create a class with Customer with the following properties CustomerID and CustomerName and in that class only write functions:

a. List<Customer> retriveCustomers() to fill the customer class with objects and retrieve filled details of the customer .

b. FindCustomer (List<Customer> clist1,int custid1) find the customer from the above list of customers by fetching id from the user.

c. Updatecustomer(List<Customer> clist1, int custid1) to update a particular customer when id is given

d. Deletecustomer (List<Customer> clist1,int custid1) to delete the particular customer when id is given .

Due to a rush at the end of the exam, Professor could not arrange the answer sheets in the

sequence as desired. However, he mentioned the correct location of each answer sheet with it.

Now, Professor wants all the answer sheets in the desired sequence.prepare a linklist having a data, the location, and the link node to arrange the data in the in the increasing manner of the location variable.

HINT: Item ,location ,linknode

input: 5 3 ->6 2 ->4 1->2 4 NULL

output: 4 1->6 2->5 3->2 4 NULL