The is a condition for dropping a table; is it must be an empty table.

The ALL keyword retains duplicate rows. It will display every row of the table without considering duplicate entries
SELECT ALL Place FROM Student;

Transactional Control Language (TCL) commands are used to manage transactions in the database. These are used to manage the changes made to the data in a table by DML statements.

(i) A Data Manipulation Language (DML) is a computer programming language used for adding (inserting), removing (deleting), and modifying (updating) data in a database. In SQL, the data manipulation language comprises the SQL-data change statements, which modify stored data but not the schema of the database table.
(ii) After the database schema has been specified and the database has been created, the data can be manipulated using a set of procedures which are expressed by DML.

nhy re teloW

General format of slice operation:
str[start:end]
Where start is the beginning index and end is the last index value of a character in the string. Python takes the end value less than one from the actual index specified.

strl = input ("Enter your name")
print (strl * 10)

SQL server, Oracle, MySQL, MariaDB, SQLite.

def function_name(*args):
function_body
return_statement

A block within a block is called nested block. When the first block statement is indented by a single table space, the second block of statement is indented-by double tab spaces.

Scatter plot: A scatter plot is a type of plot that shows the data as a collection of points. The position of a point depends on its two dimensional value, where each value is a position on either the horizontal or vertical dimension.

(i) The WHERE clause can be combined with AND, OR, and NOT operators.
(ii) The AND and OR operators are used to filter records based on more than one condition.

g++ is a program that calls GCC (GNU C Compiler) and automatically links the required C++library files to the object code

Constructor -( - - init - - ( ))
Destructor -(- - del - - ( ))

A loop placed within another loop is called as nested loop structure. A while; within another while; for within another for; for within while and while within for to construc nested loops.

Syntax:
for counter_variable in sequence:
statements-block 1
[else: # optional block
statement-block 2]

import csv
row = ['6; 'Sajini ' ,'Madurai']
with open ('student.csv; 'a') as CF:
# append mode to add data at the end
writer = csv.writer(CF)
writer. writerow(row)
# writerow ( ) method write a single row of data in file
CF.close( )

(i) The whitespaces can be removed, by registering new dialects using csv.register_ dialect ( ) class of csv module.
(ii) A dialect describes the format of the csv file that is to be read, In dialects the parameter "skipinitialspace" is used for removing whitespaces after the delimiter.

Read 'r', write 'w' or append 'a'.

Syntax:
# Empty tuple
Tuple_Name = ()
# Tuple with n number elements
Tuple_Name = () (E1, E2, E2, ....... En)
# Elements of a tuple without parenthesis
Tuple_Name = E1, E2, E3 ..... En

The remove( ) function can also be used to delete one or more elements if the index value is not known.

In Python, append( ) function is used to add a single element and extend( ) function is used to add more than one element to an existing list.

Syntax:
Variable = [element-1, element-2, element-3 ................ elernent-n]
Example:
Marks = [10,23,41,75]
Fruits = ["Apple", "Orange", "Mango",  "Banana"]
MyList = [ ]

Asymptotic Notations are languages that uses meaningful statements about time and space complexity

(i) The way of defining an algorithm is called J algorithmic strategy.
(ii)  For example to calculate factorial for the given value n then it can be done by defining the function to calculate factorial once for the iteration-1 then it can be called recursively until the number of required iteration is reached.

(i) New line
(ii) Tab

(i) The following command can be used t invoke Python IDLE from Window OS.
(ii) Start ⟶ All Programs ⟶ Python 3.x ⟶ IDL (Python 3.x)
(or)
(iii) Click python   Icon on the Desktop if available.

The LEGB rule is used to decide the order in which the scopes are to be searched for scope resolution. The scopes are listed below in terms of hierarchy (highest to lowest).

(i) To implement the concrete level of data abstraction, languages like Python provides a compound structure called Pair which is made up of list or Tuple.
(ii) The first way to implement pairs is with the List construct

(requires: b > 0 )
(returns: a to the power of b)
let rec pow (a: int) (b: int) : int :=
if (b=0) then 1
else a * pow b (a-1 )