GPL - Gate Question |

X Close

You need to enable javascript to view this page properly.

Branch

All

Loading

565.

Let R₁ (A,B,((D) and R₂ (D,E) be two relation schema, where the primary keys are shown underlined, and let C be a foreign key in R₁ referring to R₂. Suppose there is no violation of the above referential integrity constraint in the corresponding relation instances r₁ and r₂. Which one of the following relational algebra expressions would necessarily produce an empty relation? [1 mark]

asked in Computer Science And Engineering, 2004

View Comments [0 Reply]
566.

Consider an operating system capable of loading and executing a single sequential user process at a time. The disk head scheduling algorithm used is First Come First Served (FCFS). If FCFS is replaced by Shortest Seek Time First (SSTF), claimed by the vendor to give 50% better benchmark results, what is the expected improvement in the I/O performance of user programs? [1 mark]
(a) 50%
(b) 40%
(c) 25%
(d) 0%

asked in Computer Science And Engineering, 2004

View Comments [0 Reply]
567.

Consider the following statements with respect to user-level threads and kernel supported threads
(i) context switch is faster with kernel-supported threads
(ii) for user-level threads, a system call can block the entire process
(iii) Kernel supported threads can be scheduled independently
(iv) User level threads are transparent to the kernel
Which of the above statements are true? [1 mark]
(a) (ii), (iii) and (iv) only
(b) (ii) and (iii) only
(c) (i) and (iii) only
(d) (i) and (ii) only

asked in Computer Science And Engineering, 2004

View Comments [0 Reply]
568.

Consider the grammar rule E -> E₁ – E₂ for arithmetic expressions. The code generated is targeted to a CPU having a single user register. The subtraction operation requires the first operand to be in the register. If E₁ and E₂ do not have nay-common sub-expression, in order to get the shortest possible code [1 mark]
(a) E1 should be evaluated first
(b) E2 should be evaluated first
(c) Evaluation of E1 and E2 should necessarily be interleaved
(d) Order to evaluation of E1 and E2 is of no consequence

asked in Computer Science And Engineering, 2004

View Comments [0 Reply]
569.

Consider a program P that consists of two source modules M₁ and M₂ contained in two different files. If M₁ contains a reference to a function defined in M₂ the reference will be resolved at [1 mark]
(a) Edit time
(b) Compile time
(c) Link time
(d) Load time

asked in Computer Science And Engineering, 2004

View Comments [0 Reply]
570.

Which of the following grammar rules violate the requirements of an operator grammar? P, Q, R are nonterminals, and r,s,t are terminals.
(i) P -> Q R
(ii) P -> Q s R
(iii) P -> ∈
(iv) P -> Q t R r [1 mark]
(a) (i) only
(b) (i) and (iii) only
(c) (ii) and (iii) only
(d) (iii) and (iv) only

asked in Computer Science And Engineering, 2004

View Comments [0 Reply]

801 1 ...‹‹93 9495 96 97 ›› ... 134

High Frequency Word List with Mnemonics

GPL Dictionary is fast way to learn words with mnemonics.
It contains high frequency word list which are mostly asked in various examinations.
It is dedicated for student appearing for PSUs, GRE, UPSC or any other exams in which vocabulary test is taken.
User can save their own mnemonics (key and link).

Check Now