| Other Oracle General Interview Questions |
|| Asked @
|What is the diff between Oracle and SQL Server
|Does a Before form trigger fire when the parameter form is
|select * from emp
what happened internally when we write this query in the sql
|I have my backup RMAN script called backup_rman.sh. I am on
the target database. My catalog username/password is
rman/rman. My catalog db is called rman. How would you run
this shell script from the O/S such that it would run as a
|26. Display the earliest shipping date in the format:
|where we have to use ON clause and where we have to use USING
clause in JOINS
|how to use sequence and what use of sequence cache
|1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.
|What are the types of Database Links ?
|What is different bet native dynamic sql and Dbms_Sql?
|We need to compare two successive records of a table based
on a field. For example, if the table is CUSTOMER, and the
filed is Account_ID, To compare Account_IDs of record1 and
record2 of CUSTOMER table, what can be the query ?
|1. How actually index will work ?
2. Why do people prefer mostly bitmap index and btree index
in datawarehouse ?
3. If I use the column in aggrigate functions like
max,min,count and avg and if I have a index created on that
column, will it increases the performance ?
|For more Oracle General Interview Questions Click Here |