Electrical Engineering Answers

Enlist major differences that exist between central computer and the peripheral devices. 

What role does an interface play in resolving these differences?

Explain addressing modes in detail with example of each.

Design the architecture of DMA mode of operation and illustrate how various components 

namely, CPU, RAM, DMA Controller and I/O Peripheral interface each other.

Check the given schedule for serializability:

T1

T2

R(X)

T3

T4

W(X) Commit

W(X) Commit

W(Y)

R(Z) Commit

R(X)

R(Y) Commit

All the methods for checking the serializability should be discussed with well-drawn schedules and diagrams, if any.

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’

Explain the addressing modes in detail with the help of example of each? [5 marks]

Explain the Memory stack organization of 16 locations of stack( 0 to 15). take the initial value of the

stack pointer is SP = 0E in Hex. Explain the following push and pop instructions through the Memory

stack organization diagram.

(1) PUSH R5 WHERE R5 = XX in Hex

(2) POP R4 WHERE R4 = (XX + 3 ) Hex for example roll no 64 is having the data in R5 = 64

Hex and R4 is ( 64+3 = 67 Hex) [5 marks]

Design a circuit of General register organization in which 4 registers are there from R0 to R3.

(a) Perform the following microoperation and explain the operation in the steps through the

diagram properly: - AND R3 ,R3 ,R1 .

(b) Explain the control word as per the register configuration given above. [10 marks]

he unique addresses assigned to the four registers (R11,R12,13,R14) of the I/O interface are equal

to the XX3 , XX7 , XXB and XXF in Hex . Where XX is hex digits equal to your roll no . (if student is having

roll no 45 than address are 453 ,457 ,45B , 45F in Hex ) .Show the well labeled external circuit that must

be connected between and 12-bit I/O address from the CPU and the CS, RSI, and RS0 Inputs of the

Interface.

Find the values of the flags (carry ,sign ,zero, overflow) of the processor status register for the given

example of two 8 bit no’s in Hex (A7 + EF) and draw the circuit diagram also.