Technical Interview Questions and Answers :: SQL
21 / 108
STUFF deletes a specified length of characters and inserts another set of characters at a specified starting point. REPLACE removes the specified string and inserts supplied string in place.
22 / 108
The database name to connect to.
23 / 108
Microsoft.Access.
24 / 108
Deletes it from the memory.
25 / 108
Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings.
26 / 108
Primary key cannot have null value whereas unique key can have null
27 / 108
Using distinct keyword
28 / 108
It ensures Data validity and
29 / 108
The difference between SQL and PQ SQL is
30 / 108
zero or blank space can be compared with another zero or blank space. where as one null may not be equal to another null. null means data might not be provided or there is no data.