Answer / sudipta santra

Host string is the instance name of the database in the server.

when we are using sqlplus then we use to give the
username/password@<hostname>

It relate the user as a connectivity with that specified
instance.

What is the maximum number of CHECK constraints that can be defined on a column ?

3 Answers  

---

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 Answers  

---

6. Display the client name and order date for all orders using the traditional method.

0 Answers   Wipro,

---

how to find full database size

1 Answers   BirlaSoft, Consultancy,

---

Please explain oracle left join with an example?

0 Answers  

---

what is the syntax of ALTER command?

8 Answers  

---

Can we create more than one constraint to column ?

6 Answers  

---

how to hide the stored procedure inside a package

1 Answers  

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

0 Answers  

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

how to get last monday of a month?

2 Answers   Multifonds,

---

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,

---