×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
In an SQL Server, you have to create a table called Employee2017. A user-defined datatype called typemployeecode needs to be created for the cEmployeeID attribute of the Employee2017 table.
Which of the following actions will you take to use the datatype in the Employee2017 table?
2.
Identify the correct order of steps for creating and using the CLR user-defined functions:
- Define the function as a static method of a class in a language supported by the .NET Framework.
- Register the assembly in an SQL Server by using the CREATE ASSEMBLY statement.
- Create the function that references the registered assembly by using the CREATE FUNCTION statement.
- Execute user-defined functions.
3.
What is the output of the following SQL queries:
select stor_id, count(stor_id)
from saletbl
group by stor_id
having avg(qty) >= 20
and count(stor_id) > 3
from saletbl
group by stor_id
having avg(qty) >= 20
and count(stor_id) > 3
4.
Which of the following is used by an SQL server to store data when a table does not have a clustered index?
5.
In an SQL server, which of the following commands will you use to verify that the index idxrno on the irno column has been created in the student table?
6.
In an SQL Server, which of the following integrities can be implemented using the delete trigger?
7.
In an SQL Server 2008 instance, which of the following will you check to clarify whether the database integrity check (DBCC CHECKDB) is implemented for a special database?
8.
In an SQL Server, which of the following statements is used to create the database called toys with at least 50 MB of free space and 15 MB as start size for the transaction log?
9.
State whether the statement is true or false: In an SQL database, a UNION operator can used between two tables only when the column names in the first SELECT statement matches the column names in the second SELECT statement.
10.
State whether the following statement is true or false: A psuedocolumn such as ROWNUM is not stored in a database