1 - Cyber Security (Maleware and Virus)

 

    

Malware

Malware is a catch-all term for any type of malicious software, regardless of how it works, its intent, or how it’s distributed. A virus is a specific type of malware that self-replicates by inserting its code into other programs. Viruses are a subcategory of malware.  Malware includes computer viruses, worms, Trojan horses, ransomware, spyware and other malicious programs.

 

List of malwares which are generally categorized as computer viruses:

1.       Virus

2.       Worms

3.       Trojan horse

4.       Spam virus

5.       Spyware

6.       Zombies

7.       Ransomware

8.       Cryptojackers

Computer virus

 

VIRUS: Vital Information Resources Under Seize

A computer virus is a computer program or a piece of code that is loaded onto your computer without your knowledge and run against your consent. Virus has a property to replicate itself and spread itself from one computer to another computer. It can affect the data files, boot sector of hard drive etc. when its replication succeeds. The affected area is said infected.

The majority of viruses target systems running Microsoft window. To counter with viruses, programmers created anti-virus programs.

Viruses are human made programs generally write to access private information, corrupt data, to display political and humorous messages on the user's screen.

 

Types of Computer Viruses

 

1.       Boot Sector Viruses

2.       Multipartite Viruses

3.       Stealth Viruses

4.       Macro Viruses

5.       Polymorphic Viruses

6.       Activex Viruses

7.       Browser Hijacker

8.       Resident Viruses

9.       Non-Resident Virus 

10.   File Infector Viruses

 

 

Difference between Virus and Malware:

 

Virus	Malware
Vital Information Resources Under Seize	Malicious Software
A Virus is a malicious executable code attached to another executable file which can be harmless or can modify or delete data.	Malware is a program designed to gain access to computer systems, normally for the benefit of some third party, without the user’s permission.
Resident and Non -resident viruses are two types of Virus.	Malware includes computer viruses, worms, Trojan horses, ransomware, spyware and other malicious programs.
Antivirus software are used for protection against viruses.	Antimalware software are used for protection against malware.
Virus is a type of Malware.	Malware contains several programs; virus is one of them.

 

 

Boot sector viruses

A boot sector virus is a type of virus that infects the boot sector of floppy disks or the Master Boot Record (MBR) of hard disks. The infected code runs when the system is booted from an infected disk, but once loaded it will infect other floppy disks when accessed in the infected computer. While boot sector viruses infect at a BIOS level, they use DOS commands to spread to other floppy disks. 

 

Multipartite computer virus

A multipartite also known as hybrid virus is a computer virus that's able to attack both the boot sector and executable files of an infected computer. Ghostball was the first multipartite virus discovered. The virus was discovered in October 1989, by Fridrik Skulason. Examples of multipartite viruses include Flip and Invader. A hybrid virus (sometimes called a multi-part or multipartite virus) is one that combines characteristics of more than one type to infect both program files and system sectors. 

 

 

Stealth viruses

A stealth virus is a type of virus malware that contains sophisticated means of avoiding detection by antivirus software. After it manages to get into the now-infected machine a stealth virus hides itself by continually renaming and moving itself around the disc. A stealth virus is complex malware that hides itself after infecting a computer.

Macro Virus

A macro virus is a computer virus written in the same macro language used for software programs, including Microsoft Excel or word processors such as Microsoft Word. When a macro virus infects a software application, it causes a sequence of actions to begin automatically when the application is opened. An example of a macro virus is the Melissa virus which appeared in March 1999. When a user opens a Microsoft Word document containing the Melissa virus, their computer becomes infected. 

Polymorphic viruses

This type of "shape shifting" virus produces malicious code that replicates itself endlessly and repeatedly changes its characteristics

The code changes itself each time it runs, but the function of the code will not change at all. For example, 1+3 and 6-2 both achieve the same result while using different values and operations. 

The first known polymorphic virus was written by Mark Washburn. The virus, called 1260, was written in 1990. 

ActiveX Viruses

ActiveX is a virus built into your browser. If you have it enabled, it allows any web page you look at to take over complete control of your computer and extract any information or insert any instructions the web page maintainer wants.

 

