FeedBack Form

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

ORACLE INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
11. Define Schema?
  A schema is a collection of objects associated with the database.
Your Name Your Email-ID
Your Answer
 
12. What is the difference between a database and an instance?
  A database is a set of files on disk that is managed by an instance, which is a collection of processes and memory structures that operate against the datafiles on disk.
Your Name Your Email-ID
Your Answer
 
13. What is schema objects?
 
  • Schema objects are abstractions or logical structures that refer to database objects or structures.
  • Schema objects consist of such things as clusters, indexes, packages, sequences, stored procedures, synonyms, tables, views, and so on.
Your Name Your Email-ID
Your Answer
 
14. What are some of the differences between a DELETE and a TRUNCATE statement?
 
  • A DELETE statement may be rolled back, whereas a TRUNCATE statement is implicitly committed.
  • A DELETE statement can conditionally specify which rows to delete, but a TRUNCATE statement removes the contents of the entire table.
  • A DELETE statement retains the disk space in the table for future inserts or updates, but a TRUNCATE statement frees the disk space for other tables or database objects.
  Posted by Deepika. (Mar 10, 2014)
 

Triggers does not fire in Truncate.
  Posted by MUTHUVEL P. (Dec 10, 2013)
 

TRUNCATE Statement is faster than DELETE Statement.
Your Name Your Email-ID
Your Answer
 
15. What is the main component of an Oracle8 server?
  RDBMS
Your Name Your Email-ID
Your Answer