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 6730I 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 3967Post New DB Administration Questions
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what are the performance views in an oracle rac environment?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
how can you initialize log miner?
what functionality does oracle provide to secure sensitive information?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Why would you call update statistics? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is transparent data encryption? : sql server DBA
What is dbcc? : sql server DBA