Answer / ramesh

From Scott Schema

1.Desc Dept

2.Select Table_name,Column_name,Data_type,nullable from
user_tab_columns wheRE table_name = 'DEPT'

Answer / amrutharao d

1. SQL>Desc Dept

2. SQL>Select Table_name,Column_name,Data_type,nullable from
user_tab_columns wheRE table_name = 'DEPT'

3. SQL>set long 99999
SQL>select dbms_metadata.get_ddl('TABLE','DEPT') from
dual;

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.

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

---

Datapump backup steps?

1 Answers  

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

wat is global index and local indes

1 Answers   Oracle,

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

What is the default fill factor value? : sql server DBA

0 Answers  

---

. 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?

0 Answers  

---