1) What is NVL and NVL2 Functions?
2) What is NULLIF and COALESCE Functions?
3) What is TRANSLATE and RELACE Functions?
4) What is SUBSTR and INSTR Functions?
5) What is CASE and DECODE?
6) What is ON DELETE CASCADE and ON DELETE
SET NULL?
7) What is View and what is FORCE option in
view?
8) What is Mview and what are the advantages
of MVIEW.
9) Copy a structure of a table without
records?
10) If two structure are same and one table in
having data how to insert the data into empty
table?
table?
11) How to display only duplicate rows?
12) How to display nth highest salary?
13) What are the sudo columns?
14) What is difference between IN and EXISTS?
15) Difference between Union and Union ALL.
16) What are the types of joins.
17) What is rownum and rowid.
18) When using index can be more expensive?
types of indexes.
No comments:
Post a Comment