What are the commands you'd issue to show the explain plan for "selec

What are the commands you'd issue to show the explain plan
for "select * from dual"?

Question Posted / narmada kumari

No Answer is Posted For this Question
Be the First to Post Answer

More DB Administration Interview Questions

how can you communicate with operating system files from oracle?

What are the steps you will take, if you are tasked with securing an SQL Server?

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

What is RAID and what are different types of RAID configurations?

When a user process fails, what background process cleans up after it?

What is database replicaion? What are the different types of replication you can set up in SQL Server?

what functionality does oracle provide to secure sensitive information?

What is dcl? : sql server DBA

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

For more DB Administration Interview Questions Click Here