Sumita Arora Solution

UPDATE statement is used for modifying the existing records in a table. The UPDATE command specifies the rows to be changed using the WHERE clause and the new data using the SET keyword.Syntax:UPDATE <table name>SET <fieldname> = <value or expression>WHERE <criteria> UPDATE ALTER It modifies the existing data of a database It modifies existing structure […]

DDL DML Allow task to define the database structure Allow task to manage data stored in database Exp- CREATE, ALTER, DROP Exp- INSERT, DELETE, SELECT DDL statement operate on entire table DML statement operate on rows TCL statement can not be used with DDL TCL statement can be used with DML

SQL Commands can be classified in following three ways: Data Definition Language (DDL) Commands – command that allow you to perform task related to data definition. For example CREATE, ALTER, DROP Data Manipulation Language (DML) Commands – Commands that allow you to perform data manipulation. For example SELECT, INSERT, UPDATE, DELETE Transaction Control Language (TCL)

When a variable is accessible or valid only within a part of program, it is referred as local scope of variable. When a variable is accessible or valid inside the whole program, it is referred as global scope of variable. To access a global variable within a function we use global statement to declare it.

(a)A name inside the parenthesis of a function header that can receive a value.(b)An argument passed to a specific parameter using the parameter name.(c)A value passed to a function parameter(d)A value assigned to a parameter name in the function header.(e)A value assigned to a parameter name in the function call.(f)A name defined outside all function

Global statement can be used when we want to assign some value to global variable without creating any local variable. It is not recommended because alter the global statement function always refer to global variable and local variable can not be created and hence control over variable and their scope id lost.

Local Variable Global Variable Can be accessible within a part of program Can be accessible anywhere within a program Declared within a function or block Declared at top level segment of program Its lifetime is function’s runtime Its lifetime is entire program runtime

Scope determines the accessibility and validity of an identifier, function or piece of code within a part or whole program.Python follow naming resolution scope also known as LEGB rule, which are as given below: • It checks within local environment • It checks within execution environment • It checks the global environment • It checks

Yes, a function can return multiple values in python. To return multiple values we need to do followings: • The return statement should be written like return value1,value2,…….. • Values returned by function call should be stored in tuple or by specifying same no of variables.For Example: def perimeter(r):   circle = 2*3.14*r   square

A function can be used in various styles in python. following are the examples of various function styles- void Function (Non Fruitful Function) def power():   x=intinput((“Enter Base”))   y=intinput((“Enter Exponent”))   for i in range(y):     r=r*x   print(r) Function with Arguments (Non Fruitful Function) def power(x,y):   for i in range(y):