Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles on Trending Technologies
Technical articles with clear explanations and examples
What is CTET?
It is a famous competitive exam in India. It is the acronym of Central Teacher Eligibility Test. As the name suggests, it is a qualifying exam for recruiting teachers for central schools like Kendriya Vidyalaya School, Army Public School, Navodya School and the like.The exam is taken to allow candidates who want to make their career in the teaching field to fulfil their dream of teaching. The Ministry of Human Resource Development, Govt. of India has entrusted the responsibility of conducting the Central Teacher Eligibility Test to the Central Board of Secondary Education Delhi.Is CTET only for central schools?While the ...
Read MoreHow does Constraint Layout works in android?
In simple words, constraint layout is an advanced version of a Relative layout. It is used to reduce the child view hierarchies and improve the performance.Properties of constraint layout as shown below -Wrap Content –It wrap the view size according to data. Any Size – This is very similar to match parent. Fixed Size – This allows standard height and width(fixed sizes). In the above example we have shown the button with all properties, now look into code level as shown below -In the above, we have declare layout margin-top, bottom, start and end. those are the standard distance (Similar ...
Read MoreHow to cancel an executing AsyncTask in Android?
Before getting into example, we should know what is AsyncTask in android. AsyncTask going to do operations/actions in background thread and update on mainthread. While doing background operations on background thread, user can cancel operations by using the following code -AsynTaskExample mAsyncTask = new AsyncTaskExample(); mAsyncTask.cancel(true);This example demonstrate about how to cancel an executing AsyncTask in android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. In the above code when ...
Read MoreWith an active backlog in BTech, can I get a job in the software field?
It really does not matter whether you complete your B.Tech or not if you have software skills. Many companies are allowing one or two backlogs when they select the students during campus interviews.A lot of my friends who have one or two backlogs are already placed in good companies like Deloitte, Wipro, and others based on their technical knowledge by the end of 4th year, even before final exams. At the end of the day, you have to complete the graduation. But, for time being you can start working in the software field.
Read MoreGroup month and year in MySQL?
You can group month and year with the help of function DATE_FORMAT() in MySQL. The GROUP BY clause is also used.The syntax is as follows −SELECT DATE_FORMAT(yourColumnName, '%m-%Y') from yourTableName GROUP BY MONTH(yourColumnName), YEAR(yourColumnName)DESC;To understand the above concept, let us create a table. The following is the query to create a table −mysql> create table GroupMonthAndYearDemo −> ( −> DueDate datetime −> ); Query OK, 0 rows affected (1.49 sec)Insert records in the table using the following query −mysql> insert into GroupMonthAndYearDemo values(now()); Query OK, 1 row affected (0.11 sec) ...
Read MoreProgramming the 8253
According to the microprocessor point of view, the 8253 is designed and has some specialty port chip I/O. We don't use it for interfering the I/O devices. For performing the application of time it is used. 8253 has the addressed A1 and A0 input pins.The counters have width of 16 bits. If they were 8-bits wide, the delay in time that would be generated is very small. The Least Significant Byte and the Most Significant Byte of a counter is selected by using the same address of the port.The processor here writes to the control port to configure the working of ...
Read MoreWhat is the use of the app PhonePe?
PhonePe is a very popular and useful application especially in today’s era of digitization. The app is named after Fin-Tech company, the headquarters of which are in Bangalore, India. It is quite recent, as it was found in December 2015.Uses of PhonePe1. Mobile recharge: By using this app, you can get your mobile phone recharged very easily. You simply need to mention the amount, phone number and the appropriate mobile operator's name. You can even browse plans. You don’t have to load funds into your wallet for the recharge. Rather, you can make payments from your bank account by using ...
Read MorePerform MySQL delete under safe mode?
To delete under safe mode, you can use the below query −SET SQL_SAFE_UPDATES = 0;To understand the above query, let us create a table. The following is the query to create a table −mysql> create table SafeDeleteDemo −> ( −> Price int −> ); Query OK, 0 rows affected (0.50 sec)Insert some records in the table with the help of insert command. The query is as follows −mysql> insert into SafeDeleteDemo values(100); Query OK, 1 row affected (0.11 sec) mysql> insert into SafeDeleteDemo values(200); Query OK, 1 row affected (0.19 sec) mysql> insert into SafeDeleteDemo ...
Read MoreWho is known as the Father of Internet?
Vinton G. Cerf is known as the “Father of the Internet". He is the co-designer of the TCP/IP protocols and the architecture of the Internet. The US President, Bill Clinton presented the U.S. National Medal of Technology to Cerf and his colleague, Robert E. Kahn, for founding and developing the wonderful creation of the Internet in December 1997.The contribution of Cerf and his colleagues have been acknowledged and applauded all over the world. Today, we cannot imagine our lives without the Internet.Vint Cerf has been awarded many honorary degrees and prizes that include the Turing Award, the Presidential Medal of ...
Read MoreIn MySQL how to select the top 2 rows for each group?
To select the top 2 rows from each group, use the where condition with subquery. Let us create a table. The query to create a table is as follows:mysql> create table selectTop2FromEachGroup -> ( -> Name varchar(20), -> TotalScores int -> ); Query OK, 0 rows affected (0.80 sec)Now insert some records in the table using insert command. The query is as follows:mysql> insert into selectTop2FromEachGroup values('John', 32); Query OK, 1 row affected (0.38 sec) mysql> insert into selectTop2FromEachGroup values('John', 33); Query OK, 1 row affected (0.21 sec) mysql> insert into selectTop2FromEachGroup values('John', 34); Query OK, ...
Read More