What are the type of SUB-QUERy?
There are many types of SUB-QUERY :
> Single-row sub-query: where the sub-query returns only one row.
> Multiple-row sub-query : where the sub-query returns multiple rows,
> Multiple column sub-query : where the Sub-query returns multiple columns.Reply
What are the properties of SUB-QUERY?
There are many Properties of Sub-Query are there :
> Its must be enclosed in the parenthesis.
> Its must be put in the right hand of the comparison operator.
> Its cannot contain an ORDER-BY clause.
> A query can contain more than one sub-query.Reply
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
There are a many differences b/w HAVING CLAUSE and a WHERE CLAUSE :
Having Clause is mainly used for the Group By function Its only with the GROUP BY function in a query, But In case of WHERE Clause is using only for rows, Its applied to each row before they are part of the GROUP BY function in a query. Both of Clouses are mainly specify a search condition for a group or an aggregate. But differences are there in the case of HAVING CLAUSE, it can be used only with the SELECT statement. And It is typically used in a GROUP BY clause. Even GROUP BY is not used, HAVING behaves something like a WHERE clause. Reply
When is the use of UPDATE_STATISTICS command?
UPDATE_STATISTICS command is mainly used for the solving a problem when a large processing of data has occurred. If a large amount of deletions wants any modification or when the Bulk Copy into the tables has occurred, that time it has to update the indexes to take these changes into account. Its updates the indexes on these tables accordingly.Reply
What do you mean by DELETE command?
Delete Command bassically defines as :
> It Can be used with or without a WHERE clause.
> It Activates Triggers.
> It can be rolled back.
> It is DML Command.
> It does not reset identity of the table.
> DELETE removes rows one at a time and records an entry in the transaction log for each deleted row.
> If we want to retain the identity counter, Which is use DELETE instead. If we want to remove table definition and its data, use the DROP TABLE statement.Reply
What is OLTP?
OLTP stands for Online Transaction Processing Systems. It is mainly use for relational database design for use the discipline of data modeling and generally follow the Code rules of data normalization, It is in order to ensure absolute data integrity. It is Using these rules complex information is broken down into its most simple structures or a table, where all of the individual atomic level elements relate to each other and satisfy the normalization rules.Reply
What are different types of Collation Sensitivity?
There are many diff types of Collation Sensitivity, Which are following here :
> Case Sensitivity : A and a, B and b, etc .
> Accent Sensitivity : a and �, o and �, etc.
> Kana Sensitivity : When the Japanese kana characters Hiragana and Katakana are treated differently, It is called Kana sensitive.
> Width Sensitivity : it is Bassically a single-byte character or half-width and the same character represented as a double-byte character or full-width are treated differently than it is width sensitive.Reply
What are the different index configurations a table can have?
A Table can have Diff type of the index configurations, Which are following as :
> No Indexes
> A clustered index
> A clustered index and many nonclustered indexes
> A nonclustered index
> Many nonclustered indexes
What do you mean by A non clustered index?
A Non Clustered Index is a special type of index, Which Indexes are in the logical order of the index, Its does not match the physical stored order of the rows on disk. The leaf node does not consist of the data pages Which is from non clustered index. Instead, The leaf nodes contain index rows.Reply
What is the SCD1 ?
In The SCD1 mainly use for the create a new record and its also can be replaces the original record. Only one record exist in database - current data.Reply