|
Microsoft SQL Server Interview Questions and Answers
After you've completed a backup for your Sales server
to disk, you want to be sure that this backup is intact
and able to be used for restores before writing it to
tape. What command will help you here?
RESTORE VERIFYONLY
After a backup file has been written to disk or tape,
its integrity can be checked with the RESTORE VERIFYONLY
command. This command will verufy the backup set is
complete and that the files are readable.
What is the result of the following query?
declare @a int
declare @b int
set @a = 5
set @b = 11
select @a = @a ^ @b , @b = @b ^ @a, @a = @a ^ @b
print '@a = '+convert(varchar,@a)
print '@b = '+convert(varchar,@b)
@a = 11 , @b = 5
Here is the explanation:
Step 1
@a has the value of 5 and is binairy 101
@b has the value of 11 and is binairy 1011
After “select @a = @a ^ @b , @b = @b ^ @a, @a = @a ^ @b”
the values are
@a will get the value from 101 ^ 1011 = 1110 (=14)
@b have stil the value of 1011 (=11)
Step 2
After “select @a = @a ^ @b , @b = @b ^ @a, @a = @a ^ @b”
The values are
@a will stay at the value 1110 (=14)
@b will get the value from 1011 ^ 1110 = 101 (=5)
Step 3
After “select @a = @a ^ @b , @b = @b ^ @a, @a = @a ^ @b”
@a will get the value from 1110 ^ 101 = 1011 (=11)
@b will stay at the value 101 (=5)
Out of the box Report Builder supports two report level
fields that can be shown on a report. Which option below
has those two options?
The current filter and the number of rows that matched
that filter
By default, the current filter definition and the number
of rows that matched the filter are added to the end of
the report. They can be removed and added back as
needed.
Can a particular event in SQL Server 2005, such as the
CREATE USER command, have more than one DDL trigger
assigned to it?
Yes
An event can have multiple triggers assigned to it.
You accidently delete an application from an instance of
SQL Server 2005 Notification Services. However you have
not removed the database, nor the application objects.
Can you re-associate the application with the same SSNS
instance?
No
You cannot re-assocaite the application because when you
add the application, SSNS recreates the objects. If they
already exist, the create fails.
How many users can be added to an application role in
SQL Server 2005?
None
This is a trick questions. No users are added to
application roles. Application roles are invoked by a
user.
What algorithm is used to encrypt the Database Master
Key when it is created?
Triple DES
When you create a Database Master Key, it is encrypted
using the password you supply with the Triple DES
algorithm.
Which protocols support Kerberos authentication on SQL
Server 2005?
TCP/IP
Only those clients connecting with TCP/IP can use
Kerberos authentication.
You have a few new SQL Server 2005 server instances and
you want to be sure that SQL authenticated logins must
abide by the password policy. On this platforms can you
enforce this?
Windows 2003 Server
You can only enforce password policy on the Windows 2003
Server platform and newer.
You are setting up a native XML web service on your SQL
Server 2005 to respond to inventory requests. How can
you you be sure that a SOAP queries that are looking for
a WSDL response will be provided?
Use the WSDL=DEFAULT parameter in the create endpoint
statement.
When using the CREATE ENDPOINT command, you can specify
the WSDL=DEFAULT parameter to generate a default WSDL
response or use WSDL="spname" where spname is the name
of a custom stored procedure to return WSDL responses.
Where can you view the list of server-scoped DDL
triggers?
The Object Explorer for the server has a "Triggers"
folder.
The server-scoped DDL triggers will appear in Management
Studio in the Object Explorer under the "Triggers"
folder.
You want to be sure that your reporting solutions using
a database snapshot are properly protected from
disaster. How can you back up your database snapshots?
You cannot back up a database snapshot.
A database snapshot cannot be backed up or restored.
Page Numbers : 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Have a Question ?
post your questions here. It
will be answered as soon as possible.
Check
Job Interview Questions
for more Interview Questions with Answers
|
