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

Identify the correct python statement to open a text file \texttt{"data.txt"} in both read and write mode.

Identify the correct IP address from the options given:

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

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.

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.