Company: Deloitte_MCQ_5_feb_
Difficulty: medium
Refer to the following Employee table: 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 these SQL statements would run without throwing an error? 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 Look at the query below: Select translate ('ABC','CA','234') from dual; What does this query produce as output? 3B2 3C2 2A3 3A2 Given the components listed below: (I) FC Switches (II) FC Hubs (III) FC Drivers (IV) Host-Bus Adapters (HBA) Which of these count as 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 capability of cloud infrastructure lets compute capacity grow