PERSISTENT TECHNICAL PAPER July 2012 by Persistent

🌿 Buy LinBerlin Luxury Attars - 30% Off - Exclusively on Amazon Chocolate Attar (12ml) | Sweet & Long Lasting ₹349 M.R.P: ₹499 (30% off) Up to 5% back with Amazon Pay ICICI card White Oudh Attar - Alcohol-Free | Long Lasting Indian Attar for Men & Women ₹349 M.R.P: ₹499 (30% off) Up to 5% back with Amazon Pay ICICI card Chandan Attar (12ml) | Kesar Chandan & Sandal ₹349 M.R.P: ₹499 (30% off) Up to 5% back with Amazon Pay ICICI card Mitti Attar | Natural Indian Earth Fragrance ₹349 M.R.P: ₹499 (30% off) Up to 5% back with Amazon Pay ICICI card

1)On which maximum operations cannot be performed .Something like that

a)Array

b)Hash Table

c)Linked List

d)Heap

e)Binary Tree

2)A hash table has a sie of 11 and data filled in its position like{3,5,7,9,6}how many comparisons have

to be made if data is not found in the list in worst case

a) 2

b) 6

c) 11

d)

ANS:- 2

3)Forest with n Trees and having p edges then

a)n(1-p)

b) n = p +2

c) n-p+1

d)

e)

4)Find the shortest path from B to E

ANS: 7

one Question on Postfix.

2ndSECTION (C LANGAUGE)

1) what is int(*(*ptr (int))(void)

a)Pointer to function with no arguments(void) and return pointer to integer.

b)----

c)

2)func(char *s1,char * s2)

{

char *t;

t=s1;

s1=s2;

s2=t;

}

void main()

{

char *s1="jack", *s2="jill";

func(s1,s2);

printf("%s %s ",s1,s2);

}

OUTPUT jack jill

3) void main()

{

int a[5] ={1,2,3,4,5},i,j=2,b;

for (i =0;i 0 0

Find out the string

5th section General

1)Probability to find digits which not contain 7 between 100 to 999

Ans=18/25

2)Difference between Packet switching & Circuit Switching.

Ans= CS take more time to established circuit.

3)in cache memory 100ns an in main memory 1200ns what is the cache hit ratio(Question is not

exactly the same,but something related to cache hit ratio)

4)From the set {a,b,c,d,e,f} find no. of arrangements for 3 alphabets with no data repeated.

ANS=360. OR for 4 alpha ANS=720.

6th section (DBMS)

1)employee(eno,ename) works_on(eno,pno,ename) project(pno, project)

select ename from employee where eno in(select eno from works_on where pno =(select *from

project)

what is the output ?

a)Employee who works on all project.

b)Employee who works one project .

c) name of employee who works on more than one project.



2)Select ename from employee where salary = salary

3)what is the use of B-tree

a) has fixed index file size

b) is better for queries like < >=

c) searching will be easy

4)Question on inner Join returning N- tuples & Full outer Join returns M- tuples. For both Variables are

given & in options relationship is given to find whichever have greater tuples.And variable D is

given------

a)then N= M

b) N = M + D

5) To save space which option is better

a) write all join operation then select then project

b) write all join operation then projects then select

c)write all join operation then select between project

Test 2- Consist of Two Questions. In this we have to make a C program.

Q.1)Inward-spiral order matrix.i.e you have to traverse the matrix in clockwise manner and display the elements,for eg.

1 2 5 4

8 9 7 1

9 7 6 3

2 3 5 8

output should be 1, 2, 5, 4, 1, 3, 8, 5, 3, 2, 9, 8, 9, 7, 6, 7

Q.2)Consider a two dimensional array A[N][N] of the order n x n.Then you find the sub-squares and display the largest sum of the sub-square.Sub- squares are the contigious elements in the array.Largest sum can be find out by summing the elements in the sub-square