1z0-082 Oracle Database Administration I Questions and Answers

A RAC database can have one Instance.

A RAC database can have instances on separate servers.

Two RAC databases can share their instances.

A RAC database must have three or more Instances.

A RAC database must have two or more instances.

INTERVAL year TO month columns support yearly intervals.

The value in an interval day to SECOND column can be copied into an interval year to month column.

INTERVAL day to second columns support fractions of seconds.

INTERVAL year to month columns only support monthly Intervals within a single year.

INTERVAL year to month columns only support monthly intervals within a range of years.

The year field in an interval year to month column must be a positive value.

The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set

The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

It supports diagnostics for Automatic Storage Management (ASM)

It supports diagnostics for Oracle Clusterware

It is held inside an Oracle database schema

SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

SELECT DISTINCT promo_cost || ’ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;

SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;

SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

as SCOTT in DALLAS_DB

as SCOTT in BOSTON_DB

as SCOTT in BOSTON_DB and SYS in DALLAS_DB

as SYS in both the databases

as SCOTT in both the databases

If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

The number, but not names, of columns must be identical for all SELECT statements in the query.

The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

The names and number of columns must be identical for all SELECT statements in the query.

The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

A synonym cannot be created for a PL/SQL package

A synonym can be available to all users

A SEQUENCE can have a synonym

A synonym created by one user can refer to an object belonging to another user

Any user can drop a PUBLIC synonym

WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'

WHERE order_date > TO_DATE

WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))

WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')

Add the SEGMENT SPACE MANAGEMENT AUTO clause

Set UNDO_TABLESPACE to UNDOTBS01

Add the NOLOGGING clause

Make certain that the database operates in automatic undo management mode

Add the ONLINE clause

SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table.

SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table.

SALES1 is created with 55,000 rows.

SALES1 is created with no rows.

SALES1 is created with 1 row.

Table aliases can improve performance

The BETWEEN condition always performs better than using the >= and <= conditions

The join syntax used makes no difference to performance

The BETWEEN condition always performs less well than using the >= and <= conditions

The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

The concatenation operator | | is always evaluated before addition and subtraction in an expression

NULLS influence the precedence of operators in an expression

The + binary operator has the highest precedence in an expression in a SQL statement

Arithmetic operators with equal precedence are evaluated from left to right within an expression

Multiple parentheses can be used to override the default precedence of operators in an expression

WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25

WHERE ADD_MONTHS

WHERE TO_XUMBER(start_date - SYSDATE) <= 25

WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25

The value is changed only in the PFILE and takes effect at the next instance startup

The value is changed for the current instance and in the PFILE

It fails because the SCOPE clause is missing

Change is applied to the current instance, but does not persist after instance restart

Aggregate functions can be nested to any number of levels

The AVG function implicitly converts NULLS to zero

Aggregate functions can be used in any clause of a SELECT statement

The MAX and MIN functions can be used on columns with character data types

UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.

UNDO_RETENTION specifies how long all types of UNDO are retained.

Unexpired UNDO is always retained.

Active UNDO is always retained.

UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;

SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;

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

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