Searching for "select"

Q:

Ajay and his wife Reshmi appear in an interview for two vaccancies in the same post. The Probability of Ajay's selection is 1/7 and that of his wife Reshmi's selection is 1/5. What is the probability that only one of them will be selected?

A) 5/7 B) 1/5
C) 2/7 D) 2/35
 
Answer & Explanation Answer: C) 2/7

Explanation:

P( only one of them will be selected) = p[(E and not F) or (F and not E)] 

 = PEFFE 

 

PEPF+PFPE

 

 =17×45+15×67=27

Report Error

View Answer Report Error Discuss

Filed Under: Probability
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Bank Clerk , Bank PO

Q:

In How many ways is it possible to make a selection by taking any number of 15 fruits, namely 3 oranges, 5 apples and 7 mangoes?

A) 131 B) 191
C) 68 D) 3720
 
Answer & Explanation Answer: B) 191

Explanation:

Out of 15 fruits, 7 are alike of one kind, 5 are alike of a second kind and 3 are alike of a third kind.

Hence, the required number of ways = [ (7+1) (5+1) (3+1) -1] =191

Report Error

View Answer Report Error Discuss

Q:

The following question consist of two words each that have a certain relationship to each other, followed by lettered pairs of words . Select the lettered pair that has the same relationship as the original pair of words. 

Proscenium : Stage

A) Lamp : Table B) Lines : Bed
C) Portico : House D) Compass : Needle
 
Answer & Explanation Answer: C) Portico : House

Explanation:

First is a part of the second.

Report Error

View Answer Report Error Discuss

Filed Under: Analogy

Q:

If I call performSelector:withObject:afterDelay: – is the object retained?

Answer

Yes the object is retained. It creates a timer that calls a selector on the current threads run loop. It may not be 100% precise time-wise as it attempts to dequeue the message from the run loop and perform the selector.

Report Error

View answer Workspace Report Error Discuss

Q:

How to select more than one option from list in android xml file? Give an example.

Answer

Specify android id, layout height and width as depicted in the following example.


<ListView android:id="@+id/ListView01" android:layout_height="wrap_content" android:layout_width="fill_parent"></ListView>

Report Error

View answer Workspace Report Error Discuss

Q:

Why SELECT * is not preferred in embedded SQL programs?

Answer

- If the table structure is changed ( a field is added ), the program will have to be modified.


- Program might retrieve the columns which it might not use, leading on I/O over head.


- The chance of an index only scan is lost.

Report Error

View answer Workspace Report Error Discuss

Q:

My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?

Answer

Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.


 

Report Error

View answer Workspace Report Error Discuss

Q:

How do you eliminate duplicate values in DB2 SELECT?

Answer

Use SELECT DISTINCT ..... in DB2 query


 


The DISTINCT keyword can be used to return only distinct (different) values.


Syntax:


     SELECT DISTINCT column1,column2


      FROM table_name;


 

Report Error

View answer Workspace Report Error Discuss