KyaPoocha.com

Huge Collection of Interview Questions


Archive for March, 2006

What are the different modes of mounting a Database with the Parallel Server ? 

Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance... Read more »

What are the steps involved in Instance Recovery ? 

Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments. Rolling... Read more »

What are the steps involved in Database Startup ? 

Start an instance, Mount the Database and Open the Database.  Read more »

What is On-line Redo Log? 

The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the... Read more »

What is Log Switch ? 

The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.  Read more »

What is Tablespace Quota ? 

The collective amount of disk space available to the objects in a schema on a particular tablespace.  Read more »

What is default tablespace ? 

The Tablespace to contain schema objects created without specifying a tablespace name.  Read more »

What is the use of ANALYZE command ? 

To perform one of these function on an index,table, or cluster: To collect statistics about object used by the optimizer and store them in the data dictionary. To... Read more »

Can you have more than one content canvas view attached with a window? 

Yes. Each window you create must have atleast one content canvas view assigned to it. You can also create a window that has manipulated content canvas view. At run... Read more »

What are the Built-ins used for sending Parameters to forms? 

You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.  Read more »

Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace? 

All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When objects are created their INITIAL and MINEXTENS... Read more »

Is DOS a real time OS? 

DOS is not a RTOS (real time Operating system), however MS DOS can be used with certain APIs to achieve the RTOS functionality. For example, the RT Kernel (Real... Read more »

Name some real time OSs. 

Real-time operating systems are: QNX, LynxOS, OS-9, Intergrity, Katix, Fusion, IRIX, DeltaOS, eCos, AMX, CMX-RTX, INTime, PDOS and many others.  Read more »

Describe the actions taken by thread library to context switch between user level threads? 

The thread library function performs the following actions to context switch between user level threads Copy all live registers to Thread control Block (TCB) Restore... Read more »

What is Throughput, Turnaround time, waiting time and Response time? 

Throughput – number of processes that complete their execution per time unit Turnaround time – amount of time to execute a particular process Waiting time –... Read more »

Page 4 of 85« First...«23456»...Last »