
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
George John has Published 1081 Articles

George John
1K+ Views
Restart the MySQL Server with the help of restart command.The syntax is as followsRestartLet us first check the MySQL version.The query is as followsSELECT version();Now, implement the above command in order to restart the MySQL Server.The query is as followsmysql> restart; Query OK, 0 rows affected (0.00 sec)Case 1Now, MySQL ... Read More

George John
5K+ Views
The program written in assembly language is entered by us by the help of any editor, we prefer a screen editor because when we enter the program it is of no importance for the particular exact column label of instructions and the starting of the program. But the point to ... Read More

George John
334 Views
The simplest data transfer scheme is the basic or simple data transfer. This method is beneficial to us when we have accurate knowledge of the Input-Output device timing characteristics. When we become familiar that the device is ready for transferring data, we execute the instructions IN and OUT, depending on ... Read More

George John
7K+ Views
Let us first create a table with columns for which we will calculate the difference in a new column −mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, LowValue int, HighValue int ); Query OK, 0 rows affected (0.62 sec)Insert some records in the ... Read More

George John
132 Views
To get the string representation of the CopyOnWriteArrayList, use the toString() method in Java.The syntax is as followsString toString()To work with CopyOnWriteArrayList class, you need to import the following packageimport java.util.concurrent.CopyOnWriteArrayList;The following is an example to implement CopyOnWriteArrayList class toString() method in JavaExample Live Demoimport java.util.concurrent.CopyOnWriteArrayList; public class Demo { ... Read More

George John
705 Views
We have seen previously that the linker is invoked in three modes i.e. they are command line mode, prompt mode and data file mode. For the linker to be run in this mode we type ‘LINK85 -C MULT.OBJ’ along with the change of address. In the above command simply “MULT” ... Read More

George John
608 Views
You need to use ALTER TABLE command along with MODIFYThe syntax is as followsALTER TABLE yourTableName MODIFY COLUMN yourColumnName varchar(100) NOT NULL;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table syntaxOfAlterCommandDemo -> ( -> UserId int, ... Read More

George John
2K+ Views
Intel 8085 consists of a RESET_IN* pin which is an active low input pin. We RESET 8085 by placing a logic 0 on this pin at least for 0.5μs, after that the power is supplied to Vcc pin of 8085. Moreover, in practice we place the RESET_IN* in logic 0 ... Read More

George John
1K+ Views
The master of microcomputer system is the microprocessor since all the operations of a computer are controlled by the microprocessor, the control unit often called as (CU) is found in the microprocessor. In the microcomputer system apart from processor there are several chips of RAM, CHIPS of EPROM and other ... Read More

George John
5K+ Views
A non-maskable interrupt is a Trap Interrupt which implies that whenever this pin gets activated, the 8085 always gets interrupted even if the state of 8085 is in DI. The input of Trap input is level sensitive and edge sensitive. Hence the Trap line always makes a transition from 0 ... Read More