Authentication mode is used for authentication of the user in SQL server, and it can be selected at the time of setup of the database engine.
SQL Server supports two authentication modes: Window authentication mode and mixed mode.
Window authentication mode: This authentication mode is used to connect through a Microsoft NT 4.0 or window 2000 user account. In Windows authentication server take computer's username and password for authentication purpose. SQL server authentication mode is disabled in this mode.
Mixed mode: It is used to connect with the instance of SQL Server using window authentication or SQL Server authentication. In SQL server authentication mode a unique username and password are required for a particular database, as it will not depend on windows account.
Posted Date:- 2021-09-18 06:06:00
What are associative entities?
What is "scheduled jobs" or "scheduled tasks"?
What is business intelligence?
What are the steps you will take to improve the performance of a poor-performing query?
If you have no choice but to use a SQL Server-based cursor, what tips do you have to optimize them?
What are the authentication modes in SQL Server? How can it be changed?
What is the use of the SCOPE_IDENTITY() function?
What is the purpose of UPDATE STATISTICS?
What is Referential Integrity?
Define the one-to-one relationship while designing tables.
What is a virtual table in SQL?
Explain cross join or cartesian product in sql?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is the system function to get the current user’s user id?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is difference between foreign key and unique key?
How Global temporary tables are represented and its scope?
What is a Join? Explain Different Types of Joins
Write down the general syntax for a SELECT statement covering all the options.
What are the main steps in Data Modeling?
What part does database design have to play in the performance of a SQL Server-based application?
What is a transaction and what are ACID properties?
What is the purpose of FLOOR function?
How exceptions can be handled in SQL Server Programming?
What are user-defined data types and when you should go for them?
What are defaults? Is there a column to which a default can’t be bound?
State the difference between UNION and UNION ALL?
Explain Magic tables in SQL Server?
How exceptions can be handled in SQL Server Programming?
What are scheduled tasks in SQL Server?
What methods do you follow to protect from SQL injection attack?
What is denormalization and when would you go for it?
Explain Trigger and its types?
What is normalization? Explain different levels of normalization?
Explain Subquery and state its properties?
What is COALESCE and CHECK constraint in SQL server?
What is SQL server agent and what are the two modes of authentication in SQL Server?