Find the temperature in increasing order of all cities(a) SELECT city FROM weather ORDER BY temperature;(b) SELECT city, temperature FROM weather;(c) SELECT city, temperature FROM weather ORDER BY temperature;(d) SELECT city, temperature FROM weather ORDER BY city;I had been asked this question during a job interview.Enquiry is from Structured Query Language topic in portion SQL Basics of Oracle

Find the temperature in increasing order of all cities(a) SELECT city

1.	Find the temperature in increasing order of all cities(a) SELECT city FROM weather ORDER BY temperature;(b) SELECT city, temperature FROM weather;(c) SELECT city, temperature FROM weather ORDER BY temperature;(d) SELECT city, temperature FROM weather ORDER BY city;I had been asked this question during a job interview.Enquiry is from Structured Query Language topic in portion SQL Basics of Oracle
Answer» <html><body><a href="https://interviewquestions.tuteehub.com/tag/correct-409949" style="font-weight:bold;" target="_blank" title="Click to know more about CORRECT">CORRECT</a> answer is (c) <a href="https://interviewquestions.tuteehub.com/tag/select-630282" style="font-weight:bold;" target="_blank" title="Click to know more about SELECT">SELECT</a> city, temperature FROM <a href="https://interviewquestions.tuteehub.com/tag/weather-1450884" style="font-weight:bold;" target="_blank" title="Click to know more about WEATHER">WEATHER</a> ORDER BY temperature;<br/><br/>To explain I would say: SELECT column_name, aggregate_function(column_name)<br/><br/> FROM table_name<br/><br/> WHERE column_name <a href="https://interviewquestions.tuteehub.com/tag/operator-1137101" style="font-weight:bold;" target="_blank" title="Click to know more about OPERATOR">OPERATOR</a> value<br/><br/> <a href="https://interviewquestions.tuteehub.com/tag/group-1013370" style="font-weight:bold;" target="_blank" title="Click to know more about GROUP">GROUP</a> BY column_name<br/><br/> HAVING aggregate_function(column_name) operator value<br/><br/> ORDER BY ; <br/><br/>So base on [SELECT city, temperature FROM weather ORDER BY temperature;] this will be the correct answer.</body></html>

Discussion

No Comment Found

Related InterviewSolutions

_________commands in SQL allow controlling access to data within database.(a) Database(b) Data(c) Data control(d) All of the MentionedThe question was asked by my college professor while I was bunking the class.I want to ask this question from DCL,TCL Command topic in division SQL Basics of Oracle
A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________(a) DCL(b) DML(c) DDL(d) All of the MentionedThis question was posed to me in a job interview.This question is from DCL,TCL Command in division SQL Basics of Oracle
To obtain the structure of an Oracle table, the command to use is:(a) STRUCTURE [TableName].(b) DESCRIBE [TableName].(c) DESCRIBE STRUCTURE [TableName].(d) DESC TABLE [TableName].The question was posed to me in class test.My query is from DCL,TCL Command in section SQL Basics of Oracle
The Database Language That Allows You To Access Or Maintain Data In A Database(a) DCL(b) DML(c) DDL(d) All of the MentionedThe question was asked in class test.I'm obligated to ask this question of DCL,TCL Command topic in portion SQL Basics of Oracle
A transaction completes its execution is said to be(a) Committed(b) Aborted(c) Rolled back(d) FailedThe question was posed to me in semester exam.This intriguing question originated from DCL,TCL Command topic in division SQL Basics of Oracle
Which of the following keyword is used with Data Control Language (DCL) statements?(a) SELECT(b) INSERT(c) DELETE(d) GRANTI have been asked this question in an online interview.This key question is from DCL,TCL Command in chapter SQL Basics of Oracle
DCL Provides Commands To Perform Actions Like _____________(a) Change The Structure Of Tables(b) Insert, Update Or Delete Records And Data Values(c) Authorizing Access And Other Control Over Database(d) None of the MentionedThe question was asked in my homework.This intriguing question comes from DCL,TCL Command in portion SQL Basics of Oracle
In an SQL statement, which of the following parts states the conditions for row selection?(a) Where(b) From(c) Order By(d) Group ByThis question was addressed to me in final exam.I would like to ask this question from DCL,TCL Command topic in chapter SQL Basics of Oracle
A type of query that is placed within a WHERE or HAVING clause of another query is called(a) Master query(b) Sub query(c) Super query(d) Multi-queryI had been asked this question in a job interview.This is a very interesting question from DML Command in chapter SQL Basics of Oracle
TCL stands for:(a) Transaction control languages(b) Transaction command languages(c) Transaction connect languages(d) None of the MentionedThis question was posed to me in an online quiz.My question is based upon DCL,TCL Command in section SQL Basics of Oracle

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment