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 is grd?

1073

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1242

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2028

---

how can you process messages in order asynchronously?

959

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2083

---

What is fill factor? : sql server DBA

1227

---

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

2431

---

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

1950

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1706

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1893

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

990

---

what are the benefits of flashback feature?

1003

---

Why would you use sql agent? : sql server DBA

1062

---

what is asm?

1026

---

what are the differences of where and if in SAS?

2172

---