myStr = "MISSISSIPPI"
print(myStr[:4] + "#" + myStr[-5:])
MISSI#SIPPI
MISS#SIPPI
MISS#IPPIS
MISSI#IPPIS
myStr[:4] extracts the first 4 characters, which are "MISS".myStr[-5:] extracts the last 5 characters, which are "SIPPI"."#" in between, resulting in "MISS#SIPPI".\[ \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} \]
\[ \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} \]
The SELECT statement when combined with \(\_\_\_\_\_\_\) clause, returns records without repetition.
In SQL, the aggregate function which will display the cardinality of the table is \(\_\_\_\_\_\).
Alexia Limited invited applications for issuing 1,00,000 equity shares of ₹ 10 each at premium of ₹ 10 per share.
The amount was payable as follows:
Applications were received for 1,50,000 equity shares and allotment was made to the applicants as follows:
Category A: Applicants for 90,000 shares were allotted 70,000 shares.
Category B: Applicants for 60,000 shares were allotted 30,000 shares.
Excess money received on application was adjusted towards allotment and first and final call.
Shekhar, who had applied for 1200 shares failed to pay the first and final call. Shekhar belonged to category B.
Pass necessary journal entries for the above transactions in the books of Alexia Limited. Open calls in arrears and calls in advance account, wherever necessary.