SQL query to 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 cityThe question was asked at a job interview.Query is from Basic SQL topic in chapter Laying the Foundation of SQL Server

SQL query to find the temperature in increasing order of all cities.(a

1.	SQL query to 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 cityThe question was asked at a job interview.Query is from Basic SQL topic in chapter Laying the Foundation of SQL Server
Answer» Right option is (d) SELECT CITY, temperature FROM WEATHER ORDER BY city Explanation: The ORDER BY keyword SORTS the RECORDS in ascending order by default.

Discussion

No Comment Found

Related InterviewSolutions

Which of the following command is used to get child items in powershell?(a) Get-Child(b) Set-Alias(c) Get-Command(d) Get-ChildItemThe question was posed to me in an interview.My query is from Powershell in section Laying the Foundation of SQL Server
We can test for the nonexistence of tuples in a subquery by using the __________ construct.(a) Not exist(b) Not exists(c) Exists(d) ExistThe question was asked by my school teacher while I was bunking the class.I want to ask this question from Aggregation of Data topic in section Laying the Foundation of SQL Server
Which of the following is not an aggregate function?(a) Avg(b) Sum(c) With(d) MinI got this question during an interview.My question is based upon Aggregation of Data in chapter Laying the Foundation of SQL Server
The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.(a) In(b) Lateral(c) Having(d) WithThe question was posed to me in a job interview.Enquiry is from Aggregation of Data topic in division Laying the Foundation of SQL Server
SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.(a) Group by(b) With(c) Where(d) HavingI got this question in an online quiz.My doubt stems from Aggregation of Data topic in section Laying the Foundation of SQL Server
Aggregate functions are functions that take a ___________ as input and return a single value.(a) Collection of values(b) Single value(c) Double value(d) All of the mentionedI had been asked this question by my school principal while I was bunking the class.My question is taken from Aggregation of Data topic in division Laying the Foundation of SQL Server
___________ isstored only in the Master database.(a) Database-scoped Dynamic Management View(b) Complex View(c) Catalog View(d) None of the mentionedThe question was posed to me in an interview.I need to ask this question from Views topic in division Laying the Foundation of SQL Server
Which of the following is not a SQL Server INFORMATION_SCHEMA view?(a) INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE(b) INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS(c) INFORMATION_SCHEMA.KEY_COLUMN_USAGE(d) sys.dm_exec_connectionsI had been asked this question in an internship interview.I'd like to ask this question from Views topic in portion Laying the Foundation of SQL Server
What is SCHEMABINDING a VIEW?(a) Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view(b) These are stored only in the Master database(c) These types of view are defined by users on a specified schema(d) These are used to show database self describing informationI got this question during an interview.Origin of the question is Views topic in section Laying the Foundation of SQL Server
You can delete a view with ___________ command.(a) DROP VIEW(b) DELETE VIEW(c) REMOVE VIEW(d) TRUNCATE VIEWThis question was posed to me by my school principal while I was bunking the class.My question is based upon Views in division Laying the Foundation of SQL Server

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment