State whether the given functions are correct or not. If correct, write the output they return. If incorrect, write the reason.
a. =sum(10,True)
b. =Average(1,2,3)
c. =max{111,189}
d. =Minimum(1020,1190)
e. =sum(1,2,3)
Answers
Answer:
Which best describes your or your family's personal income last
A. Below 36,000/-
B. 36,000/- to 50,000/-
C. 50,001/- to 1 lakh
D. Above 1 Lakh.
2) What are the reasons of poverty?
A. Low income
B.Less Saving
C.Sudden incident disaster,death,flood, drought etc.
D.All the above.
3)Personal financial planning involves
ban
A.Establishing an adequate financial record keeping,
B.Minimizing expenses.
a plan for future financial needs and goals.v\
Explanation:
Comprehension: Consider the following table structures related to a university for given questions.
EMPLOYEE
NAME
VARCHAR (30)
NOT NULL,
EID
VARCHAR (10)
NOT NULL,
DEPTNO
INT (5)
NOT NULL,
HODEID
VARCHAR (10),
SALARY
INT (10),
PRIMARY KEY (EID),
FOREIGN KEY (HODEID) REFRENCES EMPLOYEE (EID),
FOREIGN KEY (DEPTNO) REFRENCES DEPARTMENT (DID);
DEPARTMENT
DID
INT (5)
NOT NULL,
DNAME
VARCHAR (30)
NOT NULL,
HODID
VARCHAR (10)
NOT NULL,
HODNAME
VARCHAR (30),
PRIMARY KEY (DID),
UNIQUE (DNAME),
FOREIGN KEY (HODID) REFERENCES EMPLOYEE (EID),
PROJECT WORE:
EMPID
VARCHAR (10)
NOT NULL,
PROJNO
INT (5)
NOT NULL,
PROJECTLOC
VARCHAR (30)
NOT NULL,
PRIMARY KEY (EMPID, PROJNQ),
FOREIGN KEY (EMPID) REFERENCES EMPLOYEE (EID),
Given below are two statements to find the sum of salaries of all employees of the English department as well as the maximum. minimum and average salary in the English department.
STATEMENT I: SELECT SUM (SALARY). MAX (SALARY), MIN (SALARY), AVG (SALARY) FROM EMPLOYEE, DEPARTMENT
WHERE DEPTNO=DID AND DNAME='ENGLISH';
STATEMENT II: SELECT SUM (SALARY), MAX (SALARY), MIN (SALARY), AVG (SALARY) FROM EMPLOYEE, DEPARTMENT
WHERE DNAME='ENGLISH';
In the light of the above statements, choose the correct answer from the options given below