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 types of replication are supported in sql server? : sql server DBA

1348

---

How to start SQL Server in minimal configuration mode?

8081

---

what do you understand by fine-grained auditing?

1103

---

Why would you call update statistics? : sql server DBA

1039

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1058

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1180

---

What happens on checkpoint? : sql server DBA

1139

---

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.

2043

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3807

---

what is asm?

1111

---

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

1959

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2123

---

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

2491

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

2268

---

what is the use of recording information about current session?

1108

---