Tag: databases

Questions Related to databases

Which edition of SQL server supports Asynchronous mirroring.
technology databases

  1. Workgroup

  2. Express

  3. Standard

  4. Enterprise

Show answer
Correct Option: D

How to find out no. of objects in a database.
technology databases

  1. Sp_find

  2. select * from Sys.sysobjects

  3. select * from sys.dm_exec_objects

  4. Sp_helpobjects

Show answer
Correct Option: B

What are three steps of data recovery when database goes in recovery mode.

technology databases

  1. Analysis ,redo,undo

  2. Redo.Analysis ,undo

  3. Undo,analysis,Redo

  4. Analysis,Redo,Recovery

Show answer
Correct Option: A

How will you see logical reads for a query when executing it.

technology databases

  1. SET XMLSTATS IO ON

  2. SET STATISTICS TIME ON

  3. SET STATISTICS I/O ON

  4. SET STATISTICS IO ON

Show answer
Correct Option: D

How many clusterd index you can create on a table

technology databases

  1. 3

  2. Depends on senario

  3. 2

  4. 1

Show answer
Correct Option: D

What is the specific partitioning technique should be used for join stage?
technology databases

  1. auto

  2. hash

  3. entire

  4. same

Show answer
Correct Option: B

what are the client components in data stage 8.0?

technology databases

  1. administrator

  2. manager

  3. designer

  4. directror

Show answer
Correct Option: A,C,D

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

technology databases

  1. ENV

  2. $UNSET

  3. $PROJDEF

  4. None of the above

Show answer
Correct Option: C

Stages which run in sequential mode by default?

technology databases

  1. sequential file stage

  2. File set stage

  3. Lookup file set stage

  4. Row generator stage

Show answer
Correct Option: A,D

What is the order of execution of constraints,derivation.Stage variables in a transformer stage?

technology databases

  1. Constraints,Derivations,Stage variables

  2. Derivations,Constraints,Stage variables

  3. Stage variables,Derivations,Constraints

  4. Any of the above

Show answer
Correct Option: C