Explain the use of grant option in exp command.
Query to retrieve record for a many to many relationship ?
What is redo log?
How to omit columns with default values in insert statement in oracle?
definition of cluster and non-clustered index?
What happens if the imported table already exists?
what r routers?
Please explain compound trigger in oracle?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
What is concurrency in oracle?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
WHT ARE THE AGGREATE FUNCTIONS?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...