Functions — Computer Science STD 12 Science — Question

How relative path is different from absolute path.

Name some applications of Stack.

Define the following terms: Scope of a variable,

Choose the correct answer for the following questions on the basis of given table:

Table: Persons

FirstName	LastName
Naveen	Gupta
Ram	Sharma
Mohan	Kumar
Aayu	Chugh

(a) With SQL, how do you select a column named "FirstName "from a table named "Persons "?

(b) With SQL, how do we select all the columns from a table named "Persons "?

(c) With SQL, how do we select all the records from a table named "Persons "where the value of the column "FirstName "is "Naveen "?

(d) With SQL, how do we select all the records from a table named "Persons "where the value of the column "FirstName "starts with an "a "?

(e) With SQL, how do we select all the records from a table named "Persons "where the "FirstName "is "Aayu "and the "LastName "is "Chugh "?

(f) With SQL, how do we select all the records from a table named "Persons "where the "LastName "is alphabetically between (and including) "Sharma "and "Chugh "?

(g) With SQL, how can we return all the records from a table named "Persons "sorted descending by "FirstName "?

(h) With SQL, how can we insert a new record into the "Persons "table?

(i) With SQL, how can we insert "Mehta "as the "LastName "in the "Persons "table?

(j) How can we change "Chugh "into "Bajaj "in the "LastName "column in the Persons table?

(k) With SQL, how can you delete the records where the "FirstName "is "Gupta "in the Persons Table?

(l) With SQL, how can you return the number of records in the "Persons "table?

Name the few free public clouds.

Question write SQL statements for the following.

(i) To print the current date and time.

(ii) To print the today ’s date only.

(iii) To print the month name from the date "2019-10-10 ".

(iv) To the month from the date "2020-01-10 "

(v) To print the square of 5.

(vi) To round of the number 345.56 upto 1 decimal place.

(vii) To print the modulus of 4 to 5.

(viii) To round of the number 4567.10 multiple of 10.

Write the codings to display the content of file "welcome.txt".

How will you append new rows to a pandas DataFrame?

A table Item and Store have one common column Item-Id. Item table consists of 5 rows and 3 columns while the store table consists of 7 rows and 5 columns.

What will be the degree and cardinality of these tables in the cartesian product?

Define Cyberfraud.