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

» Computer » SQL

Edit
MCQ▾

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

Edit

Appeared in Year: 2014

MCQ▾

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

Question number: 454

» Computer » MS-Excel

Edit
MCQ▾

Question

What term describes a background that appears as a grainy, non smooth surface?

Choices

Choice (4) Response

a.

Texture

b.

Velvet

c.

Gradient

d.

Pattern