Pass Oracle 1Z0-082 Actual Free Exam Q&As Updated Dump Dec 31, 2022 [Q63-Q85]

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

NEW QUESTION 64
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.)

NEW QUESTION 65
Examine this command:

Which two statements are true? (Choose two.)

NEW QUESTION 66
Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

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

NEW QUESTION 68
Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

NEW QUESTION 69
Which three statements are true about table data storage in an Oracle Database? (Choose three.)

NEW QUESTION 70
Which two are true about RETENTION GUARANTEE? (Choose two.)

NEW QUESTION 71
Which two statements are true about views used for viewing tablespace and datafile information?
(Choose two.)

NEW QUESTION 72
Which two statements are true about Enterprise Manager Database Express? (Choose two.)

NEW QUESTION 73
Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

NEW QUESTION 74
Examine this SQL statement:
SELECT cust_id, cust_last_name “Last Name”
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

NEW QUESTION 75
You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

NEW QUESTION 76
Which compression method is recommended for Direct-Path Insert operations?

NEW QUESTION 77
Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

NEW QUESTION 78
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

NEW QUESTION 79
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

NEW QUESTION 80
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

NEW QUESTION 81
Which three statements are true regarding indexes? (Choose three.)

NEW QUESTION 82
Which three statements are true about table data storage in an Oracle Database? (Choose three.)

NEW QUESTION 83
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?

NEW QUESTION 84
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

NEW QUESTION 85
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.)