FuelPHP Interview Questions and Answers for Beginners

Question: What is FuelPHP?
FuelPHP is PHP Framework written in PHP, based on the HMVC pattern.


Question: Is FuelPHP Open Source?
Yes, It is Open Source.


Question: What is minimum PHP Version required for FulePHP?
PHP 5.4+


Question: Is FulePHP support Multilingual?
Yes, It support Multilingual.


Question: What is offical website of FulePHP?
fuelphp.com


Question: What are Key Features of FuelPHP?

1. URL routing system
2. RESTful implementation
3. HMVC implementation
4. Form Data validation
5. ORM (Object Relational Mapper)
6. Vulnerability protections like XSS, CSRF, SQL Protection and encode output.
7. Caching System

Question: What is full form of HMVC?
Hierarchical-Model-View-Controller


Question: What is HMVC?
HMVC is an evolution of the MVC pattern.


Question: What are benefits of HMVC?

1. Modularization
2. Organization
3. Reusability
4. Extendibility

Question: How to get Query in FulePHP?

$userQueryToExecute = Model_Article::query()
        ->select('users')        
        ->where('blocked', '=', 1);

echo $userQueryToExecute->get_query();

Question: How to check that Redis server is running?

try
{
    $redis = \Redis::instance();    
}
catch(\RedisException $e)
{
    //here error will come
}

Question: How to use join with condition?

$queryObj = \Services\Model_Org::query()
->related('org')
->related('profile_image')->related( array(  'comments' => array(   'where' => array(    array('visible' , '=' , '0')   )
  ) ))
->where('rating','!=', 'null')
->order_by('rating','desc')
->get();

Best Related Posts are Following:

1. Laravel Interview Questions and Answers.
2. YII interview questions and answers for fresher.
3. Python Interview Questions and Answers for Freshers.
4. OOP Interview Questions and Answers.
5. jQuery Mobile interview questions and answers.
6. AngularJS Interview Questions and Answers for Experienced.
7. Codeigniter Interview Questions for Experienced.
8. SMTP interview questions and answers.
9. Apache Interview Questions and Answers.
10. Magento interview questions and answers for experienced.
11. Frontend Interview Questions and Answers for experienced.
12. Android Interview Questions and Answers for fresher and Experienced.
13. Htaccess interview Questions and Answers for fresher and experienced.
14. Javascript Interview Questions and Answers for Experienced.
15. Paypal Integration Interview Questions and Answers.
16. Android Interview Questions and Answers for Freshers.
17. HTML5 interview Questions and Answers for Fresher and Experienced.
18. SAML Interview Questions and Answers.
19. Backbone Js interview questions and answers.
20. Bootstrap Interview Questions and Answers for Experienced.
21. HTML interview questions and Answers.
22. SEO Interview Questions and Answers.
23. Wordpress Interview Questions and Answers.
24. Difference Between Hadoop and Big-Data.
25. Memcached interview questions and answers.
26. UNIX Commands Interview Questions and Answer

What is Super Key, Candidate keys and Alternate Key?

Super Key
A Super key is any combination of fields within a table that uniquely identifies each record within that table.

Example:
managers (table)

ManagerID (unique)
Name
Title
DepartmentID

ManagerID+Name=Super Key
ManagerID+Title=Super Key


Candidate keys
Candidate keys are those keys which is candidate for primary key of a table. Candidate keys are such keys which full fill all the requirements of primary key which is not null and have unique records.

Example:

Suppose we have a table named Employee which has two columns EmpID and EmpMail, both are not null and have unique value.
Both Field are Candidate keys.

Alternate Key
If any table have more than one candidate key, then after choosing primary key from those candidate key, rest of candidate keys are known as an alternate key of that table.

Example:

Suppose we have a table named Employee which has two columns EmpID and EmpMail, both are not null and have unique value.
So both columns are treated as candidate key.
IF we make EmpID as a primary key, then EmpMail is known as alternate key.

Referential integrity
Referential integrity is a database concept that ensures that relationships between two table remain consistent.

Suppose one table has a foreign key to another table. Referential integrity makes ensure the both have valid record.

Example:

products (table)
    id (primary key)
    name 
    price
    sale_price
    size

reviews (another table)
    id (primary key),    
    product_id (foreign key)
    review by
    title
    start_rating

One Product can have one Or multiple reviews.
Referential integrity make sure following:

1. You can't delete record from product table, till review exist in reviews table for same product Id.
2. You can't add record in reviews table, till you have not added record in product table for same product Id.
3. If you delete the record from product table, reviews will be deleted automatically using cascade for the same product Id.

Best Related Posts are Following:

1. MySQL Query Optimization Tips and Techniques.
2. How can I make SQL Query case sensitive string comparison on MySQL?.
3. DBMS Interview Questions and Answers for Freshers.
4. MySQL Interview Questions and Answers for Experienced.
5. Difference between inner join and outer join in MySQL.
6. How to get a list of MySQL user accounts?.
7. How to delete MySQL Binary logs Files in Wamp Server?.
8. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY.
9. Multiple column ordering in Zend Framework.
10. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL.
11. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
12. Difference Between MyISAM and innoDB - MySQL.
13. MySQL Functions - MySQL tutorial for beginners.
14. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries.
15. Mysql FullText Search Examples.
16. MySQL Constraint Example.
17. MySQL Cascade Example.
18. Mysql-Group-Concat.
19. MySQL Expressions.
20. MySQL Delete Table Example.
21. Replace Table - Update Field, Move Records to another table MySQL.
22. mysql insert syntax - Add records from another table - Copy Table from one table to another.
23. Mysql Update Syntax - Update Multiple Records.
24. What is Mysql.
25. Mysql Console Commands - Export and Import database from command line.
26. MySQL interview Questions and Answers For Experienced.