Write a method in Python to read lines from a text file DIARY.TXT, and display those lines, which are starting with an alphabet ‘P’.
def display():
file=open('DIARY.TXT','r')
line=file.readline()
while line:
if line[0]=='P' :
print line
line=file.readline()
file.close() #IGNORE
Observe the following table MEMBER carefully and write the name of the RDBMS operation out of (i) SELECTION (ii) PROJECTION (iii) UNION (iv) CARTESIAN PRODUCT, which has been used to produce the output as shown in RESULT. Also, find the Degree and Cardinality of the RESULT.
NO | MNAME | STREAM |
M001 | JAYA | SCIENCE |
M002 | ADIYTA | HUMANITIES |
M003 | HANSRAJ | SCIENCE |
M004 | SHIVAK | COMMERCE |
NO | MNAME | STREAM |
M002 | ADIYTA | HUMANITIES |
SELECTION
Degree of table RESULT=3
Cardinality of table RESULT = 2
Differentiate between the following:
Considering the following definition of class COMPANY, write a method in Python to search and display the content in a pickled file COMPANY.DAT, where CompID is matching with the value ‘1005’.
class Company:
def __init__(self,CID,NAM):
self.CompID = CID #CompID Company ID
self.CName = NAM #CName Company Name
self.Turnover = 1000
def Display(self):
print self.CompID,':',self.CName,':',self.Turnover
import pickle
def ques4c():
f=Factory()
file=open('COMPANY.DAT','rb')
try:
while True:
f=pickle.load(file)
if f.CompID==1005:
f.Display()
except EOF Error:
pass
file.close() #IGNORE