Qtr No. 213, New Town Yehlanka Indore 454775
Consider the table recover with below data.
recover:
rid | size | data
-----+-----------+-----------
1 | 20 GB | Ram data
2 | 20 GB | Hard disk
3 | 120 GB | Hard disk
4 | 20 GB | Ram Data
5 | 20 GB | Hard disk
Match the following query with the output given below.
Queries:
i) select distinct(size), data from recover;
ii) select size,data from recover where data like '%d%';
iii) select distinct on(size)size,data from recover;
Output:
a. size | data
---------+-----------
20 GB | Ram data
20 GB | Hard disk
120 GB | Hard disk
20 GB | Hard disk
b. size | data
--------+-----------
120 GB | Hard disk
20 GB | Ram data
c. size | data
--------+-----------
20 GB | Ram data
20 GB | Hard disk
20 GB | Ram Data
120 GB | Hard disk
i) -> a, ii) -> b, iii) ->c
i) -> c, ii) -> a, iii) ->b
i) -> b, ii) -> a, iii) ->c
i) -> c, ii) -> b, iii) ->a
To get all Infosys Certified PostgreSQL Associate Exam questions Join Group https://bit.ly/infy_premium_group
We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.
Qtr No. 213, New Town Yehlanka Indore 454775
admin@prepflix.in
