Answer Posted / guruswamy

create user <username> IDENTIFIED BY password;

Can 2 queries be executed simultaneously in a distributed database system?

1150

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

---

Is truncate ddl or dml?

997

---

What are expressions?

1019

---

What is sap sql?

989

---

Explain the structure of pl/sql in brief.

1096

---

What is rownum and rowid?

1038

---

What is dcl in sql?

967

---

How do you update a table in sql?

993

---

what are the difference between clustered and a non-clustered index? : Sql dba

1034

---

what is the difference between group by and order by in sql? : Sql dba

1133

---

Can we insert data into view?

909

---

Why primary key is required?

1012

---

How can you tell the difference between an index and a view?

937

---

Is natural join same as inner join?

948

---