SQL Set 2

1.

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.

2.

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

3.

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

4.

In an SQL Server, which of the following system tables contains the pointer of the root page of an index?

Sysobjects Sysreferences Sysdepends Sysindexes

5.

In an SQL Server, ____________________ is the property possessed by a transaction when locking is implemented.

Atomicity Consistency Isolation Durability

6.

In an SQL Server, which of the following statements is correct?

A view is used to derive data from multiple tables across different databases. However, a view cannot be used to derive data from a temporary table.

A base table can be modified through a view if the modification does not involve any computed column.

Both of these None of these 1 is true and 2 is false 1 is false and 2 is true

7.

Which of the following system databases is used by an SQL Server to sort data before returning the result?

master msdb tempdb model

8.

In an SQL Server, which of the following system functions is used to determine the line number at which the error has occurred?

ERROR_LINE()

ERROR_MESSAGE()

ERROR_NUMBER()

ERROR_NO()

9.

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"

10.

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')

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