Answer / Ram Dwivedi

To force the CBO to use a specific index for a given statement, you can use the FORCE_INDEX initialization parameter in the spfile/init.ora file or ALTER SESSION command. Here's an example:

```sql
ALTER SESSION FORCE INDEX (table_name) ON (column_name);
```

This command will force the CBO to use the specified index for the given table and column.

how can you create a user-defined lock?

1 Answers   Oracle,

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

What are the different types of indexes available in sql server? : sql server DBA

1 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

Give two examples of referential integrity constraints.

2 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

1 Answers  

---

what are the performance views in an oracle rac environment?

1 Answers   Oracle,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

what are the types of connection load-balancing?

1 Answers   Oracle,

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---