Which is true about security rules on a compute node?

• A.The port used for HTTPS connections is enabled by default based on a predefined security rule.
• B.A security rule can restrict IP addresses that can connect to a database instance on a compute node.
• C.A compute node port can be enabled only if it is associated with an existing security rule.
• D.New security rules can be defined to use only the TCP protocol but multiple port numbers.
• E.A new database deployment on a compute node automatically enables a set of predefined security rules.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about inner and outer joins? (Choose three.)

• A.A full outer join returns matched and unmatched rows
• B.An inner join returns matched rows
• C.Outer joins can only be used between two tables per query
• D.A full outer join must use Oracle syntax
• E.Outer joins can be used when there are multiple join conditions on two tables
• F.A left or right outer join returns only unmatched rows

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

• A.It overwrites data in EMP with data in EMP.DAT
• B.It generates a sql script that it uses to load data from EMP.DAT to EMP
• C.It appends data from EMP.DAT to EMP
• D.It uses the database buffer cache to load data
• E.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

Comment: *

Name: *

Email: *

Verification: *

Which two functions are performed by a listener?

• A.creating a user session in the System Global Area (SGA)
• B.verifying a user's authentication credentials
• C.connecting a user process to a server process
• D.maintaining the connection to a client's user process until the user request is completed
• E.verifying the service name in an incoming user request
• F.returning the results of processing from the server process to the user process

Comment: *

Name: *

Email: *

Verification: *

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week.
Which query can be used?

• A.SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
• B.SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;
• C.SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;
• D.SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

Comment: *

Name: *

Email: *

Verification: *