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 4 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

Q31.

Query alternative to the following SQL code in LINQ is ____________

SELECT TOP 10 UPPER (c1.Name)
FROM Customer c1
WHERE
   c1.Name LIKE 'A%'
   AND c1.ID NOT IN
   (
      SELECT TOP 20 c2.ID
      FROM Customer c2
      WHERE c2.Name LIKE 'A%'
      ORDER BY c2.Name
   ) 
ORDER BY c1.Name

var query =
FROM c IN db.Customers
WHERE c.Name.EndsWith ("A")
orderby c.Name
SELECT c.Name.ToUpper();
var thirdPage = query.Skip(20).Take(10);

var query =
FROM c IN db.Customers
WHERE c.Name.StartsWith ("65")
orderby c.Name
SELECT c.Name.ToUpper();
var thirdPage = query.Skip(20).Take(10);

var query =
FROM c IN db.Customers
WHERE c.Name.StartsWith ("A")
orderby c.Name
SELECT c.Name.ToUpper();
var thirdPage = query.Skip(20).Take(10);

var query =
FROM c IN db.Customers
WHERE c.Name.StartsWith ("A")
orderby c.Name
SELECT c.Name.ToLower();
var thirdPage = query.Skip(20).Take(10);

Discuss

Answer: (c).var query =
FROM c IN db.Customers
WHERE c.Name.StartsWith ("A")
orderby c.Name
SELECT c.Name.ToUpper();
var thirdPage = query.Skip(20).Take(10);

Q32.

Point out the correct statement.

LINQ supports flat outer joins

LINQ’s parameterization is inline, typesafe, and highly readable

LINQ queries are composable

All of the mentioned

Discuss

Answer: (d).All of the mentioned

Q33.

LINQ query to retrieve a selection of customers, each with their high-value purchases is _____________

FROM c IN db.Customers
WHERE c.Address.State == "WA"
SELECT NEW
{
c.Name,
c.CustomerNumber,
HighValuePurchases = c.Purchases.Where (p => p.Price > 1000)
}

FROM c IN db.Customers
WHERE c.Address.State = "WA"
SELECT NEW
{
c.Name,
c.CustomerNumber,
HighValuePurchases = c.Purchases.Where (p => p.Price > 1000)
}

FROM c IN db.Customers
WHERE c.Address.State == "WA"
SELECT NEW
{
c.Name,
c.CustomerNumber,
HighValuePurchases != c.Purchases.Where (p => p.Price > 1000)
}

All of the mentioned

Discuss

Answer: (a).FROM c IN db.Customers
WHERE c.Address.State == "WA"
SELECT NEW
{
c.Name,
c.CustomerNumber,
HighValuePurchases = c.Purchases.Where (p => p.Price > 1000)
}

Q34.

LINQ Query to list all purchases of $1000 or greater made by customers who live in Washington.

FROM p IN db.Purchases
WHERE p.Customer.Address.State == "WA" || p.Customer == NULL
WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) = 1000
SELECT p

FROM p IN db.Purchases
WHERE p.Customer.Address.State == "WA" || p.Customer == NULL
WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) < 1000
SELECT p

FROM p IN db.Purchases
WHERE p.Customer.Address.State == "WA" || p.Customer == NULL
WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) > 1000
SELECT p

None of the mentioned

Discuss

Answer: (c).FROM p IN db.Purchases
WHERE p.Customer.Address.State == "WA" || p.Customer == NULL
WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) > 1000
SELECT p

Q35.

Point out the wrong statement.

Compared to SQL, LINQ is complex, tidier, and lower-level

LINQ supports ad hoc join

Another benefit of LINQ is that you can query across relationships without having to join

None of the mentioned

Discuss

Answer: (a).Compared to SQL, LINQ is complex, tidier, and lower-level

Q36.

The following code is used will perform _________ operation in LINQ.

public bool IsValidUser(string userName, string passWord)
{
       DBNameDataContext myDB = NEW DBNameDataContext();
       List<User> users = myDB.Users.Where(u => u.Username == userName && u.Password==passWord);
       IF(users.Count>0)
       {
             RETURN TRUE;
       }
       RETURN FALSE;
}

update

select

insert

All of the mentioned

Discuss

Answer: (b).select

Q37.

Query alternative to the following LINQ code in SQL is ____________

FROM p IN db.Purchases
WHERE p.Customer.Address.State == "WA" || p.Customer == NULL
WHERE p.PurchaseItems.Sum (pi => pi.SaleAmount) > 1000
SELECT p

SELECT p.*
FROM Purchase p
LEFT OUTER JOIN
Customer c INNER JOIN Address a ON c.AddressID = a.ID
ON p.CustomerID = c.ID
WHERE
(a.State = 'WA' || p.CustomerID IS NULL)
AND p.ID IN
(
SELECT PurchaseID FROM PurchaseItem
GROUP BY PurchaseID WHERE SUM (SaleAmount) > 1000
)

None of the mentioned

Discuss

Answer: (b).SELECT p.*
FROM Purchase p
LEFT OUTER JOIN
Customer c INNER JOIN Address a ON c.AddressID = a.ID
ON p.CustomerID = c.ID
WHERE
(a.State = 'WA' || p.CustomerID IS NULL)
AND p.ID IN
(
SELECT PurchaseID FROM PurchaseItem
GROUP BY PurchaseID HAVING SUM (SaleAmount) > 1000
)

Q38.

Which of the following sample code is used to select data Using LinQ To SQL?

public bool IsValidUser(string userName, string passWord)
{
DBNameDataContext myDB = NEW DBNameDataContext();
RETURN Enumerable.Count(userResults) > 0;
}

public bool IsValidUser(string userName, string passWord)
{
DBNameDataContext myDB = NEW DBNameDataContext();
var userResults = FROM u IN myDB.Users
WHERE u.Username == userName
&& u.Password == passWord
SELECT u;
RETURN Enumerable.Count(userResults) > 0;
}

All of the mentioned

Discuss

Answer: (b). public bool IsValidUser(string userName, string passWord)
{
DBNameDataContext myDB = NEW DBNameDataContext();
var userResults = FROM u IN myDB.Users
WHERE u.Username == userName
&& u.Password == passWord
SELECT u;
RETURN Enumerable.Count(userResults) > 0;
}

Q39.

Which of the following code snippet would traverse through all result objects ?

foreach(USER USER IN userResults)
{
//checking the RESULT AS LIKE object
IF(USER.Role == 'admin')
{
//do whatever you need
}
}

FOR(USER USER IN userResults)
{
//checking the RESULT AS LIKE object
IF(USER.Role == 'admin')
{
//do whatever you need
}
}

While(USER USER IN userResults)
{
//checking the RESULT AS LIKE object
IF(USER.Role == 'admin')
{
//do whatever you need
}
}

None of the mentioned

Discuss

Answer: (a).foreach(USER USER IN userResults)
{
//checking the RESULT AS LIKE object
IF(USER.Role == 'admin')
{
//do whatever you need
}
}

Q40.

LINQ to SQL is considered to be one of Microsoft’s _______ products.

ORM

ODBC

JDBC

SQLLIB

Discuss

Answer: (a).ORM

Page 4 of 10

Welcome to the Data Connectivity MCQs Page

Data Connectivity MCQs | Page 4 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

C# programming

Computer Architecture

Object Oriented Programming Using C++

Discrete Mathematics

Management Information Systems

Visual Basic

Java Programming

Cloud Computing

Cryptography and Network Security