Programming & Computer Science Answers

Describe how and why computer operating system is important for your computer and how categorised in different categorie?

Write the definition of void function that takes as input two parameters of type int, double and string.the functions seta the values of int and double variable to 0 and the value of the string variable to the empty string

Solve this Backtracking Question in C++

A two dimensional array of characters can be considered as a field. Each cell is either water 'W' or

a tree 'T'. A forest is a collection of connected trees. Two trees are connected if they share a side

i.e. if they are adjacent to each other. Your task is, given the information about the field, print the

size of the largest forest. Size of a forest is the number of trees in it. See the sample case for clarity;

Sample Input:

5

TTTWW

TWWTT

TWWTT

TWTTT

WWTTT

Sample Output:

10

Speed Typing Test

In this assignment, let's build a Speed Typing Test by applying the concepts we learned till now.

Refer to the below image.

https://assets.ccbp.in/frontend/content/dynamic-webapps/speed-typing-test-output.gif

The Url will show you the required output to be generated.

Instructions:

• Add HTML container element with id speedTypingTest
• Add HTML paragraph elements with id timer, quoteDisplay and result
• Add HTML textarea element with id quoteInput
• Add HTML button elements with id submitBtn and resetBtn
• Add the Bootstrap component spinner

By following the above instructions, achieve the given functionality.

• When the page is opened
• Make a HTTP request to get a random quotation
• URL: https://apis.ccbp.in/random-quote
• Display the random quotation in the HTML paragraph element with id quoteDisplay
• Start the timer and display the time in seconds in the HTML paragraph element with id timer
• When a value is entered in the HTML textarea element with id quoteInput and the HTML button element with id submitBtn is clicked
• If the value entered in the HTML textarea element with id quoteInput is same as the quotation in the HTML paragraph element with id quoteDisplay
• The timer should be stopped and a success message should be shown in the HTML paragraph element with id result
• If the value entered in the HTML textarea element with id quoteInput does not match the quotation in the HTML paragraph element with id quoteDisplay
• The timer should be running and an error message should be shown in the HTML paragraph element with id result
• When the HTML button with id resetBtn is clicked
• Make a HTTP request to get a new random quotation
• Display the new random quotation in the HTML paragraph element with id quoteDisplay
• Reset the timer to 0 seconds and display the time in seconds in the HTML paragraph element with id timer
• Empty the HTML textarea element with id quoteInput
• Add loading status with Bootstrap component spinner while making an HTTP request.

Resources

Clock Image:

• https://assets.ccbp.in/frontend/dynamic-webapps/clock-img.png

CSS Colors Used:

Background Color Hex Codes Used:

#690cb0

#dac0ff

#f3eaff

#f2ebfe

#ffffff

Border Color Hex Codes Used:

#9aa5b1

Text Color Hex Codes Used:

#690cb0

#3e4c59

#ffffff

#323f4b

• When the text in the HTML paragraph element with id quoteDisplay and the value entered in HTML textarea element with id quoteInput are not the same, and the HTML button element with id submitBtn is clicked an error message should be shown in the HTML paragraph element with id result

• Page should consist of HTML textarea element with id quoteInput

• Page should consist of HTML button element with id resetBtn

• When the text in the HTML paragraph element with id quoteDisplay and the value entered in HTML textarea element with id quoteInput are not the same, and the HTML button element with id submitBtn is clicked the timer should be running

• When the text in HTML paragraph element with id quoteDisplay is entered in HTML textarea element, and the HTML button element with id submitBtn is clicked a success message should be shown in HTML paragraph element with id result

• Page should consist of HTML paragraph element with id timer

• The HTML paragraph element with id timer should always have numbers greater than or equals to 0

• Page should be using the Bootstrap component Spinner

• When the text in HTML paragraph element with id quoteDisplay is entered in HTML textarea element, and the HTML button element with id submitBtn is clicked the timer should stop

• Paee should consist of HTML paragraph element with id quoteDisplay

• Page should consist of HTML button element with id submitBtn

• Page should consist of HTML paragraph element with id result

• Page should consist of HTML container element with id speedTypingTest

• JS code implementation should use classList.add and classList.remove to show and hide bootstrap spinner element

• JS code implementation should use setInterval and clearInterval to implement timer

• When the reset button is clicked, an HTTP request should be made to get a random quotation from the given URL and the value in the HTML paragraph element with id quoteDisplay should be replaced with quotation received in the response

• When page is opened, an HTTP request should be made to get a random quotation from the given URL and the HTML paragraph element with id quoteDisplay should have the quotation received in the response.

Book Search

In this assignment, let's build a Book Search page by applying the concepts we learned till now.

Refer to the below image.

https://assets.ccbp.in/frontend/content/dynamic-webapps/book_search_output.gif

Just for not having the image inserting option in this platform, I am giving the url of the image as that we have to generate.

