Free Oracle 1Z0-082 Exam Dumps Questions & Answers

Examine the description of the employees table:

Which query requires explicit data type conversion?

• A.SELECT join_date FROM employees WHERE join_date > '10-02-2018';
• B.SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;
• C.SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;
• D.SELECT join_date I I ' ' II salary FROM employees;

Which two statements are true regarding a SAVEPOINT? (Choose two.)

• A.Rolling back to a SAVEPOINT can undo a DELETE statement
• B.Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
• C.A SAVEPOINT does not issue a COMMIT
• D.Rolling back to a SAVEPOINT can undo a TRUNCATE statement
• E.Only one SAVEPOINT may be issued in a transaction

Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

• A.Directory Naming can be used if Connect-Time Failover is required.
• B.Local Naming requires setting the TNS_ADMIN environment variable on the client side.
• C.A client can connect to an Oracle database instance even If no client side network admin has been configured.
• D.Directory Naming requires setting the TNS_ADMIN environment variable on the client side.
• E.Local naming can be used if Connect-Time Failover Is required.
• F.Easy Connect supports TCP/IP and SSL.

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

• A.T1 only
• B.T1, an index segment for the primary key, a LOB segment, and a lobindex segment
• C.T1, an index segment for the primary key, and a LOB segment only
• D.no segments are created
• E.T1 and an index segment created for the primary key only

Which two statements are true about undo and undo tablespaces?

• A.undo segments are owned by SYSBACKUP.
• B.An instance will crash if the active undo tablespace is lost.
• C.There can be only one undo tablespace created in a database.
• D.An undo tablespace may be owned by only one instance.
• E.undo segments are owned by SYSTEM.