SQL Server Set 2

1.

In an SQL Server, which of the following queries will you use to list all the employees with their username, first name, last name, and working in the Operations department?

EMP_ID	User_name	F_Name	L_name	Dep_ID
1	AAlice	Alice	Smith	1
2	BBob	Bob	Jones	2
3	BBen	Ben	Johnson	2
4	MMike	Mike	White	2
5	AAnita	Anita	Williams	3
6	LLisa	Lisa	Davis	3
7	MMary	Mary	Brown	4
8	JJohn	John	Wilson	4

Dep_ID	Dep_name
1	Technical Innovations
2	Technical Support
3	Operations
4	Customer Delight

select e1.User_name,e1.F_Name,e1.L_Name,e2.Dep_Name from EmployeeTbl e1 inner join DepartmentsTbl e2 on e1.Dep_ID=e2.Dep_ID where e2.Dep_Name ="Operations"

select User_name,F_Name,L_Name,Dep_Name from EmployeeTbl e1 inner join DepartmentsTbl e2 on e1.Dep_ID=e2.Dep_ID where Dep_Name ="Operations"

select e1.User_name,e1.F_Name,e1.L_Name,e2.Dep_Name from EmployeeTbl e1 inner join DepartmentsTbl e2 on e1.Dep_ID=e2.Dep_ID

select e1.User_name,e1.F_Name,e1.L_Name,e2.Dep_Name from EmployeeTbl e1 inner join DepartmentsTbl e2 where e2.Dep_Name ="Operations"

2.

In an SQL Server, which of the following functions will return the names of all the distributors who live in a country specified by the user at runtime?

create function distributorname(@country varchar(30)) returns table as begin select * from distributors where country = @country end select * from distributorname('germany')

create function distributorname(@country varchar(30)) returns varchar(30) as begin select * from distributors where country = @country end select * from distributorname('germany')

create function distributorname(@country varchar(30)) returns table as return(select * from distributors where country = @country) select * from distributorname('germany')

create function distributorname(@country varchar(30)) returns table as begin return(select * from distributors where country = @country) end select * from distributorname('germany')

3.

In an SQL Server, which of the following takes place when you implement null in unique indexes?

Null values are treated as duplicate values when indexed. Null values ensure that the indexed column contains no duplicate values. Null values ensure that each combination of values in the indexed column is unique. Columns can contain null in more than one row.

4.

The fill factor clause in an SQL Server is used to _________________.

Improve performance of the system by minimizing the amount of page splitting that occurs each time an index page becomes full Skip statements after continue inside the loop Exit from the while loop Sort data stored in table in ascending order

5.

In an SQL Server, which of the following system-stored procedures is used to create a user-defined datatype?

sp_addtype sp_droptype sp_bindrule sp_unbindrule

6.

In an SQL Server, what is the use of null in unique indexes?

Null values are treated as duplicate values when indexed Null values ensure that the indexed column contains no duplicate values Null values ensure that each combination of values in the indexed column is unique Columns can contain null in more than one row

7.

Which of the following SQL commands is used to add and record data to a database table in an SQL Server?

ADD UPDATE APPEND INSERT

8.

In an SQL Server, the hexadecimal value for an apostrophe ( ) in xml query is_____________________________.

&apostrophe

@apost

@aps

&apos

9.

In an SQL Server, which of the following commands is used to add columns to a pre-existing table?

ALTER TABLE TableName ADD ColumnName ALTER TABLE TableName ADD COLUMN ColumnName MODIFY TABLE TableName ADD ColumnName MODIFY TABLE TableName ADD COLUMN ColumnName

10.

What SQL command can be used to delete columns from a pre-existing table?

MODIFY TABLE TableName DROP ColumnName MODIFY TABLE TableName DROP COLUMN ColumnName ALTER TABLE TableName DROP ColumnName ALTER TABLE TableName DROP COLUMN ColumnName

SQL Server Set 2

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 2

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