Welcome to the Data Connectivity MCQs Page

Dive deep into the fascinating world of Data Connectivity with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Data Connectivity, a crucial aspect of SQL Server. In this section, you will encounter a diverse range of MCQs that cover various aspects of Data Connectivity, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within SQL Server.

Check out the MCQs below to embark on an enriching journey through Data Connectivity. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of SQL Server.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Data Connectivity. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Data Connectivity MCQs | Page 10 of 10

Explore more Topics under SQL Server

01

SQL Server Basics

02

Data Modification and Constraints

03

Beyond Relational

04

Data Definition Language

05

Development with SQL Server

06

Enterprise Data Management

07

Data Security

08

Monitoring and Auditing

09

Performance Tuning and Optimization

10

Business Intelligence and Reporting Services

Q91.

Point out the correct statement.

SSMS for Access converts Access database objects to SQL Server or SQL Azure database object

Use the CONVERSION page of the Project Settings dialog box to specify how much data appears on the Data tab

SSMA for Access converts Access database objects to SQL Server or SQL Azure database object

None of the mentioned

Discuss

Answer: (c).SSMA for Access converts Access database objects to SQL Server or SQL Azure database object

Q92.

When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.

link

unlink

import

all of the mentioned

Discuss

Answer: (b).unlink

Q93.

__________ is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005.

SSAM

SSMA

SSMS

SSAS

Discuss

Answer: (b).SSMA

Q94.

Point out the wrong statement.

SQL Server Migration Assistant is an environment that helps you quickly migrate Access databases to SQL Server or SQL Azure

By using SSMA, you can review Access and SQL Server or SQL Azure database objects

When you link an Access table to a SQL Server, SQL Server database engine stores connection information and table metadata

None of the mentioned

Discuss

Answer: (c).When you link an Access table to a SQL Server, SQL Server database engine stores connection information and table metadata

Q95.

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

Discuss

Answer: (b).Slow performance with linked tables

Q96.

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

Discuss

Answer: (a).Advanced Object Select dialog box

Q97.

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

Discuss

Answer: (d).Highlighting of “well known” LOB schemas

Q98.

_________ 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

Discuss

Answer: (b).Access Metadata Explorer

Q99.

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

UDP

Named pipes

TCP

None of the mentioned

Discuss

Answer: (c).TCP

Page 10 of 10

Welcome to the Data Connectivity MCQs Page

Data Connectivity MCQs | Page 10 of 10

Explore more Topics under SQL Server

SQL Server Basics

Data Modification and Constraints

Beyond Relational

Data Definition Language

Development with SQL Server

Enterprise Data Management

Data Security

Monitoring and Auditing

Performance Tuning and Optimization

Business Intelligence and Reporting Services

Suggested Topics

Neural Networks

Data Science

R Programming

CSS

IT Fundamentals

Human Computer Interaction

Computer Architecture

Formal Languages and Automata Theory

MongoDB