Answer Posted / 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;

What happens on checkpoint? : sql server DBA

1035

---

Explain materialized views and how they are used.

2384

---

Can you redefine a table online?

1060

---

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

1113

---

how can you schedule a job in database?

1043

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1916

---

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.

2516

---

how does an oracle clusterware manage crs resources?

1027

---

What is a system database and what is a user database? : sql server DBA

1116

---

What authentication modes does sql server support? : sql server DBA

1139

---

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

2401

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1032

---

internal architecture

2143

---

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

2367

---

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

954

---