This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Analysis Services – 1”. 1. The Analysis Services __________ role defines administrative access of Windows users and groups to an instance of Analysis Services. a) database b) server c) user d) none of the mentioned 2. Point out the correct statement. a) … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Business Intelligence”. 1. Business intelligence (BI) is a broad category of application programs which includes _____________ a) Decision support b) Data mining c) OLAP d) All of the mentioned 2. Point out the correct statement. a) OLAP is an umbrella term that … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Resource Governor”. 1. Resource Governor is a feature that enables you to specify limits on the amount of ____________ a) CPU b) Physical IO c) Memory d) None of the mentioned 2. Point out the correct statement. a) You can set IO … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Partitioning”. 1. SQL Server 2014 supports up to ________ partitions by default. a) 20000 b) 2000 c) 1000 d) 15000 2. Point out the correct statement. a) On x86-based systems, creating a table or index with more than 1000 partitions is possible … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Data Compression”. 1. Which of the following compression type is supported by SQL Server 2014? a) Row b) Column c) Both row and column d) None of the mentioned 2. Point out the correct statement. a) The details of data compression are … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Working With Transaction Log”. 1. The transaction log supports which of the following operations? a) Recovery of all incomplete transactions when SQL Server is started b) Recovery of individual transactions c) Supporting transactional replication d) All of the mentioned 2. Point out … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Blocking”. 1. Which of the following design strategy can reduce the occurrence of blocking locks? a) Use non-clustered indexes on high-usage tables b) Use clustered indexes on high-usage tables c) Use clustered indexes on less-usage tables d) Make sure that CREATE and … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Locking”. 1. Which of the following resource can be locked in SQL Server? a) TID b) RID c) PID d) SID 2. Point out the correct statement. a) Deadlocking is same as normal blocking b) No other transactions can read or modify … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) for campus interviews focuses on “Transaction-2”. 1. Which of the following argument is ignored by database engine in COMMIT TRANSACTION? a) @tran_name_variable b) @tran_name c) transaction_name d) all of the mentioned 2. Point out the correct statement. a) ROLLBACK TRANSACTION with a savepoint_name or … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Transaction – 1”. 1. The INSERT, UPDATE, or DELETE statement fails if the OLE DB provider used to access the linked server does not support the _________ interface. a) ITransJoin b) ITransactionJoin c) IactionJoin d) None of the mentioned 2. Point out … Read more
