Expected Questions Series 3

1) Which type of clustering index is defined on the fields?
a. Non-key and non-ordering
b. Non-key and ordering
c. Key and non-ordering
d. Key and Ordering

2) What type of relationship does a hierarchical schema help to establish between the items of a database?

a. top-to-bottom relationship 
b. bottom-to-top relationship
c. one-to-many relationship
d. many-to-one

3) What is truncating a table?

a. Data alone deleted, Performs an automatic commit 
b. Data alone deleted, Doesn’t perform automatic commit
c. Table structure + Data are deleted
d. Table structure alone deleted, Performs an automatic commit

4) Which attributes can the screen readers read? (HTML)

a. ctrl
b. alt 
c. both A & B
d. None of the above

5) Consider a counting semaphore which was initialized to 10 and then 6P (wait) operations and 4v(signal) operations were completed on this semaphore. What is the resulting value of semaphore?

a. 10
b. 9
c. 8
d. 0

6) Why is the Software interrupt required by the processor?

a. Return from subroutine.
b. Obtain system services, which need execution of privileged instruction. 
c. Test the interrupt system of the processor.
d. Implement co-routines.

Answers:

1) b

2) a

3) a

4) b

5) c

6) b