This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Views”. 1. What is a view? a) A view is a special stored procedure executed when certain event occurs b) A view is a virtual table which results of executing a pre-compiled query c) A view is a database diagram d) None … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Joins”. 1. What type of join is needed when you wish to include rows that do not have matching values? a) Equi-join b) Natural join c) Outer join d) All of the Mentioned 2. What type of join is needed when you … Read more
This set of SQL Server Inteview Questions and Answers for freshers focuses on “Basic SQL – 3”. 1. Which of the following command makes the updates performed by the transaction permanent in the database? a) ROLLBACK b) COMMIT c) TRUNCATE d) DELETE 2. Which TCL command undo all the updates performed by the SQL in … Read more
This set of SQL Server Multiple Choice Questions and Answers for freshers focuses on “Basic SQL – 2”. 1. What does DML stand for? a) Different Mode Level b) Data Model Language c) Data Mode Lane d) Data Manipulation language 2. With SQL, how do you select all the records from a table named “Persons” … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Basic SQL – 1”. 1. Which SQL function is used to count the number of rows in a SQL query? a) COUNT() b) NUMBER() c) SUM() d) COUNT(*) 2. Which SQL keyword is used to retrieve a maximum value? a) MOST b) … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Builtin Functions”. 1. ______________ function returns current date and time. a) SET DATEFIRST b) SYSDATETIME c) Cert_ID d) GETDATE 2. Which of the following function checks whether the expression is a valid date or not? a) ISDATE b) ISDAY c) ISVALID d) … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Data Types”. 1. Which of the following is a large object data type? a) varchar(max) b) varbinary(max) c) nvarchar(max) d) image 2. Data types in SQL Server are organized into how many categories? a) 6 b) 8 c) 9 d) 10 3. … Read more
This set of SQL Server Interview Questions and Answers focuses on “Management Studio – 2”. 1. SMO in SQL Server stands for ___________ a) Server Management Object b) Service Management Object c) SQL Management Object d) SQL Server Management Object 2. Which of the following feature is not provided by SSS 2008? a) Automatic formatting … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Management Studio – 1”. 1. Management Studio is ________ used for development of SQL Server database. a) Front end tool b) Back end tool c) Database engine d) SQL Server 2. Which panel presents a list of objects under the selected node? … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Introduction”. 1. When was the first version of Microsoft SQL Server released? a) 1983 b) 1988 c) 1990 d) 1991 2. Which of the following companies originally worked together to create and market the first version of SQL Server? a) Microsoft b) … Read more
