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


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

Post New Answer

More DB Administration Interview Questions

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,


What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  


Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,


Give the reasoning behind using an index.

2 Answers  


what is the role of dip user in our database?

0 Answers  






Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  


What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  


Which environment variables are absolutely critical in order to run the OUI?

2 Answers  


How many packages we have in db

1 Answers   Tesco,


if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  


A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,


Categories