List of top Computer Science Questions

Identify the correct IP address from the options given:

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 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

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}

A __________ value is specified for the column, if no value is provided.

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:

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

Given two relations:

Employee with structure as (ID, Name, Address, Phone, Deptno)
Department with structure as (Deptno, Dname)
__________ is used to represent the relationship between two relations Employee and Department.

Write a program in C++ to accept a number then display how many digits it contains and the sum of its digits.

Write a program in C++ to generate and display prime number from 1 to 51.

Explain stack.

Describe the types of Data structure.

What is topology ?

Differentiate between stack and queue data structure.

Define DML.

What is a primary key ?

Explain the different types of SQL commands.

What is the difference between delete and truncate commands ?

What is array ?

Explain the rule of association in Boolean Algebra.

What is abstract class ?