1z0-082 Oracle Exam Questions and Free Practice Test

Question 7

Which two tasks can you perform using DBCA for databases? (Choose two.)

A. Configure a nonstandard block size for a new database

B. Register a new database with an available Enterprise Manager Management server

C. Change the standard block size of an existing database

D. Configure incremental backups for a new database

E. Enable flashback database for an existing database

Correct Answer:BC

Question 8

Which two statements are true about UNDO and REDO? (Choose two.)

A. The generation of UNDO generates REDO

B. DML modifies Oracle database objects and only generates UNDO

C. The generation of REDO generates UNDO

D. DML modifies Oracle database objects and only generates REDO

Correct Answer:AC

Question 9

Which three statements are true about inner and outer joins? (Choose three.)

A. A full outer join returns matched and unmatched rows

B. An inner join returns matched rows

C. Outer joins can only be used between two tables per query

D. A full outer join must use Oracle syntax

E. Outer joins can be used when there are multiple join conditions on two tables

F. A left or right outer join returns only unmatched rows

Correct Answer:ABF

Question 10

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

A. The Oracle join syntax supports creation of a Cartesian product of two tables

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

C. The SQL:1999 compliant ANSI join syntax supports natural joins

D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

E. The Oracle join syntax only supports right outer joins

F. The Oracle join syntax supports natural joins

G. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

Correct Answer:CDF

Question 11

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

B. SYSDATE can be queried only from the DUAL table

C. CURRENT_DATE returns the current date and time as per the session time zone

D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR

E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Correct Answer:BC

Question 12

You execute this command:
1Z0-082 dumps exhibit
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

A. AUTOEXTEND is possible for the datafile

B. It must be bigger than the largest SMALLFILE tablespace

C. Additional data files may not be added

D. It will be a dictionary-managed tablespace by default

E. It will always have a 32K blocksize

Correct Answer:AB

START 1z0-082 EXAM