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 returns matched and unmatched rows
• D.A full outer join must use Oracle syntax
• E.A left or right outer join returns only unmatched rows
• F.Outer joins can only be used between two tables per query

Comment: *

Name: *

Email: *

Verification: *

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

• A.as SCOTT in DALLAS_DB
• B.as SCOTT in BOSTON_DB
• C.as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• D.as SYS in both the databases
• E.as SCOTT in both the databases

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

• A.A table that is truncated will always have its segment removed
• B.An index that is altered to be UNUSABLE will retain its segment
• C.Private Temporary Tables (PTTS) store metadata in memory only
• D.An index created with the UNUSABLE attribute has no segment
• E.If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

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

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.Set OS_AUTHENT_PREFIX to OPS$
• B.Have the OS administrator add KING to the OSDBA group
• C.Grant DBA to KING
• D.Unset REMOTE_LOGIN_PASSWORDFILE
• E.Alter user KING to be IDENTIFIED EXTERNALLY

Comment: *

Name: *

Email: *

Verification: *