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)

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

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

0 Answers  

---

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.

0 Answers  

---