Top 35 SEO Job Interview Questions

Seo Questions

Seo Questions

1) What is SEO and introduce its types?

Search engine optimization or SEO is a process of keep changing the position of a web page or website in a search engine results by using keywords or phrases.

Two Types of SEO are:

1.  On Page Optimization

2.  Off Page Optimization

2) What are the SEO tools do you use?

The SEO tools that I use are Google analytic, keyword search, Alexa, open site explorer, Google Webmaster.

3) What do you mean by Backlink?

 The incoming links to your website or webpage is referred as Backlink.

4) What are out bound Links?

The outbound links are our website links to other webpage or website.

5) Can you tell me something about Googlebot?

To index a webpage Google uses the Googlebot software. Caching, Crawling and indexing of a webpage are done through Googlebot by collecting details from that webpage.

6) What is Cross linking and what are the function of Cross linking?

1.  Cross linking is used to refer the process of linking one site to another site and provide a way to allow the accessing to it.

2.  It provides the users with reference sites that consists the content related to the search.

3.  It doesn’t need to be owned by the same person as it provides the methods that have been built on the Internet.

4.  It serves the purpose to display the page on the search engines using search engine optimization techniques and methods.

5.  The site ranking is calculated on the basis of the relevance of the sites and then it is reflected on the search engine.

6.  It uses SEO tools that provide reciprocal links and inbound links that can be used as our SEO.

7) What is the main purpose of using keyword in SEO?

Keyword is a single word, and while a combination of those keywords makes phrases. These keywords or phrases are used by the search engines to populate the subjects over the internet. Search engine stores keywords in the database, and when search is done, it will come up with the best possible match.

8) Can you mention the functions of body content relevance?

Whenever there is a text that does not have images on the web page is referred as body content relevance or non-image text. It helps in good optimization of the sites and also to improve your ranking in the search engine.

9) What are Spiders, Robots and Crawlers and what are their functions?

Spiders, robot and crawler, they are all same and referred by different names. It is a software program that follows, or “Crawls” different links throughout the internet, and then grabs the content from the sites and adds to the search engine indexes.

10) What does it mean if nothing appears on doing search on the domain?

On doing search on your domain and if nothing appears then there are three possibilities.

1.  May be the site is banned by search engines

2.  May be no index by search engines

3.  Some canonical issues

11)What is keyword stemming?

The process of finding out the root word from the search query is referred as keywords stemming.

12) Name some SEO blogs that you frequently read?

1.  Jimboykins

2.  Search Engine Land

3.  SEOSmarty

4.  MOZ

5.  Search Engine Journal

13) What do you mean by Cloaking?

Cloaking is a deceptive way of optimizing search. In this technique a different content will be searched by the search engine than what is presented or searched by the users.

14) How many types of Meta Tags are there in SEO and what are their characters limits?

There are two types Meta tags in SEO.

1.  Description Meta tag with 150 characters limits

2.  Keyword Meta tag with 200 characters limits

15) How many characters limits in Title tag?

We can add 70 characters in title tag.

16) What is Google Sandbox?

Google sandbox is an imaginary area where new websites and their search rating are put on hold until they prove worthy for ranking. In other words, it checks the standard of the website.

17) Tell me something about Black Hat SEO?

In order to get a high ranking in search engine result page, websites go for various methods and techniques which are characterized by two categories. One method that is acceptable by search engine guidelines is known as White Hat SEO, while the other method which is not acceptable by search engine guidelines is known as Black Hat SEO.

18) Name few Black Hat SEO techniques?

1.  Link Farming

2.  Hidden text, etc.

3.  Gateway or Doorway pages

4.  Cloaking

5.  Keyword Stuffing

19) Can you differentiate between ‘nofollow’ and ‘dofollow’ link?

Nofollow links are not passed by search engines bot and therefore cannot be cached or indexed. Dofollow link is a kind of hyperlink and it passes through all search engines and it puts an impact over page rank.

20) What is the difference between PR (page rank) and SERP (Search engine result page)?

Page rank is calculated on the basis of quality inbound links from other website or webpages to our webpage or a website.

SERP (Search Engine Result page) is the placement of the website or web-pages which is returned by the search engine after a search query or attribute.

21) Why the Title Tag in website is valuable?

Title tags are very essential in SEO, as it tells about the contents on that web page. Through title tags only the search engine will tell the user, what is there in the page.

22) What is considered as more significant, creating content or building backlinks?

Both are necessary, creating quality content is equally important to building backlinks. Although, building backlinks are useful in building authority to a site and for ranking as well, quality content is the first element that is considered to be more responsible for ranking.