Instructions:

• Add HTML input element with id searchInput inside an HTML container element
• Add HTML select element with id selectDisplayCount inside an HTML container element
• Add HTML container element with id searchResults

By following the above instructions, achieve the given functionality.

• When a value is entered in the HTML input element with id searchInput and press on Enter key
• Get title, imageLink, author (HTTP response with key search_results) by making HTTP request using fetch with URL https://apis.ccbp.in/book-store?title=kalam&maxResults=30
• Set imageLink in the HTML img element and set author in the HTML paragraph element
• When a value is entered in the HTML input element with id searchInput and an option is selected in the drop down
• Make a HTTP GET request to fetch the books based on the title entered and maximum number of results
• If search results not equal to zero, then append the search results to the HTML container element with id searchResults
• If search results equal to zero, then display "No results found"
• Add loading status with Bootstrap component spinner while making an HTTP request

Resources

Use this Background image:

https://assets.ccbp.in/frontend/dynamic-webapps/book-search-bg.png

CSS Colors used:

Text colors Hex code values used:

#323f4b

#ffffff

CSS Font families used:

• Roboto

Rules to be followed:-

• Page should consist of at least three HTML option elements inside an HTML select element with id selectDisplayCount

• Page should consist of HTML input element of type search with id searchInput inside an HTML container element

• Page should be using the Bootstrap component Spinner

• Page should consist of HTML main heading element

• Page should consist of HTML container element with id searchResults

• Page should consist of HTML container element with the CSS property background-image

• Page should consist of HTML select element with id selectDisplayCount inside an HTML container element

• When a value is entered in the HTML input element with id searchInput, x books option is selected in the HTML select element with id selectDisplayCount, an HTTP GET request with a valid url parameters title and maxResults should be made

• When a value is entered in the HTML input element with id searchInput, x books option is selected in the HTML select element with id selectDisplayCount, an HTTP GET request should be made to fetch and display x book items

• JS implementation should contain addEventListener for keydown event

please Help me.

This is the code for Getting all the channel_ids that uploaded at least one video in "AI/ML" or "Robotics" technologies between 2018 and 2021.

SELECT

 DISTINCT channel_id

FROM

 video

WHERE

 video_id >= 1

 AND name LIKE '%AI/ML%'

 OR name LIKE '%Robotics%'

 AND strftime('%Y', published_datetime) BETWEEN "2018"

 AND "2021"

GROUP BY

 channel_id

ORDER BY

 channel_id ASC;

Output Table:

channel_id
    351
    353
    364
    365
    377

But,

How can I Get all the channel_ids that uploaded at least 20 videos in "AI/ML", "Cyber Security", "Data Science" or "Robotics" technologies between 2018 and 2021.

Example: If a channel publishes 5 videos in AI/ML, 10 videos in Cyber Security and 5 videos in Data Science, consider the channel

the table data is very huge so, I cant send the complete table data.

please help me.

This is the code for Getting all the channel_ids that uploaded at least one video in "AI/ML" or "Robotics" technologies between 2018 and 2021.

SELECT

 DISTINCT channel_id

FROM

 video

WHERE

 video_id >= 1

 AND name LIKE '%AI/ML%'

 OR name LIKE '%Robotics%'

 AND strftime('%Y', published_datetime) BETWEEN "2018"

 AND "2021"

GROUP BY

 channel_id

ORDER BY

 channel_id ASC;

Output Table:

channel_id
    351
    353
    364
    365
    377

But,

How can I Get all the channel_ids that uploaded at least 20 videos in "AI/ML", "Cyber Security", "Data Science" or "Robotics" technologies between 2018 and 2021.

Example: If a channel publishes 5 videos in AI/ML, 10 videos in Cyber Security and 5 videos in Data Science, consider the channel

the table data is very huge so, I cant send the complete table data.

please help me.

Find the sum of durations of the videos published by each channel in hours.

Note:

• The output must contain the duration as number of hours.
• Sort the output in the descending order of the no_of_hours

Table: Video

video_id	name	duration_in_secs	published_datetime	no_of_views	   channelid
1002   Victoria Beckham
        Gives Strangers 
        Fashion Advice      836	         2021-01-19 20:12	    75609	      353
       for $2 in Central 
       Park | Vanity Fair	
	
1007	DIY - Simon's Cat  
       |NEW BLACK & WHITE!	 1365	     2012-09-07 11:32	    106271	      355

