×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
In an SQL Server, which of the following will you use view the details such as size and date of creation of all its databases?
2.
In an SQL Server, the__________ database manages all the server-specific configuration information.
3.
In an SQL Server, which of the following methods is used to preserve space on leaf pages and avoid splitting while creating indexes?
4.
In which of the following cases will you implement vertical partitioning of tables in an SQL Server:
- In the tables where you want restricted access of sensitive data to users.
- In the table scanning reports where you get a voluminous amount of data.
- Vertical partitioning is used on BLOB columns and it is helpful.
- The ntext, text, image, or varbinary(max), Microsoft .NET Framework CLR user-defined type and alias data type columns can be specified as partitioned columns.
5.
In an SQL Server, which of the following queries is used to search for created and available file groups in the current database along with the type and read-only status?
6.
In an SQL Server, which of the following queries is used to ensure if the created secondary files are successfully added to the filegroup?
7.
What is the output of the following SQL code:
Declare @count int
Select @count=11
While @count>0
Begin
Select @count=@count-1
If@ count = 4
Begin Break
End
If@ count = 6
Begin Continue
End
Print@ count
End
Select @count=11
While @count>0
Begin
Select @count=@count-1
If@ count = 4
Begin Break
End
If@ count = 6
Begin Continue
End
Print@ count
End
8.
In SQL Server, which of the following stored procedures correctly executes and displays the details of the employee's city and address?
9.
In SQL Server, which one of the following is true for an aligned index?
- If a table and its indexes are aligned, MS SQL Server switches in between the partition structure of both the table and its indexes for a quick and an efficient data maintenance.
- An index has to be in the same partition function if you have to align it with the base table.
- The alignment in between the partition table and partition index will follow the same partition function in terms of arguments, datatypes, and the number of partitions.
10.
In SQL Server, the stored procedure prcDispEmpDetails prints the details of the employees based on their employee code by using multiple base tables. Alice wants to view the names of all the tables involved in printing this report. Therefore, she issues the sp_helptext command for the mentioned procedure, but she is unable to view any details. Identify the reason for this error?