SQL Questions

Aggregate functions perform a calculation on a set of values and return a single value. Aggregate functions ignore NULL values except COUNT function. HAVING clause is used, along with GROUP BY, for filtering query using aggregate values.

Following functions are aggregate functions. 

AVG, MIN CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING, VAR, MAX. VARP

Constraints enable the RDBMS to enforce the integrity of the database automatically, without the need to create triggers, rule or defaults.

Types of Constraints: NOT NULL, CHEQUE, UNIQUE, PRIMARY KEY, FOREIGN KEY.

Cursor_Already_Open,  Invalid_Cursor.

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

A database is used to store, modify, extract and to search for the data within it.

Too_many_rows.

No_Data_Found.

Zero_Error.

By default, primary key creates a clustered index on the column, whereas a unique key creates a non clustered index by default.