Answer / Akash Kumar

Hot backups are online, non-intrusive backups that allow databases to remain accessible during the backup process. They provide faster recovery times as less downtime is required for the backup. However, they can consume more system resources and may require a higher level of expertise to perform. Cold backups, on the other hand, involve shutting down the database instance before taking the backup. This approach consumes fewer resources but requires longer recovery times. The benefits of hot backups are faster recovery times and less downtime, while cold backups offer better resource utilization and lower risk of data corruption.

What do you mean by cdb and pdb in oracle 12c?

1 Answers  

---

difference between imlicit cursor and explicit cursor ?

5 Answers   Cap Gemini,

---

Explain oracle insert into command?

1 Answers  

---

SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.

2 Answers   Cognizant,

---

Explain the use of record length option in exp command.

1 Answers  

---

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

---

Display the records between two range?

2 Answers  

---

How to write an inner join with the where clause in oracle?

1 Answers  

---

When system tablespace is created?

1 Answers  

---

What is Java Pool in Oracle?

1 Answers   MCN Solutions,

---

How to pass parameters to procedures in oracle?

1 Answers  

---

What is format trigger?

1 Answers  

---