Interested to Buy Any Domain ? << Click Here >> for more details...
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 6567I 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 3872Post New DB Administration Questions
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is transparent data encryption? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What is the default fill factor value? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how to restore files with rman?
What is a system database and what is a user database? : sql server DBA
What is replication? : sql server DBA
what is the use of recording information about current session?
What are the commands used in dcl? : sql server DBA
how can you schedule a job in database?
What would you do with an "in-doubt" distributed transaction?
