L

Lazy writer in Memory ?

July 18, 2021

1 Min Read

0 8

July 18, 2021

1 Min Read

0 8

Answer : Lazy write is an effect caused by the use of a write-back cache…

SQL

Editor

Continue Reading

W

What is the difference between the SubQuery and Corelated SubQuery ?

July 18, 2021

1 Min Read

0 23

July 18, 2021

1 Min Read

0 23

Answer : The inner query is executed only once…

SQL

Editor

Continue Reading

W

What is the Difference between join and union ?

July 18, 2021

1 Min Read

0 10

July 18, 2021

1 Min Read

0 10

Answer : The union operator combines the results of two or more queries into a single result set…

SQL

Editor

Continue Reading

W

What is the SQLCode -501 ?

July 18, 2021

1 Min Read

0 20

July 18, 2021

1 Min Read

0 20

Answer : sqlcode -501 pops up to show…

SQL

Editor

Continue Reading

W

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE ?

July 18, 2021

1 Min Read

0 8

July 18, 2021

1 Min Read

0 8

Answer : The HAVING clause sets conditions on the GROUP BY…

SQL

Editor

Continue Reading

D

Difference between Clustered and Non-clustered index ?

July 18, 2021

1 Min Read

0 10

July 18, 2021

1 Min Read

0 10

Answer : Cluster index: Clustered index will be created…

SQL

Editor

Continue Reading

W

What is an Index ?

July 18, 2021

1 Min Read

0 19

July 18, 2021

1 Min Read

0 19

Answer : Index is a database object which improves the efficiency of the query…

SQL

Editor

Continue Reading

H

How to find the second highest salary from emp table ?

July 18, 2021

1 Min Read

0 7

July 18, 2021

1 Min Read

0 7

Answer : Select max(sal)…

SQL

Editor

Continue Reading