Free Access Oracle.1Z1-082.v2026-07-18.q117 Practice Test (Page 6)

Question 21

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 22

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

A.SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;

B.SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

C.SELECT NVL2(cust_credit_linit * .15, 'Not Available') FROM customers;

D.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

E.SELECT NVL(cust_credit_linit * .15, 'Not Available') FROM customers;

Question 23

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

A.It will be a dictionary-managed tablespace by default

B.It will always have a 32K blocksize

C.Additional data files may not be added

D.It must be bigger than the largest SMALLFILE tablespace

E.AUTOEXTEND is possible for the datafile

Question 24

Examine these commands:

Which two statements are true about the sqiidr execution?

A.It overwrites all data in emp with data from emp.dat.

B.It appends data from EMP.DAT TO EMP.

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

D.It overwrites the data for Alan and adds data for Curl and Bob

E.It generates a sqi script that it uses to load data from EMP.DAT TO EMP.

Question 25

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

A.It will be a dictionary-managed tablespace by default

B.AUTOEXTEND is possible for the datafile

C.It must be bigger than the largest SMALLFILE tablespace

D.It will always have a 32K blocksize

E.Additional data files may not be added

Other Version: 1483Oracle.1Z1-082.v2023-04-08.q100

Latest Upload: 206Cisco.300-610.v2026-08-19.q170; 194CompTIA.PT0-003.v2026-08-19.q179; 153Databricks.Databricks-Generative-AI-Engineer-Associate.v2026-08-18.q40; 148SAP.C_CR125_2601.v2026-08-17.q28; 210Salesforce.Field-Service-Consultant.v2026-08-17.q134; 167Oracle.1Z0-1170.v2026-08-16.q64; 175Oracle.1Z1-1170.v2026-08-16.q64; 200Juniper.JN0-336.v2026-08-13.q60; 373EMC.NCP-AII.v2026-08-13.q200; 222CIRO.RSE.v2026-08-12.q41

Question 21

Question 22

Question 23

Question 24

Question 25

Download PDF File