Technical Interview Questions and Answers :: SQL
51 / 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.
52 / 108
The database name to connect to.
53 / 108
Microsoft.Access.
54 / 108
Deletes it from the memory.
55 / 108
Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings.
56 / 108
Primary key cannot have null value whereas unique key can have null
57 / 108
Using distinct keyword
58 / 108
It ensures Data validity and
59 / 108
The difference between SQL and PQ SQL is
60 / 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.