SQL Server Practice Test 5

1. Which of the following script is an example of Quick detection in the SQL injection attack?

SELECT header, txt FROM news UNION ALL SELECT name, pass FROM members

For integer inputs : convert(int,@@version)

SELECT loginame FROM master..sysprocesses WHERE spid = @@SPID

IF condition true-part ELSE false-part (S)

2. Point out the wrong statement.

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

None of the mentioned

LINQ supports ad hoc join

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

3. Point out the wrong statement.

The operations that are minimally logged in this recovery model are bulk insert, create index, “bcp” commands, insertion of text , image column and select into query

Backups under BULK_LOGGED recovery model will include log records and the data pages changed by bulk operations

None of the mentioned

In Bulk-logged recovery model, few transactions are completely logged

4. Which is the default field terminator for bulk insert in SQL Server?

Brackets

Full stop

Parenthesis

Comma

5. Which of the following will increase the Rows/sec calculation in SSIS?

Use single NIC cards

None of the mentioned

Improve drivers and driver configurations

Start single connections

6. Which of the following is a bulk import operation?

All of the mentioned

BULK INSERT

INSERT..SELECT

bcp

7. 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.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.ToLower();
var thirdPage = query.Skip(20).Take(10);

8. Which of the following method is used to delete records in LINQ?

None of the mentioned

DeleteOnSubmit

DeleteOn

Delete

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

None of the mentioned

Do not perform excessive casting of data types

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

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

10. 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

« Prev - SQL Server Practice Test 4

» Next - SQL Server Practice Test 6