This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Access With Sql Server”.
1. The __________ is an Access add-in program that provides data analysis tools for financial analysis.
a) Analysis ToolPak
b) Analysis Tool
c) Analysis ToolSQL
d) All of the mentioned
View Answer
Explanation: Analysis ToolPak is used for complex, statistical analyses.
2. Point out the correct statement.
a) SSMS for Access converts Access database objects to SQL Server or SQL Azure database object
b) Use the CONVERSION page of the Project Settings dialog box to specify how much data appears on the Data tab
c) SSMA for Access converts Access database objects to SQL Server or SQL Azure database object
d) None of the mentioned
View Answer
Explanation: SSMA loads those objects into SQL Server or SQL Azure, and then migrates data from Access to SQL Server or SQL Azure.
3. When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.
a) link
b) unlink
c) import
d) all of the mentioned
View Answer
Explanation: If you have linked the Access tables to one SQL Server instance, and then you want to change the links to another instance, you must relink the tables.
4. __________ is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005.
a) SSAM
b) SSMA
c) SSMS
d) SSAS
View Answer
Explanation: SSMA stands for Microsoft SQL Server Migration Assistant for Access.
5. Point out the wrong statement.
a) SQL Server Migration Assistant is an environment that helps you quickly migrate Access databases to SQL Server or SQL Azure
b) By using SSMA, you can review Access and SQL Server or SQL Azure database objects
c) When you link an Access table to a SQL Server, SQL Server database engine stores connection information and table metadata
d) None of the mentioned
View Answer
Explanation: Jet database engine stores connection information and table metadata.
6. Which is the most serious issue after migration of access database to SQL Server?
a) Auto-increment columns are not updated until the record is updated
b) Slow performance with linked tables
c) New records are not available
d) You cannot modify a linked table schema with Access
View Answer
Explanation: Some queries might be slow after upsizing.
7. Which of the following option is used to find database objects by using filter criteria?
a) Advanced Object Select dialog box
b) Advanced find Select dialog box
c) Advanced filter Select dialog box
d) Advanced Object and filter Select dialog box
View Answer
Explanation: Advanced Object Select dialog box first uses filter criteria to search for objects.
8. Which of the following change took place in JULY 2014 release of SSMA?
a) Added support of MS SQL Server 2014
b) Set cascade actions for circular references to No Action
c) Fixed bugs regarding invisible report pages in IE 10
d) Highlighting of “well known” LOB schemas
View Answer
Explanation: This change was done so that they can be ignored in conversion.
9. _________ shows information about Access databases that have been added to the project.
a) SQL Server Metadata Explorer
b) Access Metadata Explorer
c) Access Metadata Expl
d) None of the mentioned
View Answer
Explanation: SSMA contains two metadata explorers to browse and perform actions on Access and SQL Server or Azure SQL DB databases.
10. Which of the following network protocol should be selected to enable IP address?
a) Udp
b) Named pipes
c) Tcp
d) None of the mentioned
View Answer
Explanation: You must restart the SQL Server service after making changes to network protocols.
Sanfoundry Global Education & Learning Series – SQL Server.
To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.
If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]- Apply for Programming Internship
- Practice Programming MCQs
- Check SQL Server Books
- Check Information Technology Books