Answer / suman

we have 8 packages in our database that is
1.procedures
2.triggers
3.tables
4.indexes
5.synonyms
6.views

Give the reasoning behind using an index.

2 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

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  

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

---

Can we take incremental backups in datapump?

1 Answers  

---

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

0 Answers  

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---