GeekInterview Latest Oracle Interview Questions Updates

Problem with Utlfile.fopen - Hi,There is problem with ultfile.fopen. When I run from the server side,

Problem with Utlfile.fopen - Hi,There is problem with ultfile.fopen. When I run from the server side, there is no issue with utlfile and it is working fine.If I run the same procedure from Client machine, I am facing problem. It throws an exception...
Answer Question
Asked by : Ananth.p | Last Updated On : May 12, 2008
Filed in : PL/SQL Interview Questions

Oracle Forms - Read Data and compare with sysdate - i want to retrieve data from table where apply date

Oracle Forms - Read Data and compare with sysdate - i want to retrieve data from table where apply date field from table which likedate = sysdate,so i not got a data , what i doe.g.select date from abc where date = sysdate;this is right or wrong ,plz...
Answer Question
Asked by : mcmbsolutions | Last Updated On : May 10, 2008
Filed in : D2K Interview Questions

How i will run a report in scheduled task - i want to run a report daily, actually there is a whole data

How i will run a report in scheduled task - i want to run a report daily, actually there is a whole data retrieving in one report so, i want the report daily at evening auto run and generate data and convert it into pdf, so how i it put the report in...
Answer Question
Asked by : mcmbsolutions | Last Updated On : May 10, 2008
Filed in : D2K Interview Questions

Long Raw Columns - How many columns you can create in table from this type "long raw"

Long Raw Columns - How many columns you can create in table from this type "long raw"
Answer Question
Asked by : pc_mts | Last Updated On : May 09, 2008
Filed in : PL/SQL FAQ

Find Sequence MAX Value - How to find the max value in a Sequence

Find Sequence MAX Value - How to find the max value in a Sequence
Answer Question
Asked by : pc_mts | Last Updated On : May 09, 2008
Filed in : PL/SQL FAQ

Store Image in Oracle - How to store Image in Oracle table

Store Image in Oracle - How to store Image in Oracle table
Answer Question
Asked by : amplemaddy | Last Updated On : May 06, 2008
Filed in : Oracle FAQs

Oracle Forms Progress bar - how can i implement progress bar in form 6i.

Oracle Forms Progress bar - how can i implement progress bar in form 6i.
Answer Question
Asked by : raaj211 | Last Updated On : May 04, 2008
Filed in : D2K Interview Questions

Display deptno wise first three lowest salaries in ascending order of deptno and desc order of salary

Display deptno wise first three lowest salaries in ascending order of deptno and desc order of salary
Answer Question
Asked by : lalit.eng.kumar | Last Updated On : May 09, 2008
Filed in : Oracle SQL FAQ

Correlated subquery - display the 5th lowest sal from emp table using Correlated subquery

Correlated subquery - display the 5th lowest sal from emp table using Correlated subquery
Answer Question
Asked by : lalit.eng.kumar | Last Updated On : May 09, 2008
Filed in : Oracle SQL FAQ

Skip Columns with SQLLDR - How to skip columns while loading data with SQLLDR

Skip Columns with SQLLDR - How to skip columns while loading data with SQLLDR
Answer Question
Asked by : Hsingh85 | Last Updated On : Apr 30, 2008
Filed in : PL/SQL FAQ

Analytical functions - What are analytical functions and how are they used

Analytical functions - What are analytical functions and how are they used
Answer Question
Asked by : Hsingh85 | Last Updated On : Apr 30, 2008
Filed in : PL/SQL FAQ

Nested tables - How do you create nested tables

Nested tables - How do you create nested tables
Answer Question
Asked by : jannaat | Last Updated On : Apr 29, 2008
Filed in : PL/SQL FAQ

Oracle commit and commit work - what is the difference between commit and commit work

Oracle commit and commit work - what is the difference between commit and commit work
Answer Question
Asked by : jannaat | Last Updated On : Apr 29, 2008
Filed in : Oracle FAQs

Arrange Date Week Wise - How to arrange date in week wise like from Monday to Sunday

