| Question: |
What is SQL?
|
|
Question: |
What is SELECT statement? |
| Question: |
How
can you compare a part of the name rather
than the entire name? |
| Question: |
What
is the INSERT statement? |
| Question: |
How do you delete
a record from a database? |
| Question: |
How could I get
distinct entries from a table? |
| Question: |
How to get the results of a Query sorted
in any order? |
| Question: |
How can I find the total number of records
in a table? |
| Question: |
What
is GROUP BY? |
| Question: |
What
is the difference among "dropping a table",
"truncating a table" and "deleting all records"
from a table? |
| Question: |
What are the Large object types suported
by Oracle? |
| Question: |
Difference between a "where" clause
and a "having" clause ? |
| Question: |
What's
the difference between a primary key and
a unique key? |
| Question: |
What
are cursors? Explain different types of
cursors. What are the disadvantages of cursors?
How can you avoid cursors? |
| Question: |
What
are triggers? How to invoke a trigger on
demand? |
| Question: |
What
is a join and explain different types of
joins. |
| Question: |
What is
a self join? |