Instant Access Oracle.1Z0-082.v2022-06-18.q110 Actual Practice Test Engine for Free (Page 18)

40%off

1Z0-082 Premium Dumps

Latest 1Z0-082 Exam Premium Dumps provide by TrainingQuiz.com to help you Passing 1Z0-082 Exam! TrainingQuiz.com offers the updated 1Z0-082 exam dumps, the TrainingQuiz.com 1Z0-082 exam questions has been updated to correct Answer. Get the latest TrainingQuiz.com 1Z0-082 pdf dumps with Exam Engine here:

(165 Q&As Dumps, 40%OFF Special Discount: DumpsDB)

Question 81

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

A.analysis of all privileges used by all users including administrative users in the database
B.analysis of all privileges used by all users but excluding administrative users in the database
C.analysis of privileges that a user has on their own schema objects that they did not use
D.analysis of privileges that a user has on their own schema objects that they did use
E.analysis of privileges granted directly to a role that are then used by a user who has been granted that role
F.analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Question 82

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

A.INTERSECT returns rows common to both sides of the compound query
B.INTERSECT ignores NULLs
C.Column names in each SELECT in the compound query can be different
D.Reversing the order of the intersected tables can sometimes affect the output
E.The number of columns in each SELECT in the compound query can be different

Question 83

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

A.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
B.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
C.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
D.Employees 100 and 200 will have the same JOB_ID as before the update command
E.Employees 100 and 200 will have the same SALARY as before the update command
F.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Question 84

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A.The names and number of columns must be identical for all SELECT statements in the query.
B.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
C.The number, but not names, of columns must be identical for all SELECT statements in the query.
D.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
E.The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.

Question 85

You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

A.SELECT ROUND(SYSDATE ?'01-JAN-2019') FROM DUAL;
B.SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY') ?'01-JAN-2019' FROM DUAL;
C.SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;
D.SELECT SYSDATE ?TO_DATE('01-JANUARY-2019') FROM DUAL;
E.SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;