Answer Posted / kittu

by issuing above statement it freezes tablespace it won't
allow single transaction to datafile

What are the different sql server versions you have worked on? : sql server DBA

1007

---

who owns the operating system files created by the utl_file package?

1063

---

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

1195

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4423

---

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.

1989

---

How would you go about verifying the network name that the local_listener is currently using?

3209

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2628

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1982

---

what do you understand by fine-grained auditing?

1051

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2713

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2441

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1969

---

what is the use of ocr?

1027

---

What are the operating modes in which database mirroring runs? : sql server DBA

1181

---

Query processing is slow(eg select query)how will u solve that

7903

---