Management  (ASM). How would you achieve this?

NAME    TYPE         VALUE 

temp_undo_enabled    boolean        TRUE 

undo_management    string        AUTO 

undo_retention        integer        900

 undo_tablespace    string        UNDOTBS1

Your database has three undo tablespaces and the default undo tablespace  is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transaction?

A data file in the USERS tablespace is damaged. Which command must you execute before starting the recovery of this tablespace? 

ALTER SYSTEM SET LOG_BUFFER=32M; What is the outcome of this command? 

SGL> CREATE TABLESPACE tbs1 DATAFILE ‘/u02/oracle/data/tbs01.dbf’ SIZE 50M; The u02 file system has 1 GB of

free space available. 

What is the outcome?

The EMPLOYEE.DEPARTMENT_ID  column has a foreign key constraint with the ON DELETE CASCADE  option that

refers to the DEPARTMENTS.DEPARTMENT_ID column.

An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction delete a primary key in the DEPARTMENTS table,

which has child rows in the EMPLOYEES table.     Which statement is true?

SQL> CREATE  AUDTT POLICY  table_aud  PRIVILEGES  CREATE  ANY TABLE, DROP  ANY TAETE  ROLES  hr_admin, oe_admin;

Which statement is true?

CREATE TABLE daily_ords_lst(ordno NUMBER, ord_date  DATE)  PCTFREE 20; 

 How does the PCTFREE storae parameter influence data storage for this table?

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default 

CONFIGURE BACKUP OPTIMIZATION OFF; # default 

CONFIGURE CONTROLFILE AUTOBACKUP  OFF; # default

CONFIGURE  DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET ; 

CONFIGURE  ARCHIVELOG  BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default 

Examine the command：

RMAN> BACKUP DATABASE  PLUS ARCHIVELOG  DELETE INPUT; What is the outcome?

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

UNIFORM; 

which statement  is true?

1. Execute the ALTER DATABASE ARCHIVELOG command

2. Execute SHUTDOWN IMMEDIATE

3. Execute STARTUP MOUNT

4. Set the DA_RECOUVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/

5. Execute STARTUP NOMOUNT 

6. Open the database

Identify the require steps in the correct sequence. 

Name    Null?    Type

CITYID    NOT NULL    NUMBER(4)

CITYNAME                     VARCHAR2(50)

Examine the command：

SQL>ALTER TABLE cities SHRINK SPACE COMPACT;  

What must you do nefore executing it? 

The table will also be used for queries. Which compression option should be used?