SQL Server Set 1

1.

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"

2.

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

3.

Consider the following structure for Toys table:

vToyName	mToyRate	vToyCategory

In an SQL Server, which of the following queries is used to select the names of all those toys which belongs to the category Racer?

SELECT * FROM toys WHERE vToyName like '%Racer%'

SELECT * FROM toys WHERE vToyCategory like '%Racer%'

SELECT * FROM toys WHERE iToyRate like '%Racer%'

SELECT * FROM toys WHERE ToyID like '%Racer%'

4.

In an SQL Server, which of the following statements is used to add a new user called myuser to the system administrators role?

exec sp_addsrvrolemember 'myuser', 'sysadmin' exec sp_addsrvrolemember 'myuser', 'db_ddl_admin' exec sp_srvaddrolemember 'sysadmin', 'myuser' exec sp_srvaddrolemember 'db_ddl_admin', 'myuser'

5.

You have a ContractRecruiter table. You want to display the names of all the contract recruiters whose names start with ‘J’. Which of the following SQL queries will display the task?

Select * from ContractRecruiter WHERE cName = 'J%'

Select * from ContractRecruiter WHERE cName LIKE 'J%'

Select * from ContractRecruiter WHERE cName in 'J%'

Select * from ContractRecruiter WHERE cName LIKE J%

6.

In an SQL Server, consider the following table structure:

vFirstName	vLastName	siTestScore	dTestDate

Which of the following queries will you use to create a report displaying the names of candidates and their respective scores who took the test between March 5, 2016, and March 12, 2016?

SELECT vFirstName,vLastName,siTestScore,dTestDate FROM ExternalCandidate WHERE dTestDate between '03/05/16' and '03/12/16'

SELECT vFirstName,vLastName,siTestScore,dTestDate FROM ExternalCandidate WHERE dTestDate in( '03/05/16' , '03/12/16')

SELECT vFirstName,vLastName,siTestScore,dTestDate FROM ExternalCandidate WHERE dTestDate in( '03/05/16' and '03/12/16')

SELECT vFirstName,vLastName,siTestScore,dTestDate FROM ExternalCandidate WHERE dTestDate on '03/05/16' and '03/12/16'

7.

In an SQL Server, AND, OR, and NOT are __________________________________.

Logical operators Comparison operators Range operators Arithmetic operators

8.

In an SQL Server, which of the statements about a trigger is correct?

A trigger can be explicitly invoked or executed like procedures. A trigger prevents incorrect, unauthorized, and inconsistent changes in data. A trigger can return data to the user. A trigger cannot call another trigger because triggers cannot be explicitly invoked.

9.

In an SQL Server, if you want to create a user-defined table that can be replicated for any new user database, then you should create the table in the ____________________ database.

Master MSDB Pubs Model

10.

In an SQL Server, which of the following files is essential for any type of database?

Primary data file
Secondary data file
Transaction Log

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

SQL Server Set 1

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 Server Set 1

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