Browser Hijacker 

A browser hijacker is a malware program that modifies web browser settings without the user's permission and redirects the user to websites the user had not intended to visit.

Resident Virus 

A resident virus is a computer virus that stores itself within memory, allowing it to infect other files even when the originally infected program is no longer running. Being stored in memory allows the virus to spread easier because it has more access to other parts of the computer.

Non-Resident Virus 

A non-resident virus is a computer virus that does not store or execute itself from the computer memory. Executable viruses are an example of a non-resident virus.

 

File Infector Virus

A file infector virus is a type of virus that typically attaches to executable code, such as computer games and word processors. Once the virus has infected a file, it can spread to other programs, and even into other networks that utilize the infected files and programs.

 

Worms

 A computer worm is a type of malware that spreads copies of itself from computer to computer. A worm can replicate itself without any human interaction, and it does not need to attach itself to a software program in order to cause damage. It is a standalone malware computer program that replicates itself

Trojan Horse 

A Trojan horse (or simply trojan) is any malware which misleads users of its true intent. It is a type of malicious code or software that looks legitimate but can take control of your computer.

 

Difference between Worms and Virus :

 

WORMS	VIRUS	Trojan Horse
A Worm is a form of malware that replicates itself and can spread to different computers via Network.	A Virus is a malicious executable code attached to another executable file which can be harmless or can modify or delete data.	Trojan Horse rather than replicate capture some important information about a computer system or a computer network.
The main objective of worms to eat the system resources.	The main objective of virus is to modify the information.	The main objective of Trojan horse to steal the information.
It doesn’t need a host to replicate from one computer to another.	It require host is needed for spreading.	Trojan horse does not replicate itself.
It is less harmful as compared.	It is more harmful.	It is more harmful.
Worms can be detected and removed by the Antivirus and firewall.	Antivirus software are used for protection against viruses.	Trojan can be detected and removed by the Antivirus and firewall.
Worms can be controlled by remote.	Virus can’t be controlled by remote.	Trojan horse can also be controlled by remote.
Worms are executed via weaknesses in system.	Viruses are executed via executable files.	Trojan horse executes through a program and interprets as utility software.
Morris Worm, Storm Worm and SQL Slammer,  ILOVEYOU, Michelangelo, and MSBlast are some of the examples of worms.	Resident and Non -resident viruses are two types of Virus.	A friend might have sent an email with an attachment. The user will expect that it's something important and download it. They'll open the file and there the problem starts.
It does not needs human action to replicate.	It needs human action to replicate.	It needs human action to replicate.
Its spreading speed is faster.	Its spreading speed is slower as compared.	Spreading rate of Trojan horse is slow in comparison of both virus and worms.

 

 

 

1 - Data Visualization using matplotlib in Python

 

Data Visualization using matplotlib in Python

 

Data Visualization:

                Data Visualization refers to the graphical or visual representation of information and data using visual elements like charts, graphs, maps etc.

 

PyPlot:

                PyPlot is a collection of methods within matplotlib library of Python, Which allow user to create 2D Plots easily. Matplotlib is a Python library.

To install matplotlib use the following command.

Pip install matplotlib

 

Type of basic charts of PyPlot

1.       Line Chart: A line chart is created using plot() method.

2.       Bar Chart: A vertical bar chart is created using bar() method and horizontal bar chart using barh() method.

3.       Histogram Plot: A histogram is created using hist() method

4.       Pie Chart: A pie chart is created using pie() method.

5.       Scatter Plot: A scatter plot is created using scatter() method.

 

import matplotlib.pyplot as plt

x=[1,2,3,4,5]

y=[2,3,4,5,6]

plt.plot(x,y)        #draw a line chart

plt.xlabel(“x axis values”)

plt.ylabel(“y axis values”)

plt.legend()        #show the legend

plt.show()           #show the chart/plot as per given specification

 

 

import matplotlib.pyplot as plt

x=[1,2,3,4,5]

y=[1,2,3,4,5]

plt.plot(x,y)

plt.show()

 

 

 

import matplotlib.pyplot as plt

x=["Ram","Raj","Sam","john","Amit"]

y=[30,20,25,40,35]

plt.plot(x,y)

plt.title("Marks Sheet")

plt.xlabel("Student's Name")

plt.ylabel("Marks")

plt.show()

 

 

 

import matplotlib.pyplot as plt

x=[2,3,4,5,6,7]

y=[1,2,3,4,5,6]

plt.plot(x,y)

plt.show()

 

 

import matplotlib.pyplot as plt

x=["VII","VIII","IX","X"]

y=[40,50,35,45]

plt.bar(x,y)

plt.show()

 

Specifying Plot Size and Grid

 

plt.figure(figsize=(width,height))

 

plt.grid(True)

 

Changing Line Color and Style

 

Plt.plot(x,y,color_code)

 

 

Color Code

 

‘r’ red

‘g’ green

‘b’ blue

‘m’ magenta

‘y’ yellow

‘k’ black

‘c’ cyan

‘w’ white

 

 

Change Line Width

 

linewidth=width

plt.plot(x,y,linewidth=2)

 

Line Style

 

linestyle or ls =[‘solid’ | ‘dashed’ | ‘dashdot’ | ‘dotted ]

 

ls=’:’ | ‘-‘  | ‘_ _’ | ‘-‘

 

plt.plot(x,y,linewidth=4,linestyle=’dashed’)

 

 

Assignment - 1

 

1.       WAP to plot a line chart to depict the changing weekly onion prices for four weeks. Give appropriate axes labels.

 

2.       Marks is a list that stores marks of a student in 10 unit tests. Write a program to plot the student’s performance in these 10 unit tests.

 

3.       Ram is doing some research. She has a stored line of pascal’s triangle numbers as ar2 as shown below:

ar2 = [1,7,21,35,21,7,1]

·         He want to plot the sine, cosine, and tangent values for the same array.

·         He wants cyan color for sine line, red color for cosine line and black color for tangent line

·         Tangent line should be dashed.

 

 

Game No. 5 : PING - PONG Menu Based game to select level and paddle color by S P SHARMA CLASSES

 

Game No. 5 : PING - PONG Menu Based game to select level and paddle color by S P SHARMA CLASSES

#PING - PONG Menu Based game to select level and paddle color by Sachin Kumar, 9910707562

#sachinpgt2019@gmail.com

import pygame

import random,sys

 

pygame.init()

clock = pygame.time.Clock()

 

sw = 800

sh = 600

screen = pygame.display.set_mode((sw,sh))

pygame.display.set_caption("PING--PONG BY SACHIN KUMAR")

bg_color = pygame.Color('red')

game_font = pygame.font.Font('freesansbold.ttf', 60)

font1 = pygame.font.SysFont("comicsansms", 45)

p_color="red"

b_color="blue"

level = 1

opponent_speed = 6

 

score_time = None

def c_color(OS1):

    global p_color,b_color

    sw = 800

    sh = 600

 

    ball = pygame.Rect(sw//2 - 15, sh//2 - 15, 30, 30)

    player = pygame.Rect(sw-20, sh//2 - 60, 10, 120)

    opponent = pygame.Rect(10, sh//2 - 60, 10, 120)

 

    bg_color = pygame.Color('yellow')

    running  = True

    while running:

        screen.fill(bg_color)

        for event in pygame.event.get():

            if event.type == pygame.QUIT:

                welcomscreen = False

                pygame.quit()

                sys.exit(0)

     

            if event.type == pygame.KEYDOWN:

                if event.key == pygame.K_SPACE:

                    welcomscreen = False

                    StartGame(OS1)

                if event.key == pygame.K_1:

                    p_color="red"

                    b_color="blue"

     

                elif event.key == pygame.K_2:

                    p_color="black"

                    b_color="red"

     

                elif event.key == pygame.K_3:

                    p_color="blue"

                    b_color="red"

        if p_color=="red":

            pygame.draw.rect(screen, (250,0,0), pygame.Rect(sw//2-190, sh-410, 350, 70), 2)

        elif p_color=="black":

            pygame.draw.rect(screen, (250,0,0), pygame.Rect(sw//2-190, sh-310, 350, 70), 2)

        elif p_color=="blue":

            pygame.draw.rect(screen, (250,0,0), pygame.Rect(sw//2-190, sh-210, 350, 70), 2)

 

        Welcome_message = font1.render("PING PONG BY SACHIN KUMAR", True, (250,0,0))

        screen.blit(Welcome_message, (sw//2 - 320, 20))

     

        Select_level = font1.render("SELECT PADDLE COLOR", True, (250,0,0))

        screen.blit(Select_level, (sw//2 - 230, sh-500))

     

        Easy = game_font.render("RED", True, (250,0,0))

        screen.blit(Easy, (sw//2 - 90, sh-400))

     

        Medium = game_font.render("BLACK", True, (250,0,0))

        screen.blit(Medium, (sw//2-130, sh-300))

     

        Hard = game_font.render("BLUE", True, (250,0,0))

        screen.blit(Hard, (sw//2 - 90, sh-200))

     

        Start_game = font1.render("PRESS SPACE TO START", True, (250,0,0))

        screen.blit(Start_game, (sw//2-260, sh-100))

        clock.tick(30)

        pygame.display.update()

def StartGame(OS):

    global score_time

    sw = 800

    sh = 600

 

    ball = pygame.Rect(sw//2 - 15, sh//2 - 15, 30, 30)

    player = pygame.Rect(sw-20, sh//2 - 60, 10, 120)

    opponent = pygame.Rect(10, sh//2 - 60, 10, 120)

 

    bg_color = pygame.Color('yellow')

 

    ball_speed_x = 6*random.choice((-1,1))

    ball_speed_y = 6*random.choice((-1,1))

 

    player_speed = 0

    opponent_speed = OS

 

    player_score = 0

    opponent_score = 0

 

    game_font = pygame.font.Font('freesansbold.ttf', 32)

 

    score_time = None

    def ball_restart():

        global score_time

        ball.center = (sw//2 + 7, sh//2)

        #ball.x = sw//2 - 15

        #ball.y = sh//2 - 15

        current_time = pygame.time.get_ticks()

        if current_time - score_time <= 2000:

            ball_speed_x = 0

            ball_speed_y = 0

 

        if current_time - score_time > 2000:

            ball_speed_x = 6*random.choice((-1,1))

            ball_speed_y = 6*random.choice((-1,1))

            score_time = None

 

    running  = True

    while running:

        screen.fill(bg_color)

        for event in pygame.event.get():

            if event.type == pygame.QUIT:

                running = False

                pygame.quit()

                sys.exit(0)

 

            if event.type == pygame.KEYDOWN:

                if event.key == pygame.K_UP: player_speed -= 7

                if event.key == pygame.K_DOWN: player_speed += 7

 

            if event.type == pygame.KEYUP:

                if event.key == pygame.K_UP: player_speed += 7

                if event.key == pygame.K_DOWN: player_speed -= 7

        

 

        #SCORE

        if ball.left <= 0:

            score_time = pygame.time.get_ticks()

            player_score += 1

            ball_restart()

 

        if ball.right >= sw:

            score_time = pygame.time.get_ticks()

            opponent_score += 1

            ball_restart()

 

        if score_time:

            ball_restart()

 

        #COLLISION

        if ball.colliderect(player) or ball.colliderect(opponent):

            ball_speed_x *= -1

 

        #BALL MOVEMENT

        ball.x += ball_speed_x

        ball.y += ball_speed_y

 

        if ball.top <= 0 or ball.bottom >= sh:

            ball_speed_y *= -1

        

        if ball.left <= 0 or ball.right >= sw:

            ball_speed_x *= -1

 

        #PLAYER MOVEMENT

        player.y += player_speed

        if player.top <= 0:

            player.top = 0

        if player.bottom >= sh:

            player.bottom = sh

 

        #OPPONENT MOVEMENT

        if opponent.bottom < ball.y:

            opponent.bottom += opponent_speed

        if opponent.top > ball.y:

            opponent.top -= opponent_speed

 

        pygame.draw.rect(screen, p_color, player)

        pygame.draw.rect(screen, p_color, opponent)

        pygame.draw.ellipse(screen, b_color, ball)

        pygame.draw.aaline(screen, (200,200,200), (sw//2,0), (sw//2,sh))

 

        player_text = game_font.render(str(player_score), True, (250,0,0))

        screen.blit(player_text, (sw//2 + 20, sh//2 - 16))

 

        opponent_text = game_font.render(str(opponent_score), True, (250,0,0))

        screen.blit(opponent_text, (sw//2 - 42, sh//2 - 16))

 

        clock.tick(30)

        pygame.display.update()

 

 

welcomscreen = True

while welcomscreen:

    screen.fill(bg_color)

    for event in pygame.event.get():

        if event.type == pygame.QUIT:

            welcomscreen = False

            pygame.quit()

            sys.exit(0)

 

        if event.type == pygame.KEYDOWN:

            if event.key == pygame.K_SPACE:

                welcomscreen = False

                #pygame.quit()

                #sys.exit(0)

                c_color(opponent_speed)

                #StartGame(opponent_speed)

            if event.key == pygame.K_1:

                level = 1

                opponent_speed = 6

 

            elif event.key == pygame.K_2:

                level = 2

                opponent_speed = 10

 

            elif event.key == pygame.K_3:

                level = 3

                opponent_speed = 13

 

    #pygame.draw.rect(screen, (250,0,0), pygame.Rect(sw//2, sh-140, 350, 70), 2)

 

    if level == 1:

        pygame.draw.rect(screen, (0,0,250), pygame.Rect(sw//2-190, sh-410, 350, 70), 2)

    elif level == 2:

        pygame.draw.rect(screen, (0,0,250), pygame.Rect(sw//2-190, sh-310, 350, 70), 2)

    elif level == 3:

        pygame.draw.rect(screen, (0,0,250), pygame.Rect(sw//2-190, sh-210, 350, 70), 2)

 

    

    Welcome_message = font1.render("PING PONG BY SACHIN KUMAR", True, (250,250,250))

    screen.blit(Welcome_message, (sw//2 - 320, 20))

 

    Select_level = game_font.render("SELECT LEVEL", True, (250,250,250))

    screen.blit(Select_level, (sw//2 - 200, sh-500))

 

    Easy = game_font.render("EASY", True, (250,250,250))

    screen.blit(Easy, (sw//2 - 90, sh-400))

 

    Medium = game_font.render("MEDIUM", True, (250,250,250))

    screen.blit(Medium, (sw//2-130, sh-300))

 

    Hard = game_font.render("HARD", True, (250,250,250))

    screen.blit(Hard, (sw//2 - 90, sh-200))

    

    Start_game = font1.render("PRESS SPACE TO SELECT COLOR", True, (250,250,250))

    screen.blit(Start_game, (sw//2-360, sh-100))

 

    clock.tick(30)

    pygame.display.update()

 

VBscript class-12 (part-2 input-box)

 <html>

<body>

<script type="text/VBScript">

a=inputBox("Enter a number")

msgBox a

b=inputBox("Enter a number","Input Box")

msgBox b

c=inputBox("Enter a number","Input Box", 123)

msgBox c

</script>

</body>

</html>

VB script class 12 (part 1 message box)

 <html>

<body>

<script type="text/VBScript">

'MsgBox("Hello from VBScript <br/> Hello from VB")

'MsgBox("Hello from VBScript" & VbLf & "Hello from VB")

's1="ram"

's2="kumar"

'MsgBox(s1 & " " & s2)

'msgBox("1-HelloIndia")

'msgBox "1-HelloIndia"

'msgBox("2-HelloIndia" & vblf & "HelloDelhi")

'msgBox("3-HelloIndia" & vbcr & "HelloDelhi")

'msgBox("3-HelloIndia" & chr(10) & "HelloDelhi")

'msgBox("3-HelloIndia" & chr(13) & "HelloDelhi")

'msgBox "0-HelloIndia",0

'msgBox "1-HelloIndia",1

'msgBox "2-HelloIndia",2

'msgBox "3-HelloIndia",3

'msgBox "4-HelloIndia",4

'msgBox "5-HelloIndia",5

'msgBox "16-Error",16

'msgBox "32-Question",32

'msgBox "48-Warning",48

'msgBox "64-Information",64

'msgBox "0-Default",3+16+0

'msgBox "256-Default",3+16+256

'msgBox "512-Default",3+16+512

msgBox "0-Application Model",3+16+512+0

msgBox "4096-System Model",3+16+512+4096

msgBox "0-Application Model",3+16+512+0, "Application Model"

msgBox "4096-System Model",3+16+512+4096, "System Model"

</script>

</body>

</html>

Concurrency Control Protocol MCQ

 Concurrency Control Protocol MCQ

1.      If a transaction has obtained a __________ lock, it can read but cannot write on the item
a) Shared mode
b) Exclusive mode
c) Read only mode
d) Write only mode

2.      If a transaction has obtained a ________ lock, it can both read and write on the item
a) Shared mode
b) Exclusive mode
c) Read only mode
d) Write only mode

3.      A transaction can proceed only after the concurrency control manager ________ the lock to the transaction
a) Grants
b) Requests
c) Allocates
d) None of the mentioned

4.      If a transaction can be granted a lock on an item immediately in spite(बावजूद)  of the presence of another mode, then the two modes are said to be ________
a) Concurrent
b) Equivalent
c) Compatible
d) Executable

5.      A transaction is made to wait until all ________ locks held on the item are released
a) Compatible
b) Incompatible
c) Concurrent
d) Equivalent

6.      The situation where no transaction can proceed with normal execution is known as ________
a) Road block
b) Deadlock
c) Execution halt
d) Abortion

7.      The protocol that indicates when a transaction may lock and unlock each of the data items is called as __________
a) Locking protocol
b) Unlocking protocol
c) Granting protocol
d) Conflict protocol

8.      If a transaction T may never make progress, then the transaction is said to be ____________
a) Deadlocked
b) Starved
c) Committed
d) Rolled back

9.      The two phase locking protocol consists which of the following phases?
a) Growing phase
b) Shrinking phase
c) Both a and b
d) None of the mentioned

10.   If a transaction may obtain locks but may not release any locks then it is in _______ phase
a) Growing phase
b) Shrinking phase
c) Deadlock phase
d) Starved phase

11.   If a transaction may release locks but may not obtain any locks, it is said to be in ______ phase
a) Growing phase
b) Shrinking phase
c) Deadlock phase
d) Starved phase

12.   Which of the following cannot be used to implement a timestamp
a) System clock
b) Logical counter
c) External time counter
d) None of the mentioned

13.   A logical counter is _________ after a new timestamp has been assigned
a) Incremented
b) Decremented
c) Doubled
d) Remains the same

