Online Access Free 1z1-072 Exam Questions

As the DBA, you execute this command:
GRANT SELECT ON hr.emp TO brown WITH GRANT OPTION;
BROWN then executes this command:
GRANT SELECT ON hr.emp TO scott WITH GRANT OPTION;
Which is true?

• A.When you revoke the SELECT privilege from BROWN, it is automatically revoked from SCOTT.
• B.When you revoke the SELECT privilege from BROWN, only the WITH GRANT OPTION is revoked from SCOTT.
• C.You can revoke only WITH GRANT OPTION from BROWN.
• D.When you revoke the SELECT privilege from BROWN, nothing is revoked from SCOTT.
• E.BROWN can revoke only WITH GRANT OPTION from SCOTT.

Which two are true about the roles? (Choose two.)

• A.The SET ROLE statement enables as well as disables roles in a session.
• B.A role must be disabled before it can be revoked from a user.
• C.All privileges and roles granted to a user are enabled by default when the user logs in.
• D.The ALTER USER statement must be used to set specific default roles for a user.
• E.The SET ROLE statement can be used once per session.

Which two are true about conventional path SQL load? (Choose two.)

• A.It cannot load data into clustered tables.
• B.It enforces referential integrity constraints.
• C.It always generates redo.
• D.It locks objects being processed.
• E.It does not generate UNDO.

Which three object types support deferred segment creation? (Choose three.)

• A.clustered tables
• B.temporary tables
• C.index organized tables
• D.heap organized tables
• E.external tables
• F.partitioned tables

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