Project Manager Questions


Q:

In 1990 a person is 15 years old. In 2000 that same person is 5 years old. How can this be possible?

Answer

 It can be possible in only B.C. i.e, Before Christ. That was about 2000 years ago.


 Given, 


 In 1990 B.C = 2000 + 1990 = 3990 years ago, a person is 15 years Old  


=> In 1995 B.C = 2000 + 1995 = 3995 years ago, the same person will be 10 years Old 


Therefore, In 2000 B.C = 2000 + 2000 = 4000 years ago, the same person will be 5 years Old.

Report Error

View answer Workspace Report Error Discuss

48 9631
Q:

Which dml command is used in conjunction with @@identity?

A) INSERT and UPDATE B) UPDATE and DELETE
C) SCOPE_IDENTITY and IDENT_CURRENT D) Commit and rollback
 
Answer & Explanation Answer: C) SCOPE_IDENTITY and IDENT_CURRENT

Explanation:

Using automatically incrementing IDENTITY columns is very popular with database developers. You don’t need to explicitly calculate unique surrogate keys when inserting new data, the IDENTITY column functionality does that for you. The IDENTITY feature also allows you to specify useful Seed and Increment properties. When you use an INSERT statement to insert data into a table with an IDENTITY column defined, SQL Server will generate a new IDENTITY value.

 

You can use the @@IDENTITY variable and the SCOPE_IDENTITY and IDENT_CURRENT functions to return the last IDENTITY value that has been generated by SQL Server. This is very useful when you need to return the key for the row that has just been inserted, back to the caller.

Report Error

View Answer Report Error Discuss

20 9423
Q:

Pipe K fills a tank in 30 minutes. Pipe L can fill the same tank 5 times as fast as pipe K. If both the pipes were kept open when the tank is empty, how much time will it take for the tank to overflow ?

A) 3 minutes B) 2 minutes
C) 4 minutes D) 5 minutes
 
Answer & Explanation Answer: D) 5 minutes

Explanation:

Let the total capacity of tank be 90 liters.
Capacity of tank filled in 1 minute by K = 3 liters.
Capacity of tank filled in 1 minute by L = 15 liters.
Therefore, capacity of the tank filled by both K and L in 1 minute = 18 liters.
Hence, time taken by both the pipes to overflow the tank = 90/18 = 5 minutes.

Report Error

View Answer Report Error Discuss

11 9176
Q:

Explain soundex() and metaphone() ?

Answer

soundex()
The soundex() function calculates the soundex key of a string. A soundex key is a four character long alphanumeric string that represent English pronunciation of a word. he soundex() function can be used for spelling applications.
< ?php
$str = "hello";
echo soundex($str);
? >


metaphone()
The metaphone() function calculates the metaphone key of a string. A metaphone key represents how a string sounds if said by an English speaking person. The metaphone() function can be used for spelling applications.
< ?php
echo metaphone("world");
? >

Report Error

View answer Workspace Report Error Discuss

42 8734
Q:

Word length of a personal computer is

A) 32 bit B) 16 bit
C) 8 bit D) 4 bit
 
Answer & Explanation Answer: C) 8 bit

Explanation:

Word length refers to the number of bits processed by a computer's CPU in one go. These days, typically 32 bits or 64 bits are used.

Data bus size, instruction size, address size are usually multiples of the word size.

Report Error

View Answer Report Error Discuss

11 8507
Q:

19 persons do 19 programs in 19 hours . If they take 15 mins interval and then how much time they need to do 52 programs.

A) 23 hours B) 47 hrs 15 min
C) 52 hrs 15 min D) 22 hrs 15 min
 
Answer & Explanation Answer: C) 52 hrs 15 min

Explanation:

Since they can do 19 programs in 19 hours, Then 52 programs in 52 hours respectively.
And a 15 min interval
Total time they take to do 52 programs is 52 hours 15 minutes.

Report Error

View Answer Report Error Discuss

11 8419
Q:

How many 3-digit numbers can be formed from the digits 2, 3, 5, 6, 7 and 9 which are divisible by 5 and none of the digits is repeated ?

A) 15 B) 20
C) 5 D) 10
 
Answer & Explanation Answer: B) 20

Explanation:

Since each number to be divisible by 5, we must have 5 0r 0 at the units place. But in given digits we have only 5.

 

So, there is one way of doing it.

 

Tens place can be filled by any of the remaining 5 numbers.So, there are 5 ways of filling the tens place.

 

The hundreds place can now be filled by any of the remaining 4 digits. So, there are 4 ways of filling it.

 

Required number of numbers = (1 x 5 x 4) = 20.

Report Error

View Answer Report Error Discuss

12 8175
Q:

Processor's speed of a computer is measured in

A) Hertz B) Baud
C) MIPS D) BPS
 
Answer & Explanation Answer: A) Hertz

Explanation:

CPU speed is the central factor in a computer's performance. And this CPU speed depends on the processor in the CPU chip. In a computer, clock speed refers to the number of pulses per second generated by an oscillator that sets the tempo for the processor. Clock speed is usually measured in Hertz (Hz).

 

But now-a-days, a pure processor's performance is measured in MIPS (Millions of Instructions Per Second). As here in the question, how a processor's speed is measured is asked and it is Hertz. 

 

Hence, Processor's speed of a computer is measured in Hertz(Hz) [MHz, GHz].

Report Error

View Answer Report Error Discuss

10 7691