Wordpress Interview Questions Answers
1) What is wordpress?
Wordpress is a free opensource CMS (Content Management System) that powers many popular blogs, article section of many different websites that have reputed brand, enterprise blogs, startup blogs etc
2) Why do businesses make use of wordpress?
Any enterprise be it startup, small business, medium sized business up to corporate needs marketing as an essential tool for product positioning which in turn drives sales, brings in money into business needed for business prosper. With changing business trends digital media marketing has become indispensable in this era. Wordpress makes digital media marketing very easy and simple
3) What is digital media marketing?
Called by various terms like online marketing, online media marketing the digital media marketing in plain simple terms, is marketing your business online.
4) How will you start your digital media marketing?
Digital media marketing starts with a website that talks more on your brand including when it got started, kind of services offered, what value a customer does get out of doing this business with you, your current stock price in case you have gone public, press release talking about market news, services offered, service pricing if one is available publicly, whitepapers related to your business in case of technology business etc
Now-a-days this information may not be sufficient unless otherwise you are an established brand. To market your brand online digital media marketing is an essential tool that can't be overlooked.
5) What marketing strategies are essential components of digital media marketing?
Digital media marketing is comprised of one or more of the following marketing strategies - content marketing, SEO marketing, PPC campaign etc
6) Where does wordpress fit in digital media marketing of an enterprise?
Wordpress has become the preferred CMS choice of most of the businesses starting with startup, small businesses as well as enterprises owing to the ton lots of features it has to offer
1) Easy to install - Now-a-days wordpress is a default CMS with any hosting provider and is included as part of most of their hosting plans be it shared hosting, dedicated web hosting. Wordpress installation happens at the click of a mouse. The domain name is automatically mapped onto the wordpress install folder. Creating a website with wordpress takes 5 mins maximum. Hosting providers like siteground that we make use of for all our web projects offer wordpress based hosting options to suit your needs
2) Simple to use - This is one of the handy tools that is as simple as opening a notepad, typing and saving a content. One difference is that the posts, pages created in wordpress websites are published to pull traffic that eventually translates to valuable customers for small businesses
3) Easy Administration - With basic mysql, php, webserver knowledge it is possible to administer wordpress - In most cases this is not even necessary as your hosting provider does take care of infrastructure part of your website
4) Plugin Functionality extensability - With wordpress plugins that are free it is possible to achieve several functionality. A simple wordpress site can be made shopping cart, online classifieds portal, event ticketing site etc
5) Change look and feel using wordpress themes - Most of the themes are free and premium themes cost probably between $45 to $90. Cheapest themes provide professional looking websites that are well optimized
All this is possible at one click of mouse.
7) Is wordpress helpful in building search engine optimization (SEO) friendly websites?
SEO is possible by simple tweaks to wordpress configuration options like changing post title format to %postname% using permalinks in dashboard, making use of yoast SEO plugin, creating simple sitemaps using sitemap.xml generator plugin etc
8) Your business wants to know how does choosing wordpress as CMS help them improve their business performance? Can you justify your decision ?
Today's business websites need to be created, hosted, positioned without much delay. Many enterprises are opting to utilize easy CMS like wordpress. Wordpress the most popular content management system (CMS) runs on PHP/MySQL stack. The backend database happens to be MySQL most of the time as much of the default hosting providers offer this stack as default with wordpress installer that happens to be 100% automatic in many cases
As MySQL is the preferred database that many hosting providers support, in addition to frontend administration of wordpress using dashboard it would be really easy to learn backend database manipulation to optimize the wordpress. This has a direct impact on increasing business performance
9) Which command is used to get to know the number of posts in each category?
To get to know the number of posts in each category this command comes handy:
select count(term_taxonomy_id),term_taxonomy_id from wp_term_relationships group by term_taxonomy_id;
10) How will you update content of posts in bulk in your wordpress website?
Lets say if a website has undergone migration as a whole from one domain name to another (or) some of the website posts have been moved to another website with a different domain name with links that does contain old domain name as part of it. In both these cases there is a need to update the domain name (or) some of the content after migration. To accomplish this make use of MySQL replace function against wp_posts table
update wp_posts set post_content=replace(post_content,'original_value','new_value') where post_Status='publish';
Above command updates only published posts. To update all post_types including publish, drafts etc try using the following:
update wp_posts set post_content=replace(post_content,'original_value','new_value');
11) What is the significance of bulk post deletion in a wordpress database? Why do you need that?
From dashboard we can delete maximum 20 posts at a time. Instead delete from backend in bulk. Lets look at bulk post deletion command from mysql database the backend
delete from wp_posts where (criteria can be specified);
Backend Tweaks to Optimize Wordpress :
12) How will you check valid users to stop spam users in your website?
I run a classifieds section in some of my websites. There had been lots of times wherein I had to see the entire site go down completely owing to resource consumption in the beginning days. To check against this if I look at Google analytics (or) Google webmaster tools report the number of searches against hosting account resource consumption dashboard and there was a mismatch
To look for users who are considered spam or bots and not a valid usertype issue the following command:
select * from wp_users where id not in (select author from wp_posts);
The basic meaning of above command is to pull users that don't contain any posts. However, check carefully before deleting users
As a general rule we have assumed the table names to be default table name wp_{tablename}. Depending on the installation it can take any prefix. Check the tablename prefix before issuing the commands as some of these commands make permanent changes that can't be changed in future
Check Valid Users :
Delete content directly from backend :
Get list of posts belonging to specified Category:
To get to know details of posts belonging to specified category issue the following command:
select * FROM wp_posts where id in(select object_id from wp_term_relationships WHERE term_taxonomy_id=value);
To get list of posts not belonging to any category issue:
select * from wp_posts where id not in (select object_id from wp_term_relationships);
Delete Comments - Mostly spam comments can be deleted as a single click deletion of all the comments issue:
delete from wp_comments;
Bulk purging of Trash Posts
To remove all trash posts at once we can use the command given below. This usually happens whenever we run plugin to remove duplicate posts:
delete from wp_posts where post_status='trash';
Get list of duplicated posts:
Though I rely on wordpress plugins to remove duplicate posts, to get list of duplicate posts that have been duplicated at content and title level issue the following command:
SELECT a.ID,a.post_title
FROM wp_posts AS a
INNER JOIN (
SELECT post_title, MIN( id ) AS min_id,post_content
FROM wp_posts
WHERE post_type = 'post'
AND post_status = 'publish'
GROUP BY post_title,post_content
HAVING COUNT( * ) > 1
) AS b ON b.post_title = a.post_title
and b.post_content=a.post_content
AND b.min_id <> a.id
AND a.post_type = 'post'
AND a.post_status = 'publish'
Update Post Content:
To update post_content we can use replace function of mysql
update wp_posts set post_content=replace(post_content,'original_value','new_value') where post_Status='publish';
10)
Why do you choose wordpress for creating your website?
Wordpress is the most popular CMS as it is free, easy to install
