Which edition of SQL server supports Asynchronous mirroring.
Workgroup
Express
Standard
Enterprise
How to find out no. of objects in a database.
Sp_find
select * from Sys.sysobjects
select * from sys.dm_exec_objects
Sp_helpobjects
What are three steps of data recovery when database goes in recovery mode.
Analysis ,redo,undo
Redo.Analysis ,undo
Undo,analysis,Redo
Analysis,Redo,Recovery
How will you see logical reads for a query when executing it.
SET XMLSTATS IO ON
SET STATISTICS TIME ON
SET STATISTICS I/O ON
SET STATISTICS IO ON
How many clusterd index you can create on a table
3
Depends on senario
2
1
What is the specific partitioning technique should be used for join stage?
auto
hash
entire
same
what are the client components in data stage 8.0?
administrator
manager
designer
directror
what is to be entered to ensure that env variables need not be edited in the jobs when code moves from one env to other(dev to test)?
ENV
$UNSET
$PROJDEF
None of the above
Stages which run in sequential mode by default?
sequential file stage
File set stage
Lookup file set stage
Row generator stage
What is the order of execution of constraints,derivation.Stage variables in a transformer stage?
Constraints,Derivations,Stage variables
Derivations,Constraints,Stage variables
Stage variables,Derivations,Constraints
Any of the above