SAP Off Campus Hiring_ March 2015 Computer Skills

Q)What will be the output of the given code?

#include<stdio.h>
#include<conio.h>
void main()
   {
      clrscr();
      int a[5] = {1,2,3,4,5};
       for(int i = 0; i< 5;i+2)  
          printf("%d" ,i++[a]);
          printf(",%d",i);
           getch();
}
2 4 6 ,6
1 4 ,6
1 2 3 4 5 ,5
Compiler Error
None of these

Q)A contents of a file are "I love computer\r\n". The file is read using fgets() and the result is stored in array buff.
What does buff contain?

"I love computer"
"I love computer\n\0"
"I love computer\r\0"
"I love computer\r\n\0"

Q)If the description of function is "input the quantity, validate that the quantity is greater than 1, subtract 1 from the quantity, and print the quantity," the function is:

sequentially cohesive
logically cohesive
communicationally cohesive
functionally cohesive

Q)In which statements, does a 'continue' statement cause the control to go directly to the test condition and then continue the looping process?

for' and 'while'
while' and 'if-else'
do-while' and 'if-else'
while' and 'do-while'
None of the above

Q)The complexity of binary search algorithm is:

O(n 2)
O(n log n)
O(n)
O(log n)
Clear Response

Q)Which of the following is correct way of establishing self referencing foreign key in a table EMP where Manager column is a foreign key referring Epcode column ?

Create table emp
( Epcode number(4) ,
   manager number(4) references epcode,
);

Create table emp
( Epcode number(4) primary key ,
   manager number(4) references epcode,
);

Create table emp
( Epcode number(4) primary key ,
   manager number(4) references emp,
);

Create table emp
( Epcode number(4) ,
   manager number(4) references emp,
);

Q8) Below relation conforms to which of the following normal forms

1
SALES TABLE
2

3
P_CODE | S_CODE |     DATE     | STATUS
4
-----------------------------------------------
5
1                     3               01-01-14        P
6
2                     3               07-02-14        P
7
3                     1               22-01-14        S
8
4                     2               15-01-14        P

9
Consider (P_CODE, S_CODE) forms the composite key for sales relation.

1NF
2NF
3NF
None of these

Q9)Consider W-Timestamp(Q) and R-Timestamp(Q) are the maximum timestamps of any transaction that executed Write and Read on Q respectively.
Suppose a Transaction T issues Read(Q)
if Timestamp(T) <= W-timestamp(Q) then which of the following is true in timestamp based protocol ?

Read operation is rejected
Read operation is executed
Depends on R-Timestamp(Q)
Deadlock will occur


Q10)Identify the invalid value for a primary key field?

Blank
134689
JoeSmith44
All of the above