Sample Questions to test ORACLE
Knowledge
1)which of the following
statements are DML Statements?
1.select
2.create
3.Truncate
4.commit
ans :1
2)char datatype "hhh"=="hhh "
what is the result?
1.true
2.false
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