R

Ram Sharma • 193.86K Points
Coach 

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

  • (A) SELECT * FROM weather WHERE temperature > ‘Paris’ temperature
  • (B) SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)
  • (C) SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)
  • (D) SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’
  • Correct Answer - Option(D)
  • Views: 153
  • Filed under category SQL Server

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on SQL Server

Q. Which of these identifies a query plan uniquely for any batch that has been executed and whose plans reside in our plan cache?

Q. Which of the following is not a mathematical function ?

Q. If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ______________

Q. Which of the following is used to overcome the Replication in SQL Server?

Q. What will be the output of the following code?

Q. LocalDB was introduced in which of the following versions of SQL Server ?

Q. Which of these commands would defragment the clustered as well as the secondary indexes of any given specified table?

Q. In which database state, the database is in single-user mode and may be repaired or restored.

Q. Ctrl+K+K shortcut refers to ___________

Q. T-SQL provides enhancement regarding

Learn All SQL Server MCQs

Question analytics