23) Can you mention the difference between SEO and SEM?

SEM (Search Engine Marketing), it is used for the promotion of website through Search Engine Result Page (SERP) , while to optimize the search result of your webpage or website SEO (Search Engine Optimization) is used.

24) What do you know about LSI?

LSI stands for Latent Semantic Indexing. This technique is established to obtain the data by relating the word to its closest counterparts or to its similar context. For example, if you are searching something with a keyword “CAR” it will show all the related things like classic cars, car auctions, Bentley car, car race etc.

25) How will you cross-check whether your SEO campaign is working or not?

To check whether your SEO campaign is working or not, the first approach is to check the websites statistics, which tells you about the origin of traffic.  The other way of checking is to make a search based on the relevant keywords and key phrases and look for the search result. The number of search result will tell you whether your SEO campaign is working or not.

26) What is the meaning of competitive analysis?

Competitive analysis does the comparison, between the website I am optimizing, and the website that is ranked highly in search results.

27) What will be your next steps if your SEO methods or technique does not work?

My first attempt would to try analysis the problem and resolve them step by step

1.  Firstly I would try to see whether it is a new project, and then like to re-check the key words.

2.  Also, I would look for relevant key-words that can be helpful.

3.  Even though the webpage and website has been indexed well and still not appearing on the first 10 pages of search engine result page, then I would make some changes in page text, titles and description.

4.  If website is not indexed well or dropped from the index, than it might comprises     serious issues and re-work might be required.

28) What is PPC?

PPC stands for Pay Per Click and is an advertisement campaign hosted by Google.  It is segmented into two modules CPC ( Cost per click) and CPM ( Cost per thousand impressions) through flat rate and bidding respectively. In CPC, if the user clicks on the advert, only then the advertiser will be charged.

29) What is 301 redirect?

It is a method by which the user is redirected to new page url to old page url . It is a permanent redirect and it is also useful in directing link juice to new url from old url .

30) What are Webmaster tools?

Webmaster tool is a service provided by Google from where you can get backlink information, crawl errors, search queries, Indexing data, CTR etc.

31) What is keyword density and what is the formula for knowing keyword density?

From SEO point of view, keyword density will definitely help to stand out your content from others. The formula to know the keyword density is ( Total number of keyword/ total number of words in your article) multiply by 100.

32) What is robots.txt? 

Robots.txt is a text file. It is through this file, it gives instruction to search engine crawlers about indexing and caching of a webpage, file of a website or directory, domain.

33) What will you do, for the company website you are working for, decides to move all the contents to new domain?

The first step would be to update the previous site with a permanent redirect to new page for all the pages. After that, I will remove the previous content from search engine in order to avoid duplicate content issues.

34) Can you optimize the website which has pages in millions?

From SEO point of view, for dynamic website, special additional SEO stuffs have to be    implemented.

1.  Good Internal link structure

2.  Generation of dynamic title and description

3.  Dynamic XML sitemap generation

35) What is the latest update in SEO?

The latest updates in SEO are:

1.  Panda

2.  Penguin

Bonus! 3 More!

36) What are the key aspects of Panda update?

Panda is to improve the search in Google. The latest version has focused on quality content, proper design, proper speed, proper use of images and many more.

37) What are the key aspects of Penguin update?

Penguin is the code name for Google algorithm. Its main target is to decrease the ranking of that website that are violating the Google Webmaster guidelines. These guidelines are violated by using black hat techniques like cloaking and stuffing.

38) How will you neutralize a toxic link to your site?
Through Backlink Quality Checker you can know who links to your website. Now, you have to go to ‘ Toxic link’ report, where you will find all the links, that are harmful to your websites. If there is any link in ‘ Toxic link report’ that matches with the link on your website, then you can remove it by using ‘Google Disavov tool’.

1 Read More »

Top 15 Microsoft Access Database Interview Questions

1) Explain how you can import data from other sources into Access database?

To import data into Access data-base

·          In the main menu, click on EXTERNAL DATA, in the Import and Link group

·          Choose the type of the file you want to import

·          To know which type of file can be import or link Access database, follow the instruction in the Get External Data wizard

2) Explain what is the size limitation for an Access database?

The Access 2.0 database has the size limitation of 1 gigabyte.

3) Between different data’s what are the types of relationship can be formed?

The table contains your data can build three types of relationship

·          One-to-one relationships: A single data in one table is linked with a single data in another table.

·          One-to-many relationship: A single data in a table is linked to several data’s in another table

·          Many-to-many relationship: Where several data’s in one table is related to several other data’s in another table

