1.
In 8085 microprocessor which of the following
flag(s) is (are) affected by an arithmetic operation?

(1) AC flag
Only

(2) CY flag
Only

(3) Z flag
Only

(4) AC, CY,
Z flags

Answer: 4

2. In
8085 microprocessor the address bus is of .................... bits.

(1) 4

(2) 8

(3) 16

(4) 32

Answer: 3

3. In
the architecture of 8085 microprocessor match the following:

**List - I**

(a)
Processing unit

(b)
Instruction unit

(c) Storage
and Interface unit

**List - II**

(i)
Interrupt

(ii) General
purpose Register

(iii) ALU

(iv) Timing
and Control

**Code :**

(a) (b) (c)

(1) (iv) (i)
(ii)

(2) (iii)
(iv) (ii)

(3) (ii) (iii) (i)

(4) (i) (ii) (iv)

Answer: 2

4. Which
of the following addressing mode is best suited to access elements of an array
of contiguous memory locations?

(1) Indexed
addressing mode

(2) Base
Register addressing mode

(3) Relative
address mode

(4)
Displacement mode

Answer: 1

5. Which
of the following is correct statement?

(1) In
memory - mapped I/O, the CPU can manipulate I/O data residing in interface registers
that are not used to manipulate memory words.

(2) The
isolated I/O method isolates memory and I/O addresses so that memory address range
is not affected by interface address assignment.

(3) In
asynchronous serial transfer of data the two units share a common clock.

(4) In
synchronous serial transmission of data the two units have different clocks.

Answer: 2

6. A
micro-instruction format has micro-ops field which is divided into three
subfields F1, F2, F3 each having seven distinct micro-operations, condition
field CD for four status bits, branch field BR having four options used in
conjunction with address field ADF. The address space is of 128 memory
locations. The size of micro-instruction is:

(1) 17 bits

(2) 20 bits

(3) 24 bits

(4) 32 bits

Answer: 2

7. Consider
the following four schedules due to three transactions (indicated by the
subscript) using read and write on a data item X, denoted by r(X) and w(X)
respectively. Which one of them is conflict serializable?

S

_{1}: r_{1}(X); r_{2}(X); w_{1}(X); r_{3}(X); w_{2}(X)
S

_{2}: r_{2}(X); r_{1}(X); w_{2}(X); r_{3}(X); w_{1}(X)
S

_{3}: r_{3}(X); r_{2}(X); r_{1}(X); w_{2}(X); w_{1}(X)
S

_{4}: r_{2}(X); w_{2}(X); r_{3}(X); r_{1}(X); w_{1}(X)
(1) S

_{1}
(2) S

_{2}
(3) S

_{3}
(4) S

_{4}
Answer: 4

8. Suppose
a database schedule S involves transactions T

_{1}, T_{2}, .............,T_{n}. Consider the precedence graph of S with vertices representing the transactions and edges representing the conflicts. If S is serializable, which one of the following orderings of the vertices of the precedence graph is guaranteed to yield a serial schedule?
(1)
Topological order

(2) Depth -
first order

(3) Breadth
- first order

(4)
Ascending order of transaction indices

Answer: 1

9. If
every non-key attribute is functionally dependent on the primary key, then the
relation is in ....................

(1) First
normal form

(2) Second
normal form

(3) Third
normal form

(4) Fourth
normal form

Answer: 3

10. Consider
a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and
following functional dependencies exist.

CH → G

A → BC

B → CFH

E → A

F → EG

The relation
R is ....................

(1) in 1NF
but not in 2NF

(2) in 2NF
but not in 3NF

(3) in 3NF
but not in BCNF

(4) in BCNF

Answer: 1

## 5 Comments

Please answer with explain of some questions

ReplyDeleteIf every non-key attribute is functionally dependent on the primary key, then the relation is in ....................

ReplyDelete(1) First normal form

(2) Second normal form

(3) Third normal form

(4) Fourth normal form

the answer is 2.But your answer is 3 that is wrong please provide the correct answer.

yes. I do agree on this..

DeleteVery Nice but give explanation for each and very question. Thanks.

ReplyDeleteYes this is the second normal form

Delete