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

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

• A.SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
• B.SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
• C.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
• D.SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
• E.SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

• A.Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
• B.Base tables can be queried directly
• C.It is owned by the SYSTEM user
• D.Usernames of all users including database administrators are stored in the data dictionary
• E.Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
• F.The data dictionary is created and maintained by the database administrator

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

• A.Column names in each SELECT in the compound query can be different
• B.The number of columns in each SELECT in the compound query can be different
• C.Reversing the order of the intersected tables can sometimes affect the output
• D.INTERSECT returns rows common to both sides of the compound query
• E.INTERSECT ignores NULLs

Comment: *

Name: *

Email: *

Verification: *