What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

How do you add a data file to a tablespace?

3 Answers  

---

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

3 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

How do you resize a data file?

2 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---