Tag: programming languages

Questions Related to programming languages

  1. response.setparameter () method

  2. response.getparameter () method

  3. request.setparameter () method

  4. request.getparameter () method


Correct Option: D
  1. HTTPRequest.setUserName()

  2. HttpServletRequest.getUserName()

  3. HTTPResponse.setUserName()

  4. HTTPResponse.getUserName()


Correct Option: B
  1. acts as an interface between view and model

  2. does not interact with view

  3. does not interact with controller

  4. nothing but view


Correct Option: A

Which of the following statements is true regarding the UNDO_POLICY=REQUIRED option?

  1. It must be used with the REQUIRED integrity constraint.

  2. It ignores the specified integrity constraints if any of the rows that you want to insert or update do not meet the constraint criteria.

  3. It restores your table to its original state if any of the rows that you try to insert or update do not meet the specified integrity constraint criteria.

  4. It allows rows that meet the specified integrity constraint criteria to be inserted or updated, but rejects rows that do not meet the integrity constraint criteria.


Correct Option: C
  1. Table One and Table Two X Y X Z ------------ 1 2 2 5 1 2 3 6 1 2 4 9 2 3 2 5 2 3 3 6 2 3 4 9

  2. Table One and Table Two X Y X Z ------------ 1 2 2 5 2 3 2 5

  3. Table One and Table Two X Y Z ------------ 1 2 5 2 3 5

  4. Table One and Table Two X Y Z ------------ 1 2 . 2 3 5


Correct Option: A
  1. One and Two Joined One b Two b ------------------- a 1 a 1 b 2 b 2 d 4 d 4 c . e . c . f .

  2. One and Two Joined One b Two b ------------------- a 1 a 1 b 2 b 2 c . c . d 4 d 4 c . e . c . f .

  3. One and Two Joined One b Two b ------------------- a 1 a 1 b 2 b 2 c . c . d 4 d 4

  4. One and Two Joined One b Two b ------------------- a 1 a 1 b 2 b 2 . . . . d 4 d 4


Correct Option: B
  1. Table MERGED Flight Supervisor Destination 145 Kang Brussels 150 Miller Paris 155 Evanko 157 Lei 165 Seattle

  2. Table MERGED Flight Supervisor Destination 145 Kang Brussels 150 Miller Paris

  3. Table MERGED Flight Supervisor Destination 145 Kang Brussels 145 Ramirez Edmonton 150 Miller Paris 150 Picard Madrid

  4. Table MERGED Flight Supervisor Destination 145 Kang Brussels 145 Ramirez Edmonton 150 Miller Paris 150 Picard Madrid 155 Evanko 157 Lei 165 Seattle


Correct Option: D
  1. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Kang 145 Brussels 145 Kang 145 Edmonton 145 Ramirez 145 Brussels 145 Ramirez 145 Edmonton 150 Miller 150 Paris 150 Miller 150 Madrid 150 Picard 150 Paris 150

  2. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Ramirez 145 Edmonton 150 Picard 150 Madrid

  3. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Kang 145 Brussels 145 Kang 145 Edmonton 150 Miller 150 Paris 150 Miller 150 Madrid

  4. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Kang 145 Brussels 145 Ramirez 145 Brussels 150 Miller 150 Paris 150 Picard 150 Paris 150 Picard 150 Madrid


Correct Option: A
  1. Column names in the result set are determined by the first table.

  2. To be overlaid, columns must be of the same data type.

  3. To be overlaid, columns must have the same name.

  4. By default, only unique rows are displayed in the result set.


Correct Option: C