ISRO Scientist or Engineer Computer Science 2015

Instructions

For the following questions answer them individually

ISRO Scientist or Engineer Computer Science 2015 - Question 21


If $$D_1, D_2, ....., D_n$$ are domains in a relational model, then the relation is a table, which is a subset of

Video Solution

ISRO Scientist or Engineer Computer Science 2015 - Question 22


Consider the following relational query on the above database:
SELECT S.sname
FROM Suppliers S
a WHERE S.sid NOT IN (SELECT C.sid 
     FROM Catalog C
     WHERE C.pid NOT IN (SELECT P.pid
             FROM Parts P
             WHERE P.color < > ‘blue’))
Assume that relations corresponding to the above schema are not empty. Which of the following is the correct interpretation of the above query?

Video Solution

ISRO Scientist or Engineer Computer Science 2015 - Question 23


Consider the following schema:
Emp (Empcode, Name, Sex, Salary, Deptt)
A simple SQL query is executedasfollows:
SELECT Deptt FROM Emp
WHEREsex = ‘M’
GROUP by Dept
Having avg (Salary) > { select avg (Salary) from Emp}
The output will be

Video Solution

ISRO Scientist or Engineer Computer Science 2015 - Question 24


Given the following expression grammar:
$$E \rightarrow  E * F \mid F + E \mid F$$
$$F \rightarrow F - F \mid  id$$
Which of the following is true?

Video Solution

ISRO Scientist or Engineer Computer Science 2015 - Question 25


The number of token the following C statementis
printf (“i = %d, &i =%x”, i&i);

Video Solution

ISRO Scientist or Engineer Computer Science 2015 - Question 26


Which grammar rules violate the requirement of the operator grammar? A, B, C are
variables and a, b, c are terminals
(i) $$A \rightarrow BC$$
(ii) $$A \rightarrow CcBb$$
(iii) $$A \rightarrow BaC$$
(iv) $$A \rightarrow ε$$

Video Solution

ISRO Scientist or Engineer Computer Science 2015 - Question 27


Which one of the following is a top-down parser?

Video Solution

ISRO Scientist or Engineer Computer Science 2015 - Question 28


Yacc stands for

Video Solution

ISRO Scientist or Engineer Computer Science 2015 - Question 29


Which statementis true?

Video Solution

ISRO Scientist or Engineer Computer Science 2015 - Question 30


Semaphoresare used to solve the problem of
(i) race condition
(ii) process synchronization
(iii) mutual exclusion
(iv) none of the above

Video Solution
cracku

Boost your Prep!

Download App