List of top Computer Science Questions

The SELECT statement when combined with \(\_\_\_\_\_\_\) clause, returns records without repetition.

What will be the output of the following statement:
print(16 * 5 / 4 * 2 / 5 - 8)

The slicing operations in the given code work as follows:

myStr[:4] extracts the first 4 characters, which are "MISS".
myStr[-5:] extracts the last 5 characters, which are "SIPPI".
These two substrings are concatenated with a "#" in between, resulting in "MISS#SIPPI".

In SQL, the aggregate function which will display the cardinality of the table is \(\_\_\_\_\_\).

Which protocol out of the following is used to send and receive emails over a computer network?

Identify the invalid Python statement from the following:

Question: Select the correct output of the following code:


event = "G20 Presidency@2023"
L = event.split(' ')
print(L[::-2])

Consider the statements given below and then choose the correct output from the given options:

myStr = "MISSISSIPPI"
print(myStr[:4] + "#" + myStr[-5:])

Identify the statement from the following which will raise an error:

Which of the following options is the correct unit of measurement for network bandwidth?

Observe the given Python code carefully:

a = 20
def convert(a):
    b = 20
    a = a + b
convert(10)
print(a)

Select the correct output from the given options:

State whether the following statement is True or False:
While handling exceptions in Python, name of the exception has to be compulsorily added with except clause.

Which of the following is not a DDL command in SQL?

Fill in the blank:
\(\_\_\_\_\_\_\_\_\) is a set of rules that needs to be followed by the communicating parties in order to have a successful and reliable data communication over a network.

Consider the following Python statement:
F = open('CONTENT.TXT')
Which of the following is an invalid statement in Python?

Assertion (A): CSV file is a human-readable text file where each line has a number of fields, separated by a comma or some other delimiter.
Reason (R): writerow() method is used to write a single row in a CSV file.
Mark the correct choice:

Assertion (A): The expression "HELLO".sort() in Python will give an error.
Reason (R): sort() does not exist as a method/function for strings in Python.
Mark the correct choice:

Expand the following terms:
XML, PPP Give one difference between circuit switching and packet switching.

Define the term web hosting.
Name any two web browsers.

The code given below accepts five numbers and displays whether they are even or odd:
Observe the following code carefully and rewrite it after removing all syntax and logical errors.
Underline all the corrections made.

Write a user-defined function in Python named Puzzle(W, N) which takes the argument W as an English word and N as an integer and returns the string where every Nth alphabet of the word W is replaced with an underscore ("_").

Example: If W contains the word "TELEVISION" and N is 3, then the function should return the string "TE_EV_SI_N". Likewise, for the word "TELEVISION" if N is 4, the function should return "TEL_VIS_ON".

Write the output displayed on execution of the following Python code:

LS = ["HIMALAYA", "NILGIRI", "ALASKA", "ALPS"]
D = {}
for S in LS:
    if len(S) % 4 == 0:
        D[S] = len(S)
for K in D:
    print(K, D[K], sep = "#")

A tuple named subject stores the names of different subjects. Write the Python commands to convert the given tuple to a list and thereafter delete the last element of the list.

Ms. Veda created a table named Sports in a MySQL database, containing columns Game_id, P_Age, and G_name.
After creating the table, she realized that the attribute Category has to be added.
Help her to write a command to add the Category column.
Thereafter, write the command to insert the following record in the table: Game_id: G42 P\_Age: Above 18 G_name: Chess Category: Senior

Write the SQL commands to perform the following tasks:
(i) View the list of tables in the database Exam
(ii) View the structure of the table Term1