Online 1z0-082 Practice TestMore Oracle Products >

Free Oracle 1z0-082 Exam Dumps Questions

Oracle 1z0-082: Oracle Database Administration I

- Get instant access to 1z0-082 practice exam questions

- Get ready to pass the Oracle Database Administration I exam right now using our Oracle 1z0-082 exam package, which includes Oracle 1z0-082 practice test plus an Oracle 1z0-082 Exam Simulator.

- The best online 1z0-082 exam study material and preparation tool is here.

4.5

(495 ratings)

Question 1

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:
1Z0-082 dumps exhibit
Exhibit 1.

Exhibit 2.

What will be the result?

A. It gives an error because the ALL keyword is not valid

B. It gives an error because the GROUP BY clause is not valid

C. It executes successfully but does not give the required result

D. It executes successfully and gives the required result

Correct Answer:D

Question 2

In which three situations does a new transaction always start? (Choose three.)

A. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

B. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

C. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

D. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

E. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfullyin the same session

F. when issuing a DML statement after a DML statement failed in the same session

Correct Answer:ADF

Question 3

Which two are true about shrinking a segment online? (Choose two.)

A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)

B. It always eliminates all migrated rows if any exist in the table

C. To shrink a table it must have a PRIMARY KEY constraint

D. To shrink a table it must have a UNIQUE KEY constraint

E. To shrink a table it must have row movement enabled

F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Correct Answer:CE

Question 4

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

A. The online redo logs are opened

B. The online data files are opened

C. The alert log records the execution details

D. The Oracle background processes are started

E. The initialization parameter file is read

F. The control file is read

Correct Answer:DF

Question 5

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

A. Column names in each SELECT in the compound query can be different

B. The number of columns in each SELECT in the compound query can be different

C. Reversing the order of the intersected tables can sometimes affect the output

D. INTERSECT returns rows common to both sides of the compound query

E. INTERSECT ignores NULLs

Correct Answer:AE

Question 6

You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

A. SELECT TO_CHAR(SYSDATE, ‘DD-MON-YYYY’) – ’01-JAN-2019’ FROM DUAL;

B. SELECT ROUND(SYSDATE – ’01-JAN-2019’) FROM DUAL;

C. SELECT ROUND(SYSDATE – TO_DATE(‘01/JANUARY/2019’)) FROM DUAL;

D. SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ‘01/JANUARY/2019’ FROM DUAL;

E. SELECT SYSDATE – TO_DATE(’01-JANUARY-2019’) FROM DUAL;

Correct Answer:AB

START 1z0-082 EXAM