What are the Properties of Relational Tables?

Properties: All the values should be Atomic Each Column must have a unique name in the table All the Rows must be Unique All the values of a column are of same kind Ordering of columns is not necessary(doesn’t matter) Ordering of

Read More

What is a Dirty page?

Dirty page When we do any modification in the data, same will not be impacted in the physical table immediately. This follows a cycle to complete the action.  Modify the data in buffer cache pages – Called ‘Logical write’. Write the same

Read More

What is the difference between ASCII() and CHAR() functions?

ASCII() vs CHAR(): ASCII() and CHAR() functions work with ASCII characters. But the functionality wise, both work quiet opposite. ASCII() function returns the ASCII code number for the given character as input. Where as, CHAR() function returns the ASCII character for the

Read More

What is the difference between COALESCE() and ISNULL()?

Both functions are used to return the first not null value among all the input values passed. ISNULL(): It takes only two parameters. ISNULL() is T – SQL specific function. The return data type of ISNULL() is the datatype of the first

Read More