What are user-defined data types and when you should go for them?MS-SQL interview question for fresher/MS-SQL Interview Questions and Answers for Freshers & Experienced

What are user-defined data types and when you should go for them?

Lets you extend the base SQL Server data types by providing a descriptive name and format to the database

E.g. Flight_num appears in many tables and all these tables have varchar(8)
Create a user-defined data-type

Posted Date:- 2021-09-18 05:19:01

What are associative entities?

What is "scheduled jobs" or "scheduled tasks"?

What is business intelligence?

What is Atomicity?

What is a prime attribute?

What is an ER Diagram?

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 is a database table?

What are the authentication modes in SQL Server? How can it be changed?

What do you consider are the best reasons to use stored procedures in your application instead of passing Transact-SQL code directly to SQL Server?

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 is RDBMS?

What are the main steps in Data Modeling?

What can a developer do during the logical and physical design of a database to help ensure that their database and SQL Server-based application will perform well?

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 PL/SQL?

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 is SQL server agent?

What methods do you follow to protect from SQL injection attack?

What is CHECK constraint?

What is CHECK constraint?

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 Profiler?

What is SQL server agent and what are the two modes of authentication in SQL Server?

What is MSSQL?

Search
R4R Team
R4R provides MS-SQL Freshers questions and answers (MS-SQL Interview Questions and Answers) .The questions on R4R.in website is done by expert team! Mock Tests and Practice Papers for prepare yourself.. Mock Tests, Practice Papers,MS-SQL interview question for fresher,MS-SQL Freshers & Experienced Interview Questions and Answers,MS-SQL Objetive choice questions and answers,MS-SQL Multiple choice questions and answers,MS-SQL objective, MS-SQL questions , MS-SQL answers,MS-SQL MCQs questions and answers Java, C ,C++, ASP, ASP.net C# ,Struts ,Questions & Answer, Struts2, Ajax, Hibernate, Swing ,JSP , Servlet, J2EE ,Core Java ,Stping, VC++, HTML, DHTML, JAVASCRIPT, VB ,CSS, interview ,questions, and answers, for,experienced, and fresher R4r provides Python,General knowledge(GK),Computer,PHP,SQL,Java,JSP,Android,CSS,Hibernate,Servlets,Spring etc Interview tips for Freshers and Experienced for MS-SQL fresher interview questions ,MS-SQL Experienced interview questions,MS-SQL fresher interview questions and answers ,MS-SQL Experienced interview questions and answers,tricky MS-SQL queries for interview pdf,complex MS-SQL for practice with answers,MS-SQL for practice with answers You can search job and get offer latters by studing r4r.in .learn in easy ways .