Answer / Kunwar Pratap Singh

To create tables for ODBC connection testing in Oracle Database, follow these steps: 1. Connect to your database as a user with appropriate privileges (sys or system). 2. Create a new schema if necessary using the CREATE USER and CREATE PROFILE commands. 3. Grant the necessary privileges to the user you are testing with. 4. Create two tables, one for numeric data and another for character data: CREATE TABLE num_data (id NUMBER(10), value NUMBER(20)); CREATE TABLE char_data (id NUMBER(10), name VARCHAR2(20)); 5. Insert some test data into the tables.

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

What happens to the data files if a tablespace is dropped?

1 Answers  

---

I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  

---

Briefly explain what is literal? Give an example where it can be used?

1 Answers  

---

What is tns entry?

1 Answers  

---

who is the father of oracle and send chodd rules

4 Answers   ME,

---

What is a Sequence ?

3 Answers  

---

Difference between the “verify” and “feedback” command?

1 Answers  

---

Can a formula column be obtained through a select statement ?

1 Answers   Oracle,

---

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

1 Answers   Polaris,

---

State any two functions of oracle?

1 Answers   Aricent,

---

Explain how are indexes update?

1 Answers  

---