Question 1

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200. Examine this statement:
Which two statements are true? (Choose two.)

Accepted Answer

Correct answer: AB

Question 2

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

Accepted Answer

Correct answer: AE

Question 3

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

Accepted Answer

Correct answer: BDE

Question 4

Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE ‘undotbs_01.dbf’ SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

Accepted Answer

Correct answer: BD

Question 5

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

Accepted Answer

Correct answer: BCF

Question 6

From SurePassExam
https://www.surepassexam.com/1z0-082-exam-dumps.html (142 New Questions)
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonth rrrr’) What is the result?

Accepted Answer

Correct answer: B

Question 7

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
\1. A size of 100 MB
\2. AUTOEXTEND is off
\3. UNDO_RETENTION is set to 15 minutes
\4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens. What will happen when the next update is attempted by any transaction?

Accepted Answer

Correct answer: C

Question 8

You have been tasked to create a table for a banking application. One of the columns must meet three requirements:
 Be stored in a format supporting date arithmetic without using conversion functions
 Store a loan period of up to 10 years
 Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

Accepted Answer

Correct answer: B

Question 9

In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

Accepted Answer

Correct answer: BD

Question 10

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?
(Choose two.)

Accepted Answer

Correct answer: CE