IMPORTANT SQL QUESTIONS

1)      List various data types available in oracle. Explain it.

2)      What is constraint? List various constraints. Explain Primary Key.

3)      Explain referential integrity constraint. (F.K.)

4)      Explain business constraint.( check constraint )

5)      Explain various types of joins in oracle.

6)      Explain index and its types in detail.

7)      What is view? Explain views in detail.

8)      Explain sequence with example.

9)      Explain synonym.

10)  Explain group by and having with example.

11)  Explain union, intersect and minus.

12)  List various types of functions available in oracle. Explain aggregate function(group functions : avg,min,max,count,sum,greatest,least).

13)  Explain string functions. (lower, upper, initcap, substr, length, ltrim, rtrim, lpad, rpad, instr, soundex)

14)  Explain numeric functions. (abs,ceil,floor,mod,power,round,sign,sqrt,trunc,cos,sin,tan,log,ln)

15)  Explain date functions. (add_months, last_day, months_between, next_day)

16)  Explain conversion functions. (to_number, to_date, to_char)

17)  List various collection types. Explain any one. (Varray, Nested table, PL/SQL table).

18)  Explain grant and revoke. Explain role.

Read More

IMPORTANT PL/SQL QUESTIONS

1)      Explain the PL/SQL block structure.

2)      Explain advantages of PL/SQL.

3)      List the special data types of PL/SQL and explain it. (%TYPE & %ROWTYPE)

4)      What is cursor? Explain in detail.

5)      Explain parameterized cursor.

6)      Explicit cursor handling using for loop.

7)      Advantages of using procedure and function.

8)      Explain procedure with example.

9)      Explain function with example.

10)  Explain trigger in detail.

11)  Explain types of triggers.

12)  Explain package.

13)  Explain error handling in PL/SQL.

14)  Explain named exception handlers.

15)  Explain user defined exception handlers.

16)  Explain types of Locks and level of Locks.

17)  Explain concurrency control in oracle with its implementation method. (OR explain Locks.).

18)  Explain if condition, For loop, While loop and goto statement.

Read More

ORACLE ARCHITECTURE

1)      State E.F.Codds’s 12 rules of RDBMS.

2)      What is database? Explain processes.

3)      Explain database support processes (or server processes).

4)      List and explain oracle background processes.

5)      Define blocks, segments and extents.

6)      Explain control files and redo log files.

7)      Explain types of tablespace in oracle.

8)      Explain initialization parameter (or init.ora) file.

9)      The logical and physical structure of oracle database.

10)  List and explain responsibilities of DBA.

11)  Explain oracle instance.

12)  Explain oracle memory structure.

13)  Explain SGA with its components.

14)  Explain PGA.

15)  Explain difference between DDL and DML.

16)  Explain E-R diagram and types of relationship.

17)  What is Entity? Explain type of relationship between entities with diagram.

18)  What is transaction? Explain with a facility to undo the changes.

19)  Explain SQL*Loader.

20)  Explain IMPORT & EXPORT facility in oracle.

Read More