Search & Filtering
Write SQL Queries for following set of tables:
EMPLOYEE (EmpNo, Name, DoB, Address, Gender, Salary, DNumber) ,
DEPARTMENT (DNumber, Dname, ManagerEmpNo, MnagerStartDate).
Write the following queries ( create table and add random data):
i) Display the Age of ‘male’ employees.
ii) Display all employees in Department named ‘Marketing’.
iii) Display the name of highest salary paid ‘female’ employee.
iv) Which employee is oldest manger in company?
v) Display the name of department of the employee ‘SMITH’
38. A 12-ohm resistor is connected in parallel with a series combination of resistors of 8 and 16 ohms. If the drop across the 8-ohm resistor is 48 volts, determine the total impressed emf and the total current.
45. Two equal resistors RA and Rв are connected in parallel and to a 120-volt source. What potential difference exists between the midpoint of RA and a point that is one-third from either end of RB?
Design a transistor fixed bias circuit with VCC = 12V, VBE = 0.7V, β=100 and RC =1KΩ to operate in middle of the Load line (for IC = 6mA), cut off region (for IC = 0.5
mA) and saturation region (for IC = 11.5 mA). Determine the corresponding values of
RB and VCEQ for the three different cases.
One thousand kilograms per hour of a mixture of benzene (B) and toluene (T) that contains 60 % benzene by mass are separated by distillation into two fractions. The mass flow rate of benzene in the top stream is 470 kg B/h, and that of toluene in the bottom stream is 350 kg T/h. The operation is at steady state. a. Draw and label the flowchart of the process. b. Write balances on benzene and toluene to calculate the unknown component flow rates in the output streams.
3 Explain if the priority method is not used, then what other possible method
can be used to effectively access I/O devices. Give proper diagram and
explanation of working.
(answer for 10 marks.)
Alight ray is incident from glass to air. If the transmitted power is 0 dB,
compute the reflected power.
This computer organization would not require registers to execute its instructions , elaborate properly with an example and diagram on how this mechanism works.
Give any 5 addressing modes which do not use the address given inside the instruction to fetch the given operand directly, instead they use one form or another for it.
Explain the process followed by CPU while completing the interrupts and resuming to instructions with proper steps.
