Question & Additional Information
 
Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?
Add to My IQ
 

 | 
Inappropriate
Answer Title
Answer
Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.
Question Tag Title
Tags
Question Asked At Title
Asked At
None
Question Job Title
Job Titles


Check out our newest job listings!

Post a Job! $49 for 60 days



Your Name:
Add your comment text
 
Related Questions
Related Questions
Flag this interview question as inappropriate Inappropriate
See Answer
There are numerous good possibilities:
Loyalty, Energy, Positive attitude, Leadership, Team player, Expertise, Initiative, Patience, Hard work, Creativity, Problem solver.
Click here to improve the Interview Question, Answer and other fields.
Comments (1) :
1.
bbfromdc
Sunday, October 12, 2008 8:02 AM
I simply love my supervisor Is it okay ?
Flag this interview question as inappropriate Inappropriate
See Answer
Used in client-certificate authentication to enable the server, and optionally the client, to authenticate each other. The public key certificate is the digital equivalent of a passport. It is issued by a trusted organization, called a certificate authority, and provides identification for the bearer.
Create Date
:
Tuesday, May 13, 2008
Tags
:
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
There are two authentication modes in SQL Server 2k:  -     Windows authentication: if user is already authenticated on the windows domain as valid windows user, SQL Server 2k can be requested to trust authentication by the operating system and allow the user assess to SQL Server 2k based on these credentials. You call a connection using windows authentication as a trusted connection.-   SQL Server authentication: if the user accessing either has not been authenticated on the windows domain or wants to connect using a SQL Server 2k security account the user can request that SQL Server 2k directly authenticate the user based on submission of a username and password.
Create Date
:
Saturday, May 10, 2008
Asked At
:
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
It depends what the logic is. If you need to do complex manipulation of data already in the database, it is probably better than trying to run sql queries and fetch the data into the middle tie and perform the manipulation in the middle tie, then send the large amount of data back to the database using sql insert or update. On the other hand, you can do to something simple using sql, but you have to write quite a lot of code in stored procedure, why do that.

For stored procedure vs. dynamic sql queries, assuming you are not talking about case where you can call stored procedure within a sql query or you can use dynamic sql inside a stored procedure, dynamic query has a downside (at least in Oracle db), that it has to be compiled if the exact sql string is not used recently (seconds I think) by any session, which could takes some time, and use some system resource. On the other hand, logic in stored procedure is not necessary automatically better.

I think you have to compare approaches based on how easy it is to write the code to do what you want, how easy it is for others to understand and maintain the code, and what is the performance cost in a target database, etc.
Create Date
:
Monday, May 05, 2008
Asked At
:
None
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
The Clone() method returns a new array (a shallow copy) object containing all the elements in the original array.  The CopyTo() method copies the elements into another existing array.  Both perform a shallow copy.  A shallow copy means the contents (each array element) contains references to the same object as the elements in the original array.  A deep copy (which neither of these methods performs) would create a new instance of each element's object, resulting in a different, yet identacle object.
Create Date
:
Saturday, May 03, 2008
Tags
:
Asked At
:
None
Job Positions
:
None
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
 
• More Related Questions: 
Suggestions & Comments




Share Your Interview Questions
Ask Interview Questions
View Unanswered Questions





Advertise on this site