4) Explain how you can build a relationship between the different databases in Access?

When you establish a relationship between two data, the first table for your data is referred as the primary key while the new field in another data is called a foreign key.

5) Name some of the file extension for MS Access?

Some of the file extension for MS Access is

·          Access database.accdb

·          Access project.adp

·          Access project.mdw

·          Access blank project template.adn

·          Access workgroup.mdw

·          Protected access database.accde

6) Explain what do you mean by queries?

Queries are the medium of manipulating the data to display in the form or report.  Queries can join tables, update data, delete data, sort, calculate, filter, etc.

7) Explain what joins are and how you can open the database in Access?

Joins determines the relationship between tables in Access by stating the details of the relationship between two tables.  You can create joins on the database tools tab or by opening a query in design view.

8) Mention how you can create a simple query in Access 2013?

·          Open your database

·          Go to -> create tab

·          Click on the query wizard icon

·          Select a query type

·          From the pull-down menu choose the appropriate table

·          Select the field you want in the query results

·          To add information from additional tables, repeat steps 5 and 6

·          Click on next

·          Choose the type of results that you would like to produce

·          Give your query a title

·          Click on finish

9) Explain how you can export data in Excel format?

·          From the toolbar click on the External Data tab

·          Click Excel on the Export group

·          It will open the export excel spreadsheet dialog box

·          Specify the destination of the file name and format

·          When you click OK, it will export the data to Excel spreadsheet

10) Explain how you can create a table using MAOL (Microsoft Access Object Library)?

To create a table using MAOL, you have to pronounce a variable of type object and then initialize it with the CreateTableDef() method of the recent database object.  This technique takes argument as the name of the table.

11) Explain how you can create a form in Microsoft Access 2013?

Forms allow inserting data across multiple tables.  There are different methods for creating forms but with Form Wizard method, you can always modify the form later using Design View.  To create a form

·          From the main menu, click on CREATE and then choose the FORM option

·          It will create a new form in Layout view, based on the fields in the Customer table

·          Scroll the drop down arrow under the View icon and select Form View. This how the user will see the form.

·          On the form, you will see fields like CustomerId, First Name, Last Name and Date Created

·          After filling of all details in the form, you can see the newly created record with data in the table

·          Once you completed filling the field in the form, confirm that you click on the save button on the top of the ribbon

12) In MS Access 2013 what are the different ways you can enter data?

Different methods you can enter data in MS Access are

·          Datasheet View

·          Form

·          SQL View

·          Import from External Data (XML, Data Services, HTML etc.)

13) Explain the use of WHERE clause in MS Access SQL?

·          In the WHERE clause of a SELECT statement, you use query criteria. For example, you want to find the address of a particular customer, but you only remember his last name that is Harrison. Instead of searching all the fields in the table, you use where clause to retrieve the address of the customer.

WHERE [LASTNAME] = ‘Harrison’

·          You cannot link or join fields that have dissimilar data types. To link data from two different data sources, depending on values in fields that have different data types; you will create a WHERE clause that uses one field as a criteria for the other field, by using LIKE keyword.

14) Explain how we can do multi-join query in MS Access?

In Access, we can only join two tables, in order to join more tables you require to group the first join together by using parentheses, as if it was a newly derived table.  After that, you can join another table to that group.

Select

*

from

( ( Table 1

LEFT JOIN Table 2…

)

LEFT JOIN Table3…

)

LEFT JOIN Table4…

15) Explain how MS Access is better than MS SQL Server?

·          With a small number of users, MS Access is easy to handle and suited for desktop use

·          Easy compatibility and sharing compare to MS SQL Server

·          SQL server is, usually, used by developers and in a bigger organization

·          MS Access is cheaper than MS SQL

·          MS Access requires less database administration

1 Read More »

Top 25 Microsoft PowerPoint Interview Questions

Powerpoint Interview Questions

1) How you can set password in PowerPoint 2013?

To set a password in power point

·          Go to File > Click on Info

·          Click on protect presentation

·          Under which there is an option, “Encrypt with Password” , click on it

·          Hit “OK” once you enter the password

·          Now it will again ask to Re-enter the password

·          OKà Exit

2) How can you show your presentation online in PowerPoint 2013?

To present your online presentation in PowerPoint

·          Click on Fileà Shareà Present Online

·          Select the option enable remote viewers to download the presentation check box

·          Click Present Online

·          Send your meeting invitation to attendees by copying link or send in email

·          To get out of the Slide Show press ESC and click on End Online Presentation to end the presentation

3) What is the short cut key for last action performed and to move the mouse insertion point to the next panel in PowerPoint 2013?

