Answer Posted / basobdutta

Archivelog mode - In archivelog mode cold and hot backups
are possible. We can recover our database upto the last
point of failure.

Noarchivelog mode- Here we can only go for cold
backup.Generally in this mode complete recovery is not
possible

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1251

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2091

---

what functionality does oracle provide to secure sensitive information?

1049

---

what is a crs resource?

1236

---

who owns the operating system files created by the utl_file package?

1125

---

How can you control the amount of free space in your index pages? : sql server DBA

1373

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2150

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1123

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2216

---

What are the operating modes in which database mirroring runs? : sql server DBA

1238

---

How to start SQL Server in minimal configuration mode?

8081

---

What the different types of replication and why are they used? : sql server DBA

1227

---

how can you connect from 10g user to 11g user??

2164

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2123

---

What is transparent data encryption? : sql server DBA

1251

---