Answer / kittu

1. Logical Backups(traditional backups of oracle)export/import, datapump physical backup hot backup(online backup), cold backup(offline backup), RMAN backup

2. cold backup & logical backups

Explain the use of table functions.

1 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

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

1 Answers   STC,

---

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  

---

Explain the concept of the DUAL table.

3 Answers  

---

What is dcl? : sql server DBA

0 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  

---