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 5759I 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 3333Post New DB Administration Questions
what is the use of ocr?
What is fill factor? : sql server DBA
Explain about your sql server dba experience? : 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
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how can you record information about current session?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Explain materialized views and how they are used.
what are the differences of where and if in SAS?
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?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the commands used in dcl? : sql server DBA
what functionality does oracle provide to secure sensitive information?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
How would you extract DDL of a table without using a GUI tool?
