a2zinterviews

SQL, PL/SQL&Oracle Questions

• What is OEM (Oracle Enterprise Manager)?
• What is integrity?
• What are integrity constants?
• What is fork?
• What is rollback?
• What is primary key?
• What is commit statement?
• What are different modes of parameters used in function and procedures?
• What is the difference between procedures and functions?
• How you will avoid duplicating records in a query?
• What is the use of cursor variables?
• What are the advantages of views?
• What is the subquery?
• What is referential integrity?
• What are the data types allowed in a table?
• What is correlated subquery?
• What are various constraints used in SQL?
• What is the difference between rename and alias?
• Can a primary key contain more than one columns?
• What is the difference between primary key and unique key?
• What are procedural langauges?
• What is grip command?
• What are triggers?
• What is acid properties?
• Compare and contrast Truncate and Delete for a table?
• Give two examples of referential integrity constants?
• What are oops concept in oracle?
• What are snap shots?
• What are mutating objects?
• What is clustered index?
• What are attribute cursor?
• What are record group?
• What is log switch?
• What are the types of user exits?
• What are the types of cursors?
• What is a stored procedure?
• What is pl/sql?
• What are the components of pl/sql?
• What are the uses of database triggers?
• What is a package?
• What is database buffers?
• What is redo log?
• What is the use of control file?
• What is synonym?
• What is an oracle sequence?
• What are the advantages of views?
• What is a tablespace?
• What is rollback segment?
• What is index cluster?
• Define transactions?
• What is a deadlock?
• What are roles?
• Difference b/w simple and complex snapshots?
• What is a data segment?