Searching for "he"

Q:

What is the difference between Cursor Stability and Repeatable Read isolation levels?

Answer

CURSOR STABILITY:


- CS is a row level locking


- Acquires an exclusive lock on the row that is to be updated


- When the control is moved to the next updatable row, the lock is released


REPEATABLE READ:


- RR is a page level locking


- Acquires an exclusive lock on the entire page which is the source of row availability


- When the control is moved to the next updatable page the lock is released

Report Error

View answer Workspace Report Error Discuss

Q:

What is DBRM? What it contains? When it will be created?

Answer

- DBRM stands for Database Request Module


- The output of pre-compile process is represented as DBRM


- The SQL statements are extracted from the host language by the pre-compiler

Report Error

View answer Workspace Report Error Discuss

Q:

What is REORG? When it is used?

Answer

REORG reorganizes data on physical storage to reclutser rows, positioning overflowed rows in their proper sequence, to reclaim space, to restore free space. It is used after heavy updates, inserts and delete activity and after segments of a segmented tablespace have become fragmented.

Report Error

View answer Workspace Report Error Discuss

Q:

Write a method to fill all the spaces in a string with '%20'

Answer

public class Test {


    public void replaseSpaces(char[] str, int length) {


        int spaceCount = 0, newLength = 0, i = 0;


        for(i = 0; i < length; i++) {


            if (str[i] == ' ') 


                spaceCount++;


        }


 


        newLength = length + (spaceCount * 2);


        str[newLength] = '\0';


        for(i = length - 1; i >= 0; i--) {


            if (str[i] == ' ') {


                str[newLength - 1] = '0';


                str[newLength - 2] = '2';


                str[newLength - 3] = '%';


                newLength = newLength - 3;


            }


            else {


                str[newLength - 1] = str[i];


                newLength = newLength - 1;


            }


        }


        System.out.println(str);


    }


 


    public static void main(String[] args) {


        Test tst = new Test();


        char[] ch = {'t', 'h', 'e', ' ', 'd', 'o', 'g', ' ', ' ', ' ', ' ', ' ', ' '};


        int length = 6;


        tst.replaseSpaces(ch, length);  


    }


}

Report Error

View answer Workspace Report Error Discuss

Q:

What are the different types of system calls?

Answer

The main types of system calls are as follows:


Process Control: These types of system calls are used to control the processes. Some examples are end, abort, load, execute, create process, terminate process etc.


File Management: These types of system calls are used to manage files. Some examples are Create file, delete file, open, close, read, write etc.


Device Management: These types of system calls are used to manage devices. Some examples are Request device, release device, read, write, get device attributes etc.


Information Maintenance: These types of system calls are used to set system data and get process information. Some examples are time, OS parameters, id, time used etc.


Communications: These types of system calls are used to establish a connection. Some examples are send message, received messages, terminate etc

Report Error

View answer Workspace Report Error Discuss

Q:

Explain the basic difference between 32-bit and 64-bit operating system?

Answer

A 32 bit processor is faster than a 64 bit processor, 64 bit processors are very commonly used that you can find it easily in any home pc but the main difference is the hardware you are having on your machine. For 32 bits there isn't any need of any wide main bus to carry 32 bits at a time but for 64 bits its must that you should have a wider bus to carry 64bits.

Report Error

View answer Workspace Report Error Discuss

Q:

What is the purpose of creating partitions for a Windows operating system?

Answer

Creating partition may serve different purposes. The common reason is that a separate partition can be used to store data files so that when Windows needs to be reinstalled, the main partition can be formatted without fear of loosing data, which are stored on the other partition.

Report Error

View answer Workspace Report Error Discuss

Q:

What is the difference between a Windows server operating system and a workstation version?

Answer

The server version of a Windows operating system is designed to provide more optimized networking services over a network. It can manage domains better and it includes more security feature and data backup support. Workstation versions act merely as clients and therefore do not need to have as much resources when compared to the server versions.

Report Error

View answer Workspace Report Error Discuss