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

Comment: *

Name: *

Email: *

Verification: *

Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

• A.one instance on one server associated with two or more databases on separate servers
• B.one instance on one server not associated with any database
• C.one instance on one server associated with two or more databases on the same server
• D.two or more instances on separate servers all associated with one database
• E.one instance on one server associated with one database

Comment: *

Name: *

Email: *

Verification: *

The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions?
(Choose two.)

• A.invoice_date = '15-march-2019' : uses implicit conversion
• B.CONCAT (qty_sold, invoice_date) : requires explicit conversion
• C.invoie_date > '01-02-2019' : uses implicit conversion
• D.qty_sold = `0554982' uses implicit conversion
• E.qty_sold BETWEEN `101' AND '110' : uses implicit conversion

Comment: *

Name: *

Email: *

Verification: *

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

• A.It executes successfully and gives the required result
• B.It gives an error because the GROUP BY clause is not valid
• C.It executes successfully but does not give the required result
• D.It gives an error because the ALL keyword is not valid

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEES table:

Which query is valid?

• A.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
• B.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
• C.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
• D.SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

Comment: *

Name: *

Email: *

Verification: *