gs gs116 Data Connectivity - LINQ - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Data Connectivity. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: 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);
Question 2: 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
Question 3: 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
Question 4: 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
Question 5: 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
Question 6: 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
Question 7: 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 ) 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 )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 )
None of the mentioned
Question 8: 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; } 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
Question 9: 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
Question 10: LINQ to SQL is considered to be one of Microsoft's _______ products.
ORM
ODBC
JDBC
SQLLIB
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