1008	You, but in emojis.
        (YIAY #375)	         3874	     2021-01-19 20:12	    16469	      352

1009	100 People Hold 
       Their Breath for as   2885	     2015-05-17 19:32	    272102	      354
       Long as They Can	     

1010	Luke Bryan - Hooked
          On It (Audio)	     2106	     2016-02-10 12:32	    184471	      366

1011	The perfect ice - 
          Ice boats on       2549	     2020-07-10 15:32	    108047	      352
           Lake Geneva	

1012	5 Days Of Wearing 
        DIY Makeup | Try     3172	     2018-11-05 08:32	    178623	      358
       Living With Lucie 
        | Refinery29	

1013	Idiot's Guide to 
      Japanese Squat Toilets  709	     2009-08-05 11:32	    44293	      356

1019	Vostok Brompton Beach 
                Ride	        2022	 2016-04-05 19:00	    204704	      367

1020	SHOPPING FOR NEW FISH!! 3496	 2021-01-19 20:12	    294429	      359

1021	Paramore: Fake Happy 
           [OFFICIAL VIDEO]	    1397	 2015-07-05 19:00	    245138	      368

1022	Howard Stern: George 
      Takei Talks About Harvey 
        Weinstein and Sexually  776	     2021-01-19 20:12	    35875	      360
                Assault	

1023	Tony Hawk Answers 
      Skateboarding Questions   4476	 2017-02-17 19:32	    143404	      354
           From Twitter |
        Tech Support | WIRED	

1024	Kimbra - Top of the 
        World (Official Music   3243	 2015-01-05 19:00	    220673	      368
               Video)	

1025	Aly Raisman On Dr. 
      Larry Nassar’s Medical 
      Treatment: I Didn’t Know  2978	 2014-12-17 19:32	     93272	      354
      It Was Abuse | Megyn Kelly 
             TODAY	

1026	When Someone Has A 
     Crush on You | Lilly Singh	 959	 2021-01-19 20:12	     139481	      360

1051	Demi Lovato - Sorry 
   Not Sorry in the Live Lounge	 3929	 2021-01-19 20:12	     265864	      365

Expected Output Format

  channel_id	no_of_hours
      ...	       ...

Get all the channel_ids that uploaded at least 5 videos in "AI/ML", "Cyber Security", "Data Science" or "Robotics" technologies between 2018 and 2021.

Example: If a channel publishes 2 videos in AI/ML, 1 videos in Cyber Security and 2 videos in Data Science, consider the channel.

Note:

• Consider all the videos that have any of the technologies mentioned above in their name
• Sort the output in the ascending order of channel_id.

Table: Video

video_id	name	duration_in_secs	published_datetime	no_of_views	   channelid
1002   Victoria Beckham
        Gives Strangers 
        Fashion Advice      836	         2021-01-19 20:12	    75609	      353
       for $2 in Central 
       Park | Vanity Fair	
	
1007	DIY - Simon's Cat  
       |NEW BLACK & WHITE!	 1365	     2012-09-07 11:32	    106271	      355

1008	You, but in emojis.
        (YIAY #375)	         3874	     2021-01-19 20:12	    16469	      352

1009	100 People Hold 
       Their Breath for as   2885	     2015-05-17 19:32	    272102	      354
       Long as They Can	     

1010	Luke Bryan - Hooked
          On It (Audio)	     2106	     2016-02-10 12:32	    184471	      366

1011	The perfect ice - 
          Ice boats on       2549	     2020-07-10 15:32	    108047	      352
           Lake Geneva	

1012	5 Days Of Wearing 
        DIY Makeup | Try     3172	     2018-11-05 08:32	    178623	      358
       Living With Lucie 
        | Refinery29	

1013	Idiot's Guide to 
      Japanese Squat Toilets  709	     2009-08-05 11:32	    44293	      356

1019	Vostok Brompton Beach 
                Ride	        2022	 2016-04-05 19:00	    204704	      367

1020	SHOPPING FOR NEW FISH!! 3496	 2021-01-19 20:12	    294429	      359

1021	Paramore: Fake Happy 
           [OFFICIAL VIDEO]	    1397	 2015-07-05 19:00	    245138	      368

1022	Howard Stern: George 
      Takei Talks About Harvey 
        Weinstein and Sexually  776	     2021-01-19 20:12	    35875	      360
                Assault	

1023	Tony Hawk Answers 
      Skateboarding Questions   4476	 2017-02-17 19:32	    143404	      354
           From Twitter |
        Tech Support | WIRED	

1024	Kimbra - Top of the 
        World (Official Music   3243	 2015-01-05 19:00	    220673	      368
               Video)	

1025	Aly Raisman On Dr. 
      Larry Nassar’s Medical 
      Treatment: I Didn’t Know  2978	 2014-12-17 19:32	     93272	      354
      It Was Abuse | Megyn Kelly 
             TODAY	

1026	When Someone Has A 
     Crush on You | Lilly Singh	 959	 2021-01-19 20:12	     139481	      360

1051	Demi Lovato - Sorry 
   Not Sorry in the Live Lounge	 3929	 2021-01-19 20:12	     265864	      365

Expected Output Format

 channel_id
     ...