Interview Questions

- A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages.

- A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.

It can be done by setting the record length’s size to more than half of the page’s size.

PHP: Hypertext Preprocessor is open source server-side scripting language that is widely used for web development. PHP scripts are executed on the server. PHP allows writing dynamically generated web pages efficiently and quickly. The syntax is mostly borrowed from C, Java and perl. PHP is free to download and use.

Inheritance is the ability to create new classes based on existing classes. It is useful to reuse existing code.

An XSL sheet or a document may have duplicate elements and attributes. Therefore, the XML namespaces define a way to distinguish between duplicate element types and attribute names.

An XML namespace is a collection of element type and attribute names. It is a URI due to which any element type or attribute name in an XML namespace can be uniquely identified. 

It consists of two parts : the name of the XML namespace and the local name.

e.g.: xmlns: h=”https://www.abc.com”

After this, you can write

<h:table>

……..

</h:table>

to associate the table with the declared namespace. 

This question can be answered in several ways. You can describe your education: fine arts with fashion/design focus. You can describe your work experience: fashion houses, employers, employees, and of course your actual work (the portfolio). Or you can describe your personal characteristics.