ISRO Scientist or Engineer Computer Science 2015

Instructions

For the following questions answer them individually

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
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
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
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
Question 25

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

Video Solution
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
Question 27

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

Video Solution
Question 28

Yacc stands for

Video Solution
Question 29

Which statementis true?

Video Solution
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