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

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

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

• A.You can no longer monitor it
• B.You can reattach to it and monitor it
• C.It is paused and can be resumed
• D.It continues to run in the background
• E.It terminates

Comment: *

Name: *

Email: *

Verification: *

Which two can you use to recover a dropped table? (Choose two.)

• A.FLASHBACK DROP
• B.FLASHBACK QUERY
• C.FLASHBACK DATABASE
• D.FLASHBACK TRANSACTION
• E.FLASHBACK TABLE TO SCN

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

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.Revoke the CREATE SESSION privilege from user HR
• B.Log in to the database instance
• C.Execute DML statements in the HR schema
• D.Revoke the CREATE SESSION privilege from other users
• E.Execute DDL statements in the HR schema
• F.Grant the CREATE SESSION privilege with ADMIN OPTION to other users

Comment: *

Name: *

Email: *

Verification: *