List of top Computer Science Questions

Match List-I with List-II:

List-I	List-II
(A) Cyber Appellate Tribunal	(III) Resolves disputes arising from cyber crime.
(B) Environmental Protection Act 1986	(I) Punishes people causing pollution.
(C) Indian Information Technology Act 2000	(IV) Provides guidelines on storage, processing and transmission of sensitive data.
(D) Central Pollution Control Board	(II) Provides guidelines for proper handling and disposal of e-waste.

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)

Sequence the given process for checking whether a string is a palindrome or not, using a deque:
(A) Load the string into the deque.
(B) Continuously remove characters from both ends.
(C) Compare the characters.
(D) Determine if the string is a palindrome based on the comparisons.

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

Violation of intellectual property right may happen due to:
(A) Copyright Infringement
(B) Patent
(C) Trademark Infringement
(D) Plagiarism

Identify the correct code to read data from the file \texttt{notes.dat} in a binary file:

Matplotlib library can be installed using pip command. Identify the correct syntax from the following options.

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

Match List-I with List-II.

List-I	List-II
(A) Primary key	(III) Attribute used to uniquely identify a tuple.
(B) Degree	(I) Total number of attributes in a table.
(C) Foreign key	(II) Attribute used to relate two tables.
(D) Constraint	(IV) A restriction on the type of data that can be inserted in a column.

Identify type of data being collected/generated in the scenario of recording a video:

In SQL table, the set of values which a column can take in each row is called __________.

Identify the incorrect statement in the context of measures of variability:

The HTTPS based websites require:

Data Transfer Rate 1 Gbps is equal to: (A) 1024 Mbps
(B) 1024 Kbps
(C) $2^{30}$ bps
(D) $2^{20}$ bps

Evaluate the postfix expression: \[ 24 \; 5 \; 7 \; \; 5 \; / \; + \]

Bandwidth of a channel is:

Match List-I with List-II. \

List-I	List-II
(A) Modem	(II) Modulator-Demodulator
(B) RJ45	(I) An eight pin connector used with Ethernet cables for networking.
(C) Network interface unit	(IV) Ethernet card
(D) ISP	(III) An organization that provides services for accessing the internet.

Single row functions are also known as ________ functions.

Ms Ritika wants to delete the table 'sports' permanently. Help her in selecting the correct SQL command from the following.

Which of the following are text functions? (A) MID()
(B) INSTR()
(C) SUBSTR()
(D) LENGTH()

For binary search, the list is in ascending order and the key is present in the list. If the middle element is less than the key, it means:

State the output of the following query: \[ \text{SELECT LENGTH(MID('INFORMATICS PRACTICES',5,-5));} \]

Match List-I with List-II:

List-I	List-II
(A) group by	(III) having
(B) mid()	(IV) text function
(C) count()	(II) aggregate function
(D) mod()	(I) math function