Online Access Free 1Z1-082 Practice Test

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

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

You currently have an active transaction in your session and have been granted select access to vstransaction.

In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

• A.after successfully executing a commit or rollback followed by a select statement
• B.after successfully executing a create table as select statement followed by a select for update statement
• C.after successfully executing a commit or rollback followed by a DML statement
• D.after successfully executing a DML statement following a failed DML statement
• E.after successfully executing a truncate statement followed by a DML statement
• F.after successfully executing a create table statement followed by a create index statement

Which two statements are true about trace files produced by the Oracle Database server?
(Choose two.)

• A.They can be written by server processes
• B.Trace files are written to the Fast Recovery Area (FRA)
• C.Trace file names are based on the database name concatenated with a sequential number
• D.They can be written by background processes
• E.All trace files contain error information that require contacting Oracle Support

In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR.
h two statements are true about expressions using PROMO_BEGIN_DATE contained In a query?

• A.to_numberipromo_begin_date) - s will return a number.
• B.PROMO_ BEGIN_DATE - 5 will return a date.
• C.PROMO_ BEGIN_DATE - sysdate will return a number.
• D.TO_date(PROMO_ BEGIN_DATE * 5| will return a date.
• E.PROMO_ BEGIN_DATE - sysdate will return an error.

Which three failures do not require intervention for recovery? (Choose three.)

• A.transaction failure
• B.statement failure
• C.user process failure
• D.media failure
• E.network interface card (NIC) failure