Arrange Date Week Wise - How to arrange date in week wise like from Monday to Sunday
Answer Question
Asked by : aurobinda.dalai | Last Updated On : Apr 28, 2008
Filed in : Oracle SQL FAQ

Alias in Joins - Why do we use aliases during joining two tables

Alias in Joins - Why do we use aliases during joining two tables
Answer Question
Asked by : manishayadav_1 | Last Updated On : Apr 28, 2008
Filed in : Oracle SQL FAQ

DBMS v/s RDBMS - Discuss the advantages and disadvantages of hierarchical database management system

DBMS v/s RDBMS - Discuss the advantages and disadvantages of hierarchical database management system in comparison with RDBMS. Discuss types of applications suitable for hierarchical DBMS and RDBMS.
Answer Question
Asked by : vasanthakashyap | Last Updated On : Apr 22, 2008
Filed in : Oracle DBA Interview Questions

Find all tables in a database - How to find all the tables existing in a database

Find all tables in a database - How to find all the tables existing in a database
Answer Question
Asked by : vinodhinifelix | Last Updated On : May 08, 2008
Filed in : Oracle SQL FAQ

Global Temporary Table - What is Global temporary table and what are the benefits of it

Global Temporary Table - What is Global temporary table and what are the benefits of it
Answer Question
Asked by : ravishing_sid | Last Updated On : Apr 29, 2008
Filed in : PL/SQL Interview Questions

Oracle admin Scenario based question - I have applied the following commands:Shutdown abortstartupNow

Oracle admin Scenario based question - I have applied the following commands:Shutdown abortstartupNow what will happen, will the database will give an error / it will work.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Export query question - exp userid=system/manager file=expfile.dmp log=expfile.log full=Y compress=Y

Export query question - exp userid=system/manager file=expfile.dmp log=expfile.log full=Y compress=Y buffer=1000000If i dot mention compress buffer parameter , then this query will run/not.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Oracle Snapshot too old error - What is Ora1555 error. Snapshot too Old error. Explain in detail.

Oracle Snapshot too old error - What is Ora1555 error. Snapshot too Old error. Explain in detail.
Answer Question
Asked by : Pragati.rch | Last Updated On : May 01, 2008
Filed in : Oracle DBA Interview Questions

Oracle Compress Parameter - My database size is 100GB. I am using compress parameter. Will my database

Oracle Compress Parameter - My database size is 100GB. I am using compress parameter. Will my database size reduce, remain same, Increase. What will Happen.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Check database state using pfile/spfile. - How to check whether database whether it is opened by pfile/spfile.

Check database state using pfile/spfile. - How to check whether database whether it is opened by pfile/spfile.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Difference between 9i OEM 10G OEM. - Explain the differences between 9i OEM 10G OEM along with new

Difference between 9i OEM 10G OEM. - Explain the differences between 9i OEM 10G OEM along with new features that changes the way you do your daily job
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Dbbuffercache tuning - Dbbuffercache : How we will tune it.

Dbbuffercache tuning - Dbbuffercache : How we will tune it.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Oracle Table space used and unused space - I have to check used space/unused space in table space. Which

Oracle Table space used and unused space - I have to check used space/unused space in table space. Which view /command will provide me the desired answer.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Oracle DB Buffer Cache - How the data is processed in DB Buffer Cache.

