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

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

  1. USER_TAB_PRIVS_MADE

  2. USER_TAB_PRIVS

  3. USER_COL_PRIVS_MADE

  4. USER_COL_PRIVS


Correct Option: D
  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
  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

Default Queue has the limit policy of

  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

When a rvd does not run with -permenant option what it does

  1. Runs for ever

  2. Dies after 15 min of inactivity

  3. Dies after 30min of inactivity

  4. None


Correct Option: B

When a rvperfm runs with no rvperfs . it is used to determine

  1. maximum through put from the send

  2. Determins the network efficiency

  3. Maximum listening capacity

  4. None


Correct Option: A

If two programs A1,A2 are communicating thru subject name ( _LOCAL.SUB), then which of the following is true ..

  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