Answer / monal

Live Lock occurs when exclusive lock is denied continuously
by series of overlapping shared locks keep on interfering
each other and they keep changing status further preventing
them to complete the task.

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

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?

1 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

Explain an ORA-01555

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  

---

Give two examples of referential integrity constraints.

2 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,

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---