Sumita Arora Solution

Intellectual Property rights are the rights of the owner of information to decide how much information is to be exchanged, shared or distributed. also it gives owner a right to decide the price for doing so.

It is important to think of digital footprint because- • Digital Persona: should be very careful about which site you are visiting. • Safety: should not provide personal information as it could be misinterpreted. • Employment: organizations find people with positive and clean digital footprint.

Digital footprint are record or activities of users leave behind as they use Internet such as social media post, online purchasing, browsing activities, location visited. It is also referred as ‘Digital tattoos’.

SELECT YEAR(CURRENT_DATE()) – YEAR(B_date()) AS ‘Age’;

We can use following syntax:SELECT DAYOFWEEK(<your date of birth in yyyy-mm-dd>);for example-SELECT DAYOFWEEK(‘2000-11-24’);

Ans 7:SELECT CURDATE();orSELECT CURRENT_DATE();Ans 8:SELECT MONTHNAME(CURRENT_DATE());Ans 9:SELECT CONCATE(‘Today, The Date is ‘,CURRENT_DATE());

Ans:CONCAT( CONCAT( LCASE( TRIM( TRAILING ‘.’ FROM ‘INFORMATION PRACTICE…’)) . ‘ ‘ ).LCASE( TRIM( LEADING ‘.’ FROM ‘…FOR CLASS XI’)));

A function is predefined set of commands that performs a specific task and may return a single value.

Ans 10 :we can use if_exists = ‘append’ argument to retain old data of table. Syntax:<dataframe_object>.to_sql( “table_name”, connection_object, if_exists = “append”)Example:df.to_sql(“book”, con, if_exists = “append”) Ans 11 :import pandas as pdimport mysql.connector as sqltcon = sqlt.connect (host = “localhost”, user = “root”, passwd = “yourpassword” , database = “yourdatabasename”)cursor = con.cursor()qry = “select * from

pandamysql.connectorpymysql