Access With Sql Server MCQ

Test your knowledge with important Access With Sql Server MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Access With Sql Server MCQs at Bissoy

• Which of the following network protocol should be selected to enable IP address?
  ক

  Udp

  খ

  Named pipes

  গ

  Tcp

  ঘ

  None of the mentioned
• _________ shows information about Access databases that have been added to the project.
  ক

  SQL Server Metadata Explorer

  খ

  Access Metadata Explorer

  গ

  Access Metadata Expl

  ঘ

  None of the mentioned
• Which of the following change took place in JULY 2014 release of SSMA?
  ক

  Added support of MS SQL Server 2014

  খ

  Set cascade actions for circular references to No Action

  গ

  Fixed bugs regarding invisible report pages in IE 10

  ঘ

  Highlighting of “well known” LOB schemas
• Which of the following option is used to find database objects by using filter criteria?
  ক

  Advanced Object Select dialog box

  খ

  Advanced find Select dialog box

  গ

  Advanced filter Select dialog box

  ঘ

  Advanced Object and filter Select dialog box
• Which is the most serious issue after migration of access database to SQL Server?
  ক

  Auto-increment columns are not updated until the record is updated

  খ

  Slow performance with linked tables

  গ

  New records are not available

  ঘ

  You cannot modify a linked table schema with Access
• __________ is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005.
  ক

  SSAM

  খ

  SSMA

  গ

  SSMS

  ঘ

  SSAS
• The __________ is an Access add-in program that provides data analysis tools for financial analysis.
  ক

  Analysis ToolPak

  খ

  Analysis Tool

  গ

  Analysis ToolSQL

  ঘ

  All of the mentioned