Answer Posted / gangaram

Should you place Recovery Catalog in the Same DB?
Recovery catalog can be in the same database. but its
recommended by oracle that we need to have recovery catalog
in other DB.

Can you use RMAN without Recovery catalog
Yes we can use RMAN without catalog.
The information gets stored in the control file.
$>connect target / no catalog

is the command.

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

1165

---

What authentication modes does sql server support? : sql server DBA

1159

---

What is replication? : sql server DBA

1119

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

962

---

what is the use of ocr?

982

---

what is asm?

1013

---

how can you find out if a table can be redefined?

978

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1046

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1957

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2429

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

969

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1008

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2126

---

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

7805

---

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

2031

---