Multiple choice

Which of he following is the correct SQL statement to select ENAME, SAL and a virtual column 10% INCREASED SAL from emp table?

  1. Select ENAME, SAL, SAL* 0.1 10% INCREASED SAL from emp;

  2. Select ENAME, SAL, SAL* 10 10% INCREASED SAL from emp;

  3. Select ENAME, SAL, SAL* 0.01 '10% INCREASED SAL' from emp;

  4. Find ENAME, SAL, SAL* 0.1 10% INCREASED SAL from emp;

  5. Seek ENAME, SAL, SAL* 0.1 10% INCREASED SAL from emp;
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This is the correct SQL statement to find the specified fields with the virtual column.

Keep practicing — related questions