List of top Computer Science Questions

Given table 'StudAtt' with structure as (Rno, Attdate, Attendance). Identify the suitable command to add a primary key to the table after creation.
Note: We want to make both Rno and Attdate columns as primary key.

The SELECT command when combined with DISTINCT clause is used to:

____________________________________ is used to search for a specific pattern in a column.

Match List-I with List-II:

List-I (Aggregate function)	List-II (Description)
(A) count(marks)	(III) Count all non null values of marks column
(B) count()	(I) Count all rows
(C) avg(marks)	(II) Finding average of non null values of marks
(D) sum(marks)	(IV) Finding sum of all marks

While transferring the data from a DataFrame to a CSV file, if we do not want the column names to be saved to the file on disk, the parameter to be used in \texttt{to__csv()} is __________.

Dataframe.quantile() is used to get the quartiles. The second quantile is known as ..............

Given Relation: \texttt{STUDENT} \begin{center} \begin{tabular}{|c|c|c|} \hline SNO & SNAME & MARKS
\hline 1 & Amit & 20
2 & Karuna & 40
3 & Kavita & NULL
4 & Anuj & 30
\hline \end{tabular} \end{center} Find the value of: \begin{verbatim} SELECT AVG(MARKS) FROM STUDENT; \end{verbatim}

The intellectual property right that is granted for inventions is ____________.

The plot function of pandas matplotlib uses 'kind' argument which can accept a string indicating the type of graph to be plotted. Which of the following are valid plots?

Match List-I with List-II.

List-I	List-II
(A) SUBSTR()	(II) To extract a substring from a string.
(B) TRIM()	(IV) To remove spaces from both sides of the string.
(C) INSTR()	(I) To find the position of a substring in a string.
(D) LEFT()	(III) To extract characters from the left side of the string.

____________ in matplotlib also known as correlation plot, because they show how two variables are related.

After establishing the connection to fetch the data from the table of a database in SQL into a DataFrame, which of the following function will be used?
(A) pandas.read__sql__query()
(B) pandas.read__sql__table()
(C) pandas.read__sql__query__table()
(D) pandas.read__sql()

Which of the following is the correct command to display the top 2 records of Series \texttt{tail}?

Match List-I with List-II:

List-I	List-II
(A) Static web page	(II) A web page whose content is fixed.
(B) Home page	(IV) First page of website.
(C) Dynamic web page	(I) A web page whose content keeps changing.
(D) Web server	(III) Delivers the contents to web browser.

Choose the correct answer from the options given below:

The process of changing the structure of a DataFrame using function pivot() is known as .............

__________ operation is used to get the common tuples from two relations.

Identify the relational algebra operation denoted by: \[ \text{Course X Student;} \] where 'Course' and 'Student' are two relations and X is an operation.

Sequence the steps to append data to an existing file and then read the entire file:
(A) Open the file in a+ mode.
(B) Use the read() method to output the contents.
(C) Use the write() or writelines() method to append data.
(D) Seek to the beginning of the file.

Arrange the following Python code segments in order with respect to exception handling: (A) except ZeroDivisionError:
\hspace{0.5cm} print("Zero denominator not allowed")
(B) finally:
\hspace{0.5cm} print("Over and Out")
(C) try:
\hspace{0.5cm} n = 50
\hspace{0.5cm} d = int(input("enter denominator"))
\hspace{0.5cm} q = n/d
\hspace{0.5cm} print("division performed")
(D) else:
\hspace{0.5cm} print("Result=", q)

__________ is the process of transforming data or an object in memory (RAM) to a stream of bytes called byte streams.