Amit Diwan has Published 112 Articles

How to run JavaTuples program in Eclipse?

Amit Diwan

Amit Diwan

Updated on 30-Jun-2020 12:13:33

Tuples in Java are an ordered collection of objects of different types. To run Tuple in Java, you need to upload an external jar file. Here, we will be using Eclipse IDE to create a new Java Project and upload the JavaTuples external jar file.The JavaTuples jar file is to ... Read More

Mass Storage Management

Amit Diwan

Amit Diwan

Updated on 22-Jun-2020 08:30:46

Disks are the mainly used mass storage devices. They provide the bulk of secondary storage in operating systems today.Disk StructureEach modern disk contains concentric tracks and each track is divided into multiple sectors. The disks are usually arranged as a one dimensional array of blocks, where blocks are the smallest ... Read More

User View vs System View in Operating System

Amit Diwan

Amit Diwan

Updated on 21-Jun-2020 16:37:44

An operating system is a construct that allows the user application programs to interact with the system hardware. Operating system by itself does not provide any function but it provides an atmosphere in which different applications and programs can do useful work.The operating system can be observed from the point ... Read More

Process Management

Amit Diwan

Amit Diwan

Updated on 20-Jun-2020 16:57:05

A process is an active program i.e a program that is under execution. It contains the program code, program counter, process stack, registers etc.Process StatesThe different states that a process is in during its execution are explained using the following diagram −New- The process is in new state when it ... Read More

What is an Operating System?

Amit Diwan

Amit Diwan

Updated on 20-Jun-2020 15:58:42

An operating system is a construct that allows the user application programs to interact with the system hardware. Operating system by itself does not provide any function but it provides an atmosphere in which different applications and programs can do useful work.The place of an operating system in a computer ... Read More

Database Backup and Recovery

Amit Diwan

Amit Diwan

Updated on 20-Jun-2020 09:55:23

It is imperative to have a backup of the database in case the original is corrupted or lost because of any reason. Using this backup, the database can be recovered as it was before the failure.Database backup basically means that a duplicate of the database information and data is created ... Read More

N-ary Relationship in Database

Amit Diwan

Amit Diwan

Updated on 20-Jun-2020 09:52:14

A relationship is an important part of any Entity relationship diagram as it shows the relation between two different entities. In an n - ary relationship, the n shows the number of entities in the relationship. It can be anything but the most popular relationships are unary, binary and ternary ... Read More

Functions in Oracle DBMS

Amit Diwan

Amit Diwan

Updated on 20-Jun-2020 09:50:11

The different types of functions in Oracle are −Oracle String FunctionsOracle Numeric FunctionsOracle Date FunctionsMore details about these functions are given as follows −Oracle String FunctionsThe following are the Oracle String Functions −ASCII(str)This function returns the ASCII or numeric value of the first word in the string str provided. If ... Read More

Special Operators in SQL

Amit Diwan

Amit Diwan

Updated on 20-Jun-2020 09:06:26

The different special operators in SQL are as follows −ALL operatorANY OperatorBETWEEN OperatorEXISTS OperatorIN OperatorLIKE OperatorNow let us create a table to understand the examples of special operators −Emp_IDEmp_NameEmp_SalaryEmp_DeptIDEmp_DeptName1Aaron1000010Technical2Harry1200020Operations3Mary500030Finance4Angel5500010Technical5Will2000030FinanceDep_IDEmp_IDDep_NameDep_Age10012Keith8810023Kim510035Lucy90Details of all the special operators using the above tables are −ALL operatorThe ALL operator compares a value with all the values ... Read More

Cursors in Oracle DBMS

Amit Diwan

Amit Diwan

Updated on 20-Jun-2020 08:53:39

When a SQL statement is executed in Oracle, the temporary context area is created. This area contains all the relevant information relating to the statement and its execution. The cursor is a pointer to this context area and allows the PL/SQL program to control this area.There are two types of ... Read More

1 2 3 4 5 ... 12 Next
Advertisements