Oracle 1Z0-082 Quiz 1 Topic 4 Questions 1-5

Question: 1

Which three statements are true about a self-join? (Choose three.)

AThe ON clause must be used

BThe query must use two different aliases for the table

CIt must be an equi join

DIt must be an inner join

EThe ON clause can be used

FIt can be an outer join

Show Answer

Question: 2

You want to use table compression suitable for OLTP that will:

* Compress rows for all DML statements on that table

* Minimize the overheads associated with compression

Which compression option is best suited for this?

ACOLUMN STORE COMPRESS FOR QUERY LOW

BROW STORE COMPRESS BASIC

CCOLUMN STORE COMPRESS FOR ARCHIVE LOW

DCOLUMN STORE COMPRESS FOR ARCHIVE HIGH

EROW STORE COMPRESS ADVANCED

Show Answer

Question: 3

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.

You want to display the date of the first Monday after the completion of six months since hiring.

The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee.

Which query can be used?

ASELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;

BSELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;

CSELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

DSELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

Show Answer

Question: 4

You execute this command:

CREATE SMALLFILE TABLESPACE sales

DATAFILE '/u01/app/oracle/sales01.dbf

SIZE 5G

SEGMENT SPACE MANAGEMENT AUTO;

Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

AIt must be smaller than the smallest BIGFILE tablespace

BFree space is managed using freelists

CAny data files added to the tablespace must have a size of 5 gigabytes

DIt uses the database default blocksize

EIt is a locally managed tablespace

Show Answer

Question: 5

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE

User U1 has a 1 MB quota in tablespace DATA.

U1 executes this command:

SQL> CREATE TABLE t1 AS

(SELECT object_name, sharing, created

FROM dba_objects);

U1 complains that the command is taking too long to execute.

In the alert log, the database administrator (DBA) finds this:

03/06/2017 11:45:17

statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA'

Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

AAdd a data file to DATA

BDrop other U1 objects in DATA

CIncrease U1's quota sufficiently in DATA

DSet DEFERRED_SEGMENT_CREATION to TRUE

EGrant UNLIMITED TABLESPACE to U1

FSet AUTOEXTEND ON for data files in DATA

Show Answer

Oracle 1Z0-082 Quiz:1 Topic:4 Questions:1-5