Interview Questions & Answers

If you look at the large variety of SQL commands, they can be divided into three large subgroups.

Data Definition Language deals with database schema and descriptions of how the data should reside in the database, therefore language statements like CREATE TABLE or ALTER TABLE belong to DDL.

DML deals with data manipulation, and therefore includes most common SQL statements such SELECT, INSERT, etc.

Data Control Language includes commands such as GRANT, and mostly concerns with rights, permissions and other controls of the database system.

Allow modules to interact with the Drupal core.
Drupal's module system is based on the concept of "hooks". A hook is a PHP function that is named foo_bar(), where "foo" is the name of the module (whose filename is thus foo.module) and "bar" is the name of the hook. Each hook has a defined set of parameters and a specified result type.

To extend Drupal, a module need simply implement a hook. When Drupal wishes to allow intervention from modules, it determines which modules implement a hook and calls that hook in all enabled modules that implement it.

Yes, you can use drush –
drush is a command line shell and Unix scripting interface for Drupal

Drupal is an open-source platform and content management system for building dynamic web sites offering a broad range of features and services including user administration, publishing workflow, discussion capabilities, news aggregation, metadata functionalities using controlled vocabularies and XML publishing for content sharing purposes. Equipped with a powerful blend of features and configurability, Drupal can support a diverse range of web projects ranging from personal weblogs to large community-driven sites.

Drupal, Joomla, Wordpress, TYPO3

A content management system (CMS) is a collection of procedures used to manage work flow in a collaborative environment. These procedures can be manual or computer-based.
The procedures are designed to:
Allow for a large number of people to contribute to and share stored data
Control access to data, based on user roles. User roles define what information each user can view or edit
Aid in easy storage and retrieval of data
Reduce repetitive duplicate input
Improve the ease of report writing
Improve communication between users
In a CMS, data can be defined as almost anything - documents, movies, pictures, phone numbers, scientific data, etc. CMSs are frequently used for storing, controlling, revising, semantically enriching, and publishing documentation. Content that is controlled is industry-specific. For example, entertainment content differs from the design documents for a fighter jet. There are various terms for systems (related processes) that do this. Examples are web content management, digital asset management, digital records management and electronic content management. Synchronization of intermediate steps, and collation into a final product are common goals of each.