SQL Server Mock Test 5

10%

Question 1 of 10

1. Point out the wrong statement.

The use of PL-SQL opens the door to these vulnerabilities

SQL injection vulnerabilities occur whenever input is used in the construction of an SQL query without being adequately constrained or sanitized

None of the mentioned

SQL injection allows an attacker to access the SQL servers and execute SQL code under the privileges of the user used to connect to the database

Question 1 of 10

Question 2 of 10

2. The easiest way to start is to create a linked server 'localhost' by using _____________

sp_addlinkedserver 'localhost'

sp_addlinkedsrvlogin 'localhost'

sp_addlinkedserverlogin 'localhost'

sp_addlinkedserv 'localhost'

Question 2 of 10

Question 3 of 10

3. Which of the following is enumeration for ADO.net with SQL Server?

All of the mentioned

SqlBulkCopyOptions

SqlInfo

SqlNotification

Question 3 of 10

Question 4 of 10

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

None of the mentioned

from p in db.Purchases
where p.Customer.Address.State == "WA" || p.Customer == null
where p.PurchaseItems.Sum (pi => pi.SaleAmount) < 1000
select p

Question 4 of 10

Question 5 of 10

5. Which of the following service broker component defines the infrastructure used for exchanging messages between instances?

Conversation

Service definition

Security

All of the mentioned

Question 5 of 10

Question 6 of 10

6. Which of the following steps should be carried out using data types in SSIS for efficient results?

Do not watch precision issues when using the money, float, and decimal types

Do not perform excessive casting of data types

None of the mentioned

Make data types as wide as possible so you will allocate more memory for your transformation

Question 6 of 10

Question 7 of 10

7. Which of the following gives trusted Connection from a CE device?

connetionString="Data Source=ServerName; 
Initial Catalog=DatabaseName;User ID=myDomain\UserName;
Password=Password;

connetionString="Data Source=ServerName; 
Integrated Security=SSPI;User ID=myDomain\UserName;P
assword=Password;

connetionString="Data Source=ServerName; 
Initial Catalog=DatabaseName;Integrated Security=SSPI;
User ID=myDomain\UserName;Password=Password;

All of the mentioned

Question 7 of 10

Question 8 of 10

8. Which of the following is the best practice related to SSIS?

Plan for capacity by understanding resource utilization

Baseline source system extract speed

All of the mentioned

SSIS is an in-memory pipeline, so ensure that all transformations occur in memory

Question 8 of 10

Question 9 of 10

9. SQL injection is an attack in which _________ code is inserted into strings that are later passed to an instance of SQL Server.

clean

malicious

non malicious

redundant

Question 9 of 10

Question 10 of 10

10. 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.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 ("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.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 ("A")
   orderby c.Name
   select c.Name.ToLower();
var thirdPage = query.Skip(20).Take(10);

Question 10 of 10

« Prev - SQL Server Mock Test 4

» Next - SQL Server Mock Test 6