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