NCO- Cyber Olympiad (SOF) Class 12: Questions 452 - 454 of 520
Access detailed explanations (illustrated with images and videos) to 520 questions. Access all new questions we will add tracking exam-pattern and syllabus changes. Subscription can be renewed yearly absolutely FREE! View Sample Explanation or View Features.
Rs. 350.00 or
How to register?
Question number: 452
Question
Which of the following SQL code is CORRECT, if you want to show the average salary for all the departments with more than 2 people for a job from the table named emp?
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | Select AVG (sal) from emp where COUNT ; |
|
| b. | Select AVG (sal) from emp GROUP BY (empno) AND COUNT ; |
|
| c. | Select AVG (sal) from emp GROUP BY (empno) where COUNT ; |
|
| d. | Select AVG (sal) from emp GROUP BY deptno HAVING COUNT (empno) ; |
|
Question number: 453
» Logical and Analytical Reasoning » Analogy and Classification
Appeared in Year: 2014
Question
P, Q, R, S, T, V and W are seven friends who left for seven different destinations – Delhi, Chennai, Hyderabad, Bangalore, Kolkata, Chandigarh and Jaipur – each one on a different day of the week. R left for Jaipur on Monday. On the last day of the week, which was a Sunday, the person left for Bangalore. T left the next day of P, who left for Chandigarh and on the previous day of W. S left for Kolkata on Friday. Q did not leave for either Hyderabad or Bangalore and W left for Delhi. Which of the following combinations of person-place is not correct? (Week begins with Monday) (SET-B)
Choices
| Choice (4) | Response | |
|---|---|---|
| a. | P – Chandigarh |
|
| b. | R – Jaipur |
|
| c. | T – Hyderabad |
|
| d. | All a. , b. and c. are correct |
|