SQL MCQ

Which answer is NOT a type of table index?

• nonclustered

• unique

• heap

• hash

The keywords AND, IN, LIKE, and between all belong to a category called what?

• joining operations

• linking operations

• criteria operations

• logical operations

What is the result of this series of statements?

BEGIN TRY

SELECT 'Foo' ASResult;

END TRY

BEGIN CATCH

SELECT 'Bar' ASResult;

END CATCH

• Foo

• FooBar

• Foo Bar

• Bar

Given these two tables, which query generates a listing showing student names

and the department office location where you could reach each student?

• SELECT Students.first_name, Students.last_name, Departments.office_location FROM Students, Departments;

• SELECT Students.first_name, Students.last_name, Departments.office_location

  FROM Students JOIN Departments ON Students.department = Departments.department;

• SELECT Students.first_name, Students.last_name, Departments.office_location

  FROM Students JOIN Departments;

• SELECT Students.first_name, Students.last_name, Departments.office_location

  FROM Students ON Students.department = Departments.department;

Given the Games table pictured, which query generates the results shown?

• SELECTGameType, MaxPlayers, count(*) ASNumberOfGames

  FROMGames

  GROUP BYMaxPlayers, GameType

  ORDER BYMaxPlayers, GameType;

• SELECTGameType, MaxPlayers, count(*) ASNumberOfGames

  FROMGames

  GROUP BYGameType, MaxPlayers

  ORDER BYGameType;

• SELECTGameType, count(Players) ASMaxPlayers, NumberOfGames

  FROMGames

  GROUP BYGameType, MaxPlayers

  ORDER BYGameType;

• SELECTGameType, MaxPlayers, count(*) ASNumberOfGames

  FROMGames

  GROUP BYGameType

  ORDER BYMaxPlayers;

Which answer is a possible result of the sequence of commands below?

DECLARE@UniqueID uniqueidentifier = NEWID();

SELECT@UniqueID ASResult;

• 1

• bb261196-66a5-43af-815d-123fc593cf3a

• z350mpj1-62lx-40ww-9ho0-4u1875rt2mx4

• 0x2400001155F04846674AD4590F832C0

You need to find all students that are not on the "Chemistry Cats" team. Which

query does NOT work for this task?

• WHERE team NOT 'Chemistry Cats';

• WHERE team <> 'Chemistry Cats';

• WHERE team != 'Chemistry Cats';

• WHERE NOT team = 'Chemistry Cats';

You need to write a query that returns all Employees that have a LastName starting with the letter A. Which WHEREclause should you use to fill in the blank in this query?

• WHERE LastName = A*

• WHERE LastName = LIKE '%A%'

• WHERE LastName LIKE 'A%'

• WHERE LastName IN ('A*')

Which query shows the first name, department, and team of all students with the

two lowest points?

• SELECT LIMIT(2) first_name, department, team FROM Students ORDER BY points ASC;

• SELECT TOP(2) first_name, deprtment, team FROM Students ORDER BY points DESC;

• SELECT TOP(2) WITH TIES first_name, department, team FROM Students ORDER BY

  points;

• SELECT BOTTOM(2) first_name, department, team FROM Students ORDER BY points ASC;

Answer explanation

the picture of table is important here and there it can be seen that there are only two

value with min points. Secondly, the previous answer was wrong because order by

DESCwill put highest points into the beginning of result list and TOP(2)will take first

two highest points, and we need the lowest points.

What is the result of this statement?

SELECT FLOOR(-1234.321)

• -1234.3

• -1234

• -1235

• 1234.321