InterviewDot Com - A Job Portal One Click Dream Job - interviewdot/upload-resume/uploadresume.htm Top Oracle Interview Questions : When we give select * from emp; how does Oracle respond ? What is the difference between trim and truncate functions in Oracle ? Explain the difference between a hot backup and a cold backup and the benefits associated with each ? You have just had to restore from backup and do not have any control files. How would you go about bringing up this database ? How do you switch from an init.ora file to a spfile ? Explain the difference between a data block, an extent and a segment ? Give two examples of how you might determine the structure of the table DEPT. Where would you look for errors from the database engine ? Compare and contrast TRUNCATE and DELETE for a table ? Give the reasoning behind using an index. Give the two types of tables involved in producing a star schema and the type of data they hold. What type of index should you use on a fact table ? Oracle version 9.2.0.4.0 what does each number refers to ? How do you find current date and time in oracle ? Write the syntax to find current date and time in format “YYYY-MM-DD” ? How will you convert a date to char in Oracle give one example ? What is bulk copy or BCP in oracle ? What are the extensions used by oracle reports ? What is Save Points in Oracle database ? How will you convert string to a date in oracle database ? What is hash cluster in Oracle ? What is Snap shot in Oracle database ?
Posted on: Thu, 26 Sep 2013 05:38:11 +0000
Trending Topics
Recently Viewed Topics
© 2015