Oracle DB Buffer Cache - How the data is processed in DB Buffer Cache.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Changes in Database buffer cache - What are the changes that happen in Database buffer cache(List of

Changes in Database buffer cache - What are the changes that happen in Database buffer cache(List of all changes in DB Buffer Cache)
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Oracle table space Quota and users - How to create User in Oracle, allocate quota on Oracle table space

Oracle table space Quota and users - How to create User in Oracle, allocate quota on Oracle table space
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

SARS Command - Explain SARS Command

SARS Command - Explain SARS Command
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA FAQ

Oracle Backsets created by RMAN - Can you use Backsets created by RMAN with any other utility

Oracle Backsets created by RMAN - Can you use Backsets created by RMAN with any other utility
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Why do you take tablespaces in backup mode.

Why do you take tablespaces in backup mode.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Online backup of a Control File - Can you take online backup of a Control File If yes, How

Online backup of a Control File - Can you take online backup of a Control File If yes, How
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Can you change priority of a Process in Unix

Can you change priority of a Process in Unix
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

How do you kill a process in Unix

How do you kill a process in Unix
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Oratab file - What is stored in Oratab file

Oratab file - What is stored in Oratab file
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Remove Oracle memory segments - how do you remove memory segments

Remove Oracle memory segments - how do you remove memory segments
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Oracle segments - How do you see how many memory segments are acquired by Oracle Instance.

Oracle segments - How do you see how many memory segments are acquired by Oracle Instance.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Oracle memory segments - How do you see how many memory segments are acquired by Oracle Instance.

Oracle memory segments - How do you see how many memory segments are acquired by Oracle Instance.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Oracle OERR Utility - What is OERR Utility

Oracle OERR Utility - What is OERR Utility
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Oracle maximum data files limit - How many max datafiles can there be in an Oracle Database.

Oracle maximum data files limit - How many max datafiles can there be in an Oracle Database.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Oracle Datafiles limit - How do you control No. of Datafiles one can have in an Oracle Database.

Oracle Datafiles limit - How do you control No. of Datafiles one can have in an Oracle Database.
Answer Question
Asked by : Pragati.rch | Last Updated On : Apr 19, 2008
Filed in : Oracle DBA Interview Questions

Multiple Row Values - How to retrieve multiple row values in a single column

Multiple Row Values - How to retrieve multiple row values in a single column
Answer Question
Asked by : BISHNUPRIYA | Last Updated On : Apr 18, 2008
Filed in : Oracle FAQs

Log Miner - What is meant by log miner

Log Miner - What is meant by log miner
Answer Question
Asked by : vishnudba | Last Updated On : Apr 17, 2008
Filed in : Oracle DBA FAQ

Oracle Shared pool - What is meant by Shared pool fragmentation.

Oracle Shared pool - What is meant by Shared pool fragmentation.
Answer Question
Asked by : satishd | Last Updated On : Apr 16, 2008
Filed in : Oracle Memory Management Interview Questions

Sub query and correlated sub query - What is the difference between sub query and correlated sub query

Sub query and correlated sub query - What is the difference between sub query and correlated sub query
Answer Question
Asked by : sinraj | Last Updated On : Apr 13, 2008
Filed in : Oracle SQL FAQ

PL/SQL Block output - begin For i in 1..5 loop insert into A values(i); savepoint 1; end loop;

PL/SQL Block output - begin For i in 1..5 loop insert into A values(i); savepoint 1; end loop; rollback to savepoint 1; commitend;--initially there are no data in table A. So my question is after execution of this block what should be the data...
Answer Question
Asked by : Kanhucharan | Last Updated On : May 07, 2008
Filed in : PL/SQL Interview Questions

Difference between Varray and Nested Table - What is the difference between Varray And Nested Table

Difference between Varray and Nested Table - What is the difference between Varray And Nested Table
Answer Question
Asked by : Kanhucharan | Last Updated On : May 02, 2008
Filed in : Oracle Interview Questions

Delete contents in two tables at a time - How to delete contents in two tables at a time When you delete

Delete contents in two tables at a time - How to delete contents in two tables at a time When you delete contents in one table then other table contents should also be deleted.
Answer Question
Asked by : jyothivdaru | Last Updated On : Apr 13, 2008
Filed in : Oracle SQL FAQ

RMAN Backup - Detail script of backup using RMAN in both mode catalog and nocatalog

RMAN Backup - Detail script of backup using RMAN in both mode catalog and nocatalog
Answer Question
Asked by : khadri4u | Last Updated On : Apr 09, 2008
Filed in : Oracle Backup and Recovery Interview Questions
Tags: Backup