14.   Which of the following timestamp based protocols generates serializable schedules?
a) Thomas write rule
b) Timestamp ordering protocol
c) Validation protocol
d) None of the mentioned

15.   The _________ requires each transaction executes in two or three different phases in its lifetime
a) Validation protocol
b) Timestamp protocol
c) Deadlock protocol
d) View protocol

16.   During __________ phase, the system reads data and stores them in variables local to the transaction.
a) Read phase
b) Validation phase
c) Write phase
d) None of the mentioned

17.   During the _________ phase the validation test is applied to the transaction
a) Read phase
b) Validation phase
c) Write phase
d) None of the mentioned

18.   During the _______ phase, the local variables that hold the write operations are copied to the database
a) Read phase
b) Validation phase
c) Write phase
d) None of the mentioned

19.   Read only operations omit the _______ phase
a) Read phase
b) Validation phase
c) Write phase
d) None of the mentioned

 

List of Python with CS practical for class 12

 

List of Python with CS practical for class 12 

Part – 1 Python with CS

1)     WAP in Python to find the factorial of a number using function.

2)     WAP in Python to implement default and positional parameters.

3)     Write a program in Python to input the value of x and n and print the sum of the following series

1+x+x^2+x^3+ ----------------x^n

4)     WAP in Python to read a text file and print the number of vowels and consonants in the file.

