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

AI Explanation

To view the object privileges granted to a user on specific columns, you should query the USER_COL_PRIVS data dictionary table.

Let's go through each option to understand why it is correct or incorrect:

Option A) USER_TAB_PRIVS_MADE - This option is incorrect because USER_TAB_PRIVS_MADE is used to view the object privileges granted by the user.

Option B) USER_TAB_PRIVS - This option is incorrect because USER_TAB_PRIVS is used to view the object privileges granted to the user on tables or views, not on specific columns.

Option C) USER_COL_PRIVS_MADE - This option is incorrect because USER_COL_PRIVS_MADE is used to view the column privileges granted by the user.

Option D) USER_COL_PRIVS - This option is correct because USER_COL_PRIVS is the data dictionary table that should be queried to view the object privileges granted to the user on specific columns.

Therefore, the correct answer is D) USER_COL_PRIVS. This option is correct because it provides information about the object privileges granted to the user on specific columns.

  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

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?

  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

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) The DESCRIBE DEPT statement displays the structure of the DEPT table. This option is correct. The DESCRIBE statement in SQL is used to display the structure of a table. In this case, the DESCRIBE DEPT statement will display the structure of the DEPT table.

Option B) The ROLLBACK statement frees the storage space occupied by the DEPT table. This option is incorrect. The ROLLBACK statement in SQL is used to undo the changes made in the current transaction. It does not directly free the storage space occupied by a table.

Option C) The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist. This option is incorrect. Since the CREATE TABLE dept statement is executed before the DESCRIBE DEPT statement, the DEPT table does exist. Therefore, the DESCRIBE DEPT statement will not return an error.

Option D) The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement. This option is incorrect. The DESCRIBE statement can be used to display the structure of a table regardless of whether a COMMIT statement has been executed or not.

The correct answer is A. The DESCRIBE DEPT statement displays the structure of the DEPT table.

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

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.

  1. True

  2. False


Correct Option: A

Will the performance improve by using dataset in parallel jobs?

  1. True

  2. False


Correct Option: A

What is the default cache size?

  1. 512MB

  2. 128MB

  3. 256MB

  4. 64MB


Correct Option: B

Types of vies in Datastage Director?

  1. Job View

  2. Run view

  3. Log View

  4. Status View


Correct Option: A,C,D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Job View - This option is correct. In the Datastage Director, the Job View is used to view and manage the jobs. It provides information about the job status, such as whether the job is running, completed, or failed. It also allows you to monitor the progress of the job and view detailed job logs.

Option B) Run View - This option is incorrect. There is no specific "Run View" in Datastage Director. It might be a misinterpretation or a term used in a different context.

Option C) Log View - This option is correct. The Log View in Datastage Director allows you to view the detailed log information for a job. It displays the log messages generated during the job run, including any error messages or warnings. This view is useful for troubleshooting and debugging purposes.

Option D) Status View - This option is correct. The Status View in Datastage Director provides an overview of the job status. It shows the current status of the job, such as running, completed, or failed. It also displays information about the job run, such as the start time, end time, and duration.

Therefore, the correct answer is A, C, D. These options represent the Job View, Log View, and Status View in Datastage Director.

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

Default Queue has the limit policy of

  1. Discard none

  2. Discard first

  3. Discard New

  4. Discard last


Correct Option: A

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

  1. Discard none

  2. Discard last

  3. Discard new

  4. Discrd first


Correct Option: C

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

ErrorAdvisory Msg PARAM_MISMATCH is presented when

  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

What is the default tcp port for rvrd

  1. 7600

  2. 7680

  3. 7504

  4. 7500


Correct Option: D

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

Which are the following must be supplied to the TibrvEvent

  1. Listener

  2. Transport

  3. Queue

  4. Call Back


Correct Option: C,D
- Hide questions