Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Theme writing is very important under the banner of Academic writing. One must keep it crisp and clear in order to avoid any confusion in it.Things to keep in mind for Theme WritingUnity: All your sentences should work around a central idea. This will happen only when at the beginning itself we know about the keywords and the key sentence in the paragraph. The key sentence in the paragraph defines our field of work or the subject matter of our creative flow of thoughts. We must strategically confine ourselves to eliminate ourselves from any sort of digression from our themeCoherence: ... Read More
Human Resource manager or HR of a company holds quite a significant role in the overall functionality of the proceedings carried out in an organization. However, an HR sometimes may appear quite different in the other employees' depiction. So, why does it happen? Plainly because the responsibilities the HR person has to carry. But can it be done without being characterized? Here's the answer:Attitude You Must CarryNot To Be Too Close to Anyone In the Office: Human Resource Manager should be someone who alienates himself/herself in the office. This is because, HR is involved in dealing with leave applications, appraisal ... Read More
To test and certify on one's knowledge about HPE server products and solutions, the HPE0-S37 exam is conducted. By completing the exam and attaining certification, one can increase his/her chances of getting server-related jobs.The question is how to pass the exam with flying colors. Due to the complexity of the course, it is a tough task to pass HPE0-S37. If you know the structure of the exam, you can prepare accordingly and chances of passing will increase. Here is the pattern of questions given during the exam.Foundational server architecture and technology 37%Functions, features, and benefits of HPE server products and ... Read More
The ftp_chdir() function changes the current directory on the FTP server.Syntaxftp_chdir(con, dir)Parameterscon − The FTP connectiondir − The directory to change toReturnThe ftp_chdir() function returns TRUE on success or FALSE on failure.ExampleThe following is an example wherein the current directory is changed −
You need to use CAST() or CONVERT() function to convert output of MySQL query to UTF8. Here, I am using MySQL version 8.0.12. Let us first check the version:mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.12 | +-----------+ 1 row in set (0.00 sec)In this if you use utf8 then you will get warning of aliases because it has utf8mb4. Therefore, you can avoid the warning by placing utf8mb4.Note: Never use UTF8. For current versions, use UTF8MB4Here is the syntax to convert output of MySQL query to UTF8:SELECT yourColumnName1, convert(yourColumnName2 USING utf8) as anyVariableName FROM ... Read More
To perform echo print statements while executing SQL scripts, use the following syntax.The syntax is as follows −SELECT ‘anyStringValue as’ ‘;The query is as follows −mysql> select 'This is a SQL Script' AS' ';The following is the output −+----------------------+ | | +----------------------+ | This is a SQL Script | +----------------------+ 1 row in set, 1 warning (0.00 sec)You can add dynamic data to your status like insert, update and delete with the help of concat() function. The query is ... Read More
Every business will have stiff competition from already established businesses and brands. Nowadays whether it is simple chips packet or a luxury car, people have become smart enough to go through the reviews and customer ratings before they buy. People will judge by hearing the name of the brand and make decisions based on other customer's reviews. These trends are seen more in online eCommerce sites.It's clear that customer satisfaction metrics are essential for any business. They impact the decisions of current and potential customers. This is the reason, you should never ignore the importance of customer satisfaction. Online surveys ... Read More
The occurrence of lifting the outer border of the curved road over the inner border is to give necessary combining force to the vehicles to take a guarded turn and the curved road is termed as Banking of Roads. When a vehicle prevails around a curved road, it needs some combining force.While moving around the curve, the wheels of the vehicle have a propensity to leave the curved path and recover the straight line path. Force of friction between wheels and the roads goes against this propensity of the wheels. This force of friction accordingly acts towards the middle of ... Read More
Bank PO, SSC examinations are some of the popular competitive examinations taken by aspirants who wish to step into a good government job. The syllabus includes questions on Quantitative Aptitude, Logical Reasoning, Verbal Ability, and General Knowledge.How to Prepare for Verbal Ability?Go through the complete syllabus of the particular exam you are planning to take.Purchase verbal ability books available in the market. You may also get it from someone, or get second-hand books from the market if you do not wish to buy new copies.Practice each and every concept from these books, and practice those concepts which you find difficult ... Read More
To adjust display settings of MySQL command line, use the /G at the end of MySQL queries instead of semicolon(;).The syntax is as follows −SELECT *FROM yourTableName \GThe above syntax adjusts the display settings. Here we will display records in row format from our sample ‘studenttable’ table which we created using CREATE −mysql> create table StudentTable −> ( −> Id int, −> Name varchar(100) −> ); Query OK, 0 rows affected (0.65 sec)To get all the records −mysql> select *from StudentTable;The following displays the records −+------+---------+ | Id | Name | +------+---------+ | ... Read More