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

Match List-I with List-II:

List-I	List-II
(A) f.seek(-10,1)	(I) From beginning of file, move 10 bytes forward
(B) f.seek(10,1)	(II) From current position, move 10 bytes backward
(C) f.seek(10)	(III) From current position, move 10 bytes forward
(D) f.seek(-10,2)	(IV) From end of the file, move 10 bytes backward

SQL applies conditions on the groups through ________ clause after groups have been formed?

What will be the result after pass 2 using Bubble Sort, if we are sorting elements in ascending order?
Initial List: 7 19 18 9 23 51 12 54 73

Amit wants to be familiar with SQL. One of his friends Anand suggests him to execute the following SQL commands:
(A) Create Table Student
(B) Use Database DB
(C) Select * from Student
(D) Insert into Student
In which order Amit needs to run the above commands?

In a ________ topology, if there are n devices in a network, each device has n-1 ports for cables.

140.168.220.200 is a 32-bit binary number represented as four decimal values, each 8 bits, in the range 0 to 255 separated by decimal points. What is this number called?

What is the purpose of a Domain Name System (DNS) Server in networking?

Match List-I with List-II:

List-I (Device)	List-II (Use)
(A) RJ45 Connector	(I) relay frames between two originally separate segments that follow same protocols.
(B) Bridge	(II) amplifies a signal that is transmitted across the network so that the signal is received same as it is sent.
(C) Gateway	(III) establishes an intelligent connection between a local area network and external networks with completely different structures.
(D) Repeater	(IV) plug-in device primarily used for connecting LANs particularly Ethernet.

Which of the following statement(s) is/are TRUE in respect of Media Access Control (MAC) Address?
Options:
(A) It can be changed if a node is removed from one network and connected to another network.
(B) Each MAC address is a 12-digit hexadecimal number.
(C) It is a unique value associated with a network adapter called NIC.
(D) It is provided by the Internet Service Provider to locate computers connected to the internet.
Choose the correct answer from the options given below:

Which SQL expression calculates the square root of 16?

What is the result of the following arithmetic operation in SQL: SELECT 5 + NULL AS RESULT?

Which of the following is correct syntax for inserting foreign key constraint in a relation?

Consider the following SQL functions:
(A) CURDATE()
(B) CURRENT DATE()
(C) CURRENT DATE
(D) TODAY()

An alternate key is ________.

The primary key is chosen from ________.

A relation in a relational database is also known as:

A domain in a relational database refers to:

What is the primary difference between a database and a file system?

To find the difference between maximum and minimum stock prices for a company over a week, which statistical technique is used?

_________ is the positive square root of the average of squared differences of each value from the mean.

________ are unorganized facts that can be processed to generate meaningful information called?

__________ compares neighboring elements only and swaps them when necessary?