5)     WAP in Python to read a text file and print the line or paragraph starting with the letter ‘S’

6)     WAP in Python to read a text fileand print the number of uppercase and lowercase letters in the file.

7)     WAP in Python to create a binaryfile with name and roll number of the students. Search for a given roll numberand display the name of student.

8)     Create a binary file with roll_no,name and marks of some students and update the marks of specific student.

9)     Create a binary file with eid, ename and salary and update the salary of the employee.

10)  Create a text file and remove the lines from the file which contains letter ‘K’

11)  Create a binary file with 10 random numbers from 1 to 40 and print those numbers.

12)  Write a program in Python to create a CSV file with the details of 5 students.

13)  WAP in Python to read a CSV file.

14)  Write a menu driven program which insert, delete and display the details of an employee such as eid, ename and salary using Stack.

15)  Write a menu driven program which insert, delete and display the details of a book such as book_id, book_name and price using Stack.

16)  Write a menu driven program which insert, delete and display the details of a student such as roll_no, sname and course using Stack.

17)  Write a menu driven program which insert, delete and display the details of a movie such as movie_id, mname and rating using Stack.

18)  Write a menu driven program which insert, delete and display the details of a product such as pid, pname and price using Stack.

19)  Write a menu driven program which insert, delete and display the details of a club such as club_id, cname and city using Stack.

