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

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 four actions can HR perform? (Choose four.)

• A.Revoke the CREATE SESSION privilege from other users
• B.Revoke the CREATE SESSION privilege from user HR
• C.Log in to the database instance
• D.Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• E.Execute DDL statements in the HR schema
• F.Execute DML statements in the HR schema

Comment: *

Name: *

Email: *

Verification: *

Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE 'undotbs_01.dbf'
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A.Set UNDO_TABLESPACE to UNDOTBS01
• B.Add the NOLOGGING clause
• C.Make certain that the database operates in automatic undo management mode
• D.Add the SEGMENT SPACE MANAGEMENT AUTO clause
• E.Add the ONLINE clause

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

• A.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
• B.SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• C.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• D.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• E.SYSDATE can be queried only from the DUAL table
• F.CURRENT_DATE returns the current date and time as per the session time zone

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.Employees 100 and 200 will have the same SALARY as before the update command
• 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.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• F.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Comment: *

Name: *

Email: *

Verification: *