1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
2 6693I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
1 3932Post New DB Administration Questions
how can you process messages in order asynchronously?
what is the diffrence between core dba and apps dba?
What is dcl? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what functionality does oracle provide to secure sensitive information?
how can you record information about current session?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Where would you look for errors from the database engine?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what are the types of connection load-balancing?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Explain materialized views and how they are used.
What is the default port no on which sql server listens? : sql server DBA
internal architecture