Un-Answered Questions { Oracle General }

What is the difference between $oracle_base and $oracle_home?

574


State and explain the different types of data models?

525


What is key preserved table?

554


What is a sub query and what are the different types of subqueries?

612


What are the different pseudo commands? Explain in general?

534


Explain the different normalization forms?

583


State the various uses of dbcc command?

539


What are a collation and state the different types of collation sensitivity?

543


State the difference between a primary key and foreign key?

506


What are the different types of trigger and explain its various uses and functions?

540


Explain about functional dependency and its relation with table design?

543


Explain about your project and its relation to the current job position you are applying to?

530


What are privileges and grants?

562


How to display row numbers with the records?

574


What are the uses of linked server and explain it in detail?

580