What is a pre-requisite to alter a role?

What should you do to ensure that a job stores minimal job metadata and runtime data on disk,and uses only existing PL/SQL programs?

SHOW PARAMETER INMEMORY_SIZE

NAME TYPE VALUE

Inmemory_size big integer 1G

Now examine this command ：

ALTER TABLE hr.emp INMEMORY ;

Table altered .

Which is true about effects of this command and any subsequent processing on hr.emp?

Which naming method enables clients to connect to a database instance without any client side configuration in sqlnet.ora or tnsnames.ora?

Examine these commands：

SQL>SELECT open_mode FROM v$database ;

OPEN_MODE

READ WRITE

SQL>ARCHIVE LOG LIST ;

Database log modeNo Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Now examine these steps：

-1.STARTUP NOMOUNT 

-2.STARTUP MOUNT

-3.STARTUP FORCE

-4.ALTER DATABASE ARCHIVELOG; 

-5.SHUTDOWN TRANSACTIONAL 

-6.ALTER DATABASE OPEN;

-7.SHUTDOWN ABORT

-8.ALTER DATABASE MOUNT

Identify the required steps in the correct order to change the database to run in ARCHIVELOG mode.

In one of your databases, unified auditing is enabled and an SH.SALES table exists.

You successfully execute these commands：

SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales;

SQL>AUDIT POLICY sales_pol;

Which statement is true about SALES_POL?

All of your live databases run in ARCHIVELOG mode.

On the SALES database there is no LEVEL 0 backup.

Examine these commands issued against the SALES database target：

RMAN> BACKUP AS BACKUPSET DATABASE ;

Backup set complete, elapsed time： 00：00：03

RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE ;

What is true about the execution of these commands?

Examine this command：

SQL>STARTUP FORCE

ORACLE instance started .

Total System Global Area 5117049968 bytes

Fixed size 9038960 bytes

Variable size 922746880 bytes

Database Buffers 4177526784 bytes

Redo Buffers 7737344 bytes

Database mounted

Database opened .

Now examine these steps：

-1.Oracle instance is started.

-2.The control file is read.

-3.Instance recovery is started.

-4.Datafiles and redo log files are opened.

-5.The spfile or pfile is read.

-6.The database is available for use .

-7.The database is mounted .

-8.Instance recovery is completed.

Identify the steps that were executed in the correct order to open the database：

In your database instance, the UNDO RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.

Which st atement is true about undo retention?

All of your database instances use SPFILES.

You executed this command in one of them： ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M; Which statement is true?

Examine this backup strategy for the ORCL database：

1) A LEVEL 0 backup is taken every two weeks.

2) A CUMULATIVE LEVEL 1 backup is taken weekly.

3) A DIFFERENTIAL LEVEL 1 backup is taken daily.

Which blocks are backed up in the CUMULATIVE LEVEL 1 backup?

Your database is in ARCHIVELOG mode.

You want to disable archiving for the database.

Examine these steps:

-1.Execute the ALTER DATABASE NOARCHIVELOG command.

-2.Execute SHUTDOWN IMMEDIATE.

-3.Execute STARTUP MOUNT.

-4.Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/.

-5.Execute STARTUP NOMOUNT.

-6.Open the database.

Execute SHUTDOWN TRANSACTIONAL

Identify the required steps in the correct sequence

A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following: