If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the out

Question

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?SELECT emp_idFROM personORDER BY emp_id DESC;

Options:

A . {9, 7, 6, 4, 3, 1, 2}

B . {1, 2, 3, 4, 6, 7 , 9}

C . {2, 1, 3, 4, 6, 7, 9}

D . None of the mentioned

Answer: Option A

Submit Your Solution Below and Earn Points !

Next Question

Submit Solution

More Questions on This Topic :

Question 1. Is there any error in the following query?SELECT emp_id, title, start_date, fname, fed_idFROM personORDER BY RIGHT (fed....emp_id, title, start_date, fname, fed_idFROM personORDER BY RIGHT (fed_id, 3);

Question 2. What will be the output of a query given below?SELECT person_id, Fname, lnameFROM person; ....

Question 3. What will be the result of the query given below?SELECT emp_id,'ACTIVE' AS STATUS,emp_id * 3.14 AS emp_pi,UPPER (lname)....AS STATUS,emp_id * 3.14 AS emp_pi,UPPER (lname) AS last_nameFROM employee;

Question 4. What will be the output of the query given below?SELECT emp_id, fname, lnameFROM employeeWHERE title='HEAD TELLER' AND ....given below?SELECT emp_id, fname, lnameFROM employeeWHERE title='HEAD TELLER' AND start_date=2008-11-24;

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI

Tabulation - Test Paper 2 Data Interpretation Reasoning & DI

Test Paper 1 Direction Sense Test Reasoning & DI

ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0

GFM Combined 1 Free Revision Test SAIL JO E-0

Submit Solution

More Questions on This Topic :

Latest Videos

Latest Test Papers