GATE (Graduate Aptitude Test in Engineering) Computer Science: Questions 2069 - 2071 of 2080

Access detailed explanations (illustrated with images and videos) to 2080 questions. Access all new questions- tracking exam pattern and syllabus. View the complete topic-wise distribution of questions. Unlimited Access, Unlimited Time, on Unlimited Devices!

View Sample Explanation or View Features.

Rs. 550.00 -OR-

How to register? Already Subscribed?

Question 2069

Question

MCQ▾

Let the set of functional dependencies hold on a relation schema . X is not in BCNF. Suppose X is decomposed into two schemas and Z where and . Consider the two statements given below:

I. Both Y and Z are in BCNF

II. Decomposition of X into Y and Z is dependency preserving and a lossless.

Which of the above statements is/are correct?

Choices

Choice (4)Response

a.

I only

b.

II only

c.

All of the above

d.

None of the above

Question 2070

Edit

Appeared in Year: 2020

Question

Numeric Answer▾

Consider the following C program.

  1. #include < stdio.h >
  2. intmain ( ) {
  3. inta [ 4 ] [ 5 ] ={ { 1, 2, 3, 4, 5 } ,
  4.   { 6, 7, 8, 9, 10 } ,
  5.   { 11, 12, 13, 14, 15 } ,
  6.   { 16, 17, 18, 19, 20 } } ;
  7.  printf ( "%d/n", ⚹ ( ⚹ ( a +⚹ ⚹ a +2 ) +3 ) ) ;
  8. return ( 0 ) ;
  9. }

The output of the program is ________.

Question 2071

Appeared in Year: 2020

Question

MCQ▾

Consider the following five disk five disk access requests of the form (request id, cylinder number) that are present in the disk scheduler queue at a given time.

(P, 155) , (Q, 85) , (R, 110) , (S, 30) , (T, 115)

Assume the head is positioned at cylinder 100. The scheduler follows Shortest Seek Time First scheduling to service the requests.

Which one of the following statements is FALSE?

Choices

Choice (4)Response

a.

T is serviced before P

b.

The head reverses its direction of movement between servicing of Q and P

c.

Q is serviced after S, but before T

d.

R is serviced before P

Developed by: