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

Question 31

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

A.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount !=NULL;

B.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;

C.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;

D.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

E.SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;

Question 32

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

A.A TIMESTAMP data type column contains information about year, month, and day

B.The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

C.A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

D.The CURRENT_TIMESTAMP function returns data without time zone information

E.The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

Question 33

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

A.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.

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

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

D.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.

E.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.

Question 34

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.It uses the database default blocksize

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

E.It is a locally managed tablespace

Question 35