20)  Write a menu driven program to demonstrate add, display, update, delete and exit. Performed on a table Book containing (bid, bname, bprice) through python-MySql connectivity.

21)  Write a menu driven program to demonstrate add, display, update, delete and exit. Performed on a table Product containing (pid, pname, price) through python-MySql connectivity.

22)  Write a menu driven program to demonstrate add, display, update, delete and exit. Performed on a table club containing (club_id, cname, city) through python-MySql connectivity.

23)  Write a menu driven program to demonstrate add, display, update, delete and exit. Performed on a table student containing (sid, sname, course) through python-MySql connectivity.

24)  Write a menu driven program to demonstrate add, display, update, delete and exit. Performed on a table movie containing (mid, mname, rating) through python-MySql connectivity.

25)  Write a menu driven program to demonstrate add, display, update, delete and exit. Performed on a table Employee containing (eid, ename, salary) through python-MySql connectivity.

Part – 2 MYSQL

SQL Practical

1.       Shiva, a student of class XII, created a table “CLASS”. Grade is one of the columns of this table. Write the SQL query to find the details of students whose grade have not been entered.

2.       Shiva is using a table with the following details:

Students(Name, Class, Stream_id, Stream_Name)

Write the SQL query to display the names of students who have not been assigned any stream or have been assigned Stream_Name that end with “computers”

3.       Write the difference between drop, delete andtruncate command with example.

4.       Write the sort notes on group by, having and where clause with example.

5.       Write the SQL query to find out the square root of 26.

6.       Shiva is using a table employee. It hasfollowing details: Employee(Code, Name, Salary, DeptCode). Write the SQL queryto display maximum salary department wise.

7.       Write the SQL Query to display the difference ofhighest and lowest salary of each department having maximum salary greater than4000.

8.  Write the SQL Query to increase 20% salary ofthe employee whose experience is more than 5 year of the table Emp(id, name, salary,exp)

9. Write the SQL Query for inner join of two tables Emp(eid, ename,salary,dept_id) and Dept(dept_id, dname)

10. Write the SQL Query for full outer join of two tables Emp(eid, ename,salary,dept_id) and Dept(dept_id, dname)

11. Write a SQL to Enter 5 Employee data in a single query in the table Emp (eid, ename, salary, city, dob).

12. Display 4 characters extracted from 5^th right character onwards from string ‘ABCDEFG’.

13. Write a query to create a string from the ASCII values 65, 67.3, ‘68.3’

14. Display names ‘MR. MODI’ and ‘MR. Sharma’ into lowercase.

15. How many characters are there in string ‘CANDIDE’.