Question No. 1

Choose the best answer.

Examine the description of the EMPLOYEES table:

Which query is valid?

ASELECT dept_id, join_date,SUM(salary) FROM employees GROUP BY dept_id, join_date;

BSELECT depe_id,join_date,SUM(salary) FROM employees GROUP BY dept_id:

CSELECT dept_id,MAX(AVG(salary)) FROM employees GROUP BY dept_id;

DSELECT dept_id,AVG(MAX(salary)) FROM employees GROUP BY dapt_id;

Show Answer

Correct Answer: A

Question No. 2

Which three are true about the CREATE TABLE command?

AIt can include the CREATE...INDEX statement for creating an index to enforce the primary key constraint.

BThe owner of the table should have space quota available on the tablespace where the table is defined.

CIt implicitly executes a commit.

DIt implicitly rolls back any pending transactions.

EA user must have the CREATE ANY TABLE privilege to create tables.

FThe owner of the table must have the UNLIMITED TABLESPACE system privilege.

Show Answer

Correct Answer: A, B, C

Question No. 3

The CUSTOMERS table has a CUST_CREDT_LIMIT column of data type number.

Which two queries execute successfully?

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

BSELECT NVL2(cust_credit_limit * .15,'Not Available') FROM customers;

CSELECT NVL(cust_credit_limit * .15,'Not Available') FROM customers;

DSLECT NVL(TO_CHAR(cust_credit_limit * .15),'Not available') from customers;

ESELECT NVL2(cust_credit_limit,TO_CHAR(cust_credit_limit * .15),'NOT Available') FROM customers;

Show Answer

Correct Answer: D, E

Question No. 4

Choose two

Examine the description of the PRODUCT DETALS table:

APRODUCT_ID can be assigned the PEIMARY KEY constraint.

BEXPIRY_DATE cannot be used in arithmetic expressions.

CEXPIRY_DATE contains the SYSDATE by default if no date is assigned to it

DPRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it

EPRODUCT_PRICE contains the value zero by default if no value is assigned to it.

FPRODUCT_NAME cannot contain duplicate values.

Show Answer

Correct Answer: A, D

Question No. 5

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.

The table has two rows whose COST_LAST_MANE values are Anderson and Ausson.

Which query produces output for CUST_LAST_SAME containing Oder for the first row and Aus for the second?

ASELECT REPLACE (REPLACE(cust_last_name,'son',''),'An','O') FROM customers;

BSELECT REPLACE (TRIM(TRALING'son' FROM cust_last_name),'An','O') FROM customers;

CSELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name),'An','O')) FROM customers;

DSELECT REPLACE (SUBSTR(cust_last_name,-3),'An','O') FROM customers;

Show Answer

Correct Answer: A

Free Oracle 1Z0-071 Exam Actual Questions

The questions for 1Z0-071 were last updated On May 4, 2024