Answer Posted / sanjaya

STEP 1:
-------
OPEN SQL*PLUS
LOGIN AS
USER: SYSTEM
PASSWORD: ********

STEP 2:
-------
SQL> GRANT OLAP_USER TO SCOTT;

STEP 3:
-------
SQL> CONNECT
Enter user-name: SCOTT
Enter password: *****

STEP 4:
-------
SQL> CREATE [PUBLIC] SYNONYM <SYN_NAME>
FOR <USER_NAME.ABLE_NAME>;

Explain about various levels of constraint.

700

---

Can pl sql procedure have a return statement?

722

---

What can you do with pl sql?

769

---

what is a table in a database ? : Sql dba

750

---

what are string data types? : Sql dba

699

---

---

Explain the the update statement in sql?

770

---

How much does sql cost?

735

---

what are the different tables present in mysql? : Sql dba

678

---

Is id a reserved word in sql?

860

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

746

---

What is the mutating table and constraining table?

738

---

How can a function retun more than one value in oracle with proper example?

803

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

822

---

State some properties of relational databases?

759

---

What is primary key and foreign key with example?

685

---