a)      Short cut key for last action performed: F4

b)      Short cut key to move the mouse insertion point to the next panel: F6

4) How you can record a slide show in PowerPoint 2013?

To record a slide show in power point

·          Click the slide show tab, then locate the Set Up group

·          Click the Record Slide Show drop down arrow.  Select either “Start recording from current slide” or “ Start recording from Beginning”

·          A dialog box will appear, select the desired options “Select and animation timings” and second option is “ Narration and laser pointer” and then click on “ Start Recording” option.

·          Soon you click on “Start Recording” your presentation will open on a full screen

·          Perform your slide show, when you are ready to move to the next slide, click “Next” button represented with an arrow mark on the “Recording Toolbar”

5) How you can create a video in PowerPoint 2013?

·          Select the file tab

·          Select Export and then click Create a Video , video export option will appear on the right

·          Click the drop down arrow next to Computer and HD Displays for the size and quality of your video

·          Select the option according whether you want to record narration or not

·          Click Create Video and then save the video

6) How can you play music for the duration of your slide show in PowerPoint 2013?

·          Download or store music to your PC hard drive and from there upload it to PowerPoint

·          In the main menu on the “Insert” tab, click “Audio” and then click on “Audio on my PC”

·          Locate and double click the music file

·          Click on “Play in Background” under “Playback” tab

7) How you can use and Eyedropper Tool in PowerPoint 2013?

To match the text color match with the slide, Eyedropper function can be useful.

·          Click inside an already created text box, with in “home tab”, select the font color icon in the navigation bar.  In the drop down menu, click the “Eyedropper” at the bottom

·          Select the Eyedropper option over the part of the image you want to colour and click on it. The font color will change

8) How to merge shapes in PowerPoint 2013?

To merge two shapes in PowerPoint 2013,

·          Go to à  Insert tab

·          You will see the “Shapes” button, click on it

·          Select the shape you want

·          Repeat the same step again to add second shape to the slide

·          Select the two shapes

·          Go to à Format tab

·          Click on the small icons available and choose your options, like Union, Combine, etc. Here we use option Combine to merge shapes

9) How you can copy slide master from one presentation to another in PowerPoint 2013?

·          Open both the presentation which you want to copy and where you want to copy

·          In the presentation that contains the slide master that you want to copy on the viewtab and click Slide Master

·          In the slide thumbnail panel, right click the slide master and then click Copy

·          On the View tab , click Slide Master.

·          In the thumbnail panel, right click the slide master and then do one

·          Click Close Master View on the Slider Master tab once done

10) Can we make PowerPoint slides into PDF files in PowerPoint 2013?

To convert PowerPoint slides into PDF files select

·          File à Export à Create PDF/XPS document.  Click the create PDF/XPS button

11) How someone can check compatibility check when you share PowerPoint 2013 slide to previous or older version?

When you share or send PowerPoint slide 2013 to an older version and want to check compatibility test, Go to File à Info à Check for issues à Check Compatibility.  The tool tells you which new features are not compatible with older versions.

12) How you can add services in PowerPoint 2013?

To add services in PowerPoint 2013,

·          Select Account option from the file menu

·          A account window will open and you will find a Connected Services section

·          You will see in this section that the list of services is added for PowerPoint

·          With-in Add a service drop down menu, you will find options like Images & Videos ( Flickr, Youtube) , Storage ( 365 Sharepoint, Onedrive)  and Sharing (Facebook, Twitter)

·          Once you click the Connect button, it will ask for your mail address and once connected to service click on Done button

13) How you can convert text to shapes in PowerPoint 2013?

To convert text into shapes

·          On your slide insert a text box and type some text

·          Select the text box on a slide

·          Insert a shape that overlaps your text box in a way that covers it completely

·          Once the rectangle shape is placed, re-order the rectangle shape by sending it behind the existing text box

·          Select the text box first and then select the rectangle shape, after that access theDrawing Tools Format and click the Merge Shapes button

·          Under Merge Shapes drop down gallery, click on Intersect option

·          It will convert text into shapes

·          To ensure the text is converted into shape, right click on the text and a context menu will appear, you will see the edit point option

·          If no edit points option is available, it means your text has not been converted into a shape

·          When you click on Edit Points option, you will see all the edit points on text

14) How to use PowerPoint 2013 Slide Zoom Feature?

To use PowerPoint 2013 Slide Zoom,

·          Beneath the main slide, click on the magnifying glass icon in Presenter View

·          Hover around the area of the slide you want to magnify

·          Click and drag the hand tool over the slide to move the slide around while still zoomed in

