Free Access Oracle.1Z0-082.v2022-07-18.q111 Practice Test (Page 13)

Question 56

Examine these commands:

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

A.It uses the database buffer cache to load data

B.It overwrites data in EMP with data in EMP.DAT

C.It appends data from EMP.DAT to EMP

D.It generates a sql script that it uses to load data from EMP.DAT to EMP

E.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations

Question 57

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A.The names and number of columns must be identical for all SELECT statements in the query.

B.The number, but not names, of columns must be identical for all SELECT statements in the query.

C.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

D.The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

E.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Question 58

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

A.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

B.A DROP COLUMN command can be rolled back

C.A column that is set to UNUSED still counts towards the limit of 1000 columns per table

D.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.

E.An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.

F.Partition key columns cannot be dropped.

Question 59

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 only in the PFILE and takes effect at the next instance startup

B.The value is changed for the current instance and in the PFILE

C.It fails because the SCOPE clause is missing

D.Change is applied to the current instance, but does not persist after instance restart

Question 60

You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

A.It must be smaller than the smallest BIGFILE tablespace

B.Free space is managed using freelists

C.Any data files added to the tablespace must have a size of 5 gigabytes

D.It uses the database default blocksize

E.It is a locally managed tablespace

Other Version: 2581Oracle.1Z0-082.v2023-08-24.q111; 1630Oracle.1Z0-082.v2023-03-31.q49; 5326Oracle.1Z0-082.v2022-03-27.q110; 6225Oracle.1Z0-082.v2022-02-11.q110; 98Oracle.Prepawaytest.1Z0-082.v2021-09-10.by.ives.98q.pdf

Latest Upload: 119Microsoft.MS-700.v2025-12-27.q286; 110SAP.C-BCFIN-2502.v2025-12-27.q12; 115SAP.C-BCBTM-2502.v2025-12-26.q9; 122SAP.C_THR89_2505.v2025-12-26.q45; 115SAP.C-BCBTM-2509.v2025-12-26.q10; 166IAPP.AIGP.v2025-12-25.q64; 146CISI.UAE-Financial-Rules-and-Regulations.v2025-12-25.q35; 178SAP.C-S4TM-2023.v2025-12-25.q82; 128EMC.D-VXR-DS-00.v2025-12-24.q43; 184Splunk.SPLK-5001.v2025-12-24.q37

Question 56

Question 57

Question 58

Question 59

Question 60

Download PDF File