Answer Posted / animesh

SQL IS A STRUCTURED QUERY LANGUAGE THROUGH WHICH WE CAN
COMMUNICATE WITH THE ORACLE SERVER AND SQL STATEMENTS ARE
DIVIDED INTO FIVE STATEMENTS i:e. Data defintion language
(DDL) which is used in creating the tables,views. In DDL
create,
Alter,
Drop,
Rename,
Trucate comes.
where as Data Manipulation Language(DML)command is used to
manipulate the data.In DML
Insert,
Update,
Delete,
Merge.
the third one is Data retrieval i:e. the select command
the fourth one is Transcation control i:e.
commit,Rollback,savepoint.
the fifth one is data control language(DCL) i:e.
grant,revoke

What happens if the update subquery returns multiple rows?

1166

---

How many categories of data types?

1041

---

What do you understand by a database object? Can you list a few of them?

1063

---

Is oracle an operator?

982

---

Why we use bulk collect in oracle?

1112

---

How to turn on or off recycle bin for the session?

1174

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1091

---

How to test null values?

1154

---

How to write a query with a left outer join in oracle?

1124

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4680

---

What happens to the data files if a tablespace is dropped?

1107

---

What does sharding mean?

1052

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2084

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3244

---

What is the difference between "as" and "is" in an oracle stored procedure?

1046

---