Answer / kittu_chintu2005

Startup mount
Alter database archive log;
Alter database begin backup;
Alter tablespace ts_name begin backup;
Copy the *.dbf & *.ctl files @ os level when copying completed issue the statement “alter database end backup;”

Answer / nagesh yadav

1)Database should be in archivelog mode
2)we can take the hot backup at tablespace level or database
level
3)when we kept in begin backup mode performance will be poor
so take the backup at tablespace level.
4)alter tablespace tablespace_name begin backup; OR
5)alter database begin backup;
Note:- Don't add datafiles in begin backup
select status from v$backup;
If status is active means its is in begin backup mode.

Describe what redo logs are.

1 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

Explain materialized views and how they are used.

0 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---