Database Query Using–SQL — Computer Science STD 12 Science — Question

What do you mean by authorisation and authentication?

 Rewrite the above script, but this time to swap the values of variables without using the third variable.

Write a python program using recursive function to search an element in a list using Binary search technique. 

Write two advantages of using an optical fiber cable over an Ethernet cable to connect two service stations, which are 190m away from each other.

What is the purpose of Modem in network?

Differentiate between Bus and Star topology of networks. 

Write the python script to connect the database, i.e.test and create the table emp21 with the following field (empno,name and salary). Also, insert the row.

What is the importance of a Primary Key in a table? Explain with a suitable example.

Write the python script that read the whole data from the table emp and display all the records.

A company has three departments namely Administrative, Sales and Production. Out of telephone cable, Optical Fibre, Ethernet Cable, which communication medium is best for high speed communication between departments?