databases Online Quiz - 42 Online Test

0

databases Online Quiz - 42

Description: databases Online Quiz - 42
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

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

technology databases

USER_TAB_PRIVS_MADE
USER_TAB_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS

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?

technology databases

The SQL statement displays the desired results.
The column in the WHERE clause should be changed to display the desired results.
The operator in the WHERE clause should be changed to display the desired results.
The WHERE clause should be changed to use an outer join to display the desired results.

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set?

technology databases

The DESCRIBE DEPT statement displays the structure of the DEPT table.
The ROLLBACK statement frees the storage space occupies by the DEPT table.
The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement

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

technology databases

NULL check
MetaData Check
Duplicate Check
Invalid Check

Array Size is mainly used to increase the buffer during Write operations into a Oracle DB in a Server job using the Oracle OCI stage.

technology databases

True
False

Will the performance improve by using dataset in parallel jobs?

technology databases

True
False

What is the default cache size?

technology databases

512MB
128MB
256MB
64MB

Types of vies in Datastage Director?

technology databases

Job View
Run view
Log View
Status View

A subject based Addressing is used as :

technology databases

Identifies Data producer to Data Consumer
Identifies Data Consumer to Producer .
Communication between data producer and Data consumers
None

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

technology databases

3
4
2
5

Default Queue has the limit policy of

technology databases

Discard none
Discard first
Discard New
Discard last

If youngest event in the queue has to be discarded ,a queue should have a limit policy of

technology databases

Discard none
Discard last
Discard new
Discrd first

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

technology databases

Immediately when the new scheduler takes its place all the incomplete task are reassigned
Reallocation will never happen
Wait for 20 sec and if the task is still incomplete it reassigns the task
None

Montior call back function takes as argument

technology databases

number of active elements
activation interval
heartbeat interval
None

ErrorAdvisory Msg PARAM_MISMATCH is presented when

technology databases

Active goal differs
activation interval differs
lost interval differs
None

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

technology databases

Runs for ever
Dies after 15 min of inactivity
Dies after 30min of inactivity
None

What is the default tcp port for rvrd

technology databases

7600
7680
7504
7500

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

technology databases

maximum through put from the send
Determins the network efficiency
Maximum listening capacity
None

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

technology databases

A1,A2 are connected to two different daemons
A1,A2 are connected to the same daemon and the same service
A1,A2 are connected to the same daemon and the different service
None

Which are the following must be supplied to the TibrvEvent

technology databases

Listener
Transport
Queue
Call Back

- Hide questions