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

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

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 SYS in both the databases
• B.as SCOTT in BOSTON_DB
• C.as SCOTT in DALLAS_DB
• D.as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• E.as SCOTT in both the databases

Comment: *

Name: *

Email: *

Verification: *

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

• A.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• B.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• C.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• D.Employees 100 and 200 will have the same JOB_ID as before the update command
• E.Employees 100 and 200 will have the same SALARY as before the update command
• F.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

• A.SELECT * FROM customers WHERE city LIKE 'D_';
• B.SELECT * FROM customers WHERE city = '%D_';
• C.SELECT * FROM customers WHERE city = 'D_%';
• D.SELECT * FROM customers WHERE city LIKE 'D_%';

Comment: *

Name: *

Email: *

Verification: *

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

• A.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
• B.Add the AUTOEXTEND ON clause with NEXT set to 100M.
• C.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• D.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
• E.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

Comment: *

Name: *

Email: *

Verification: *