Interview Questions

1 : InnoDB provides us row level locking while MyISAM provides us table level locking.

2 : InnoDB offers foreign key constraints wheres in MyISAM does not have foreign key constraints.

3 : InnoDB does not have full text search wheres MyISAM provides us full text search.

A foreign key is a reference to another table. It is used to establish relationships between tables. For example, relationship between employee and professor table. One employee can have multiple professors. The Primary key of employee becomes foreign key of professor.
Example:
create table employee ( id number NOT NULL, professor_id NOT NULL, Name varchar(200) Constraint prim_id Foreign key(id) references professor(professor_id) );

This question is designed to see how well you can mediate a situation and handle conflict. You want to come across as someone who can compromise when necessary. An interviewer wants to see that you can not only reach an outcome that is desirable for both sides of a conflict of interest, but also that you can understand where the other person is coming from. Empathy and understanding go a long way in any job and this is a good opportunity to show that you can put yourself in another’s shoes.

The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data.

PL/SQL is Procedural Language SQL that is an extension of SQL that results in a more structural language composed of blocks. It is mainly used in writing applications that needs to be structured and has error handling.

Static member class is a class defined inside outer class with static modifier.

EX:

Class A {  //top level class or outer class

    .....

    static class B {  //static member class

    }

   .....

}

An Interactive report allows the user to participate in retrieving and present data at each level.while classical report doesn't have access to interact.

As far PHP concern it only support single Inheritance in scripting. we can also use interface to achieve multiple inheritance.