ISRO Scientist or Engineer Computer Science 2015

For the following questions answer them individually

The complement of the Boolean expression $$AB(\overline{B}C + AC)$$ is

Minimum number of 2 x 1 multiplexers required to realize the following function, $$f= \overline{A} \overline{B} C + \overline{A} \overline{B} \overline{C}$$.
Assume that inputs are available only in true form and Boolean a constant 1 and 0 are available.

Six files Fl, F2, F3, F4, F5 and F6 have 100, 200, 50, 80, 120, 150 records respectively.In what order should they be stored so as to optimize act. Assume eachfile is accessed with the same frequency

A hash table with 10 buckets with one slot per bucket is depicted in fig. The symbols, S1 and S7 are initially entered using a hashing function with linear probing. The maximum number of comparisons needed in searching an item that is not present is

Consider the following Entity Relationship Diagram (ERD)


Which of the following possible relations will not hold if the above ERD is mapped into a relation model?

Consider the following log sequence of two transactions on a bank account, with initial balance 12000, that transfer 2000 to a mortgage payment and, then apply a 5% interest
(i) T1 start
(ii) T1 Bold = 12000 new = 10000
(iii) T1M old =0 new = 2000
(iv) Tl commit
(v) T2 start
(vi) T2Bold= 10000 new = 10500
(vii) T2 commit
Suppose the database system crashedjust before log record 7 is written. Whenthe system is restarted, which one statementis true of the recovery procedure?

Given a block can hold either 3 records or 10 key pointers. A database contains n records, then how many blocks do we need to hold the data file and the dense index

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

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?

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

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?

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 ε$$

Which statementis true?

In a lottery scheduler with 40 tickets, how we will distribute the tickets among 4 processes P1, P2, P3 and P4 such that each process gets 10%, 5%, 60% and 25% respectively?

A hard disk system has the following parameters:
Numberoftrack = 500
$$\frac{Numberof sectors}{track}$$ = 100
$$\frac{Numberof bytes}{sector}$$ = 500
Time taken by the head to move from one track to adjacent track = 1 ms
Rotation speed = 600 rpm
Whatis the average time taken for transferring 250 bytes from the disk?

If one uses straight two-way merge sort algorithm to sort the following elements in-~ ascending order : 20, 47, 25, 8, 9, 4, 40, 30, 12, 17, then the order of these elements after second passofthe algorithms is

What frequency range is used for microwave communications,satellite and radar?

In a class B subnet, we know the IP addressofone host and the mask as given below :
IP address = 125.134.112.66
Mask = 255.255.224.0
Whatis the first address (Network address)?

Which statement is false?

Which layers of the OSI reference model are host-to-host layers?

If in a software project the number of user input, user output, enquiries, files and external interfaces are (15, 50, 24, 12, 8), respectively, with complexity average weighing factor. The productivity if effort = 70 person-month is

Consider an uncompressed stereo audio signal of CD quality which is sampled at 44.1 kHz and quantized using 16 bits. What is required storage space if a compression ratio of 0.5 is achieved for 10 seconds of this audio?

The output of the following program is
main( )
{
static int x[] = {1, 2, 3, 4, 5, 6, 7, 8};
int i;
for (i = 2; i < 6; ++i)
x[x[i]] = x[i);
for (i = 0; i < 8; ++i)
printf(*%d", x[i]);
}

Consider the following statements
# define hypotenuse(a, b) sqrt (a*a + b*b);
The macro call hypotenuse (a+2, b+3);

Consider the following C declaration
struct {
short s[5];
union {
float y;
long z;
ju;
}t;
Assume that objects of type short, float and long occupy 2 bytes, 4 bytes and 8 bytes, respectively. The memory requirementfor variable t, ignoring alignment considerations,is

Join CAT 2026 course by 5-Time CAT 100%iler

Crack CAT 2026 & Other Exams with Cracku!