Answer Posted / kishore

DBCC dbreindex('tabname','indexname','fillfactor')

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

1104

---

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

2362

---

What are the different sql server versions you have worked on? : sql server DBA

961

---

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

2185

---

What is replication? : sql server DBA

1097

---

What is transparent data encryption? : sql server DBA

1112

---

how can you create a user-defined lock?

959

---

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

2015

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2561

---

what is grd?

1045

---

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?

1914

---

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.

1930

---

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

949

---

How would you go about verifying the network name that the local_listener is currently using?

3152

---

Why does Oracle not permit the use of PCTUSED with indexes?

2879

---