List of top Computer Science Questions on Types of Functions

Differentiate between 'w' and 'a' file modes in Python.

Consider the tables Admin and Transport given below:
Table: Admin

\[ \begin{array}{|c|c|c|c|} \hline \textbf{S\_id} & \textbf{S\_name} & \textbf{Address} & \textbf{S\_type} \\ \hline S001 & Sandhya & Rohini & Day Boarder \\ S002 & Vedanshi & Rohtak & Day Scholar \\ S003 & Vibhu & Raj Nagar & NULL \\ S004 & Atharva & Rampur & Day Boarder \\ \hline \end{array} \]


Table: Transport

\[ \begin{array}{|c|c|c|} \hline \textbf{S\_id} & \textbf{Bus\_no} & \textbf{Stop\_name} \\ \hline S002 & TSS10 & Sarai Kale Khan \\ S004 & TSS12 & Sainik Vihar \\ S005 & TSS10 & Kamla Nagar \\ \hline \end{array} \]

Write SQL queries for the following:
  1. Display the student name and their stop name from the tables Admin and Transport.
  2. Display the number of students whose S_type is not known.
  3. Display all details of the students whose name starts with 'V'.
  4. Display student ID and address in alphabetical order of student name, from the table Admin.

Write a function, c_words(), in Python that separately counts and displays the number of uppercase and lowercase alphabets in a text file, Words.txt

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

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

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: 
 

Which of the following is not a DDL command in SQL?
Which of the following options is the correct unit of measurement for network bandwidth?
Consider the statements given below and then choose the correct output from the given options: 
myStr = "MISSISSIPPI"
print(myStr[:4] + "#" + myStr[-5:])

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

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

Consider the function header given below and identify the correct call statement(s) to call the below function.
def fun(x, y=10, z=15);
A. fun(30)
B. fun(30, 40)
C. fun()
D. fun(10, 20, 30)
E. fun(10, 20, 30, 40)
Choose the correct answer from the options given below :
All aggregate functions ignore Nulls except for________ function.
The max() function of Pandas descriptive statistics axis = 1 gives,