SQL Set 3

1.

The default date format of MS SQL is MM/DD/YY. Which of the following is the correct code to convert the date syntax to DD/MM/YY?

select Convert(varchar(10),CONVERT(date,DateColumnInTable,106),103) select Convert(varchar(10),CONVERT(DateColumnInTable,106),103) select Convert(varchar(10),CONVERT(date,DateColumnInTable),103) select Convert(varchar(10),CONVERT(date,DateColumnInTable,103),106)

2.

In an SQL Server, which of the following XML options is used to display the designations of all the employees on the web, such that each row is displayed as a single element on the web page?

raw auto elements explicit

3.

In an SQL Server, which of the following operators is used to in pattern-matching for any query that is executed in a WHERE clause?

BETWEEN LIKE EXISTS EQUALS

4.

In an SQL Server, which of the following operators tests a column for the absence of data or missing information in records?

EXISTS NOT IS NULL NOT EQUALS

5.

In an SQL Server, which of the following is not a database recovery model?

Simple Full Bulk-Logged OLAP and OLTP

6.

In an SQL Server, which of the following statements is used to truncate the partition table EmployeesTbl in the range of 2, 4, 6 up to 8?

TRUNCATE TABLE EmployeesTbl WITH (PARTITIONS (2, 4, 6 TO 8)); TRUNCATE TABLE EmployeesTbl WITH (PARTITIONS (2 TO 8)); TRUNCATE TABLE EmployeesTbl WHERE (PARTITIONS (2, 4, 6 TO 8)); TRUNCATE TABLE EmployeesTbl WITH PARTITIONS (2, 4, 6 TO 8);

7.

In an SQL Server, which of the following are the benefits of partitioning a table?

You can transfer or access subsets of data quickly and efficiently without disturbing the integrity of data collection.

You can perform maintenance operations on one or more partitions quickly.

You may improve query performance, based on the types of queries you frequently run and the hardware configuration.

You use at least 16 GB of RAM if a large number of partitions are in use.

1, 2, and 3 1, 2, 3, and 4 2, 3, and 4 1, 3, and 4

8.

In SQL Server, which of the following queries will display the list of employees who are not working in the branch located in London?

SELECT EmpID, Emp_FName, Emp_LName, Branch_City FROM EmployeeTbl WHERE Branch_City <> 'London'

SELECT EmpID, Emp_FName, Emp_LName, Branch_City FROM EmployeeTbl WHERE Branch_City <> "London"

SELECT EmpID, Emp_FName, Emp_LName, Branch_City FROM EmployeeTbl WHERE Branch_City not equal to 'London'

SELECT EmpID, Emp_FName, Emp_LName, Branch_City FROM EmployeeTbl WHERE Branch_City <> London

9.

In SQL Server, which of the following queries is used to obtain the list of all the employees based on the following:

Working in Seattle, Tacoma, and Redmond

Joined between the dates 1st June to 30th July

SELECT Emp_ID, Emp_FName, Emp_LName, Branch_City FROM EmployeesTbl WHERE Branch_City IN ('Seattle', 'Tacoma', 'Redmond') AND JoinDate BETWEEN '1-june-2017' AND '30-July-2017'

SELECT Emp_ID, Emp_FName, Emp_LName, Branch_City FROM EmployeesTbl WHERE Branch_City IN (Seattle, Tacoma, Redmond) AND JoinDate BETWEEN '1-june-2017' AND '30-July-2017'

SELECT Emp_ID, Emp_FName, Emp_LName, Branch_City FROM EmployeesTbl WHERE Branch_City IN ('Seattle', 'Tacoma', 'Redmond') AND JoinDate IN BETWEEN '1-june-2017' AND '30-July-2017'

SELECT Emp_ID, Emp_FName, Emp_LName, Branch_City FROM EmployeesTbl WHERE Branch_City IN (''Seattle", "Tacoma", "Redmond") AND JoinDate BETWEEN "1-june-2017" AND "30-July-2017"

10.

Consider the toys table which has the following columns:

ToyID	vToyName	CategoryID

In SQL Server, which of the following queries is used to display the toy names and their respective categories?

SELECT t.vToyName, c.cCategory FROM Toys t JOIN Category c ON t.cCategoryId = c.cCategoryID

SELECT vToyName, cCategory FROM Toys JOIN Category ON cCategoryId = cCategoryID

SELECT t.vToyName, c.cCategory FROM Toys t JOIN Category c

SELECT t.vToyName, c.cCategory FROM Toys t, Category c ON cCategoryId = cCategoryID

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

SQL Set 3

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner