1z0-082 Practice Test

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?

 

A.

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

B.

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

C.

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

D.

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

Examine the description of the EMPLOYEES table:

Which query is valid?

A.

SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

B.

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

C.

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id,
join_date;

D.

SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due
amount as 5% of their credit limit. Customers whose due amount is null should not be
displayed.
Which query should be used?

A.

A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM
customersWHERE cust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;

B.

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM
customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;

C.

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM
customersWHERE cust_income_level <> NULLAND due_amount <> NULL;

D.

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM
customersWHERE cust_income_level != NULLAND due_amount !=NULL;

E.

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM
customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

Which three statements are true regarding indexes? (Choose three.)

A.

A UNIQUE index can be altered to be non-unique

B.

A SELECT statement can access one or more indices without accessing any tables

C.

A table belonging to one user can have an index that belongs to a different user

D.

An update to a table can result in updates to any or all of the table’s indexes

E.

When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

F.

An update to a table can result in no updates to any of the table’s indexes

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?

A.

COLUMN STORE COMPRESS FOR QUERY LOW

B.

ROW STORE COMPRESS BASIC

C.

COLUMN STORE COMPRESS FOR ARCHIVE LOW

D.

COLUMN STORE COMPRESS FOR ARCHIVE HIGH

E.

ROW STORE COMPRESS ADVANCED