[Q51-Q74] Real Exam Questions 1Z0-082 Dumps Exam Questions in here [Mar-2023]

QUESTION 51
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.)

QUESTION 52
A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

QUESTION 53
Which two can you use to recover a dropped table? (Choose two.)

QUESTION 54
Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

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

QUESTION 56
Which two statements are true about the rules of precedence for operators? (Choose two.)

QUESTION 57
A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

QUESTION 58
View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

QUESTION 59
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

QUESTION 60
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:

Exhibit 1.

Exhibit 2.

What will be the result?

QUESTION 61
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?

QUESTION 62
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

QUESTION 63
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.)

QUESTION 64
Which three statements are true about Oracle synonyms? (Choose three.)

QUESTION 65
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions?
(Choose two.)

QUESTION 66
You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

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

QUESTION 68
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

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

QUESTION 70
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON’), `dd “Monday for”
fmMonth rrrr’)
What is the result?

QUESTION 71
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?

QUESTION 72
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

QUESTION 73
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

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