Free Access Oracle.1Z0-082.v2023-08-24.q111 Practice Test (Page 12)

Question 51

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_date(PROMO_ BEGIN_DATE * 5| will return a date.

B.PROMO_ BEGIN_DATE - sysdate will return a number.

C.to_numberipromo_begin_date) - s will return a number.

D.PROMO_ BEGIN_DATE - sysdate will return an error.

E.PROMO_ BEGIN_DATE - 5 will return a date.

Question 52

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.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

Question 53

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A.It supports diagnostics for Automatic Storage Management (ASM)

B.The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

C.It supports diagnostics for Oracle Clusterware

D.The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set

E.It is held inside an Oracle database schema

Question 54

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.Add the ONLINE clause

B.Add the SEGMENT SPACE MANAGEMENT AUTO clause

C.Add the NOLOGGING clause

D.Set UNDO_TABLESPACE to UNDOTBS01

E.Make certain that the database operates in automatic undo management mode

Question 55

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A.The ADR base defaults to $ORACLE_HOME/rdbms/admin if
neither DIAGNOSTIC_DEST nor ORACLE_BASE is set