Answer Posted / guneetinder singh

Table space in a database is the logical space used by the
oracle when oracle wants to do some common work by grouping
many other subgroup, then the common group is called tablespace.
generally tablespace is of 6MB.
Out of which 2MB is system reserved and 4MB is available to
user.

What is the maximum number of triggers that can be applied to a single table?

953

---

Name the three major set of files on disk that compose a database in Oracle?

1062

---

What is an oracle wallet?

878

---

how to join query for one source type is oracle another source type is sql server ?

2376

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4291

---

Can we use bind variables in oracle stored procedure?

896

---

What is tns service name?

1069

---

Explain the use of rows option in imp command.

1040

---

What is snapshot is too old? Give and example for better understand.

1543

---

Explain alias?

1077

---

Explain the features of oracle?

987

---

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.

2040

---

How to rename an existing table?

1048

---

Explain about the analyze command in oracle?

995

---

What are the parameters that we can pass through a stored procedure?

996

---