Name        null       type

CITYID      NOT NULL   NUMBER(4)

CITY_NAME              VARCHAR2(50)

Examine the command:

SQL>ALTER TABLE cities SHRINK SPACE COMPACT;

What must you do before executing it?

Data should be compressed when using direct-path INSERT the table will also be used for occasional Dss queries.

Load performance is critical

Which compression option satisfies these requirements?

SELECT open_mode from v4database;

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

READ WRITE

ARCHIVE LOG LIST;

Database log mode                  No archive Mode

Automatic archive                  Dsiabled

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)ALTER DATABASE MOUNT;

6)ALTER DATABASE OPWEN RESETLOGS

7)SHUTDOWN IMMEDIATE

8)ALTER DATABASE OPEN;

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

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?

The data file for the USERS tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace? 

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?

You execute the command：

SQL> CREATE AUDTT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TAETE ROLES hr_admin, oe_admin; Which statement is true?

You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command. 

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

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

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; What would be the effect on current sessions?

Examine the RMAN configuration  parameters：

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?