List of top Computer Science Questions asked in CUET (UG)

What is the best way to verify the legitimacy of an email claiming to be from your bank?
To show a forecast of a stock performance throughout the year, which plot is most suitable?
How can you display percentage values inside a pie chart in Matplotlib?
Which of the following is a benefit of Free and Open Source Software (FOSS)?
In the context of Project based learning, the following question has to be solved-
What is the total population, total male population and total female population aged 10 to 24 in India?
Arrange the following solution steps to accomplish the same:
A. Read CSV file and check the shape of the DataFrame.
B. Identify the columns and the number of rows that you wants to use for plotting.
C. Create a new DataFrame containing the filtered data and Group data as per the requirement.
D. Plot data for the DataFrame.
Arrange the following steps in working of a dynamic web page:
A. HTTP response
B. An Application program handles HTTP requests
C. The program executes and produces HTML output
D. HTTP request
What does the df.isnull().sum() function do in Pandas?
For the DataFrame (df) given below, which of the following are correct ways to access column 'Texas'?
A. df['Texas']
B. df('Texas')
C. df.Texas
D. df.['Texas']
What will be the output of the following code?
>>> seriesCapCntry = pd.Series(['NewDelhi', 'WashingtonDC', 'London', 'Paris'], index=['India', 'USA', 'UK', 'France'])
>>> seriesCapCntry[1:3]
Which of the following operation combines tuples from two relations resulting in all pairs of rows from the two input relations, regardless of whether or not they have the same values on common attributes?
Which of the following describes plagiarism?
With reference to the parameter header of pd.read_csv(), which of the parameter values allow the column names to be inferred from the first line of csv file?
A. header = 1
B. header = 0
C. header = True
D. header = False
Match the LIST-I with LIST-II
Which SQL query correctly filters out groups with a total sales amount greater than 10,000?
__________ gives the transpose of a DataFrame.
Recent cyber crime that include locking a person out of his/her own device until a payment is made can be termed as __________.
__________ is the global network of computing devices.
Which function is used to get the quartiles from a dataframe 'df'?
Which function is used to sort a Pandas DataFrame in descending order based on a column?
Arrange the steps required to read data from a MySQL database to a DataFrame:
A. pip install pymysql
B. pip install sqlalchemy
C. pandas.read_sql_query(query, sql_conn)
D. engine=create_engine('driver://username:password@host/name_of_database', index=false)
In case of plots in Python, Marker "3" describes __________.
How do you select rows from a DataFrame 'df' where the 'Salary' column is greater than 50000?
Arrange the following steps of project based learning:
A. Guidance and Monitoring
B. Defining a plan
C. Identification of project
D. Outcome of project
Which property can be used to fill to each hist with pattern in histogram?
What does a left-skewed histogram indicate?