Answer / diksha

select count(*) from v$session where username like ''

Answer / kishore

select count(*),username from v$session where group by username;

Answer / braj123

select count(*) from v$session where user_name="**";

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

1 Answers  

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

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

0 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

---

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

2 Answers   Zenith,

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---