databases Online Quiz - 42
|Description: databases Online Quiz - 42|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; What is true about this SQL statement?
What various validations do you perform on the data after extraction?
Will the performance improve by using dataset in parallel jobs?
A subject based Addressing is used as :
A subject Name with “Invoice .Ny.TN” can be received by “>” “ .>” “Invoice...>” “I?.>” “Invoice..>” “Invoice.” “invoice.*” Number of listeners who can receive this are
Default Queue has the limit policy of
If youngest event in the queue has to be discarded ,a queue should have a limit policy of
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
Montior call back function takes as argument
ErrorAdvisory Msg PARAM_MISMATCH is presented when
When a rvd does not run with -permenant option what it does
What is the default tcp port for rvrd
When a rvperfm runs with no rvperfs . it is used to determine
If two programs A1,A2 are communicating thru subject name ( _LOCAL.SUB), then which of the following is true ..
Which are the following must be supplied to the TibrvEvent