1.
Which of the following is an interrupt
according to temporal relationship with system clock?
(1) Maskable
interrupt
(2) Periodic
interrupt
(3) Division
by zero
(4) Synchronous
interrupt
Answer: 4
2. Which
of the following is incorrect for virtual memory?
(1) Large programs
can be written
(2) More I/O
is required
(3) More
addressable memory available
(4) Faster
and easy swapping of process
Answer: 2
3. The
general configuration of the microprogrammed control unit is given below:
What are
blocks B and C in the diagram respectively?
(1) Block
address register and cache memory
(2) Control
address register and control memory
(3) Branch
register and cache memory
(4) Control
address register and random access memory
Answer: 2
4. Match
the following:
Addressing
Mode Location of operand
a. Implied i.
Registers which are in CPU
b. Immediate ii.
Register specifies the address
of
the operand
c. Register iii.
Specified in the register
d. Register
Indirect iv. Specified implicitly in
the
definition
of instruction
Codes:
a b
c
d
(1) iv iii i ii
(2) iv i iii ii
(3) iv ii i iii
(4) iv iii ii i
Answer: 1
5. In
8085 microprocessor, the digit 5 indicates that the microprocessor needs
(1) -5
volts, +5 volts supply
(2) +5 volts
supply only
(3) -5 volts
supply only
(4) 5 MHz
clock
Answer: 2
6. In
8085, which of the following performs: load register pair immediate operation?
(1) LDAX rp
(2) LHLD
addr
(3) LXI rp,
data
(4) INX rp
Answer: 3
7. Consider
following schedules involving two transactions:
S1:
r1(X); r1(Y); r2(X); r2(Y); w2(Y);
w1(X)
S2:
r1(X); r2(X); r2(Y); w2(Y); r1(Y);
w1(X)
Which of the
following statement is true?
(1) Both S1
and S2 are conflict serializable.
(2) S1
is conflict serializable and S2 is not conflict serializable.
(3) S1
is not conflict serializable and S2 is conflict serializable.
(4) Both S1
and S2 are not conflict serializable.
Answer: 3
8. Which
one is correct w.r.t. RDBMS?
(1) primary key
⊆ super key ⊆ candidate
key
(2) primary
key ⊆ candidate
key ⊆ super key
(3) super
key ⊆ candidate
key ⊆ primary key
(4) super
key ⊆ primary key ⊆ candidate
key
Answer: 2
9. Let
pk(R) denotes primary key of relation R. A many-to-one relationship that exists
between two relations R1 and R2 can be expressed as follows:
(1) pk(R2)→pk(R1)
(2) pk(R1)→pk(R2)
(3) pk(R2)→R1∩R2
(4) pk(R1)→R1∩R2
Answer: 2
10. For
a database relation R(A,B,C,D) where the domains of A,B,C and D include only
atomic values, only the following functional dependencies and those that can be
inferred from them are:
A→C
B→D
The relation
R is in ................
(1) First
normal form but not in second normal form
(2) Both in
first normal form as well as in second normal form
(3) Second
normal form but not in third normal form
(4) Both in second
normal form as well as in third normal form
Answer: 1
2 Comments
Question 10 answer is 2
ReplyDeleteQuestion 10 answer is 1 only.
ReplyDelete(AB) is the key and clearly both FDs are partial dependencies. So, the given relation is only in 1NF and not in 2NF.