Answer Posted / shilpa.oracle

Yes, we can relate tables of different schemas provided we
should have privileges on that table

create table test_emp
(empno number(5),deptno number(5),constraint dept_ref
foreign key (deptno) references schema.dept(deptno))

What is keys and its types?

1069

---

What is the command used to fetch the first 5 characters of a string?

1206

---

What is cold data?

946

---

What are the two different parts of the pl/sql packages?

1077

---

what is timestamp in mysql? : Sql dba

1068

---

How to rename a table?

1010

---

How do I know if I have sql express or standard?

1026

---

Can a table contain multiple primary key’s?

1092

---

Is sql a oracle?

970

---

what are the advantages of using stored procedures? : Sql dba

1099

---

Does truncate release storage space?

1070

---

how to drop an existing table in mysql? : Sql dba

1038

---

How to add new employee details in an employee_details table with the following details

1085

---

What is an example of translating a date into julian format?

1112

---

What is count * in sql?

991

---