Tag: databases

Questions Related to databases

Which operator works like an OUTER JOIN?
technology databases

  1. Minus

  2. Except

  3. Intersect

  4. Union

Show answer
Correct Option: D

Which function return NULL when X = Y and X when it does not?
technology databases

  1. NULLIF(X,Y)

  2. COALESCE(X,Y)

  3. ZEROIFNULL(X,Y)

  4. NULLIFZERO(X,Y)

Show answer
Correct Option: A

1)Which function is used to get the Current System Date and Time
technology databases

  1. GetSystemDate()

  2. GetDate()

  3. GetCurrentDateTime()

  4. None

Show answer
Correct Option: B

What will be the Output for the Below Query Select * from Retailer where rtrid = (select top 3 Rtrid from retailer)
technology databases

  1. Return Top 3 Row in the Retailer Table

  2. Return Error

  3. Return No Record

  4. Return all Records from Retailer Table

Show answer
Correct Option: B

Which function is used to get the Current System Date and Time

technology databases

  1. GetSystemDate()

  2. GetDate()

  3. GetCurrentDateTime()

  4. None

Show answer
Correct Option: B

What will be the Output for the Below Query
technology databases

  1. Return Top 3 Row in the Retailer Table

  2. Return Error

  3. Return No Record

  4. Return all Records from Retailer Table

Show answer
Correct Option: B

How many Primary Key can be set for an table

technology databases

  1. 10

  2. 1

  3. 2

  4. Infinite

Show answer
Correct Option: A

What will be the Output for Select Abs(25-45)

technology databases

  1. Abs is not a recognized function name

  2. -20

  3. 20

  4. None

Show answer
Correct Option: C

Which of the joins are available in SQL i) Inner Join ii) Left Outer Join iii) Cross Join iv) Self Join
technology databases

  1. All the Above

  2. i) and ii)

  3. i), ii) and iii)

  4. None

Show answer
Correct Option: A

How many Output Parameters can be set for an Stored Procedure
technology databases

  1. One

  2. More than One

  3. None

  4. Stored Procedure Does not support Output Parameter

Show answer
Correct Option: B