NCO- Cyber Olympiad (SOF) Class 12: Questions 13 - 16 of 520

Access detailed explanations (illustrated with images and videos) to 520 questions. Access all new questions- tracking exam pattern and syllabus. View the complete topic-wise distribution of questions. Unlimited Access, Unlimited Time, on Unlimited Devices!

View Sample Explanation or View Features.

Rs. 350.00 -OR-

How to register? Already Subscribed?

Question 13

Question

MCQ▾

Which of the following function used to perform a vertical look up in the left column and return a value in the same row from a column?

Choices

Choice (4)Response

a.

RAND ()

b.

LEN ()

c.

VLOOKUP ()

d.

MEDIAN ()

Question 14

Question

MCQ▾

The figures (i) and (ii) best a certain relationship. Identify and establish the similar relationship between figures (iii) and (iv) and select a figure from options which will replace the (?) in figure (iv) .

Problem Figure Shows (I) , (II) , (III) and (IV) Figures

Choices

Choice (4)Response

a.

Figure Shows Fourth Image in Problem Figures – Choice A

b.

Figure Shows Fourth Image in Problem Figures – Choice B

c.

Figure Shows Fourth Image in Problem Figures – Choice C

d.

Figure Shows Fourth Image in Problem Figures – Choice D

Question 15

Question

MCQ▾

Which of the following is the type of Transmission media?

Choices

Choice (4)Response

a.

Unguided Media

b.

Front Media

c.

Guided Media

d.

Both a. and c. are correct

Question 16

Question

MCQ▾

Which of the following SQL commands is CORRECT, if you want to display name and section of those students whose section is either A or C?

Choices

Choice (4)Response

a.

SELECT name, section FROM students WHERE section IN ( ‘A’ , ‘C’ ) ;

b.

SELECT name, section FROM students WHERE section BETWEEN ‘A’ AND ‘C’ ;

c.

SELECT name, section FROM students WHERE section LIKE ‘A’ and ‘C’ ;

d.

SELECT name, section FROM students WHERE section BETWEEN ( ‘A’ , ‘C’ ) ;