• databases Online Quiz - 42
Back
0

databases Online Quiz - 42

Description: databases Online Quiz - 42
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
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?

technology databases

  1. USER_TAB_PRIVS_MADE

  2. USER_TAB_PRIVS

  3. USER_COL_PRIVS_MADE

  4. USER_COL_PRIVS

Show answer
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.

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

  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.

Show answer
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?
technology databases

  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

Show answer
Correct Option: A

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

technology databases

  1. NULL check

  2. MetaData Check

  3. Duplicate Check

  4. Invalid Check

Show answer
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.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Will the performance improve by using dataset in parallel jobs?

technology databases

  1. True

  2. False

Show answer
Correct Option: A

What is the default cache size?

technology databases

  1. 512MB

  2. 128MB

  3. 256MB

  4. 64MB

Show answer
Correct Option: B

Types of vies in Datastage Director?

technology databases

  1. Job View

  2. Run view

  3. Log View

  4. Status View

Show answer
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 :

technology databases

  1. Identifies Data producer to Data Consumer

  2. Identifies Data Consumer to Producer .

  3. Communication between data producer and Data consumers

  4. None

Show answer
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

technology databases

  1. 3

  2. 4

  3. 2

  4. 5

Show answer
Correct Option: B

Default Queue has the limit policy of

technology databases

  1. Discard none

  2. Discard first

  3. Discard New

  4. Discard last

Show answer
Correct Option: A

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

technology databases

  1. Discard none

  2. Discard last

  3. Discard new

  4. Discrd first

Show answer
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

technology databases

  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

Show answer
Correct Option: C

Montior call back function takes as argument

technology databases

  1. number of active elements

  2. activation interval

  3. heartbeat interval

  4. None

Show answer
Correct Option: A

ErrorAdvisory Msg PARAM_MISMATCH is presented when
technology databases

  1. Active goal differs

  2. activation interval differs

  3. lost interval differs

  4. None

Show answer
Correct Option: B

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

technology databases

  1. Runs for ever

  2. Dies after 15 min of inactivity

  3. Dies after 30min of inactivity

  4. None

Show answer
Correct Option: B

What is the default tcp port for rvrd
technology databases

  1. 7600

  2. 7680

  3. 7504

  4. 7500

Show answer
Correct Option: D

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

technology databases

  1. maximum through put from the send

  2. Determins the network efficiency

  3. Maximum listening capacity

  4. None

Show answer
Correct Option: A

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

technology databases

  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

Show answer
Correct Option: B

Which are the following must be supplied to the TibrvEvent

technology databases

  1. Listener

  2. Transport

  3. Queue

  4. Call Back

Show answer
Correct Option: C,D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions