Technology 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.

- 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.

The new attributes provided in HTML5 for <form> are: 

a.) autocomplete

– It specifies if a form or input field should have autocomplete as on or off. 

– If autocomplete is on, the browser is able to fill the values based on the values filled by the user earlier. 

– autocomplete works for following input types: text, search, url, tel, email, password, datepickers, range, and color. 

b.) novalidate

- This is a boolean attribute. 

- When present, it signifies that the form-data should not be validated when submitted.

Oracle supports 3 transaction isolation levels: 

- Read committed (default)

- Serializable transactions

- Read only

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.

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.

AWT are heavy-weight componenets. Swings are light-weight components. Hence swing works faster than AWT.

Icon for an Activity is defined in the manifest file.

Code

<activity android:icon="@drawable/app_icon" android:name=".MyTestActivity"></activity>

...