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: *

Which two tasks can you perform using DBCA for databases? (Choose two.)

• A.Configure incremental backups for a new database
• B.Change the standard block size of an existing database
• C.Enable flashback database for an existing database
• D.Configure a nonstandard block size for a new database
• E.Register a new database with an available Enterprise Manager Management server

Comment: *

Name: *

Email: *

Verification: *

The customers table has a cust_last_name column of data type varchar2.
The table has two rows whose "jst_last_name values are Andersen and Ausson.
Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?

• A.SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;
• B.SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;
• C.SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;
• D.SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about views used for viewing tablespace and datafile information?
(Choose two.)

• A.Tablespace free space can be viewed in V$TABLESPACE
• B.V$TABLESPACE displays information about tablespaces contained in the data dictionary
• C.Tablespace free space can be viewed in DBA_TABLESPACES
• D.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
• E.V$TABLESPACE displays information that is contained in the controlfile about tablespaces

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

Comment: *

Name: *

Email: *

Verification: *