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.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
There are numerous good possibilities:
Loyalty, Energy, Positive
attitude, Leadership, Team player, Expertise, Initiative, Patience,
Hard work, Creativity, Problem solver.
Create Date
:
Thursday, September 18, 2008
Tags
:
interview,
general,
business,
network,
hr,
human resource,
SQL,
integer,
character,
management,
Flexibility,
organization,
efficiency,
general interview,
leadership,
manager,
human resources,
Microsoft,
accounting,
work attitude,
supervision,
PUZZLE
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
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
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
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
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)

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
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
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
Click here
to improve the Interview Question, Answer and other fields.