Examine the following parameters:

NAME                           TYPE          VALUE

--------------------    ---------------- --------------

log_archive_dest              string

log_archive_dest_1            string

log_recovery_file_dest        string    /u01/app/oracle/fast_recovery_area

You execute the following command after performing a STARTUP MOUNT:

SQL >ALTER DATABASE ARCHIVELOG;

Which statement is true about the execution of the command?

SQL> GRANT SELECT ON bonuses To tom WITH GRANT OPTION;

TOM then executes this command to grant privileges to the user JIM:

SQL> GRANT SELECT ON hr.bonuses TO jim;

Which statement is true?

NAME                 TYPE   VALUE

db_create_file_dest  string  /u01/ app/oracle/oradata/prod/

undo_management      string  AUTO

undo_retention      integer  900

undo_tablespace     string   UNDOTBS1

You execute this: 

CREATE UNDO TABLESPACE UNDOTBS2 SEGMENT SPACE MANAGEMENT AUTO;Which is true?

CONNECT / AS SYSDBA

CREATE DIRecTORY dumpdir AS '/u01/app/ ';

Directory created.

GRANT rEad, WRITE ON DIRECTORY dumpdir To PUBLIC;

Grant succeeded .

CREATE usER TEST IDENTIFIED BY test ;

User created .

GRANT CREATE SESSION, RESOURCE, UNLIMITED TABLESPACE To test;

Grant succeeded.

CONN test/test

connected .

CREATE TABLE test_employees (id NUMBER(3) , name VARCHAR2 (20), salary NUMBER(7));

Table created .

SQL> CREATE SYNONYM emp FoR test_employees ;

synonym created .

Now examine this command:

$expdp test/test  DIRECTORY=dumpdir DUNPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp CONTENT=data_only query='EMP:"WHERE salary=12000"'

 Which is true?

Backup scheduling for this database must be automated before upgrading to a new version of the database. 

Which two tools or utilities can do this?

Daily full database backups are taken with RMAN which is configured to perform control file autobackup.

The control file and redo log files are multi-plexed

In which two cases is media recovery required?

1.A Fast Recovery Area(FRA)has been specified for a database.

2.The database instance is in ARCHIVELOG mode

3.The default location for archived redo log files is the FRA.

Which two types of files are removed automatically due to space pressure in the FRA?

1.UNDO_RETENTION parameter is 1000

2.retention is not guaranteed

3.the undo tablespace is fixed size.

Which two statements are true?

SQL>CREATE TABLESPACE test1 DATAFILE ‘/u01/app/oracle/oradata/orcl/test1.dbf’ SIZE 5M AUTOEXTEND ON AUTOALLOCATE;

Which two statements are true?

Examine these commands:

CONFIGURE RETENTION POLICY TO REDUNDANCY 2; 

RMAN> BACKUP TABLESPACE SYSTEM; 

..

backup set complete, elapsed time: 00:00:03

..

RMAN> BACKUP TABLESPACE SYSTEM, SYSAUX;

..

backup set complete, elapsed time:00:00:04

RNAN> BACKUP DATABASE

..

backup set complete,elapsed time: 00:00:07

..

Which two are true about the execution of the third backup command?

SQL>ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true?