·          To zoom back out click the magnifying glass icon

15) How to customize your slide PowerPoint 2013?

To customize your slide, first open a new PowerPoint slide

·          Choose a theme from Design menu, once you have selected the slide theme  then you can change the look of  a slide by  clicking on variant

·          To change the color of slide you can use customize option, this option gives various option to customize slide to your liking

·          You can also customize the text box by clicking on the text and it will give text customization option

16) How you can use Document Inspector and what is the role of it in PowerPoint presentation?

The Document Inspector function can be used to remove certain personal information which may be added to the file automatically.

·          Click on File tab under Backstage View

·          From the Info panel, click Check for Issues ,  then select Inspect Document from the drop down menu

·          The Document Inspector will appear.  Check or uncheck the boxes, depending upon the content you want to review, then click Inspect

·          For any potentially sensitive data the inspection result will show exclamation mark and a Remove All button to remove the sensitive data

17) How you can protect your presentation in PowerPoint 2013?

To protect your presentation in PowerPoint 2013,

·          Click the File to Backstage View

·          In Info panel, click the Protect Presentation command

·          In drop down menu, choose the option that best suits your needs.

·          Let say if you mark it as final a pop up box will appear asking you to save document as final

·          When you click OK another pop up box appear confirming the document is saved as final

18) How you can insert online video in PowerPoint 2013?

To insert online video in PowerPoint,

·          Go to à  Insert

·          At the end of Insert menu, you see an option Video, click on it

·          Click on online Video, and you can upload video

·          You can upload video from Facebook account, by clicking on the Facebook icon

19) How you can trim video in PowerPoint 2013?

To work on specific part of video or to delete some part of video, PowerPoint gives trim option, the playback tab has several options which you can use to edit your video.

·          Select the video you want to trim and click the Playback tab on the ribbon

·          Click the  command Trim Video

·          A dialog box will appear, to set the start time use the green handle and to set the end time use the red handle

·          To preview the video, click the Play button

·          When you are done trimming the video, click OK

20) How you can add bookmark to the video in PowerPoint 2013?

To add bookmark to the video,

·          To locate the desired part of the videos click on the timeline

·          Click the Add Bookmark command from the playback tab

·          On timeline, Bookmark will appear, click the bookmark to jump to that location

21) How you can customize slide layout?

To customize slide layout

·          Navigate to Slide Master view

·          Locate and select the desired layout in the left navigation panel.  Over each layout you can hover the mouse to see which slides are currently using that layout in presentation

·          The background graphics may be hidden in some layouts, to show this graphic uncheck the box next to Hide Background Graphics

·          You can also add, remove or delete any objects as desired

·          When you finish click on Close Master View command on the Slide Master tab

22) How you can rehearse the slide show timing in PowerPoint 2013?

To set or rehearse the slide show

·          Select the Slide Show tab and then locate the Set Up group

·          Click the Rehearse Timing icon on ribbon and it will take you to the full screen of your presentation

·           You can start rehearsing your PowerPoint presentation, and your presentation timing will be noted down by rehearsing time

·          Click on next arrow on the Recording Toolbar to move to the next slide

·          At the end of your presentation, PowerPoint will close the full screen view and give the total timing for the presentation at the end.

23)  How to change effect’s start option?

To change the effect’s start option,

·          From the animation pane, select an effect. A drop down arrow will appear next to the effect

·          Click the drop down arrow, there will be three option that will appear

Start on Click: It will start the effect when mouse is clicked

Start with Previous: It will start the effect at the same time as the previous

Start after Previous: It will start the effect when the previous effects ends

24) How you can embed a chart from Excel to PowerPoint?

To embed a chart from excel to PowerPoint,

·          Go to Insert tab

·          In the Text group click the Object command

·          A dialog box will pop up, select Create from file and then click on Browse

·          Select your Excel file and then click on Insert

·          Check the box next to Link to file if you would like to link the data to the Excel chart. This will update your chart automatically whenever the changes are made to the excel chart

·          Click OK and the chart will appear in presentation

25) How you can record a slide show?

Record a slide show option is similar to rehearse time function but more comprehensive, you can include narration for your presentation by using record a slide show

·          In main menu, click the Slide Show tab and locate the Set Up group

·          Click the Record Slide Show from the drop down.

·          Now can select either of the option Start recording from beginning or Start recording from current slide

·          A checkbox will appear asking “slide and animation timing” and “Narration and laser points”. If you have checkbox the option click on Start Recording

·          When you finish recording first slide you can move to record next slide by clicking on next button on the Recording Toolbar in the top left corner or use the right arrow key

1 Read More »