FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

ORACLE INTERVIEW QUESTIONS & ANSWERS

Databases
Follow Us
 
TAGS
6. Define Query?
 
  • A query is a read–only transaction against a database.
  • A query is generated using the SELECT statement.
  • Users generally distinguish between queries and other transaction types because a query does not the change data in the database.
Your Name Your Email-ID
Your Answer
 
7. What is the difference between a relation and a relationship?
  The difference between a relation and a relationship is that a relation is another name for a table, whereas a relationship is a way to correlate, or join, two or more tables.
Your Name Your Email-ID
Your Answer
 
8. Name two new features of Oracle8?
  New features of Oracle8 include partitioned tables, index-only tables, and improved parallelism.
Your Name Your Email-ID
Your Answer
 
9. What are the three types of DML (Data Manipulation Language) statements?
 
    There are three types of DML statements are :
  • INSERT
  • UPDATE
  • DELETE
  Posted by vedant. (Oct 22, 2013)
 

MERGE .
Your Name Your Email-ID
Your Answer
 
10. What is a log group?
  A log file group is a set of identical redo log files. This provides redundancy to protect against media failure.
Your Name Your Email-ID
Your Answer