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 6829I 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 4048Post New DB Administration Questions
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is a system database and what is a user database? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What are the commands used in dcl? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you record information about current session?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
What happens on checkpoint? : sql server DBA
when does an alert gets signaled?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com