Answer / guest

The global variable @@Version stores the build number of the
sqlservr.exe, which is used to determine the service pack
installed.
eg: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17
2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service
Pack 3)

How many packages we have in db

1 Answers   Tesco,

---

What command would you use to create a backup control file?

2 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

what is grd?

0 Answers   Oracle,

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---