If you're unsure in which script a sys or system-owned
object is created, but you know it's in a script from a
specific directory, what UNIX command from that directory
structure can you run to find your answer?
Query processing is slow(eg select query)how will u solve that
Oracle 11g new features?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What command would you use to encrypt a PL/SQL application?
how can you process messages in order asynchronously?
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?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
how can you enable flashback feature?
how will you see when the database was started using sql prompt?
What is the recommended interval at which to run statspack snapshots, and why?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?