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 three are types of segments in an Oracle Database? (Choose three.)

• A.undo
• B.index
• C.stored procedures
• D.sequences
• E.tables
• F.clusters

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the employees table:

Which query requires explicit data type conversion?

• A.SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;
• B.SELECT join_date I I ' ' II salary FROM employees;
• C.SELECT join_date FROM employees WHERE join_date > '10-02-2018';
• D.SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;

Comment: *

Name: *

Email: *

Verification: *

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100

• A.'DUES AMOUNT' FROM transactions;
• B.transactions;
  SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100
• C.100 "DUES AMOUNT" FROM transactions;
  SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM
• D.DUES FROM transactions;
  SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount +
• E."DUES" FROM transactions;
  SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100

Comment: *

Name: *

Email: *

Verification: *

Examine this command:

Which two statements are true? (Choose two.)

• A.If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
• B.The file is renamed and stored in the same location
• C.The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• D.The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• E.DML may be performed on tables with one or more extents in this data file during the execution of this command.

Comment: *

Name: *

Email: *

Verification: *