Subaiya society

  write a program count the number of characture (without space) in the given string? st='hyderabad tech hall' x=0 for i in st:         if i !=' ':                 x=x+1 print(x)

 #WAP ENTER ANY CHARATURE/NAME AND COUNT THE CHARATURE? ''' name=input( 'enter any name: ') print('The total characture in{} is {}'.format(name,len(name)))      ''' #wap to check the values is even or odd numbr? ''' x=eval(input('enter any number: ')) if x%2==0:     print('{} is a even number'.format(x)) else:     print('{} is odd number'.format(x)) print('thank you')     ''' #WAP TO CHECK WHETHER STUDENT PASSED IN EXAM OE NOT? ''' marks=eval(input('enter your mark: ')) if marks >=35:     print('congratulations you passed the exam') else:     print('you failed the exam betterluck next time')  ''' #wap to check wether the citizen is eligible for vote or not? ''' Name=input('enter your name: ').lower() if type(Name) is str:     age=eval(input('enter your age: '))     if age >=18:         print('Hello {} you a...

 Q-1- What is difference between drop and delete command?   Drop command Delete command 1-Drop command belong to DDL. 2- Drop commands delete both header and table permanently. 3-Drop commands does not support where conditions.   Syntax: Drop table<Table_Name>;   1-Delete command belongs to DML 2-Delete commands delete the data / body part of the table. 3-Delete support where conditions. Syntax: Delete from<table_name> where <conditions>;       Q-2- what is difference between drop and truncate commands? Drop commands Truncate commands 1-Drop command belong to DDL. 2- Drop commands delete both header and table permanently. 3-Drop commands does not support where conditions.   Syntax: Drop table<Table_Name>;   1-Truncate commands belong to DDL. 2-Truncate command will delete both header and body of the table and re-create the header. 3-Truncate does not support where conditions.   Syntax: Truncate table<Table_name...

  what is difference between alter and update command? Alter command Update command 1-Alter command belongs to DDL. 2-Alter command is used to modify existing table header. Example- i-Adding new column. ii-Dropping Exiting column. iii-Renaming the exiting column. iv-Change the data type and size. 3-Alter command does not support where conditions. 1-Update command belong from DML. 2-Update command is used to modify the Existing table body.  Example- i-change the values. ii-Rename exiting values.   3-Update commands supports where conditions.

  What is difference between Create and insert commands?   Create command Insert commands 1-Create command belongs to DDL. 2- Create command is used to create header of the table. 3-It is also used to create data bases. 1-Insert command belongs to DML. 2-Insert command is used to create bo d y of the table. 3-  Insert command is used to insert new records in a table.  

  What are the difference between DDL and DML? DDL DML 1-DDL stands for data definition language . 2-DDL sub-language is used to work with   header of the table. 3-DDL sub language contains some commands like create,alter,truncate and drop. 1-DML stands for data manipulation language . 2-DML sub-language is used to manipulate the data base object . 3-DML sub language contain some commands like Insert, update and delete.

  What is different sub-language in SQL? ANS-   DDL  – Data Definition Language.          DML  – Data Manipulation Language.          DRL/DQL  – Data Retrieval Language/Data Query Language.         TCL  – Transaction Query Language.         DCL  – Data Control Language.         SCL  – Session Control Language.