what will happen if you query the emp table shown below select..., Oracle SQL 9i, Databases

Test
- Model Test
Index

Question:What will happen if you query the emp table shown below:
select empno,DISTINCT ename,Salary from emp;

A EMPNO ,unique value of ENAME and then SALARY are Displayed. 
B EMPNO ,unique value of the two columns, ENAME and salary are displayed. 
C DISTINCT is not a valid keyword in SQL. 
D No values will be displayed because the statement will return an error

/45

+ AnswerD

+ Report

Descriptive on Oracle SQL 9i Ebook

Total Preview: 9323

Question:What will happen if you query the emp table shown below: select empno,DISTINCT ename,Salary from emp;

A EMPNO ,unique value of ENAME and then SALARY are Displayed.

B EMPNO ,unique value of the two columns, ENAME and salary are displayed.

C DISTINCT is not a valid keyword in SQL.

D No values will be displayed because the statement will return an error

D