MCQ Problem 1

Problem Statement

Consider the Employee table given below: E_id Name Age salary 201 Anita 23 9000 202 Swati 29 8000 203 Rajesh 34 6000 204 Scott 44 9000 205 Ramesh 35 8000 Which of the following SQL statements will execute successfully? I. SELECT name, age from Employee group by salary; II. SELECT DISTINCT name, age from Employee order by name; III. SELECT name, salary from Employee where age>20 group by salary; IV. SELECT name, salary from Employee where age>20 order by name; Only II and IV Only I, II and III Only II, III and IV Only I, II and IV Consider the query given below: Select translate ('ABC','CA','234') from dual; What will be the output of the query given above? 3B2 3C2 2A3 3A2 Consider the components given below: (I) FC Switches (II) FC Hubs (III) FC Drivers (IV) Host-Bus Adapters (HBA) Which of them are considered the SAN Software Components in this context? Only (I), (II) and (IV) Only (I) and (II) Only (III) and (IV) Only (I), (II) and (III) Which cloud feature allows computing res