Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.3 Which of the following statements are correct about the WHERE clause? A. Column Alias can be used in WHERE clause to refer a column

image text in transcribed

1.3 Which of the following statements are correct about the WHERE clause? A. Column Alias can be used in WHERE clause to refer a column B. Comparison operator is an optional element in WHERE clause condition C. Functions can be used as operands in the WHERE clause D. There can be multiple WHERE clause in a SELECT query 1.4 Which of the following is true about the SQL query given below? Select COL1, COL2 From TABLE Where COL1 = 'A' ORDER BY COL2 DESC, COL1; A. It will display the row which has the COL1 value as 'A' ordered by the COL1 in the descending order and then COL2 in the descending order. B. The ORDER BY clause will not work as the keyword DESC should be always written in the end of the ORDER BY clause and not in between as given in the query. C. The above query will be sorted in descending order based on COL2 only and the use of COL1 in the ORDER BY clause will be discarded. D. It will display the row which has the COL1 value as 'A' ordered by the COL1 and then followed by COL2 as the execution of the ORDER BY clause happens from the order of columns in the SELECT statement

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 Universal Database V7.1 Application Development Certification Guide

Authors: Steve Sanyal, David Martineau, Kevin Gashyna, Michael Kyprianou

1st Edition

0130913677, 978-0130913678

Students also viewed these Databases questions