Find all the tuples having a temperature greater than ‘Paris’.(a) SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’(b) SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)(c) SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)(d) SELECT * FROM weather WHERE temperature > ‘Paris’ temperatureThe question was asked during an interview.My enquiry is from Basic SQL topic in division Laying the Foundation of SQL Server

Find all the tuples having a temperature greater than ‘Paris’.(a)

1.	Find all the tuples having a temperature greater than ‘Paris’.(a) SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’(b) SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)(c) SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)(d) SELECT * FROM weather WHERE temperature > ‘Paris’ temperatureThe question was asked during an interview.My enquiry is from Basic SQL topic in division Laying the Foundation of SQL Server
Answer» The correct answer is (a) SELECT * FROM WEATHER WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’ To elaborate: Subquery—also REFERRED to as an inner query or inner select—is a SELECT STATEMENT embedded within a DATA manipulation LANGUAGE (DML) statement or nested within another subquery.

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