- Differentiate between HAVING and GROUP BY clause.
- Explain sub-queries with an example (definition and single row).
- Explain JOIN and its types.
- Explain DDL commands in detail with proper examples.
- Explain DML commands in detail with proper examples.
- WAP to accept a string from user and calculate length of given string.
- WAP to accept a string and a character and print the number of times that character has occurred in a string.
- WAP to accept a string from user and print count as well as all the vowel characters from it.
- WAP to check whether a string is a palindrome or not.
- WAP To find out number of repeated characters in a string.
- WAP to demonstrate user defined exceptions.
This is a marked e-commerce assignment that is due Friday. It is possible to submit this electronically or on paper but it will carry actual internal marks and is due Friday.
The requirements for this assignment are:
Create an e-commerce business model (i.e. a concept for an e-commerce website). The assignment should highlight the following:
- What problem does it solve?
- What are the key benefits?
- What are the key components?
- What are the key challenges?
This is a VB.NET assignment by Madhavendra Sir to be submitted in a Journal, by the 26th of August.
- Take two numbers from a user and print the maximum and minimum of those numbers.
- Take a number from a user and check if it’s odd or even.
- Add a number to itself using the assignment operator.
- Where a = 12, b = 10, use the
Andoperator and find out the result.
- Print numbers from 15 to 30 using
- Print numbers from 10 to 30 using the
- Print all odd numbers between 1 and 20 using
- Demonstrate each loop.
- Print the multiplication table of 5.
- Find out factorial of a number.
- Calculate salary using a
- Swap two numbers (a = 10, b = 20) using a
- Swap two numbers without using a third (temp) variable.
- Find out the volume of a box where length = 10, breadth = 15, height = 25.
- Accept a number and display if it is prime or not.
- Accept a number from the user. Create 3 different methods to perform the following operations:
- Check whether number is an Armstrong Number.
- Factorial of the Number.
- Sum of the digits of a number.
1. ABCDE ABCD ABC AB A 2. 12345 1234 123 12 1
55555 4444 333 22 1
- Login with the use of a comparison operator and a logical operator.
- Concatenate a string with a number.
- Accept a password from a user a maximum of 3 times. After 3 attempts, the user must be locked.
Operating Systems (Due Date: 2 March)
Explain the structure of process management. 
Explain DOS Structure. What are the system files in DOS? How is memory
management done in DOS? 
Explain job scheduling in detail.
Explain process scheduling in detail. 
Explain three major techniques for device management. 
What is multitasking, Explain the two types of multitasking. 
Write a note on Windows XP. Explain the structure and features.
Explain the hardware requirements. 
Explain the components of a Linux system. Explain some basic commands.
Explain the uses of Linux (especially commercial uses). 
SSAD (Due Date: 4 March)
Draw and discuss Spiral model of system development. 
Explain various types of information required at different levels of
management in an organization. 
Explain “Multi-functional role of a system analyst”. 
Explain in detail, the prototype model with the help of a diagram. 
Explain “Multi-faced role of a system analyst”. 
Draw and explain the RAD model. 
What is a system? Explain the characteristics of a system. Explain the
elements of a system. .
Explain all the phases of the SDLC.