Magento Interview Questions – Set 01

by

How many tables will be created in EAV module in Magento? Name them

EAV module will create 6 tables in database.

They are as follows:

  • module
  • module_datetime
  • module_decimal
  • module_int
  • module_text
  • module_varchar

Explain the difference between EAV and flat model..

EAV database model is fully in normalized form. Each column’s value is stored in their respective data type table which makes it more complex as they have to join 5-6 tables even if you need only one detail. In EAV, columns are called attributes.

Flat model uses just one table. It is not normalized and uses more database space. It is not good for dynamic requirements where you may have to add some more columns in future. Its performance is fast as it needs only one query instead of joining 5-6 tables. In flat model, columns are called fields.

Explain the use of namespace in Magento?

Magento core modules are placed in mage namespace, core/Mage/Catalog and all custom modules are placed in local/CustomModule.

You can have more than one module with same name but they need to be placed in different namespaces.

What was the initial release date of Magento?

Magento was initially released on 31st March, 2008.

How can you add an external JavaScript/ CSS file to Magento?

css/yourstyle.css
or

skin_jsjs/ yourfile.js
skin_csscss/yourstyle. css

Explain how to change Magento core API setting?

You have to follow these steps to change Magento core API setting.

  • Go to Admin menu, choose System -> Configuration
  • Select Magento Core API on the left side of the Configuration Panel, under Services
  • Click on to expand the General Settings section
  • Type name of the Default Response Charset that you want to use
  • Determine the Client Session Timeout in seconds
  • Click the Save Config button when completed

How can you improve performance of Magento?

There are various ways to improve Magento performance.

  • Disable any unused modules
  • Magento Caching
  • Optimize your Server
  • Use a Content Delivery Network (CDN)
  • Put Stylesheets at the Top
  • Put Scripts at the Bottom
  • Avoid CSS Expressions
  • Disabling Magento Log
  • improve the image

Is it possible to have more than one grid in Magento?

Yes it is possible.

What are Magento product types?

Magento simple product: It is used for a single item without any specific selectable variations. For example, a pen, copy, etc.
Magento grouped product: It is used for a combination of Magento simple product. For example, a pen and copy together.
Magento configurable product: It is used for a single item with specific selectable variations. For example, a pen with different color options.
Magento virtual product: It is used for a virtual item i.e: non touchable item. For example, reservation, insurance, etc.
Magento bundle product: It is used for a bundle of simple products. For example, laptop with various items such as processor, hard disk, RAM, etc.
Magento downloadable product: It is used for online software items. For example, PowerPoint presentation, MP3 files, servers, etc.

Explain handles in Magento?

Handles control the structure of the page to be displayed. It decides which block will be placed where in the page. Handle is called for every page and every page request can have several unique handles.