Free Access Oracle.1Z0-082.v2022-07-18.q111 Practice Test (Page 5)

Question 16

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

A.The HAVING clause can be used with aggregating functions in subqueries

B.The WHERE clause can be used to exclude rows after dividing them into groups

C.Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query

D.The WHERE clause can be used to exclude rows before dividing them into groups

E.WHERE and HAVING clauses can be used in the same statement only if applied to different table columns

Question 17

Which is true about security rules on a compute node?

A.A new database deployment on a compute node automatically enables a set of predefined security rules.

B.The port used for HTTPS connections is enabled by default based on a predefined security rule.

C.A security rule can restrict IP addresses that can connect to a database instance on a compute node.

D.A compute node port can be enabled only if it is associated with an existing security rule.

E.New security rules can be defined to use only the TCP protocol but multiple port numbers.

Question 18

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

A.Grant the CREATE SESSION privilege with ADMIN OPTION to other users

B.Execute DML statements in the HR schema

C.Revoke the CREATE SESSION privilege from user HR

D.Execute DDL statements in the HR schema

E.Revoke the CREATE SESSION privilege from other users

F.Log in to the database instance

Question 19

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: