View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

• A.Display the total number of products supplied by supplier 102 which have a product status of obsolete
• B.Display the minimum PROD_LIST_PRICE for each product status
• C.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
• D.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• E.Display suppliers whose PROD_LIST_PRICE is less than 1000

Comment: *

Name: *

Email: *

Verification: *

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

• A.Dynamic service registration cannot be used for this database instance
• B.The LREG process registers services dynamically with the LISTENER_1 listener
• C.LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
• D.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• E.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Comment: *

Name: *

Email: *

Verification: *

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 SYSDATE ?TO_DATE('01-JANUARY-2019') FROM DUAL;
• B.SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;
• C.SELECT ROUND(SYSDATE ?'01-JAN-2019') FROM DUAL;
• D.SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;
• E.SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY') ?'01-JAN-2019' FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A.Unset REMOTE_LOGIN_PASSWORDFILE
• B.Alter user KING to be IDENTIFIED EXTERNALLY
• C.Grant DBA to KING
• D.Set OS_AUTHENT_PREFIX to OPS$
• E.Have the OS administrator add KING to the OSDBA group

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the DUAL table? (Choose two.)

• A.It can display multiple rows but only a single column
• B.It consists of a single row and single column of VARCHAR2 data type
• C.It can display multiple rows and columns
• D.It can be used to display only constants or pseudo columns
• E.It can be accessed by any user who has the SELECT privilege in any schema
• F.It can be accessed only by the SYS user

Comment: *

Name: *

Email: *

Verification: *