Free Oracle 1Z0-082 Exam Dumps Questions & Answers

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?

• A.The value is changed for the current instance and in the PFILE
• B.It fails because the SCOPE clause is missing
• C.Change is applied to the current instance, but does not persist after instance restart
• D.The value is changed only in the PFILE and takes effect at the next instance startup

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

• A.The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
• B.The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
• C.External table files can be used for other external tables in a different database
• D.The ORACLE_LOADER access driver can be used to unload data from a database into an external table
• E.They cannot be partitioned
• F.They support UPDATEs but not INSERTs and DELETEs

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
Which compression option is best suited for this?

• A.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• B.ROW STORE COMPRESS ADVANCED
• C.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• D.COLUMN STORE COMPRESS FOR QUERY LOW
• E.ROW STORE COMPRESS BASIC

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?

• A.It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".
• B.It succeeds and the generated undo is stored in SYSAUX.
• C.It succeeds and the generated undo is stored in SYSTEM.
• D.It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
• E.It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

• A.It generates a sql script that it uses to load data from EMP.DAT to EMP
• B.It uses the database buffer cache to load data
• C.It appends data from EMP.DAT to EMP
• D.It overwrites data in EMP with data in EMP.DAT
• E.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations