• Placement Questions

Frequently Asked Interview Questions and Answers

(#M40154229) AMCAT QUESTION Computer science Keep an EYE

Akshit works in a bank and has a database containing 3tables namely- Saving_accnt(cid, accnt_no, owner, balance} and, Current_accnt(cid, accnt_no_owner, balance} and Customer(cid, accnt_no}. He has a meeting with his manager and he needs to show details of a customer who has a savings account as well as a current
account in the bank.

Which of the following queries should he use to solve the purpose,if a is the alias for the Saving_accnt table and b is for Current_accnt table?

1) SELECT a.cid, a.accnt_no, a.owner, a.balance FROM Saving_accnt a INNER JOIN Current_accnt b ON a.cid=b.cid;
2) SELECT a.cid, a.accnt_no, a.owner, a.balance FROM Saving_accnt a OUTER JOIN Current_accnt b ON a.cid=b.cid;
3) SELECT a.cid,a.accnt_no, a.owner,a.balance FROM Saving_accnt a CROSS JOIN Current_accnt b ON a.cid=b.cid;
4) SELECT a.cid, a.accnt no,a.owner,a.balance FROM Saving_accnt a LEFT INNER JOIN Current_accnt b ON a.cid=b.cid;

Asked In AMCAT dhritiman (10 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (287)   (245) Submit Your Solution

(#M40154421) AMCAT QUESTION Data strctures Keep an EYE

Aparajita wants to make a function that is not bound to any identifier. Which of the foflowing functions should she incorporate in her program?
Options are :

1)Anonymous Function
2)Friend Function
3) Null Function
4)Global Function

Asked In AMCAT dhritiman (9 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (39)   (22) Submit Your Solution

(#M40154522) AMCAT QUESTION Computer Science and Computer Programming Keep an EYE

If the time taken by a person sitting at a counter to interact with a customer is ti and average time interval of arrival of new customer at the counter is t2, then under which of the following conditions will there be a requirement of a queue?
1)t1>t2
2)tl

Asked In AMCAT dhritiman (9 years ago)

Unsolved

Is this Puzzle helpful?   (80)   (54) Submit Your Solution

(#M40154407) AMCAT QUESTION Data strctures Keep an EYE

A pseudocode is used which is self explainatory
union Myunion
(
structure MyStructure
{
Integer m
Float n
Character o
}Mystr
Interger p
}MyUn
Given that the size of integer is 2 units, float is 4 units and character Is 1 unit, what will be the amount of memory occupied character by the MyUn object?
1)2 units
2)6 units
3)7 units
4)9 units

Asked In AMCAT dhritiman (9 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (230)   (196) Submit Your Solution Arrays

(#M40154534) AMCAT QUESTION Computer Science and Computer Programming Keep an EYE

Ananya has a Linked List with 10 eIements Using an algorithm, she has currently accessed 6 elements with her pointer now pointing to the 7th element. She wants to insert a node after the 7th node What will be the time taken to bring out the same?
1)O(1)
2)O(n)
3)O(log n)
4) n O(logn)

Asked In AMCAT dhritiman (9 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (129)   (85) Submit Your Solution

(#M40154403) AMCAT QUESTION Data strctures Keep an EYE

Sneha uses a runtime environment in which a program runs slowly for the first few minutes and then after that executes quickly .Which of the following options is true regarding the involved environment?

Options are;

1)The environment uses dynamic compilation
2)The environment uses static compilation
3)The program involves functioning on pointers
4) Information not enough to comment about the environment

Asked In AMCAT dhritiman (9 years ago)

Unsolved Read Solution (3)

Is this Puzzle helpful?   (172)   (106) Submit Your Solution

(#M40154396) AMCAT QUESTION Data strctures Keep an EYE

Grace writes a recursive algorithm .But she forget to add a termination condition and hence entered an infinite recursion The situation will result in to which of the following situations.
Options :
1)Overflow of running stack
2)Underflow of running stack
3)Underflow of usage of registers
4)Overflow of memory I/O

Asked In AMCAT dhritiman (9 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (67)   (47) Submit Your Solution

(#M40154532) AMCAT QUESTION Computer Science and Computer Programming Keep an EYE

Integer num,reverse=0,n
Input num
n=num
While(n!=0)
{
//missing statement
num=num/10
}
Radha wants to reverse a number using the following code
What would be the missing statement in the code

1)reverse=reverse*10 +num %10
2) reverse=reverse +num %10
3) reverse=reverse*10 +num
4)reverse=reverse*10 +num/10

Asked In AMCAT dhritiman (9 years ago)

Unsolved Read Solution (2)

Is this Puzzle helpful?   (38)   (10) Submit Your Solution

(#M40154402) AMCAT QUESTION Data strctures Keep an EYE

Code:

for integer i = 0 to M*N* O increment 1
{
//missing statement
}


A pseudo-code is used which is self explanatory
// in pseudo code refers to comment
// missing statement

Which of the following statements shall read a multidimensional Array MyArr, with the dimensions given as M * N *0 as stored in the memory i.e., reading the elements in consecutive order?
1) print (*((int* )MyArr + i))
2) print (*((int)* MyArr + i))
3) print (*((int *)MyArr))
4) print ((int* )MyArr +i)

Asked In AMCAT dhritiman (9 years ago)

Unsolved

Is this Puzzle helpful?   (129)   (77) Submit Your Solution Output

(#M40154925) TCS QUESTION Apti Keep an EYE

The price of a commodity (in rupees per kilogram) is 100+ 0.1 n . ln. on the nth day of 2007 (a = 1, 2,-----, 100).
and then remains constant. On the other hand. the price of another commodity (in rupees per kilogram) is 89+
0.15n on the nth day of 2007 (n = 1,2 ,---------,365). On which date in 2007. will the prices of these two commodities be equaP


options are
April 11 /May 20/ April 10 /May 21

Asked In TCS dhritiman (9 years ago)

Unsolved Read Solution (3)

Is this Puzzle helpful?   (6)   (4) Submit Your Solution Arithmetic