KyaPoocha.com

Related Interview Questions

• How do you load the data conditionally by run steps ?  20.09.08

  This depends upon how the ETL is done: If we are loading data using Informatica, the workflow jobs can be scheduled using Autosys or any other scheduler, in...

• How would you execute a SQL query in Oracle 8 ?  30.07.08

  Again, if you ever worked with Oracle, this question should be trivial for you to answer (from command prompt, of course) If you never worked with Oracle, note...

• How can you determine if an Oracle instance is up from the operating system level?  11.05.08

  There are several base Oracle processes that will be running on multi-user operating systems, these will be smon, pmon, dbwr and lgwr. Any answer that has them...

• What is SYSTEM tablespace and when is it created ?  02.05.08

  Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the...

• What is an Oracle Instance?  30.06.06

  The Oracle system processes, also known as Oracle background processes, provide functions for the user processes—functions that would otherwise be done by the...

• Explain the Memory Structures of the Oracle database ?  27.06.06

  Oracle creates and uses memeory sructures to complete several jobs. For example, memory is used to store program code being executed and data that is shared amo...

• Name the three major set of files on disk that compose a database in Oracle  11.03.06

  There are three major sets of files on disk that compose a database. All the files are binary. these are:- Database files Control files Redo logs The mos...

• Name two utilities that Oracle provides, which are use for backup and recovery.  08.03.06

  Along with the RDBMS software, Oracle provides two utilities that you can use to back up and restore the database. Theseutilities are Export and Import. The Exp...

• What is Oracle Block? Can two Oracle Blocks have the same address?  08.03.06

  Oracle "formats" the database files into a number of Oracle blocks when they are first created—making it easier for the RDBMS software to manage the files and...

• What is an Oracle Instance?  08.03.06

  The Oracle system processes, also known as Oracle background processes, provide functions for the user processes—functions that would otherwise be done by the...