0

databases Online Quiz - 42

Description: databases Online Quiz - 42
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. The SQL statement displays the desired results.

  2. The column in the WHERE clause should be changed to display the desired results.

  3. The operator in the WHERE clause should be changed to display the desired results.

  4. The WHERE clause should be changed to use an outer join to display the desired results.


Correct Option: C
  1. The DESCRIBE DEPT statement displays the structure of the DEPT table.

  2. The ROLLBACK statement frees the storage space occupies by the DEPT table.

  3. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.

  4. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement


Correct Option: A

What various validations do you perform on the data after extraction?

  1. NULL check

  2. MetaData Check

  3. Duplicate Check

  4. Invalid Check


Correct Option: A,B,C,D
  1. 512MB

  2. 128MB

  3. 256MB

  4. 64MB


Correct Option: B
  1. Job View

  2. Run view

  3. Log View

  4. Status View


Correct Option: A,C,D

A subject based Addressing is used as :

  1. Identifies Data producer to Data Consumer

  2. Identifies Data Consumer to Producer .

  3. Communication between data producer and Data consumers

  4. None


Correct Option: C

A subject Name with “Invoice .Ny.TN” can be received by “>” “ .>” “Invoice...>” “I?.>” “Invoice..>” “Invoice.” “invoice.*” Number of listeners who can receive this are

  1. 3

  2. 4

  3. 2

  4. 5


Correct Option: B
  1. Discard none

  2. Discard first

  3. Discard New

  4. Discard last


Correct Option: A

When a sender and Distributed Queues have a certified agreement existing between them ,if the active scheduler fails and the worker member which take the place of scheduler if the completion time parameter is said to 20 , when will the reallocation of task will be done

  1. Immediately when the new scheduler takes its place all the incomplete task are reassigned

  2. Reallocation will never happen

  3. Wait for 20 sec and if the task is still incomplete it reassigns the task

  4. None


Correct Option: C

Montior call back function takes as argument

  1. number of active elements

  2. activation interval

  3. heartbeat interval

  4. None


Correct Option: A
  1. Active goal differs

  2. activation interval differs

  3. lost interval differs

  4. None


Correct Option: B
  1. Runs for ever

  2. Dies after 15 min of inactivity

  3. Dies after 30min of inactivity

  4. None


Correct Option: B

What is the default tcp port for rvrd

  1. 7600

  2. 7680

  3. 7504

  4. 7500


Correct Option: D
  1. maximum through put from the send

  2. Determins the network efficiency

  3. Maximum listening capacity

  4. None


Correct Option: A
  1. A1,A2 are connected to two different daemons

  2. A1,A2 are connected to the same daemon and the same service

  3. A1,A2 are connected to the same daemon and the different service

  4. None


Correct Option: B
- Hide questions