Answer Posted / pvenkiroyal

select to_char(startup_time,'hh24:mi:ss dd-mom-yy') from
v$instance;

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4404

---

what do you understand by fine-grained auditing?

1103

---

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?

2036

---

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?

2858

---

internal architecture

2250

---

which background process invoke at the time of upgradation tell me???

2778

---

Why would you use sql agent? : sql server DBA

1130

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2741

---

What is dcl? : sql server DBA

1318

---

What are the different ways you can create databases in sql server? : sql server DBA

1191

---

How do you open a cluster administrator? : sql server DBA

1149

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1056

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2453

---

What is the difference between clustered and non-clustered index? : sql server DBA

1141

---

What are the different types of indexes available in sql server? : sql server DBA

1261

---