1.)which of the following statements are DML Statements?

1.select
2.create
3.Truncate
4.commit

ans :1

3)select distinct empid,empname from employees

will this query execute?

1.true
2.false

ans:1

explanation: when using distinct keyword uniqueness is verified against the complete row

4)Dual table has how many colums and rows?

1. 1 and 1
2. 0 and 1
3. 1 and 0
4. 0 and 0


ans : 1

5)select empname from employess empname like 'jack%';

what are the values given below can be returned by the query?

1.jackson and sonjack
2.jackson
3.sonjack
4.none fo the above

ans :2

6).what is the default beahaviour of order by?

1.ascending order
2.descending order

ans:1

7)Null values will appear in the top of the result when using ascending order by?

1.true
2.false

ans:2

8)Group by statement can appear after order by ?

1.true
2.false

ans:2

9)Column alias name can be used for where clause ?

1.true
2.false

ans :2

10.where clause can not appear after group by clause?

1.true
2.false

ans:1

                                                       Go To Index