nerdexam
IBM

P2090-050 · Question #92

You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?

The correct answer is B. Select * from PROD..TableA. See the full explanation below for the reasoning.

Question

You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?

Options

  • ADelete from PROD..TableA
  • BSelect * from PROD..TableA
  • CTruncate table PROD..TableA
  • DInsert into PROD..TableA select * from DEV..TableB

How the community answered

(49 responses)
  • A
    2% (1)
  • B
    80% (39)
  • C
    6% (3)
  • D
    12% (6)

Community Discussion

No community discussion yet for this question.

Full P2090-050 Practice